My Oracle Support Banner

Assessment Summary Query Locks User Session and Eventually Times Out (Doc ID 2632038.1)

Last updated on JANUARY 28, 2020

Applies to:

Oracle Utilities Network Management System - Version 2.4.0.1.0 to 2.4.0.1.0 [Release 2.4]
Oracle Network Management for Utilities - DMS - Version 2.4.0.1.0 to 2.4.0.1.0 [Release 2.4]
Information in this document applies to any platform.

Symptoms

On : 2.4.0.1.0 version, Web Workspace


Attempting to open the Assessment Summary on the Trouble Summary.  The dialog locks the user session while querying the database. The query eventually times out and displays an error.

ERROR
-----------------------

3-thread-14] ERROR com.splwg.oms.jbot.DBConnector: DBConnector.executeQuery: query failed: "SELECT a.h_cls, a.h_idx, a.current_status, SUM(NVL(a.length,0)) OVER()/5280 AS all_length, SUM(DECODE(BITAND(16, a.current_status), 16, NVL(a.length,0), 0)) OVER()/5280 AS ass_length FROM network_components a WHERE a.h_cls IN (SELECT c.c_numb c_numb FROM inheritance i, classes c WHERE c.c_name = i.sub_class CONNECT BY PRIOR i.sub_class = i.super_class START WITH c.c_name='conductor') AND a.active IN ('Y', 'A') AND a.ncg IN (SELECT cz.ncg_id FROM control_zones cz, (SELECT czs.child_ncg_id, level FROM control_zone_structures czs WHERE czs.active = 'Y' START with czs.child_ncg_id = 1001 CONNECT BY PRIOR czs.child_ncg_id = czs.parent_ncg_id) c WHERE c.child_ncg_id = cz.ncg_id AND cz.death IS NULL)"
java.lang.reflect.UndeclaredThrowableException: null
at com.sun.proxy.$Proxy19.executeSQLQuery(Unknown Source) ~[?:?]
at com.splwg.oms.client.sql.corba.DBSConnection.executeQuery(DBSConnection.java:54) ~[nms_client.jar:?]
at com.splwg.oms.client.sql.corba.DBSPreparedStatement.executeQuery(DBSPreparedStatement.java:25) ~[nms_client.jar:?]
at com.splwg.oms.jbot.DBConnector.executeQuery(DBConnector.java:49) [nms_client.jar:?]
at com.splwg.oms.jbot.JDBCDataStore.executeQuery(JDBCDataStore.java:542) [nms_client.jar:?]
at com.splwg.oms.jbot.JDBCDataStore.populate(JDBCDataStore.java:613) [nms_client.jar:?]
at com.splwg.oms.jbot.JDBCDataStore.populate(JDBCDataStore.java:593) [nms_client.jar:?]
at com.splwg.oms.jbot.JDBCDataStore.populate(JDBCDataStore.java:582) [nms_client.jar:?]
at com.splwg.oms.client.summary.TroubleSummary.populateAssessmentDatastore(TroubleSummary.java:638) [nms_client.jar:?]
at com.splwg.oms.client.summary.TroubleSummary.loadAssessmentData(TroubleSummary.java:502) [nms_client.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_231]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_231]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_231]
at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_231]
at com.splwg.oms.jbot.command.ToolMethodCommand.execute(ToolMethodCommand.java:50) [nms_client.jar:?]
at com.splwg.oms.jbot.JBotCommand.executeCommand(JBotCommand.java:420) [nms_client.jar:?]
at com.splwg.oms.jbot.CommandProcessor.processCommand(CommandProcessor.java:163) [nms_client.jar:?]
at com.splwg.oms.jbot.CommandProcessor.processPackage(CommandProcessor.java:284) [nms_client.jar:?]
at com.splwg.oms.jbot.adapter.JBotAdapter$1.run(JBotAdapter.java:671) [nms_client.jar:?]
at com.splwg.oms.jbot.adapter.JBotAdapter.processCommands(JBotAdapter.java:681) [nms_client.jar:?]
at com.splwg.oms.jbot.command.ExecuteActionCommand.execute(ExecuteActionCommand.java:105) [nms_client.jar:?]
at com.splwg.oms.jbot.JBotCommand.executeCommand(JBotCommand.java:420) [nms_client.jar:?]
at com.splwg.oms.jbot.CommandProcessor.processCommand(CommandProcessor.java:163) [nms_client.jar:?]
at com.splwg.oms.jbot.CommandProcessor.processPackage(CommandProcessor.java:284) [nms_client.jar:?]
at com.splwg.oms.jbot.adapter.JBotAdapter$1.run(JBotAdapter.java:671) [nms_client.jar:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_231]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_231]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_231]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_231]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_231]
Caused by: weblogic.transaction.internal.TimedOutException: Transaction timed out after 302 seconds
BEA1-6C108F343447CB844C2F

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.