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 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.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.
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 */
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