PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later Information in this document applies to any platform.
GOAL
How To Resubmit A Message With Done Status using SQL from the backend?
FIX
It is NOT recommended to Use SQL to directly update messages in ERROR status, as messages can be resubmitted or cancelled via the Message Monitor.
See below some examples to resubmit messages through SQL statements:
For messages in PUB con tab ------------------------------------------------------------- This is example of changing the message status for Publishing ------------------------------------------------------------- Update PSAPMSGPUBCON set PUBCONSTATUS = 1, STATUSSTRING = 'NEW' where PUBCONSTATUS = 0 and STATUSSTRING = 'DONE' and "Any other condition If needed --e.g queuename,ib_operationname etc"
For messages in SUB con tab --------------------------------------------------------------- This is example of changing the message status for Subscription ---------------------------------------------------------------
Update PSAPMSGSUBCON set SUBCONSTATUS = 1, STATUSSTRING = 'NEW' where SUBCONSTATUS = 0 and STATUSSTRING = 'DONE' and "Any other condition If needed --e.g queuename,ib_operationname etc"
For messages seen on the Service Operation Instance tab
Update PSAPMSGPUBHDR set PUBSTATUS = 1, STATUSSTRING = 'NEW' where PUBSTATUS = 0 and STATUSSTRING = 'DONE' and "Any other condition If needed --e.g queuename,ib_operationname etc"
Message Status Values:
Error=0 New=1 Start=2 Wrkng=3 Done=4 Retry=5 Time=6 Edited=7 Cncld=8 Hold=9
|