Query Timeout While Re Sequencing (Doc ID 2285587.1)

Last updated on OCTOBER 09, 2023

Applies to:

Goal

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.