Can Not Delete Replicat OGG-00552 Database Operation Failed: SQLExecDirect Error: DELETE FROM [tablename]
(Doc ID 3000921.1)
Last updated on DECEMBER 11, 2024
Applies to:
Oracle GoldenGate - Version 12.3.0.1.4 and laterInformation in this document applies to any platform.
Symptoms
When trying to delete GoldenGate replicat for MS SQL Server the following error is received
WARNING OGG-00552 Database operation failed: SQLExecDirect error: DELETE FROM [table_name]WHERE group_name = name' AND group_key = 1271479403. ODBC error: SQLSTATE S0002 native database error 208. [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'schema.tablename'.
Could not delete DB checkpoint for REPLICAT REPNAME (Deleting entry in checkpoint table 'schema.tablename' (group: 'REPNAME', key: 0x4bc93c6b).
Database error 208 ([Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'schema.tablename'.))
Could not delete DB checkpoint for REPLICAT REPNAME (Deleting entry in checkpoint table 'schema.tablename' (group: 'REPNAME', key: 0x4bc93c6b).
Database error 208 ([Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name '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 |