000038302 - Migration of ACM-69142.sql hangs when installing a patch on RSA Identity Governance & Lifecycle 7.1.1

Document created by RSA Customer Support Employee on Jan 2, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000038302
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 7.1.1

 
IssueWhen installing a 7.1.1 patch on RSA Identity Governance & Lifecycle, the migration hangs in the user interface on:
 
executing updates/7.0/ACM-69142.sql



Oracle Enterprise Manager (OEM) shows the following query being executed:




SELECT GM.ROWID, ACC.NAME
FROM T_GROUP_MEMBERSHIPS GM
JOIN T_AV_ACCOUNTS ACC
ON GM.MEMBER_ID - ACC.ID
WHERE MEMBER_TY0E = 'account' AND 0 = DECODE(GM.MEMBER_NAME,ACC.NAME,1,0)
CauseThe migration script ACM-69142.sql was introduced in 7.0.1 and might take a while to finish on databases with a lot of groups and group memberships. 

However, the most likely cause is that the database is Oracle 12.2.0.1 or Oracle 12.1.0.2 with the October 2017 or later Proactive Bundle Patch (BP). If this is the case, the optimizer settings may not be defined properly.
 
Resolution
  1. Stop the migration.
  2. Implement the recommended options as per the RSA Knowledge Base Article.
  3. Restart the database.
  4. Restart the migration.

Attachments

    Outcomes