OGG Replicat Abends with OGG-01296 Error Mapping And SQL Error -2147217900 (Doc ID 2111841.1)

Last updated on APRIL 20, 2017

Applies to:

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

Goal

Why the replicat abends with a similar error on SQLSERVER database?

[SQL error -2147217900 (0x80040e14)]
Incorrect syntax near 'GGS_REPLTRACKER'.
Server: WISENT1XA\SQLDEV34
Native Error: 102, 102
State: 1, 42000
Class: f
Source: Line Number: 1
Description: Statement(s) could not be prepared.
Statement(s) could not be prepared.
Server: WISENT1XA\SQLDEV34
Native Error: 1ff4, 1ff4
State: 1, 42000
Class: 10
Source: Line Number: 1
Description: Statement(s) could not be prepared.
 

Solution

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