Article - CS354793
Error: "ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found" during dbupgrader process in Servigistics Service Parts Management (SPM)
Modified: 15-Oct-2021
Applies To
- Servigistics Service Parts Management 12.0.0.0 NA to 12.2.0.0
Description
- Error in dbupgrader log
- dbupgrader did not abort
- Can error be ignored
- 2021-09-22 03:39:44,820[main] ERROR com.servigistics.tools.db.DbUpgrader - Error processing statement: CREATE UNIQUE INDEX DDSKU_OVERRIDE_UNIQUE ON IPCSDD_SKU_OVERRIDE
(
DownloadID,
BeginDate,
HostLocID,
HostPartID
)
2021-09-22 03:39:44,820[main] ERROR com.servigistics.tools.db.DbUpgrader - Error 1452: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
2021-09-22 03:39:44,820[main] ERROR com.servigistics.tools.db.DbUpgrader - Error processing script file: 1615387715456.SQL
2021-09-22 03:39:44,846[main] INFO com.servigistics.tools.db.DbUpgrader - Commit:
2021-09-22 03:39:44,846[main] INFO com.servigistics.tools.db.DbUpgrader - ALTER TABLE statements (rows): 1 (0)
2021-09-22 03:39:44,846[main] INFO com.servigistics.tools.db.DbUpgrader - DROP INDEX statements (rows): 1 (0)
2021-09-22 03:39:44,846[main] INFO com.servigistics.tools.db.DbUpgrader - Totals:
2021-09-22 03:39:44,846[main] INFO com.servigistics.tools.db.DbUpgrader - ALTER TABLE statements (rows): 1 (0)
2021-09-22 03:39:44,846[main] INFO com.servigistics.tools.db.DbUpgrader - DROP INDEX statements (rows): 1 (0)
2021-09-22 03:39:44,846[main] INFO com.servigistics.tools.db.DbUpgrader - Recording script <1615387715456.SQL> in upgrade history
2021-09-22 03:39:44,850[main] INFO com.servigistics.tools.db.DbUpgrader - Finished processing script <1615387715456.SQL>
This is a printer-friendly version of Article 354793 and may be out of date. For the latest version click CS354793