Repository Upgrade Failure While Delivering Workspace with Error "ORA-00001: unique constraint (SIEBEL.S_RR_WORKFLOW_U1) violated" (Doc ID 2485487.1)

Last updated on MARCH 27, 2024

Applies to:

Symptoms

Repository upgrade failure delivering workspace to MAIN. Here are steps followed

1. Run IRM with 17.5
2. Apply 18.11 PS
3. Run wsranking
4. Run repositoryupgrade which is failing while delivering 18_9_update INT branch to MAIN
   
   Error:

SQLParseAndExecute Bind Vars 4 000000025bfb19b4:0 2018-11-26 16:54:09 8: 1-2AQX3K

SQLParseAndExecute Bind Vars 4 000000025bfb19b4:0 2018-11-26 16:54:09 9: @0*0*1*0*16*Workflow Process3*32*ABCDE Report Approval5*ATTRS137*20*Clinical Trip Report1*N1*Y35*ABCDE Report Approval: 11*N2*NO0*32*ABCDE Report Approval3*All1*Y8*7.0 Flow0*0*0*0*

SQLParseAndExecute Bind Vars 4 000000025bfb19b4:0 2018-11-26 16:54:09 10: ALL

SQLParseAndExecute Bind Vars 4 000000025bfb19b4:0 2018-11-26 16:54:09 11: ABCDE Report Approval
......

SQLParseAndExecute Execute 5 000000025bfb19b4:0 2018-11-26 16:54:09 OCIStmtExecute: DML error or affected 0 rows

ObjMgrBusCompLog Error 1 000000025bfb19b4:0 2018-11-26 16:54:09 (oracon.cpp (4821)) SBL-DBC-00111: An error has occurred writing to a record.

Please continue or ask your systems administrator to check your application configuration if the problem persists.

SQLParseAndExecute Execute 5 000000025bfb19b4:0 2018-11-26 16:54:09 ORA-00001: unique constraint (SIEBEL.S_RR_WORKFLOW_U1) violated


ObjMgrBusCompLog Error 1 000000025bfb19b4:0 2018-11-26 16:54:09 (oracon.cpp (1242)) SBL-DAT-00381: A record that contains identical values to the record you have created already exists.

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.