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 FEBRUARY 23, 2023

Applies to:

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

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