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 12.3.0.1.2 to 12.3.0.1.2 [Release 12.3]
Linux x86-64

Symptoms

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 12.2.0.1.0 OGGCORE_12.2.0.1.0_PLATFORMS_151101.1925.2
to Version 12.3.0.1.2 OGGCORE_12.3.0.1.0_PLATFORMS_171208.0005

commenting out BATCHSQL enable replicat to continue to ran
--BATCHSQL BATCHTRANSOPS 500, BYTESPERQUEUE 1000000, OPSPERBATCH 100000

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