My Oracle Support Banner

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

Last updated on MARCH 03, 2021

Applies to:

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

Goal

On : 2.2.0.3.0 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 spl.properties.service.template =(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.

[sql:cy50ryx7yb3mv]
 SELECT ACT.CRE_DTTM, ACT.D1_ACTIVITY_ID, ACT.BUS_OBJ_CD BO_CD, ACT.BO_STATUS_CD
  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
  AND ACT.CRE_DTTM <= :1
  /* SQL for Zone 'D1-RETCC' */ /* com.splwg.base.web.dataExplorer.common.DataExplorerSQLExecuter */
 

Solution

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