My Oracle Support Banner

Getting SQL Error code 000099997 In XAI Service In Upgraded CCB 2.5.0.2. (Doc ID 2495139.1)

Last updated on JANUARY 17, 2019

Applies to:

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

Goal

On : 2.5.0.2.0 version, XAI - XAI

Getting error in XAI service in upgraded CCB 2.5.0.2 local system.

User upgrading CCB from 2.3 to CCB 2.5.0.2
After applying Various Framework and Application patches in local systems, we were testing the functionality of 2.3 in upgraded 2.5.0.2 local system , but while testing in CCB 2.5.0.2 local system , the XAI Service CASE which has BASE as adapter , SERVICE NAME = CILQCASP and REQUEST SCHEMA = Case.xsd is throwing the error in response which is attached, whereas the same service is running perfectly fine in CCB 2.3.

xai.trc file has:

****Response At: 2019-01-08T16:07:18.160+0530 OH\1 Origin IP:172.16.1.51 user: SYSUSER XML length:4413
<?xml version="1.0" ?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body >
<soapenv:Fault  >
<faultcode>soapenv:Client</faultcode>
<faultstring>Client Error</faultstring>
<detail>
<ouaf:Fault xmlns:ouaf="http://ouaf.oracle.com/">
<ResponseStatus>F</ResponseStatus>
<ResponseCode>2013</ResponseCode>
<ResponseText>Error while executing the request:
(Server Message)
Category: 8
Number: 3
Call Sequence: ;CIPZCTJN;CIPQEZZJ;CIPQEZZN;CIPQCCSN;CIPQCASP
Program Name: CIPZCTJN
Text: SQL Error code 000099997 occurred in module CIPMFHLX:XQ010 OPEN
Description: Please contact your system administrator.
Table:
Field: </ResponseText>
<ResponseData number="3"  numParm="2"  text="SQL Error code 000099997 occurred in module CIPMFHLX:XQ010 OPEN"  category="8"  parm1="000099997"  parm2="CIPMFHLX:XQ010 OPEN"  />
<ServerMessage>
  <Category>8</Category>
  <Number>3</Number>
  <CallSequence>;CIPZCTJN;CIPQEZZJ;CIPQEZZN;CIPQCCSN;CIPQCASP</CallSequence>
  <ProgramName>CIPZCTJN</ProgramName>
  <Text>SQL Error code 000099997 occurred in module CIPMFHLX:XQ010 OPEN</Text>
  <Description>Please contact your system administrator.</Description>
  <Table></Table>
  <Field></Field>
</ServerMessage>
</ouaf:Fault>
</detail>
</soapenv:Fault>
</soapenv:Body >
</soapenv:Envelope>

****Error At: 2019-01-08T16:07:18.160+0530 OH\1 Origin IP:172.16.1.51 user: SYSUSER XML length:4413 Error Number:2013

Error while executing the request:
(Server Message)
Category: 8
Number: 3
Call Sequence: ;CIPZCTJN;CIPQEZZJ;CIPQEZZN;CIPQCCSN;CIPQCASP
Program Name: CIPZCTJN
Text: SQL Error code 000099997 occurred in module CIPMFHLX:XQ010 OPEN
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


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