Process Remains in Posting State?

If you have supported PeopleSoft for long enough, you might have checked the Process Monitor to find many processes that continue to have the Distribution Status as “posting” even after the process has run to Success. This is especially true when you have restarted a process.

Process in Posting state

In such a situation, how would you quickly retrieve a file that was generated by the successful process?

PeopleSoft generates all files that are to be shown in the Process Monitor, to a temporary folder. After a successful post, the temporary folder is deleted. This simple SQL statement will tell you the location (on the server) of this temporary folder so that you can pick the file up from there.

SELECT 
PRCSNAME, PRCSTYPE, PRCSOUTPUTDIR
FROM PS_CDM_LIST 
WHERE PRCSINSTANCE = 'Your Process Instance'

Alternatively, you can change the status to Not Posted using the below scripts and then use the Re-send Content Radio button to force posting.

UPDATE PSPRCSRQST 
SET DISTSTATUS = 4
WHERE PRCSINSTANCE = 'Your Process Instance';
 
UPDATE PSPRCSQUE 
SET DISTSTATUS = 4
WHERE PRCSINSTANCE = 'Your Process Instance';
 
UPDATE PS_CDM_LIST 
SET DISTSTATUS = 4
WHERE PRCSINSTANCE = 'Your Process Instance';
Re-send Content

Re-send Content

Tags: , ,
Leave a Reply

Your email address will not be published. Required fields are marked *

*
*