We are attempting to upgrade GoldenGate for our SQL Server from 11.2 to 12.1. We are running SQL Server 2012
At this point I have parallel installs on one server that have managers running for both versions.
There is a checkpoint table created by the name of dbo.GGS_Checkpoint121
The GLOBALS file contains: CHECKPOINTTABLE dbo.GGS_CHECKPOINT121
I OBEYed a new replicat, it created a replicat and checkpoint file, but didn't make a record in the checkpoint table. I tried a re-OBEY, and got the error message
Database operation failed: SQLExecDirect error: DELETE FROM [dbo].[GGS_CHECKPOINT121_lox] WHERE group_name = 'RAHHR12' AND group_key = 2451413578. ODBC error: SQLSTATE S0002 native database error 208. [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'dbo.GGS_CHECKPOINT121_lox'
Why is it looking for table name 'dbo.GGS_CHECKPOINT121_lox'?