My Oracle Support Banner

Add Trandata Caused " SQLSTATE S0022 native database error 207 & OGG Error OGG-00870 Invalid Column Name " (Doc ID 2766311.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

On : 19.1.0.0.4 version, 2 - Non Oracle DB backend

OGG Error OGG-00870 Invalid column name

Environment details:

Oracle Golden Gate for SQL Server Version 19.1.0.0.4
SQL Server Version 11.0.7001.0

Collation productversion productlevel edition
------------------------------ ------------------------------ ------------------------------ ------------------------------
SQL_Latin1_General_CP1_CS_AS 11.0.7001.0 SP4 Enterprise Edition (64-bit)

OGG fails reporting the following error while executing the ADD TRANDATA command:
OGG-00552 Oracle GoldenGate Command Interpreter for SQL Server: Database operation failed: SQLExecDirect error: update ggadmin.OracleGGVersion set EndTime = getdate() where EndTime is null and id = 24. ODBC error: SQLSTATE S0022 native database error 207. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'Endtime'.

ERROR
-----------------------

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
Cause
Solution


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