Some PDF Documents that are Checked Into the Oracle Universal Content Management System (UCM) go into Workflow, and when Approve is Chosen, an Error is Thrown (Doc ID 1168234.1)

system 07.21 11:12:03.985 IdcServerThread-51 !csWfUpdateCompanion,MOCA_000241,PolicyWF,ApproverStep!csDbUnableToExecuteQuery,IworkflowDocHistory(INSERT INTO WorkflowHistory (dActionMillis\, dActionDate\, dAction\, 

dWfName\, dWfStepName\, dUser\, dID\, dDocName\, dDocType\, dDocTitle\,

dDocAuthor\, dRevClassID\, dRevisionID\, dRevLabel\, dSecurityGroup\, 

dCreateDate\, dInDate\, dOutDate\, dDocAccount\, dClbraName)

VALUES(14823969\, {ts '2010-07-21 11:12:00.000'}\, 'Exit'\, 'PolicyWF'\, 'ApproverStep'\, 'Approver1'\, 247\, 'MOCA_000241'\, 'Policy'\, '56788'\, 

      'sysadmin'\, 241\, 1\, '1'\, 'Public'\, {ts '2010-07-20 12:41:00.000'}\, {ts '2010-07-20 12:41:00.000'}\, null\, ''\, ''))!$ORA-00001: unique constraint (IDC_ADMIN.PK_WORKFLOWHISTORY) violated

-exception stack

intradoc.data.DataException: !csWfUpdateCompanion,MOCA_000241,PolicyWF,ApproverStep!csDbUnableToExecuteQuery,IworkflowDocHistory(INSERT INTO WorkflowHistory (dActionMillis\, dActionDate\, dAction\, 

dWfName\, dWfStepName\, dUser\, dID\, dDocName\, dDocType\, dDocTitle\,

dDocAuthor\, dRevClassID\, dRevisionID\, dRevLabel\, dSecurityGroup\, 

dCreateDate\, dInDate\, dOutDate\, dDocAccount\, dClbraName)

VALUES(14823969\, {ts '2010-07-21 11:12:00.000'}\, 'Exit'\, 'PolicyWF'\, 'ApproverStep'\, 'Approver1'\, 247\, 'MOCA_000241'\, 'Policy'\, '56788'\, 

      'sysadmin'\, 241\, 1\, '1'\, 'Public'\, {ts '2010-07-20 12:41:00.000'}\, {ts '2010-07-20 12:41:00.000'}\, null\, ''\, ''))!$ORA-00001: unique constraint (IDC_ADMIN.PK_WORKFLOWHISTORY) violated

 

at intradoc.server.workflow.WorkflowStates.markWorkflowFinished(WorkflowStates.java:2289)

at intradoc.server.workflow.WorkflowStates.advanceDocumentStateImplement(WorkflowStates.java:653)

at intradoc.server.workflow.WorkflowStates.advanceDocumentState(WorkflowStates.java:507)

at intradoc.server.DocStateTransition.advanceDocumentState(DocStateTransition.java:74)

at intradoc.server.workflow.WorkflowHandler.updateWorkflowAndDocState(WorkflowHandler.java:513)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at intradoc.common.IdcMethodHolder.invokeMethod(ClassHelperUtils.java:466)

at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:142)

at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:77)

at intradoc.server.workflow.WorkflowHandler.executeAction(WorkflowHandler.java:82)

at intradoc.server.Service.doCodeEx(Service.java:490)

at intradoc.server.Service.doCode(Service.java:472)

at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1353)

at intradoc.server.Service.doAction(Service.java:452)

at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1194)

at intradoc.server.Service.doActions(Service.java:447)

at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1114)

at intradoc.server.Service.executeActions(Service.java:433)

at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:635)

at intradoc.server.Service.doRequest(Service.java:1707)

at intradoc.server.ServiceManager.processCommand(ServiceManager.java:359)

at intradoc.server.IdcServerThread.run(IdcServerThread.java:197)

Caused by: intradoc.data.DataException: !csDbUnableToExecuteQuery,IworkflowDocHistory(INSERT INTO WorkflowHistory (dActionMillis\, dActionDate\, dAction\, 

dWfName\, dWfStepName\, dUser\, dID\, dDocName\, dDocType\, dDocTitle\,

dDocAuthor\, dRevClassID\, dRevisionID\, dRevLabel\, dSecurityGroup\, 

dCreateDate\, dInDate\, dOutDate\, dDocAccount\, dClbraName)

VALUES(14823969\, {ts '2010-07-21 11:12:00.000'}\, 'Exit'\, 'PolicyWF'\, 'ApproverStep'\, 'Approver1'\, 247\, 'MOCA_000241'\, 'Policy'\, '56788'\, 

      'sysadmin'\, 241\, 1\, '1'\, 'Public'\, {ts '2010-07-20 12:41:00.000'}\, {ts '2010-07-20 12:41:00.000'}\, null\, ''\, ''))!$ORA-00001: unique constraint (IDC_ADMIN.PK_WORKFLOWHISTORY) violated

 

at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2356)

at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:650)

at intradoc.server.workflow.WorkflowStates.markWorkflowFinished(WorkflowStates.java:2241)

... 24 more

Caused by: java.sql.SQLException: ORA-00001: unique constraint (IDC_ADMIN.PK_WORKFLOWHISTORY) violated

 

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)

at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)

at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4086)

at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4234)

at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1661)

at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1626)

at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:643)

... 25 more