My Oracle Support Banner

Teradata Replicat Abends With Error OGG-00551 - Error: SQLSTATE S1105 Native Database Error 0. [DataDirect][ODBC Lib] Invalid Param Type (Doc ID 2413497.1)

Last updated on JULY 10, 2018

Applies to:

Oracle GoldenGate - Version to [Release 12.3]
Linux x86-64


Problem Summary
TD rep error:OGG-00551 Database operation failed BATCH SQL SQLSTATE S1105 native database error 0

Problem Description
How to configure BATCHSQL for GG 12.3 TD replicats? it is working OK on GG 12.2

Getting GG error
2018-05-10 10:49:14 ERROR OGG-00551 Database operation failed: BATCH SQL to table aaa_BASE_T.aaa_EXTENDED_JOBRUN_INFO failed to set parameter set size to 2.. ODBC error: SQLSTATE S1105 native database error 0. [DataDirect][ODBC lib] Invalid parameter typ.

After moving GG replicats
from Version OGGCORE_12.
to Version OGGCORE_12.

commenting out BATCHSQL enable replicat to continue to ran


To view full details, 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 a vibrant support community of peers and Oracle experts.