ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Log/messages not written

Post new topic  Reply to topic
 Log/messages not written « View previous topic :: View next topic » 
Author Message
jeeth_m
PostPosted: Mon Feb 28, 2005 4:08 pm    Post subject: Log/messages not written Reply with quote

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
View user's profile Send private message Yahoo Messenger MSN Messenger
protocol
PostPosted: Tue Mar 01, 2005 12:34 am    Post subject: Reply with quote

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
View user's profile Send private message
JT
PostPosted: Tue Mar 01, 2005 6:58 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Log/messages not written
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.