"java.sql.SQLException: ORA-20002: Error while updating the task ORA-00001: unique constraint violated" Saving File Attachment in Worklist Task Throws Unique Constraint Violation Exception (Doc ID 1220943.1)

Last updated on FEBRUARY 25, 2013

Applies to:

Oracle(R) BPEL Process Manager - Version 11.1.1.2.0 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Feb-2013***

Symptoms

While adding a file to a task in the task form and saving the task, the following exception is thrown:

<Aug 19, 2010 6:09:11 PM EDT> <Error> <oracle.soa.services.workflow.common> <BEA-000000> <.
Error while updating task fb465083-60c9-4800-8089-81ef61cb92f2.
Check the underlying exception and the database connection information. If the error persists, contact Oracle Support Se
rvices.

ORABPEL-10101

Error while updating task .
Error while updating task fb465083-60c9-4800-8089-81ef61cb92f2.
Check the underlying exception and the database connection information. If the error persists, contact Oracle Support Se
rvices.

at oracle.bpel.services.workflow.repos.driver.oracle.OracleWFTask.updateTaskInDatabase(OracleWFTask.java:372)
at oracle.bpel.services.workflow.repos.driver.WFTask.updateWFTask(WFTask.java:2465)
at oracle.bpel.services.workflow.repos.driver.PersistencyService.updateWFTask(PersistencyService.java:612)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperationInTrans(TaskService.java:5906)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:5656)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:5627)
..........

Caused By: java.sql.SQLException: ORA-20002: Error while updating the task
ORA-06512: at "DEV_SOAINFRA.WFTASKPKG_111120", line 2457
ORA-00001: unique constraint (DEV_SOAINFRA.SYS_C004221) violated
ORA-06512: at line 1

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:135)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:210)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:473)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:423)
.........

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms