SQL execution ORA-01452 when upgrading Diagnostics to SP15

[Former Member]

Hello all,

I'm in the process of upgrading our Solution Manager Diagnostics application from patch 13 to patch 15 and am running into an ORA-01452 error. I've opened a message with SAP however I'm feeling like it will be bounced around for a while.

specific error is;

Aug 14, 2008 7:20:35 AM Info: 7:20:18 2008-08-14 dbs-Error: Exception caught during SQL execution ORA-01452: cannot CREATE

UNIQUE INDEX; duplicate keys found

Aug 14, 2008 7:20:35 AM Info: CREATE UNIQUE INDEX "K_CHIIG_LOC_PATH" ON "BC_WA_CONF_STORES"("CSS_PATH", "CSS_LOCATION", "H_

KEY", "C_KEY", "I_KEY", "IG_KEY")

Aug 14, 2008 7:20:35 AM Info:

I've found OSS note 23237 but don't want to delete data from the tables without specific guidance. Anyone run into this issue? Anyone know a gui interface to manually look at this data within diagnostics?

[Former Member]

Closing out this question. Resolution was found by executing the steps outlined in the previously mentioned OSS note.