My Oracle Support Banner

Failed to process SQL statement - error 10331 While Creating Checkpoint Table In Golden Gate replication from Oracle to Sybase (Doc ID 2616354.1)

Last updated on JANUARY 06, 2020

Applies to:

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

Symptoms

Oracle Goldengate replication setup is from Oracle (source database) to Sybase(target database) but  getting issue while adding checkpoint table.

GGSCI > ADD CHECKPOINTTABLE <checkpoint_tablename>
ERROR: failed to create checkpoint table '""."<checkpoint_tablename>"'. (sql statement: 'CREATE TABLE "<checkpoint_tablename>"
( group_name VARCHAR(8) NOT NULL, group_key NUMERIC(20) NOT NULL, seqno NUMERIC(10) NULL, rba NUMERIC(20) NOT NULL, audit_ts VARCHAR(29) NULL, create_ts DATETIME NOT NULL, last_update_ts DATETIME NOT NULL, current_dir VARCHAR(255) NOT NULL, PRIMARY KEY (group_name, group_key))')
Failed to process SQL statement - error 10331.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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