Publish Failing with -508 Error When Publishing ScalarVals Visitor Attribute: ORA-00001: unique constraint violated (Doc ID 2711914.1)

Last updated on FEBRUARY 29, 2024

Applies to:

Symptoms

Publish Failing with -508 Error When Publishing ScalarVals Visitor Attribute

When attempting to publish a Visitor Attribute (ScalarVals asset) to the destination, the publish fails with a -508 error

In the Realtime publish log, the following error is seen:

[ERROR] [Unpacker] To ensure data integrity, data in this publish was split between 1 groups. 1 of those did not complete successfully. Please check the logs.
[SAVED] [RESOURCE] TABLE_ROW:1111111111111
[SAVED] [RESOURCE] TABLE_ROW:1111111111112
[SAVED] [RESOURCE] TABLE_ROW:1111111111113
[SAVED] [RESOURCE] TABLE_ROW:1111111111114
[SAVED] [RESOURCE] TABLE_ROW:1111111111115
[SAVED] [RESOURCE] ScalarVals
[ERROR] [CacheFlusher] Done flushing pages for those assets that were saved
[FAIL] [__JobMonitor__] Completion status: FAIL
[TIMINGS] [__JobMonitor__] Messenger timings: global 1001ms, log writes 0ms, progress reports 900ms, asset status 11ms, send/receive 422ms
[-] [-] Publish failed for approved assets (error number: -508).



On the destination sites.log, the following error is seen:

[ERROR] [-1-Publishing-ParallelUnpacker] [fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO ScalarVals (ID,NAME,STATUS,CREATEDBY,CREATEDDATE,UPDATEDBY,UPDATEDDATE,DESCRIPTION,FW_UID) VALUES (?,?,?,?,?,?,?,?,?)
ID = 1234567890123
NAME = ExampleAttr
STATUS = ED
CREATEDBY = testuser
CREATEDDATE = 2020-08-02 12:00:00.00
UPDATEDBY = co24925
UPDATEDDATE = 2020-08-02 12:00:00.00
DESCRIPTION = ExampleAttr
FW_UID = {fw_uid}
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SYS_C0012345) violated

Changes

Cause

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