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

Last updated on MARCH 28, 2023

Applies to:

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

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