My Oracle Support Banner

STUCKTHREAD[BEA-000337] Reccurred In /ouaf/pageRead (Doc ID 2756916.1)

Last updated on OCTOBER 30, 2023

Applies to:

Oracle Utilities Meter Data Management - Version and later
Information in this document applies to any platform.


On : version, Database

STUCKTHREAD[BEA-000337] reccurred in /ouaf/pageRead

At 17:37:51, 2021/01/03, the error of STUCKTHREAD[BEA-000337] reccurred in /ouaf/pageRead of /ouaf/pageRead..
- It seems to have ended normally at 17:56:53 according to the access log.
- It’s assumed that it was caused due to prolongation of SQL:cy50ryx7yb3mv(INST:3/SESSION:3138,#54243) executed at 17:27:36 based on ASH.

1. Since SQL:cy50ryx7yb3mv is a process of Zone 'D1-RETCC', and is TABLE ACCESS FULL, it’s considered inefficient. Please confirm if our understanding of the situation is correct based on the attached log file. and In case of changing the timeout value of the relevant process including the previous event, is it correct to change as ouaf.timeout.service.DataExplorerService of =(current value:1800)

 2.If our understanding is correct, please specifically tell us at which UI operation this zone D1-RETCC did the error occurred.

  FROM d1_activity act, d1_activity_type at
  WHERE act.activity_type_cd = at.activity_type_cd
  AND at.activity_type_cat_flg = 'D1CR'
  AND act.cre_dttm IS NOT NULL
  /* SQL for Zone 'D1-RETCC' */ /* com.splwg.base.web.dataExplorer.common.DataExplorerSQLExecuter */


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.