My Oracle Support Banner

Query Timeout While Re Sequencing (Doc ID 2285587.1)

Last updated on FEBRUARY 26, 2019

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

**Disclaimer:** This KM article may include the following abbreviations:

CCB - Oracle Utilities Customer Care and Billing
OUAF/FW - Oracle Utilities Framework
PFD - Product Fix Design

 

On CCB v2.3.1, 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 = .............. 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)
..................................
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

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.