Monitoring a JMS queue (on ORACLE) for errors

[robbinma]

Hello,

Is it possible to automatically monitor the incoming continuous queue in Maximo 6.2
I would like to monitor the queue and identify the number of messages with errors?
In my setup the JMS queue uses an ORACLE database as a data store for the queue.

I know that the table sib001 contains records for items in the queue.

I have a situation where a number of incoming messages have errors and the queue stops if there are too many errors.

I would like to have an automatic process that reads the queue and checks the number of messages with errors.
I can then build an alerter that will let me know so I can move/manage the messages as necessary.

Mark

[robbinma]

The quick answer to this is no.
There is no way of doing this purely from ORACLE.

The best way to do this is as follows:
Open the Websphere admin front-end.
Looking at each message in turn:
check the creation timestamp
See if that is different from the same day.

Check the timestamp in the error log file.
The timestamp in there needs to be compared with the creation timestamp in the message. If the message is a minute later then it is almost certainly the relevant file/message combination.

[Ethen]

one way of doing this maybe writing down an user exit class.. Whenever a queue message is successfully recieved userexit class is executed.. so you can maintain the log of messages who are successfully recieved.

there is one more type of validation class in JMS messages which you can cuztomize and get the list of all the messages sent to the queue..

[robbinma]

Thanks Ethen. I'll have a think about that.
It may not log the messages that fail but we sometimes wonder about messages which are sucessful

[Ethen]

you can write an end point exit class in which recieves the response code from external system. if the response code is between 200 to 299 the data was sent successfully. In case of data being sent using HTTP u can extend HTTPExit class and write method
public void processResponseData(int responseCode, String responseMsg, byte msgBodyData[])
{
      if(responseCode >= 200 && responseCode <= 299)
     //write ur logic here
}

u can do some research on HTTPExit class and how to deploy it since its very large process..

[ericsully]

Network World posted an article about a free monitoring tool that could help you http://www.real-user-monitoring.com

[robbinma]

Thanks for all the responses.

The final resolution was to look at the root cause (the MEA implementation) and remove the cause of the issues.
After a number of patches the implementation has been tuned so almost all of the problems are prevented from occurring in the first place.

Best regards,

Mark

[Ethen]

you can probably post here what you did.

[Today]

• How to get list data whic... by kvnaresh [Today at 12:39:03 am]
• How to change an email ad... by kvnaresh [Today at 12:25:57 am]
• Difference between fixpac... by jithu1989 [Yesterday at 05:25:18 am]
• Maximo Programmer Require... by ravikorukonda [February 06, 2012, 05:59:58 pm]
• Demo Maximo 7.1 Online by hyubby [February 06, 2012, 11:05:43 am]
• Error loading the Object ... by G Jeevan [February 06, 2012, 07:21:36 am]
• plzz attribute in another... by Dileep Kumar [February 06, 2012, 07:02:09 am]
• Jpeg attachments within M... by zenagarfield [February 02, 2012, 02:02:53 pm]
• How to change senders ema... by zenagarfield [February 02, 2012, 10:28:06 am]
• Lead and Crew by G Jeevan [February 02, 2012, 07:08:45 am]