My Oracle Support Banner

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 MAY 10, 2021

Applies to:

Siebel CRM - Version 18.11 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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