My Oracle Support Banner

Select a Schema from an Oracle Remote Location Fails with '504 Gateway Time-out' (Doc ID 2900788.1)

Last updated on OCTOBER 07, 2022

Applies to:

Oracle Life Sciences Data Hub - Version 3.2 and later
Information in this document applies to any platform.


On Oracle Life Sciences Data Hub (LSH) 3.2 version,

When attempting to select a schema from an Oracle Remote Location associated with a Load Set,
the following error occurs:

504 Gateway Time-out

If attempting to access again the Load Set, the following error is generated:
"LSH Error :: ORA-20200: *** ERROR: Cdr_Exe_Lock.requestTransactionLockByName - Timed out when locking object: Lock $CDR$3901$4253$DEF is currently in use"

The issue can be reproduced with the following steps:
1. Define a new Oracle Remote Location.
2. Create a new Load Set of type Oracle Tables and Views.
3. Associate the Remote Location with the Load Set.
4. Attempt to browse through Remote Location schemas.


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

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