| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ODBC Connection Errors |
« View previous topic :: View next topic » |
| Author |
Message
|
| nomadic78 |
 Posted: Thu Dec 18, 2014 7:57 am Post subject: ODBC Connection Errors |
 |
|
Newbie
Joined: 18 Dec 2014
Posts: 2
|
Hi all,
I am a PM on a MQ project and we are encountering the following issues which are halting our testing:
Error Message : Child SQL exception, 23000, [IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-00001: unique constraint (CARDLOOKUP.LOOKUPS_U2) violated ORA-06512: at "IIB.LOOKUP", line 135 ORA-06512: at line 1
Error : Child SQL exception, HY000, [IBM][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.
Error : Child SQL exception, 22001, [IBM][ODBC Oracle Wire Protocol driver]String data, right truncated. Error in parameter 2.
Any help I would appreciate. My background is infrastructure, not much experience with MQ or middleware.
Thanks |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Thu Dec 18, 2014 7:59 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
These are three separate errors.
For the first one, you are attempting to insert a duplicate row into a table, or attempting to insert a new row into a table with a duplicate set of index values.
For the second one, something happened to interrupt the connection between the broker runtime and the database.
For the third one, you attempted to read more data than could fit into the field you were trying to put the data into. |
|
| Back to top |
|
|
| nomadic78 |
| Posted: Thu Dec 18, 2014 8:03 am Post subject: |
|
|
Newbie
Joined: 18 Dec 2014
Posts: 2
|
Thanks,
Problem 2 is causing the most pain. How can we diagnose this particular issue to pinpoint. |
|
| 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
|
|
|
|
