|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
![Reply to topic](templates/DAJ_Glass/images/lang_english/reply.gif) |
|
how to catch an ODBC Error and process the message into a di |
« View previous topic :: View next topic » |
Author |
Message
|
artham |
Posted: Fri Apr 05, 2002 7:29 am Post subject: |
|
|
Novice
Joined: 13 Feb 2002 Posts: 12
|
for a message getting processed throgh a flow we use ODBC to talk to Oracle 8.1.6 I get an error saying
2002-04-05 12:25:07.436999 744 Error BIP2628E: Exception condition detected on input node 'X'.
The input node 'X' detected an error whilst processing a message. The message flow has been rolled-back and, if the message was being processed in a unit of work, it will remain on the input queue to be processed again. Following messages will indicate the cause of this exception.
Check the error messages which follow to determine why the exception was generated, and take action as described by those messages.
2002-04-05 12:25:07.436999 744 DatabaseException BIP2321E: Database error: ODBC return code '-1'.
The message broker encountered an error whilst executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database pertaining to this error.
Use the following messages to determine the cause of the error. This is likely to be such things as incorrect datasource or table names. Then correct either the database or message broker configuration.
2002-04-05 12:25:07.436999 744 DatabaseException BIP2322E: Database error: SQL State 'HY000'; Native Error Code '3114'; Error Text '[Oracle][ODBC][Ora]ORA-03114: not connected to ORACLE
'.
The error has the following diagnostic information: SQL State 'HY000' SQL Native Error Code '3114' SQL Error Text '[Oracle][ODBC][Ora]ORA-03114: not connected to ORACLE
'
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.
2002-04-05 12:25:07.639999 744 Error BIP2628E: Exception condition detected on input node 'X'.
The input node 'X' detected an error whilst processing a message. The message flow has been rolled-back and, if the message was being processed in a unit of work, it will remain on the input queue to be processed again. Following messages will indicate the cause of this exception.
Check the error messages which follow to determine why the exception was generated, and take action as described by those messages.
2002-04-05 12:25:07.639999 744 DatabaseException BIP2321E: Database error: ODBC return code '-1'.
The message broker encountered an error whilst executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database pertaining to this error.
Use the following messages to determine the cause of the error. This is likely to be such things as incorrect datasource or table names. Then correct either the database or message broker configuration.
2002-04-05 12:25:07.639999 744 DatabaseException BIP2322E: Database error: SQL State 'HY000'; Native Error Code '3114'; Error Text '[Oracle][ODBC][Ora]ORA-03114: not connected to ORACLE
'.
The error has the following diagnostic information: SQL State 'HY000' SQL Native Error Code '3114' SQL Error Text '[Oracle][ODBC][Ora]ORA-03114: not connected to ORACLE
MY QUESTION IS:
how do I catch an error like this in the Compute NODE and process it through an error handling process to a different queue.
|
|
Back to top |
|
![](templates/DAJ_Glass/images/spacer.gif) |
kirani |
Posted: Fri Apr 05, 2002 8:53 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001 Posts: 3779 Location: Torrance, CA, USA
|
If you are using WMQI 2.1, you can make use of SQLCODE, SQLSTATE, SQLERRORTEXT and SQLNATIVEERROR vairables to check for appropriate error codes.
If you are using lower version of WMQI, supportpac IAOJ maye be useful to you. It can be downloaded from url,
http://www-3.ibm.com/software/ts/mqseries/txppacs/txpm2.html
|
|
Back to top |
|
![](templates/DAJ_Glass/images/spacer.gif) |
artham |
Posted: Fri Apr 05, 2002 12:59 pm Post subject: |
|
|
Novice
Joined: 13 Feb 2002 Posts: 12
|
thanks kiran I think this will solve my problem I am going through it.
|
|
Back to top |
|
![](templates/DAJ_Glass/images/spacer.gif) |
|
|
![Reply to topic](templates/DAJ_Glass/images/lang_english/reply.gif) |
|
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
|
|
|
|