My Oracle Support Banner

The 000099997 SQL Error Is A Timeout, It Appears The Transaction Is Long Running To Update A Record (Doc ID 2875047.1)

Last updated on MAY 02, 2024

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.6.0.1.0 and later
Information in this document applies to any platform.

Goal

On : 2.6.0.1.0 version, ENV - Environment

Unable to Generate Bill in SP1

We are unable to generate the bill in SP1, and getting the below error:

SQL Error code 000099997 occurred in module CIPBBLLR: XQ040 CHANGE

Please contact your system administrator.

ERROR:
--------------
IT520261 - 571867-5854-1 2022-04-11 13:50:45,783 [[ACTIVE] ExecuteThread:
'2' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR
(program.sql.AbstractSQLWrapper) Error in sql 'U_ROW' in Program
com.splwg.ccb.domain.billing.bill.entity.ProgramCIPBBLLR_Impl
java.lang.NullPointerException: null

IT520261 - 571867-5854-1 2022-04-11 13:50:45,875 [[ACTIVE] ExecuteThread:
'2' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO
(support.context.FrameworkSession) (Server Message)
Category: 6
Number: 3
Call Sequence: ;CIPZCTJN;CIPBNZZJ;CIPBNZZN;CIPBBILC;CIPBBILO;CIPBBLLP
Program Name: CIPZCTJN
Text: SQL Error code 000099997 occurred in module CIPBBLLR: XQ040 CHANGE
Description: Please contact your system administrator.
Table:
Field:
 

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.