| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| JDBC Adapter Error - Messages marked as redelivered |
« View previous topic :: View next topic » |
| Author |
Message
|
| vk |
 Posted: Tue Feb 28, 2006 7:09 am Post subject: JDBC Adapter Error - Messages marked as redelivered |
 |
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Hi,
I am using a JDBC connector to pick up messages from a queue (Request queue) in the broker Queue Manager and insert them into a table in SQL Server.
From the time, we deployed the code in production, messages are getting inserted into the table without any problems.
But recently, in 2 separate occasions, some of the messages went to the Fault Queue for the connector. The reason for failure in the RHF2 header was -
"The message is marked as redelivered. It is not processed and sent to fault queue."
If I move the messages from the Fault Queue, back to the Request Queue, the connector picks them up and inserts the records into the table.
Has anybody faced this error? Please let me know if you have. How can I simulate a similar scenario. I never faced any issue during development.
Thanks,
VK. |
|
| Back to top |
|
 |
| vennela |
| Posted: Tue Feb 28, 2006 8:27 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| Quote: |
| "The message is marked as redelivered. It is not processed and sent to fault queue." |
What is the BackOut count on the Message? |
|
| Back to top |
|
|
| vk |
| Posted: Tue Feb 28, 2006 9:36 am Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Hi,
The backout count in the MQMD header for the message in the Fault queue is Zero. The HardenedBackoutCount for the Request Queue is also set to Zero.
How does this matter?
Also, the connector is sending the messages to the Fault queue after keeping the messages wth it for some hours. First time, it sent the message to Fault queue after around 10 hours. Second time, the messages went to the fault queue after 6 hours.
The connector is procesing all subsequent messages from the Request queue and inserting them into the table. I check the SQL Server logs also. It does not show any errors during this time.
Thanks,
VK. |
|
| Back to top |
|
|
| vk |
| Posted: Fri Mar 10, 2006 5:28 am Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
After my last posting, the issue never happened again. This makes me wonder whether it is really a database issue or does it have something to do with the connector.
Can anybody tell me when does a connector redeliver messages? Can this happen when the connector is processing some messages and suddenly for a short period of time, the database becomes unavailabe or there are no more connections available to the database and the connector has to wait for sometime before it gets a connection?
Please let me know if any of you have faced similar issues with a JDBC connector.
Thanks,
VK. |
|
| 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
|
|
|
|
