Informix: ADD TRANDATA fails with OGG-00551 ODBC error: SQLSTATE S1000 native database error -674. sqlerrm(cdc_set_fullrowlogging. (Doc ID 2154288.1)

Last updated on NOVEMBER 18, 2016

Applies to:

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

Symptoms

OGG 12.2.0.1.1 with Informix.  Attempt to add trandata for a table:

ggsci>  ADD TRANDATA database.schema.table

fails with the following errors:

ERROR OGG-00551 Oracle GoldenGate Command Interpreter for Informix: Database operation failed: SQLExecDirect. ODBC error: SQLSTATE S1000 native database error -674. [Informix][Informix ODBC Driver][Informix]Unspecified System Error = -674. sqlerrm(cdc_set_fullrowlogging.

ERROR OGG-01668 Oracle GoldenGate Command Interpreter for Informix: PROCESS ABENDING.

Changes

 New implementation of OGG with Informix.

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