Goldengate Replicat Abends Trying To Update Checkpoint Table: ORA-12899 "LOG_CMPLT_XIDS" (actual: 149, maximum: 128))

(Doc ID 2256286.1)

Last updated on APRIL 18, 2017

Applies to:

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

Symptoms

Goldengate replicat abends while trying to update the checkpoint table with the following error:

2017-04-10 02:45:15 ERROR OGG-00665 OCI Error executing single row select (status = 12899-ORA-12899: value too large
 for column "GGS"."CHKPT"."LOG_CMPLT_XIDS" (actual: 149, maximum: 128)), SQL<UPDATE ggs.CHKPT SET last_update_ts = sysda<br/>te, seqno = :seqno, rba = :rba, audit_ts = :audit_ts, log_bsn = :log_bsn, log_csn = :log_csn, log_xid = :log_xid, log_cm
plt_csn = :log_cmplt_csn, log_cmplt_xids = :log_cmplt_xids, version = :version WHERE group_name = :group_name AND group_
key = :key>.

checkpoint table ddl:

CREATE TABLE "GGS"."CHKPT"
( "GROUP_NAME" VARCHAR2(8) NOT NULL ENABLE,
"GROUP_KEY" NUMBER(19,0) NOT NULL ENABLE,
"SEQNO" NUMBER(10,0),
"RBA" NUMBER(19,0) NOT NULL ENABLE,
"AUDIT_TS" VARCHAR2(29),
"CREATE_TS" DATE NOT NULL ENABLE,
"LAST_UPDATE_TS" DATE NOT NULL ENABLE,
"CURRENT_DIR" VARCHAR2(255) NOT NULL ENABLE,
"LOG_BSN" VARCHAR2(128),
"LOG_CSN" VARCHAR2(128),
"LOG_XID" VARCHAR2(128),
"LOG_CMPLT_CSN" VARCHAR2(128),
"LOG_CMPLT_XIDS" VARCHAR2(128),   <============= it is varchar2(128)
"VERSION" NUMBER(3,0),
PRIMARY KEY ("GROUP_NAME", "GROUP_KEY")

...

 

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