Patch or upgrade running long in step ACM-105090.sql in RSA Identity Governance & Lifecycle
Originally Published: 2021-11-24
Article Number
Applies To
RSA Version/Condition: 7.2.0, 7.2.1, 7.5.0
Issue
The patch.log file shows the process spending time on the step that deletes data from WP_ACTI_ALERT table:
[0:03:27 27%] executing updates/7.1/ACM-105090.sql
Cause
This is a known issue when patching (or upgrading) from versions older than the following versions if there is a very large amount of data in WP_ACTI_ALERT and WP_WI_ALERT tables:
- RSA Identity Governance & Lifecycle 7.2.0 P05
- RSA Identity Governance & Lifecycle 7.2.1 P01
- RSA Identity Governance & Lifecycle 7.5.0
Resolution
Allow the patch or upgrade to complete. This is a one time process.
If the patch or upgrade was aborted or you wish to reduce the upgrade time for other environments, please contact RSA Customer Support and request a workaround for this issue.
Workaround
If you encounter this issue during patching or upgrade and want to reduce the time for the migration, please contact RSA Customer Support and quote this article. RSA Customer Support can supply a cleanup script that can be run prior to the patching or upgrade to greatly reduce the migration time.
Related Articles
How to query a public database schema table for Segregation of Duties (SOD) violations in RSA Identity Governance & Lifecycle Number of Views RSA Identity Management and Governance SSLHandshakeException when using a custom Java workflow node on Red Hat Enterprise … Number of Views All RSA Authentication Manager 8.2 servers in a deployment do not respond to authentication requests at the same time Number of Views In RSA Identity Governance & Lifecycle, a SQL exception error in the UI is encountered when saving Delay node on a Workflow Number of Views Warnings that are safe to ignore when running the RSA Authentication Manager 8.6 Pre-Upgrade Check Tool Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device How to replace the RSA Authentication Manager self signed console certificate with a signed certificate from Microsoft Act… RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide How to Request Access to the RSA Authentication Manager AMI for AWS via RSA Support
Don't see what you're looking for?
