My Oracle Support Banner

Goldengate SQLServer Initial Load Extract With SQLEXEC Gives "Connection Is Busy" Error. (Doc ID 2709478.1)

Last updated on SEPTEMBER 24, 2020

Applies to:

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

Goal

 In Goldengate for SQL Server,  adding any SQLEXEC to a table during an initial load, will result in multiple

"WARNING OGG-00869  [Microsoft][ODBC Driver 17 for SQL Server]Connection is busy with results for another command (native error 0)."

and the query will fail intermittently, and results are unavailable to assign to a TOKEN.

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
References


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