My Oracle Support Banner

OGGBD: DDL changes/Table metadata changes lead to issue in Stage and Merge processing (Doc ID 2868748.1)

Last updated on JULY 20, 2024

Applies to:

Oracle GoldenGate Big Data and Application Adapters - Version 21.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

The following messages are seen in the Synapse replicat handler log file

INFO 2022-05-02 11:19:36.000007 [TaskEngine_6234(FileFinalizeTask)] -
Re-using JDBC connection for table[<schema>.<Tablename>].
ERROR 2022-05-02 11:19:36.000007 [TaskEngine_6238(FileFinalizeTask)] - An
exception occurred in an event handler execute call.
java.lang.NullPointerException: null
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.buildParamTypeDefiniti
ons(SQLServerPreparedStatement.java:408) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.buildPreparedStrings(S
QLServerPreparedStatement.java:381) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedState
ment(SQLServerPreparedStatement.java:556) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExec
ute(SQLServerPreparedStatement.java:524) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7375)
~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConne
ction.java:3206) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatem
ent.java:247) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStat
ement.java:222) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPrepa
redStatement.java:505) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
oracle.goldengate.eventhandler.synapse.SynapseJDBCClient.copyDataIntoStagingTa
ble(SynapseJDBCClient.java:209)
~[ggsynapseeh-21.4.0.0.3.001.jar:21.4.0.0.3.001]



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
References


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