My Oracle Support Banner

Golden Gate Extract For MSSQL Fails With OGG-00146 With TRANLOGOPTIONS ACTIVESECONDARYTRUNCATIONPOINT (Doc ID 2334027.1)

Last updated on JUNE 26, 2022

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

Changes

 

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
Changes
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.