Golden Gate Extract For MSSQL Fails With OGG-00146 With TRANLOGOPTIONS ACTIVESECONDARYTRUNCATIONPOINT

(Doc ID 2334027.1)

Last updated on MAY 28, 2018

Applies to:

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

Symptoms

EXTRACT process abended with the following errors:

ERROR OGG-00146 Oracle GoldenGate Capture for SQL Server, ECRM.prm: Call to VAMRead returned with error status 600: VAM Client Report <[mssqlvam::TruncMgr::Timer] Query timeout expired Additional Info : Error (-2147217871): Query timeout expired

2017-10-27 11:00:29 ERROR OGG-00146 Call to VAMRead returned with error status 600: VAM Client Report <[mssqlvam::TruncMgr::Timer] Query timeout expired Additional Info : Error (-2147217871): Query timeout expired

Cause

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