ERP Associates, Inc.

It is possible to resend a message that's in a DONE status.  I'm not saying that it's a good idea, just that it's possible.  Here's how to do it in PeopleTools versions prior to 8.48:

First, shut down the PUBSUB processes.  One sure-fire way to do it is to shut down the app server domain(s).  That'll also insure new messages aren't created during this process.  But it is possible to stop just the PUBSUB processes by launching PSADMIN, administering the domain, going to TMADMIN, and entering this command:

    shutdown -g PUBSUB

Now that your pubsub processing is shut down, you can modify the following SQL to set the status back to New:

Update PSAPMSGPUBCON
set SUBCONSTATUS = 1, STATUSSTRING = 'NEW'
where PUBID in (83780, 83781, 83782)

Obviously you'll want to replace the PUBID's with the PUBID you want to use.

In case you're wondering, valid PUBID's are:

Error=0
New=1
Start=2
Workng=3
Done=4
Retry=5
Time=6
Edited=7
Canceled=8
Hold=9

Finally, restart PUBSUB.  If you shut it down via TMADMIN, use this command to start it back up:

boot -g PUBSUB 

As always, test before trying on a production system.  There are good reasons NOT to resubmit a message.  The sequence that messages occur is important, and by republishing old messages you could easilly set data in the target system back to old values and get data out of sync.  But I suppose there are times when there's a really good reason to do it, so just be careful out there!