My Oracle Support Banner

Retrieval From Remote Database Link Views Hanging On Query:"BeginRequest failed because of open transaction on connection" (Doc ID 2781502.1)

Last updated on JUNE 12, 2023

Applies to:

Oracle WebLogic Server - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

Retrieval from Remote Database Link views hanging on query when SELECT statement across a database link connect to different version of Database, and this exception "BeginRequest failed because of open transaction on connection" was observed.

DB Topology:      [Oracle 12.1.0.2] <-db-link-> [Oracle 19.6]

Test Result with different DB scenario.

 

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