Replicat Abends With Error ORA-01407: cannot update ("XXXX"."XXXX"."XXXX") to NULL (Doc ID 2254823.1)

Last updated on APRIL 19, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Replicat process abends with below error:

 

2017-03-30 00:00:51 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rpcrm01.prm: OCI Error ORA-01407: cannot update ("SIEBEL"."S_CONTACT"."CONFLICT_ID") to NULL (status = 1407), SQL <UPDATE /*+ RESTRICT_ALL_REF_CONS */ "SIEBEL"."S_CONTACT" x SET x."CREATED_BY" = :a1,x."CONFLICT_ID" = :a5,x."PAR_ROW_ID" = :a6,x."BU_ID" = :a7,x."EMP_FLG" = :a8,x."FST_NAME" = :a9,x."LAST_NAME" = :a10,x."PERSON_UID" = :a11,x."PRIV_FLG" = :a12,x."SPEAKER_FLG" = :a13,x."SUSPECT_FLG" = :a14,x."AGENT_FLG" = :a15,x."MEMBER_FLG" = :a16,x."PROVIDER_FLG" = :a17,x."ASGN_USR_EXCLD_FLG" = :a18,x."CONSUMER_FLG" = :a19,x."ACTIVE_CTI_CFG_ID" = :a21,x."ACTIVE_TELESET_ID" = :a22,x."ALIAS_NAME" = :a23,x."CON_ASST_PER_ID" = :a24,x."CON_IMAGE_ID" = :a25,x."CON_INFLUNC_ID" = :a26,x."CON_MANAGER_PER_ID" = :a27,x."CSN" = :a28,x."CURR_PRI_LST_ID" = :a29,x."DEDUP_TOKEN" = :a30,x."EMAIL_ADDR" = :a31,x."EMP_ID" = :a32,x."EMP_NUM" = :a33,x."HOME_PH_NUM" = :a34,x."INDUST_ID" = :a35,x."INTEGRATION_ID" = :a36,x."LOGIN" = :a37,x."MED_SPEC_ID" = :a38,x."MSTR_CASE_ID" = :a39,x."OU_ID" = :a40,x."OWNER_PER_ID" = :a41,x."PAGER_COMPANY_ID" = :a42,x."PREF_LANG_ID" = :a43,x."PREF_SALE_DLR_ID" = :a44,x."PR_ACT_ID" = :a45,x."PR_CLIENT_OU_ID" = :a46,x."PR_DEPT_OU_ID" = :a47,x."PR_HELD_POSTN_ID" = :a48,x."PR_IMAGE_ID" = :a49,x."PR_OPTY_ID" = :a50,x."PR_OU_ADDR_ID" = :a51,x."PR_POSTN_ID" = :a53,x."REGION_ID" = :a54,x."SOC_SECURITY_NUM" = :a55,x."SRC_ID" = :a56,x."LAST_UPD" = :a58,x."LAST_UPD_BY" = :a59,x."MODIFICATION_NUM" = :a60,x."DB_LAST_UPD" = :a61,x."PR_PER_ADDR_ID" = :a62 WHERE x."ROW_ID" = :b0>.

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