| Author |
Message
|
| ravilegolas |
 Posted: Wed Jun 19, 2013 8:38 am Post subject: ODBC Error while connecting to Oracle Database |
 |
|
Novice
Joined: 04 Sep 2012
Posts: 15
|
Hi all,
I have a message flow which processes EDIFACT message and inserts records in Oracle Database (Oracle 10g Release 2). In production system, we are getting ODBC connection error while connecting to the remote Oracle database. Please find below the message extracted from trace file:
56 RecoverableException BIP2230E: Error detected whilst processing a message in node '
The message broker detected an error whilst processing a message in node 'ICD1A510FMFeedLoadsheetMapping.InsertDataIntoMDRDB'. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error.
2013-06-18 14:57:00.855829 56 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.
2013-06-18 14:57:00.855835 56 DatabaseException BIP2322E: Database error: SQL State ''08S01''; Native Error Code '0'; Error Text ''[IBM][ODBC 20101 driver]7505''.
The error has the following diagnostic information: SQL State ''08S01'' SQL Native Error Code '0' SQL Error Text ''[b][IBM][ODBC 20101 driver]7505[/b]''
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.
2013-06-18 14:57:00.855840 56 DatabaseException BIP2322E: Database error: SQL State ''21''; Native Error Code '-1'; Error Text ''[IBM][ODBC 20101 driver][20101]11603''.
The error has the following diagnostic information: SQL State ''21'' SQL Native Error Code '-1' SQL Error Text ''[b][IBM][ODBC 20101 driver][20101]11603[/b]''
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.
I have added the database details in odbc.ini file as well as used mqsisetdbparms command on the broker. I executed the same steps in TST system and it worked fine. From the trace file, I found out that the message flow is trying to connect to the database for 5 minutes before throwing the error. If any one has faced such problem, can you please throw some light in how to solve this problem. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Jun 19, 2013 9:02 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Tell your broker adminstrator that he or she created the ODBC DSN incorrectly in the odbc.ini file. |
|
| Back to top |
|
|
| ravilegolas |
| Posted: Wed Jun 19, 2013 10:58 am Post subject: |
|
|
Novice
Joined: 04 Sep 2012
Posts: 15
|
| Thanks for the suggestion. I will definitely check odbc.ini file again. Will we get this error if oracle driver is corrupted? |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Jun 19, 2013 10:59 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| ravilegolas wrote: |
| Will we get this error if oracle driver is corrupted? |
Is this a trick question?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jun 19, 2013 11:00 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| You only get this error if the odbc.ini is wrong. |
|
| Back to top |
|
|
| yellowbee |
| Posted: Wed Jun 19, 2013 12:38 pm Post subject: |
|
|
Acolyte
Joined: 14 Apr 2012
Posts: 58
|
| If it is a Oracle database then you have to add configuration details in Tnsnames.ora file. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jun 19, 2013 1:05 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| yellowbee wrote: |
| If it is a Oracle database then you have to add configuration details in Tnsnames.ora file. |
assuming you have used the odbc.ini to indicate that the DataDirect driver should use the tnsnames.ora file. |
|
| Back to top |
|
|
| Tibor |
| Posted: Fri Jun 21, 2013 4:29 am Post subject: |
|
|
Grand Master
Joined: 20 May 2001
Posts: 1033
Location: Hungary
|
| Quote: |
| DatabaseException BIP2322E: Database error: SQL State ''08S01'' |
It seems very strange for me, because SQLState 08S01 is an MS SQL Server error code.
Not true, it was my mistake... this is a generic ODBC error. |
|
| Back to top |
|
|
|
|
