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 laterInformation 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 |