My Oracle Support Banner

E1: JAS: GRID: Long Running Searches Cause Application Screen to Freeze [MS_SQL_QUERY_TIMEOUT] [RESULT_SET_TIMED_OUT] (Doc ID 2784359.1)

Last updated on JUNE 16, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Long running searches cause application screen to freeze. 

In several custom applications, user experience situations where the query(s) run in the background, but appear to exceed some timeout threshold. When this happens, the application screen freezes and does not progress to the next screen.

If the user toggles between another application, Work with Submitted Jobs (WSJ) for example, then returns to the original screen, it does allow the screen to progress.

The following errors are seen in the e1root log:

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.