Query Timeout While Re Sequencing

(Doc ID 2285587.1)

Last updated on JULY 13, 2017

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.3.1 to 2.3.1 [Release 2.3]
Information in this document applies to any platform.

Goal

On : CCB 2.3.1 version, ENV - Environment

Query Timeout while re sequencing

ERROR
-----------------------
ERROR (support.cobol.DBLocalCobolSQLProcessBackend) Error executing SQL Select with SQL:
'SELECT 'X' FROM CI_PREM PR WHERE PR.PREM_ID = ? AND (EXISTS (SELECT 'X' FROM CI_SA_SP SASP2 , CI_SA SA , CI_SP SP3 WHERE SP3.PREM_ID = ? AND SP3.SP_ID = SASP2.SP_ID AND SASP2.SA_ID = SA.SA_ID AND EXISTS (SELECT 'X' FROM CI_ACCT AC WHERE AC.ACCT_ID = SA.ACCT_ID AND AC.ACCESS_GRP_CD IN (SELECT AG.ACCESS_GRP_CD FROM CI_USR_ACC_GRP_VW AG WHERE AG.USER_ID = ?))) OR NOT EXISTS (SELECT 'X' FROM CI_SP SP , CI_SA_SP SASP WHERE SP.PREM_ID = ? AND SASP.SP_ID = SP.SP_ID))' with bind parameters:
Parameter 1 (Char)'8721404966'
Parameter 2 (Char)'8721404966'
Parameter 3 (Char)'TW000004'
Parameter 4 (Char)'8721404966'
with last row return values:

com.splwg.shared.common.ApplicationError: (Server Message)
Category: 11001
Number: 409
Call Sequence:
Program Name: StandardMessages$1
Text: Query timed out.
Description:
Table: null
Field: null
at com.splwg.base.support.service.TransactionTimeoutHelper.getTTL(TransactionTimeoutHelper.java:115)
at com.splwg.base.support.service.TransactionTimeoutHelper.setTimeout(TransactionTimeoutHelper.java:49)
at com.splwg.base.support.cobol.DBLocalCobolSQLProcessBackend.prepareSQLWithExistingStatement(DBLocalCobolSQLProcessBackend.java:812)
at com.splwg.base.support.cobol.DBLocalCobolSQLProcessBackend.prepareSQL(DBLocalCobolSQLProcessBackend.java:796)
at com.splwg.base.support.cobol.DBLocalCobolSQLProcessBackend.doSQLSelect(DBLocalCobolSQLProcessBackend.java:296)
at com.splwg.base.support.cobol.host.command.SimpleCobolSQLCommand.invoke(SimpleCobolSQLCommand.java:160)
at com.splwg.base.support.cobol.host.PerformCommandExecuter.invoke(PerformCommandExecuter.java:68)
at com.splwg.base.support.cobol.host.OptimizedRemoteExecuterSkel$RequestSocketReader.readRequestExecuteAndRespond(OptimizedRemoteExecuterSkel.java:167)
at com.splwg.base.support.cobol.host.OptimizedRemoteExecuterSkel$RequestSocketReader.run(OptimizedRemoteExecuterSkel.java:101)
at com.splwg.base.support.cobol.host.SocketThreadPool$WrappingParentRunnable.run(SocketThreadPool.java:204)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Thread.java:811)
TW000004 - 358020-4138-1 2016-09-02 14:53:37,406 [WebContainer : 51] INFO (support.context.FrameworkSession) (Server Message)
Category: 3
Number: 501
Call Sequence: ;CIPCSPPR
Program Name: CIPCSPPR
Text: You are not allowed access (directly/indirectly) to this account.
Description: Please contact your security administrator to check your security for this account.
Table:
Field:

STEPS
-----------------------
Steps to Renumber Service Route Sequences:
1. Access the resequence screen by opening the meter read menu from the Main Menu:
2. Identify the route you want to resequence
a. Select the Service Cycle.
b. Click the binoculars to access the available service routes.
3. Select the route you will resequence.
4. Complete the necessary fields.
5. Final step is to click renumber.


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms