'SQLIntegrityConstraintViolationException' when clicked on "Initialize Mirror Destination" (Doc ID 2148872.1)

Last updated on JUNE 16, 2016

Applies to:

Oracle WebCenter Sites - Version 11.1.1.8.0 to 11.1.1.8.0 [Release FatWire]
Information in this document applies to any platform.

Symptoms


Following error is seen when clicked on 'Initialize Realtime Destination'->Mirror button (RealTime Publishing) or 'Initialize Mirror Destination'->Mirror (Mirror to server) button. 

- On Source sites.log:  No response from remote execute to save assetype, errno=-105
- On Destination sites.log:

[2016-06-06 23:41:53,935 UTC] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO tt1464769199835 (ELEMENTNAME,DESCRIPTION) VALUES (?,?)
ELEMENTNAME = OpenMarket/Xcelerate/AssetType/MKT_Asset_C/AppendSelectDetails
DESCRIPTION = AppendSelectDetails
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CSUSER_DEV_LIVE"."TT1464769199835"."URL")

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