| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Store procedure failing, can't catch the actual error. |
« View previous topic :: View next topic » |
| Author |
Message
|
| schroederms |
 Posted: Fri Jun 08, 2007 3:58 am Post subject: Store procedure failing, can't catch the actual error. |
 |
|
Disciple
Joined: 21 Jul 2003
Posts: 169
Location: IA
|
How do you catch the error from a stored procedure? The failure node is wired on the compute node calling the stored procedure, however the error is not caught here, and the message gets thrown into the failure node wired off the input queue. The ExceptionList message just has a dequeue message, if I look into the mqsi.log file I see the error that was thrown, but I can not see that error
this is what I see in the flow:
(
(0x01000000):RecoverableException = (
(0x03000000):File = '/build/S600_P/src/DataFlowEngine/ImbMqInputNode.cpp'
(0x03000000):Line = 1808
(0x03000000):Function = 'ImbCommonInputNode::eligibleForBackout'
(0x03000000):Type = 'ComIbmMQInputNode'
(0x03000000):Name = 'EAI_PRISM_TRIAL_UPDATE#FCMComposite_1_1'
(0x03000000):Label = 'EAI_PRISM_TRIAL_UPDATE.EAI_PRISM_TRIAL_UPDATE'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2652
(0x03000000):Text = 'Dequeued failed message. Propagating a message to the failure terminal'
)
)
THIS IS WHAT I SEE IN THE WQSI.LOG (this is what I see and want to catch and do something with it).
Jun 8 06:56:00 sw29 user:err|error WebSphere Broker v6003[746492]: (BKPC1Q002.PRISM)[10024]BIP2322E: Database error: SQL State 'HY0
00'; Native Error Code '515'; Error Text '[DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]Attempt to insert NULL value int
o column 'txid', table 'PRISMDB1.dbo.pi_delete'; column does not allow nulls. Update fails. '. : BKPC1Q002.30659f54-1001-0000-0080-9
6883c8bbe8e: /build/S600_P/src/DataFlowEngine/ImbOdbc.cpp: 355: ImbOdbcHandle::checkRcInner: :
Jun 8 06:56:00 sw29 user:err|error WebSphere Broker v6003[746492]: (BKPC1Q002.PRISM)[10024]BIP2322E: Database error: SQL State '010
00'; Native Error Code '3621'; Error Text '[DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]Command has been aborted. '. :
BKPC1Q002.30659f54-1001-0000-0080-96883c8bbe8e: /build/S600_P/src/DataFlowEngine/ImbOdbc.cpp: 355: ImbOdbcHandle::checkRcInner: :
 |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Jun 08, 2007 4:03 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Try/Catch.
Or use the new error handlers in ESQL to catch and react to the SQLERROR.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mgk |
| Posted: Fri Jun 08, 2007 4:06 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
What is the setting of the "Treat Errors as Warnings" and "Throw Exceptions on DB Errors" properties on the Compute node? If the later of these is not ticked, then you will not see the exception!
Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Fri Jun 08, 2007 4:33 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Hi
what is this error all about
insert NULL value int
o column 'txid', table 'PRISMDB1.dbo.pi_delete'; column does not allow nulls. Update fails. '. : BKPC1Q002.30659f54-1001-0000-0080-9
Thanks and Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| 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
|
|
|
|
