Getting Unique Constraint Violation On FW_PubDataStore when publishing

(Doc ID 1602208.1)

Last updated on JULY 16, 2017

Applies to:

Oracle WebCenter Sites - Version 11.1.1.6.1 and later
Information in this document applies to any platform.

Symptoms

Publishing failing with unique constraint violation on the fw_pubdatastore table

[2013-11-16 09:34:02,637 EST] [ERROR] [http-8080-7] [fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO FW_PubDataStore (ID,RESKEY,BDATA,BDATASIZE,ENCODING,TYPE,PUBSESSION,PUBGROUP) VALUES (?,?,?,?,?,?,?,?)
ID = 1283938561556
RESKEY = TABLE_ROW:1384574354869
BDATASIZE = 3400
ENCODING = UTF-8
TYPE = TABLE_ROW
PUBSESSION = 1283938561506
PUBGROUP = 1_TABLEROWS_
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ORACLEWCS_MGMT.SYS_C0048131) 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