| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Root SQL exception:AIX 5.3 (Message Broker Database Connect) |
« View previous topic :: View next topic » |
| Author |
Message
|
| Vinayak.Satapute |
 Posted: Fri May 21, 2010 1:28 am Post subject: Root SQL exception:AIX 5.3 (Message Broker Database Connect) |
 |
|
Acolyte
Joined: 20 Dec 2006
Posts: 70
|
Hi All,
I am facing the following error when my message broker flow is trying to retrieve some records by connecting to the database.
The message broker(6.1.0.2) and IBM DB2(8.3) are both present on same server.
I have already set .odbc.ini / .odbc64.ini files with appropriate datasource details. (Strange part is, this same arrangement works correctly on our Development server with similar settings but when we moved to test on Test server, we started facing this following error.)
****************************************
<ErrorMessage><ExceptionNumber>2322</ExceptionNumber><ExceptionList><RecoverableException><File>/build/S610_P/src/DataFlowEngine/ImbComputeNode.cpp</File><Line>464</Line><Function>ImbComputeNode::evaluate</Function><Type>ComIbmComputeNode</Type><Name>MF_MBRK_RMG_Monitor#FCMComposite_1_4</Name><Label>MF_MBRK_RMG_Monitor.RetriveB2BDB</Label><Catalog>BIPv610</Catalog><Severity>3</Severity><Number>2230</Number><Text>Caught exception and rethrowing</Text><DatabaseException><File>/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp</File><Line>327</Line><Function>ImbOdbcHandle::checkRcInner</Function><Type></Type><Name></Name><Label></Label><Catalog>BIPv610</Catalog><Severity>3</Severity><Number>2321</Number><Text>Root SQL exception</Text><Insert><Type>2</Type><Text>-1</Text></Insert><DatabaseException><File>/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp</File><Line>456</Line><Function>ImbOdbcHandle::checkRcInner</Function><Type></Type><Name></Name><Label></Label><Catalog>BIPv610</Catalog><Severity>3</Severity><Number>2322</Number><Text>Child SQL exception</Text><Insert><Type>5</Type><Text>82</Text></Insert><Insert><Type>2</Type><Text>0</Text></Insert><Insert><Type>5</Type><Text>523 80</Text></Insert></DatabaseException></DatabaseException></RecoverableException></ExceptionList></ErrorMessage>
********************************************
Appreciate your help.
Regards,
Vinayak |
|
| Back to top |
|
 |
| wschutz |
| Posted: Fri May 21, 2010 1:54 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
|
| Back to top |
|
|
| Vinayak.Satapute |
| Posted: Fri May 21, 2010 2:43 am Post subject: |
|
|
Acolyte
Joined: 20 Dec 2006
Posts: 70
|
Hey thanks for the link you gave!
It is exactly the same issue I was having. Unfortunately the issue was due to corrupted .odbc.ini file, hence the error.
Finally, we could able to solve it, after we created the fresh file of .odbc.ini under /var/mqsi/odbc with driver relevant odbc driver details.
Regards,
Vinayak |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
