CCB RunSQL Error 99997 Is Produced When Run: TD-BSERR, TD-NOMR (Doc ID 736326.1)

Last updated on JULY 14, 2010

Applies to:

Oracle Utilities Customer Care and Billing - Version: 2.2.0.0 and later   [Release: 2.2 and later ]
Information in this document applies to any platform.

Symptoms

SQL error 99997 is produced when run: TD-BSERR, TD-NOMR

See the following error in log:

15:40:27,734 [Parent Reader:Thread-128] INFO (com.splwg.base.support.context.FrameworkSession) Issuing flush
15:40:27,750 [Parent Reader:Thread-126] INFO (com.splwg.base.support.cobol.DBLocalCobolSQLProcessBackend) do SQLCursorFetch
15:40:27,751 [Parent Reader:Thread-126] ERROR (com.splwg.base.support.cobol.DBLocalCobolSQLProcessBackend) Error fetching from cursor(sql is blank!?) with bind parameters:
with last row return values:

java.lang.NullPointerException
at com.splwg.base.support.cobol.DBLocalCobolSQLProcessBackend.executeSQLGetNext(DBLocalCobolSQLProcessBackend.java:801)
at com.splwg.base.support.cobol.DBLocalCobolSQLProcessBackend.privateDo SqlCursorFetch(DBLocalCobolSQLProcessBackend.java:392)
at com.splwg.base.support.cobol.DBLocalCobolSQLProcessBackend.do SQLCursorFetch(DBLocalCobolSQLProcessBackend.java:378)
at com.splwg.base.support.cobol.host.command.SimpleCobolSQLCommand.invoke(SimpleCobolSQLCommand.java:113)
at com.splwg.base.support.cobol.host.PerformCommandExecuter.invoke(PerformCommandExecuter.java:68)
at com.splwg.base.support.cobol.host.OptimizedRemoteExecuterSkel$RequestSocketReader.readRequestExecuteAndRespond(OptimizedRemoteExecuterSkel.java:113)
at com.splwg.base.support.cobol.host.OptimizedRemoteExecuterSkel$RequestSocketReader.run(OptimizedRemoteExecuterSkel.java:78)
at com.splwg.base.support.cobol.host.SocketThreadPool$WrappingParentRunnable.run(SocketThreadPool.java:164)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Thread.java:801)



Cause

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