Search This Blog

Wednesday, June 1, 2011

Administering the application messages

Once the messages are in the DONE status, it is not possible to resent the messages. What If we need to re submit it?

One option we found is to trigger a SQL update against the table which stores the monitoring data - PSAPMSGPUBHDR

Update PSAPMSGPUBHDR set PUBSTATUS = 1, STATUSSTRING = 'NEW' where IBTRANSACTIONID = ’Transaction ID’ and STATUSSTRING = ‘DONE’

PUBSTATUS values:
0 - Error
1 - New
2 - Started
3 - Working
4 - Done
5 - Retry
6 - Timeout
7 - Edited
8 - Canceled

To monitor the messages, query the appropriate tables with the above status values.

1 comment: