My Oracle Support Banner

OGG Sqlserver replicat - SQL error 102 mapping <Schema>.<Tablename> to <Schema>.<Tablename> (Doc ID 2866453.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

Oracle GoldenGate Sqlserver replicat failed with 

2022-04-17 10:18:11 WARNING OGG-00869 SQLFormatter::ToSQLUpdate invalid statement object, no SETParams.

2022-04-17 10:18:11 WARNING OGG-01004 Aborted grouped transaction on <Schema>.<Tablename>, Database error 102 ([SQL error 102 (0x66)][Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '%'.[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared.
).

2022-04-17 10:18:11 WARNING OGG-01003 Repositioning to rba 18491 in seqno 2.

2022-04-17 10:18:12 WARNING OGG-00869 SQLFormatter::ToSQLUpdate invalid statement object, no SETParams.

2022-04-17 10:18:12 WARNING OGG-01154 SQL error 102 mapping <Schema>.<Tablename> to <Schema>.<Tablename> [SQL error 102 (0x66)][Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '%'.[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared.

2022-04-17 10:18:12 ERROR OGG-01296 Error mapping from <Schema>.<Tablename> to <Schema>.<Tablename>.

 

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.