|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
Log/messages not written |
« View previous topic :: View next topic » |
Author |
Message
|
jeeth_m |
Posted: Mon Feb 28, 2005 4:08 pm Post subject: Log/messages not written |
|
|
Voyager
Joined: 21 Jan 2002 Posts: 93
|
Hi,
The messages flow i am using has a database node.
Database node here is used for request reply handling.
Mesg ID and reply Q/Qmgr info is inserted into database when a request message is sent. When the reply comes back it Queries the database based on the Correl ID of reply message(Mesg ID of req copied to Correl ID by back end application) for the reply Q/Qmgr info. Old info is deleted
On certain conditions if the duplicate reply message comes in it will not find the data in database and reply may fail because Query failed to provide any result. Those message will go to failure Queue.
But the reason for failure is not updated in the logs/messages file.
Any idea why it is so and where to find those error logs?
Regards,
jeeth. |
|
Back to top |
|
 |
protocol |
Posted: Tue Mar 01, 2005 12:34 am Post subject: |
|
|
 Apprentice
Joined: 25 Feb 2005 Posts: 41
|
Hi Jeeth,
1) Which platform ?
2) Are you handling the database exceptions or is WMQI/WBIMB handling it ?
3) When you say :
"But the reason for failure is not updated in the logs/messages file"
Have you used a trace nodes to capture the trace ? If so then where have you connected the trace nodes ? Did you use the debug trace ?
Protocol
[/b] |
|
Back to top |
|
 |
JT |
Posted: Tue Mar 01, 2005 6:58 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003 Posts: 1564 Location: Hartford, CT.
|
Quote: |
2) Are you handling the database exceptions or is WMQI/WBIMB handling it ? |
A database query that returns an empty result-set because the query's condition was not satisfied, is not a database exception, nor is it a warning. It's merely an empty resultset, therefore the value of SQLCODE is equal to zero. It is your responsibility to examine the target of the expected resultset to see if it exists.
See the following for details:
http://publib.boulder.ibm.com/infocenter/wbihelp/topic/com.ibm.etools.mft.doc/ac17020_.htm#ac17020_ |
|
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
|
|
|
|