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
Converting a NCLOB to a VARCHAR2 in TO_DATE after error ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conve… Number of Views Slow response time on Activities page in RSA Identity Governance & Lifecycle Number of Views Data Purging does not complete in the configured time limit in RSA Identity Governance & Lifecycle Number of Views How to identify the source of a workflow email in RSA Identity Governance and Lifecycle Number of Views Approval activity throws a Request Could Not Be Handled error in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?
