Article Number
000039203
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.1.1, 7.2.0, 7.2.1, 7.5.0, 7.5.2
Issue
When restarting RSA Identity Governance & Lifecycle, the application will not restart. There are no relevant errors in the log files. An
acm status shows as waiting for the application to start:
acm status
...
Waiting for RSA Identity Governance and Lifecycle to start......
After two minutes, a refresh of
acm status shows:
acm status
...
Waiting for RSA Identity Governance and Lifecycle to start......
The RSA Identity Governance & Lifecycle server is not running and is not in a starting state
The database is running and accessible.
On an RSA Identity Governance & Lifecycle cluster deployment, the following error message may be logged:
[7/7/21 21:48:35:280 EDT] 000000b5 ThreadMonitor W WSVR0605W: Thread "server.startup : 0" (0000009a) has been active for 704882 milliseconds and may be hung. There is/are 1 thread(s) in
total in the server that may be hung.
Cause
This issue may occur on the startup of the RSA Identity Governance & Lifecycle server or the server node in a multi-node cluster. It can occur due to the application attempting to delete a very large number of WorkPoint tokens on startup from the T_AV_WF_TRUSTED_TOKENS table.
RSA Identity Governance & Lifecycle deployments with a very large volume of Workflow activity may be more susceptible to this issue.
Resolution
This issue is resolved in the following versions:
- RSA Identity Governance & Lifecycle 7.2.1 P08
- RSA Identity Governance & Lifecycle 7.5.0 P05
- RSA Identity Governance & Lifecycle 7.5.2 P01
This resolves an issue where a large number of tokens were inadvertently added to the T_AV_WF_TRUSTED_TOKENS table.
This resolves an issue where some tokens were not purged correctly according to their expiration time.
Workaround
The following steps provide an estimate of the number of unpurged tokens. If the count is over 10,000, you may have this issue.
- Login to the database server as the oracle user.
- Login to SQL*Plus as AVUSER and run:
SQL> select count( * ) from t_av_wf_trusted_tokens;
- End the SQL*Plus session:
SQL> exit;
A one time cleanup script can be used to remove the tokens. Please contact
RSA Identity Governance & Lifecycle Customer Support for resolution and mention this RSA Knowledge Base Article ID 000039203 for reference.
