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.