ORA-00001: unique constraint (UCMPROD_OCS.PK_REVCLASSES) Error on Archive Import of Siebel Attachments (Doc ID 3055236.1)

Last updated on MARCH 19, 2025

Applies to:

Symptoms

The following error is occurring for specific revisions on import archive for the target WCC instance.


Import error for archive 'SAMPLE_ARCHIVE' in collection 'UCMPROD': Unable to execute service CHECKIN_ARCHIVE and function processCheckinArchive.
Encountered an exception while executing a query. java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (UCMPROD_OCS.PK_REVCLASSES) violated. Error : 1, Position : 0, Sql = INSERT INTO RevClasses (dRevClassID, dDocName, dDocCreator, dDocCreatedDate,
dDocLastModifier, dDocLastModifiedDate, dDocOwner, dDocFunction, dDocClass)
VALUES(1234995, '3038501', 'weblogic', TO_TIMESTAMP ('2021-01-31 16:12:09.001', 'YYYY-MM-DD HH24:MI:SS.FF'), 'weblogic', TO_TIMESTAMP ('2021-01-31 16:12:09.001', 'YYYY-MM-DD HH24:MI:SS.FF'), 'weblogic', '', ''), OriginalSql = INSERT INTO RevClasses (dRevClassID, dDocName, dDocCreator, dDocCreatedDate,
dDocLastModifier, dDocLastModifiedDate, dDocOwner, dDocFunction, dDocClass)
VALUES(1234995, '3038501', 'weblogic', {ts '2021-01-31 16:12:09.001'}, 'weblogic', {ts '2021-01-31 16:12:09.001'}, 'weblogic', '', ''), Error Msg = ORA-00001: unique constraint (UCMPROD_OCS.PK_REVCLASSES) violated. Encountered an exception while executing a query (Error Code: 'ORA-00001'). [ Details ]
An error has occurred. The stack trace below shows more information.

!csImportErrorForArchiveInCollection,SAMPLE_ARCHIVE,UCMPROD!csServiceDataException,CHECKIN_ARCHIVE,processCheckinArchive!$!csJdbcGenericError!syJavaExceptionWrapper,java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (UCMPROD_OCS.PK_REVCLASSES) violated
!syJavaExceptionWrapper,Error : 1\, Position : 0\, Sql = INSERT INTO RevClasses (dRevClassID\, dDocName\, dDocCreator\, dDocCreatedDate\,
dDocLastModifier\, dDocLastModifiedDate\, dDocOwner\, dDocFunction\, dDocClass)
VALUES(1234995\, '3038501'\, 'weblogic'\, TO_TIMESTAMP ('2021-01-31 16:12:09.001'\, 'YYYY-MM-DD HH24:MI:SS.FF')\, 'weblogic'\, TO_TIMESTAMP ('2021-01-31 16:12:09.001'\, 'YYYY-MM-DD HH24:MI:SS.FF')\, 'weblogic'\, ''\, '')\, OriginalSql = INSERT INTO RevClasses (dRevClassID\, dDocName\, dDocCreator\, dDocCreatedDate\,
dDocLastModifier\, dDocLastModifiedDate\, dDocOwner\, dDocFunction\, dDocClass)
VALUES(1234995\, '3038501'\, 'weblogic'\, {ts '2021-01-31 16:12:09.001'}\, 'weblogic'\, {ts '2021-01-31 16:12:09.001'}\, 'weblogic'\, ''\, '')\, Error Msg = ORA-00001: unique constraint (UCMPROD_OCS.PK_REVCLASSES) violated
!csJdbcGenericErrorWithCode,ORA-00001
intradoc.common.ServiceException: !csServiceDataException,CHECKIN_ARCHIVE,processCheckinArchive!$
  at intradoc.server.ServiceRequestImplementor.buildServiceException(ServiceRequestImplementor.java:2312)
  at intradoc.server.Service.buildServiceException(Service.java:2444)
  at intradoc.server.Service.createServiceExceptionEx(Service.java:2438)
  at intradoc.server.Service.createServiceException(Service.java:2433)
  at intradoc.server.ServiceRequestImplementor.handleActionException(ServiceRequestImplementor.java:1936)
  at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1886)

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.