MQSeries.net :: View topic

vids · Posted: Tue Nov 04, 2003 8:59 am Post subject:

Hi..

We have an application triggered(type FIRST) which pulls the message from the queue and inserts the record to the sql server database. If there is any error while inserting the record, the message will be rolled back. The application tries to pull those messages till the backout count is reached the threshold value. Once the backout count is reached the threshold, the message will be redirected to an error queue.

Now the message may go to an error queue because of the bad data or the database was down. If the message goes to an error queue because of the database down at that time, we need to process that message later when the database is up.

We want to schedule the task to runs the same program every 30 mins to process the message in the error queue which was put during data base was down.

Now the question is how to diffrenciate whether the message was put to an error queue because of the bad data or database down.The program will pull even the bad messages which is not necessary for us to process.

Any good suggestions to handle this situation???

Thanks
_________________
Vids