Upgrading Product Schemas Error: OIMR2PS2_OIM.PK_POP

When you are upgrading the product schemas, the unique constraint OIMR2PS2_OIM.PK_POP violated error is displayed.

The following error message is displayed:

2020-04-24T02:48:32.875-07:00] [OIM] [INCIDENT_ERROR] [] [upgrade.OIM.OIM1]
[tid: 90] [ecid: ab5f4fa6-a864-4c03-b79e-464f0b408557-00000002,0] [[
oracle.iam.oimupgrade.exceptions.OIMUpgradeException: SQL Exception in
running Upgrade Scripts
    at
oracle.iam.oimupgrade.onehop.SchemaUpgradeManager.upgrade(SchemaUpgradeManager
.java:314)
    at oracle.iam.oimupgrade.mrua.OIMMRUA.upgrade(OIMMRUA.java:203)
    at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:730)
    at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:736)
    at
oracle.ias.update.PhaseProcessor$UpgradeProcessor.runStepPhase(PhaseProcessor.
java:726)
    at oracle.ias.update.PhaseProcessor.runStep(PhaseProcessor.java:369)
    at
oracle.ias.update.PhaseProcessor$ExtendedRunnable.run(PhaseProcessor.java:1058
)
    at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142
)
    at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617
)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: ORA-20100: Exception encountered!!
ORA-00001: unique constraint (OIMR2PS2_OIM.PK_POP) violated

ORA-06512: at line 268
ORA-06512: at line 468

To solve this issue, complete the following steps:

1. From the SQL developer, connect to OIM schema.
2. Open POP OIM DB table details.
3. Go to the index tab.
4. Manually delete the PK_POP index.