| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Node Stuck in Oracle db calls? |
« View previous topic :: View next topic » |
| Author |
Message
|
| Kjell |
 Posted: Wed Mar 30, 2005 9:20 am Post subject: Node Stuck in Oracle db calls? |
 |
|
Acolyte
Joined: 26 Feb 2002
Posts: 73
|
Hi
A very confusing problem.
Sometimes, at some specific database calls to an Oracle DB from ESQL code (Compute Node) the Flow Debugger is stuck. I can trace to the very db-call inside the node, but then nothing happens. When I run the flow, outside the debugger, the message is rolled back and it's very difficult to trace why this happens.
Other nodes in the flow acces the Oracle db without problems.
Anyone recognising this ?
I'm running WBIMB 5.0, CSDE 02. Win20000. |
|
| Back to top |
|
 |
| JT |
| Posted: Wed Mar 30, 2005 9:42 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
Are you handling your own database errors?
If not, un-check the Compute node property Throw exception on database error, and add ESQL code immediately following the SQL call to interrogate the SQLCODE/SQLNATIVEERROR values. |
|
| Back to top |
|
|
| Kjell |
| Posted: Wed Apr 06, 2005 12:56 am Post subject: |
|
|
Acolyte
Joined: 26 Feb 2002
Posts: 73
|
Sorry, but I did that. No difference.
/K |
|
| Back to top |
|
|
| JT |
| Posted: Wed Apr 06, 2005 6:39 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Quote: |
| When I run the flow, outside the debugger, the message is rolled back and it's very difficult to trace why this happens. |
If all else fails, you could try the various traces available:- Set a user trace (debug) on the message flow level
- Set an odbc trace. 'TRACE=1' in the ODBC stanza of the .odbc.ini file.
|
|
| 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
|
|
|
|
