My Oracle Support Banner

Goldengate Extract Getting Query timeout Expired With Windows SQLserver Database (Doc ID 2674430.1)

Last updated on JUNE 08, 2020

Applies to:

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

Goal

 Sqlserver Extract abends with below error :

2020-03-14 23:34:48 ERROR OGG-05253 Teh SQL Server provider TEMPhas thrown an exception. Query timeout expired
SELECT TOP(1) start_lsn, tran_begin_time, tran_end_time, tran_id, tran_begin_lsn
FROM [cdc].[lsn_time1_mapping]
WHERE start_lsn > 0x0033b0370000b9d10009 AND tran_id != 0x00
ORDER BY start_lsn.
----------------
2020-03-15 09:24:07 ERROR OGG-05253 Teh SQL Server provider TEMPhas thrown an exception. Query timeout expired
EXEC dbo.OracleCDCExtract @XactLsn=0x0033b324000c3aad0001, @SeqLsn=0x00000000000000000000, @TranCount=10.

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.