WebCenter Content: Imaging Attachments Cause SOA Error "ORA-00001: unique constraint (DEV_SOAINFRA.WFATTACHMENT_UNIQUE) violated" (Doc ID 1625586.1)

Last updated on MAY 02, 2017

Applies to:

Oracle WebCenter Content: Imaging - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

When processing invoices through Imaging and into the SOA Managed Server, some BPEL processes report this error in the SOA log:

Error occurred while inserting a task attachment record.

Error occurred while inserting attachment 3.IPM_001657 for task 220253.

Check the underlying exception and the database connection information. If the error persists, contact Oracle Support Services.

                at oracle.bpel.services.workflow.repos.driver.WFAttachment.insertAttachmentIntoDatabase(WFAttachment.java:1119)

                at oracle.bpel.services.workflow.repos.driver.WFAttachment.insertProcessInstanceAttachment(WFAttachment.java:645)

                at oracle.bpel.services.workflow.repos.driver.WFTask.addProcessInstanceAttachment(WFTask.java:6313)

                ... 150 more

Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_SOAINFRA.WFATTACHMENT_UNIQUE) violated

 

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