Resending Integration Broker Messages set to Done
Praj 07 Nov 2008 03:48
You can use the following SQL to update the Integration Broker message publication header table (PSAPMSGPUBHDR) to resend messages set to done. Note that you can't do this through the service operation monitor.
update PSAPMSGPUBHDR set PUBSTATUS = 1, STATUSSTRING = 'NEW'
You will need to specify a where condition. You can do this by using the relevant fields in the (PSAPMSGPUBHDR) record.
For instance, some of the fields you might want to use are:
- Transaction ID (IBTRANSACTIONID)
- Service Operation Name (IB_OPERATIONNAME)
- Queue Name (QUEUENAME)
- Publisher's Emplid (PUBLISHER)
- Publication Process (PUBPROC)
- Create Date/Time Stamp (CREATEDTTM)
- Publish Date/Time Stamp (PUBLISHTIMESTAMP)
- Process ID (PROCESSID)
Query to the table to find the appropriate fields.