| Author |
Message
|
| raghubegur |
 Posted: Tue Jun 13, 2006 7:56 am Post subject: SQL Exception |
 |
|
Apprentice
Joined: 15 Jul 2002
Posts: 45
|
Hi,
We have just moved our code into our TEST environment.
The first line of code where we access database using a SELECT statement throws this exception.
| Quote: |
[2230 -- Caught exception and rethrowing][2321 -- Root SQL ex
ception] : -1[2322 -- Child SQL exception] : 82 : 0 : 523 80
|
We do not have this issue in our DEV envt.
There is no code difference between the 2 environments.
This could be due to DB2 set up on TEST envt. We have a couple of application tables created and populated.
Any idea what could be wrong ?
Thanks,
Raghu |
|
| Back to top |
|
 |
| JT |
| Posted: Tue Jun 13, 2006 8:16 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Can you capture the entire ExceptionList and post the contents here ? |
|
| Back to top |
|
|
| raghubegur |
| Posted: Tue Jun 13, 2006 10:37 am Post subject: SQL Exception |
|
|
Apprentice
Joined: 15 Jul 2002
Posts: 45
|
Here is the complete exception list.
| Quote: |
(0x01000000):RecoverableException = (
(0x03000000):File = '/build/S000_P/src/DataFlowEngine/ImbComputeNode.cpp'
(0x03000000):Line = 464
(0x03000000):Function = 'ImbComputeNode::evaluate'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'CCC_ProcessAccountRequest#FCMComposite_1_14.ESB_LoggingFlow#FCMComposite_1_1'
(0x03000000):Label = 'CCC_ProcessAccountRequest.ESB_LogInboundRequest.PrepareLogMsg'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x03000000):Text = 'Caught exception and rethrowing'
(0x01000000):DatabaseException = (
(0x03000000):File = '/build/S000_P/src/DataFlowEngine/ImbOdbc.cpp'
(0x03000000):Line = 232
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2321
(0x03000000):Text = 'Root SQL exception'
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '-1'
)
(0x01000000):DatabaseException = (
(0x03000000):File = '/build/S000_P/src/DataFlowEngine/ImbOdbc.cpp'
(0x03000000):Line = 360
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2322
(0x03000000):Text = 'Child SQL exception'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '82'
)
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '0'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '523 80'
)
)
)
Thanks,
Raghu
|
_________________
Cheers
Raghu |
|
| Back to top |
|
|
| JT |
| Posted: Tue Jun 13, 2006 11:19 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
In case you didn't know, the hilighted value:
| Quote: |
(0x01000000):DatabaseException = (
(0x03000000):File = '/build/S000_P/src/DataFlowEngine/ImbOdbc.cpp'
(0x03000000):Line = 360
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2322
(0x03000000):Text = 'Child SQL exception'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '82'
)
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '0'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '523 80'
)
)
) |
translates into this:
| Quote: |
BIP2322
Severity
20 : Error
Message
Database error: SQL State '<insert_0>'; Native Error Code '<insert_1>'; Error Text '<insert_2>'.
Explanation
The error has the following diagnostic information: SQL State '<insert_0>' SQL Native Error Code '<insert_1>' SQL Error Text '<insert_2>'
Response
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.
|
Were there any accompanying messages ? |
|
| Back to top |
|
|
| raghubegur |
| Posted: Tue Jun 13, 2006 11:32 am Post subject: SQL Exception |
|
|
Apprentice
Joined: 15 Jul 2002
Posts: 45
|
Hi,
I have already looked up in the manual for '2322'
I need help interpreting that.
And, this is the SELECT query :
| Quote: |
SET CacheBrokerParmsTable.Parms[] = (SELECT T.PARM_VALUE, T.PARM_NAME FROM Database.xxx.yyyy AS T);
|
The table has 2 rows.
_________________
Cheers
Raghu |
|
| Back to top |
|
|
| JT |
| Posted: Tue Jun 13, 2006 11:47 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Check db2diag.log for additional information. |
|
| Back to top |
|
|
| wacollin |
| Posted: Tue Jun 13, 2006 3:00 pm Post subject: check the odbc.ini file |
|
|
Newbie
Joined: 24 Jun 2001
Posts: 3
Location: Sunny Florida
|
Your problem is in your odbc.ini file. I had this problem once before, check the path for your
Driver=/home/db2inst1/sqllib/lib/libdb2.a
should point to the valid db2 lib.
If DB2 is installed diffrently between environments you will see this error. |
|
| Back to top |
|
|
| raghubegur |
| Posted: Tue Jun 13, 2006 3:07 pm Post subject: SQL Exception |
|
|
Apprentice
Joined: 15 Jul 2002
Posts: 45
|
Wayne,
That was my problem. It is resolved now.
Thanks.
_________________
Cheers
Raghu |
|
| Back to top |
|
|
| akbardar |
| Posted: Fri Jan 31, 2014 7:16 am Post subject: Child SQL exception - 2322 |
|
|
Novice
Joined: 05 Apr 2006
Posts: 21
Location: New Haven, CT
|
I read that thread where Ragu was having issue selecting. I have similar problem, my insert fails sometimes. I have a Oracle database. Can you recomend the Lib? My pat is as followed:
LIBPATH=/uxpm203/sapjco:/uxpm201/app/oracle/product/10.2.0/client_1/lib:/opt/IBM/mqsi/6.1/jre15/ppc64/bin:/opt/IBM/mqsi/6.1/jre15/ppc64/bin/classic:/usr/mqm/java/lib64:/opt/IBM/mqsi/6.1/xml4c/lib64:/usr/mqm/lib64:/opt/IBM/mqsi/6.1/ODBC64/V5.3/lib:/opt/IBM/mqsi/6.1/xlxpc/lib64:/opt/IBM/mqsi/6.1/lib:/opt/IBM/mqsi/6.1/bin:/usr/java5/jre/bin/classic:/usr/java5/jre/bin:/opt/CA/SharedComponents/lib:/opt/IBM/wsdtx/libs
MQSI_LIBPATH32=/opt/IBM/mqsi/6.1/jre15/bin:/opt/IBM/mqsi/6.1/jre15/bin/classic:/usr/mqm/java/lib:/opt/IBM/mqsi/6.1/xml4c/lib:/usr/mqm/lib:/opt/IBM/mqsi/6.1/ODBC32/V5.3/lib:/opt/IBM/mqsi/6.1/xlxpc/lib
ODBCINI=/opt/IBM/mqsi/6.1/ODBC64/V5.3/odbc64.ini
_________________
AkBar Dar
IT Administrator |
|
| Back to top |
|
|
|
|
