My Oracle Support Banner

ERROR OGG-05253 The SQL Server provider has thrown an exception. Query timeout expired - EXEC Dbo.OracleCDCExtract (Doc ID 2579371.1)

Last updated on AUGUST 23, 2019

Applies to:

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

Symptoms

Oracle GoldenGate Capture for SQL Server

SQL Server Log Mining Method: CDC
Version 12.3.0.1.1 OGGCORE_12.3.0.1.0_PLATFORMS_170804.2007



OGG 12.3.0.1.1 AND a batch with big transaction and latency the extract Abend with the below error:

 

2019-08-17 00:20:50 ERROR OGG-05253 The SQL Server provider has thrown an exception. Query timeout expired
EXEC dbo.OracleCDCExtract @XactLsn=0x00145b9200e7ce090105, @SeqLsn=0x00000000000000000000, @TranCount=10.


For OGG 12.3.0.1.1, setup TRANLOGOPTIONS QUERYTIMEOUT 300 fails with:

OGG-10151 (EMFD10A.prm) line 11: Parsing error, parameter [tranlogoptions] has unrecognized keyword or extra value "QUERYTIMEOUT".

Restart fix it.

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.