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

[#1]

Article Number

000038302

Applies To

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

 

Issue

When 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)

Cause

The 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

• If the RSA Identity Governance & Lifecycle Oracle database is 12.1.0.2 without the October 2017 or later Proactive Bundle, let the migration run to completion.
• If the RSA Identity Governance & Lifecycle Oracle database is 12.2.0.1 or 12.1.0.2 with the October 2017 or later Proactive Bundle Patch, please implement the new database optimizer requirements as specified in RSA Knowledge Base Article 000038082 -- Recommended optimizer_adaptive_* database parameter settings in RSA Identity Governance & Lifecycle 7.1.1 by following the steps below.

1. Stop the migration.
2. Implement the recommended options as per the RSA Knowledge Base Article.
3. Restart the database.
4. Restart the migration.