| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Database issue |
« View previous topic :: View next topic » |
| Author |
Message
|
| sammy_910 |
 Posted: Tue Jan 04, 2011 5:48 am Post subject: Database issue |
 |
|
Apprentice
Joined: 16 Dec 2010
Posts: 33
|
Hi All,
I am facing this issue when trying to insert values from WMB to Oracle 10g database.
Insert
Type:INTEGER:5
Text:CHARACTER:INSERT INTO Database.MESSAGE_EXCEPTION ( EXCEPTION_ID, IS_MESSAGE_TRUNC, IS_EXCEPTION_TRUNC, MQ_MSG_ID, CORREL_ID, REPLAY_QUEUE, MESSAGE, EXCEPTION, REPLAY_COUNT, QUEUE_NAME, STATUS, ERROR_CODE, PUT_DATE, PUT_TIME ) VALUES (EXCEPTION_ID, IS_MESSAGE_TRUNC, IS_EXCEPTION_TRUNC, MQ_MSG_ID, CORREL_ID, REPLAY_QUEUE, MESSAGE, EXCEPTION_MESSAGE, REPLAY_COUNT, QUEUE_NAME, MSG_STATUS, ERROR_CODE, PUT_DATE, PUT_TIME )
DatabaseException
File:CHARACTER:F:\build\S700_P\src\DataFlowEngine\ImbOdbc.cpp
Line:INTEGER:341
Function:CHARACTER:ImbOdbcHandle::checkRcInner
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2321
Text:CHARACTER:Root SQL exception
Insert
Type:INTEGER:2
Text:CHARACTER:-1
Insert
Type:INTEGER:14
Text:CHARACTER:odbc32.dll
What could be the possible resolution?Request your guidance. |
|
| Back to top |
|
 |
| Vitor |
| Posted: Tue Jan 04, 2011 5:54 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Is this connected to this issue?
What does the rest of the error say? Specifically the SQL error referred to here:
| sammy_910 wrote: |
| Function:CHARACTER:ImbOdbcHandle::checkRcInner |
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| sammy_910 |
| Posted: Tue Jan 04, 2011 7:06 am Post subject: |
|
|
Apprentice
Joined: 16 Dec 2010
Posts: 33
|
Hi Vitor,
It is somehow related.I applied the fixpack 1 on WMB v 7 and now I am getting this error.
The Exceptionlist that I have attached is the last end of the Exception tree. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Jan 04, 2011 7:12 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| sammy_910 wrote: |
| The Exceptionlist that I have attached is the last end of the Exception tree. |
How are you capturing that?
Old advice remains good advice here. Take a user trace & review the additional information that will throw out.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| 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
|
|
|
|
