| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Message routed to failure terminal in Db Insert Node |
« View previous topic :: View next topic » |
| Author |
Message
|
| mkhadse |
 Posted: Fri Mar 01, 2002 1:41 pm Post subject: |
 |
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
Hi,
I am storing the Input XML file into DB2 database using DB Insert Node.
One of the messages got routed to the failure terminal of the database insert node.
I have checked the system log, db2alert.log and db2diag.log. But there is no indication of a database error at the time the message was processed.
The table in which the XML is being inserted doesn't have a primary key, therefore there is no question of primary key violation. MQSI and the db2 database is running on an AIX box.
Does anybody have an idea, under what circumstances the message will be routed to a failure node?
Thanks in advance
|
|
| Back to top |
|
 |
| kirani |
| Posted: Fri Mar 01, 2002 2:31 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Hi,
Your message will porpagate to failure terminal if,
(text from Control Center help)
"A failure is detected during the computation. If you have checked 'Treat warnings as errors' on the node properties, database warning messages will cause the message to be propagated to this node even though the processing might have completed successfully."
Did you check your event viewer/system log for any error message? Can you run this test again? IF so, try printing ExceptionList in a trace node.
Regards,
Kiran
|
|
| Back to top |
|
|
| mkhadse |
| Posted: Fri Mar 01, 2002 3:58 pm Post subject: |
|
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
I did check the system log and there were no errors/warmining/information message in it.
I cannot reproduce this scenario. It has happened in production environment the first time in 3-4 months.
Are there any DB2 logs that might have any information on why this might have happened? |
|
| Back to top |
|
|
| mkhadse |
| Posted: Fri Mar 01, 2002 3:59 pm Post subject: |
|
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
Forgot to add:
'Treat warnings as error' checkbox is not checked. |
|
| 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
|
|
|
|
