PeopleSoft Process Stuck in Posting

Recently I have faced the issue where the process stuck in posting for couple of days. Though in the backend I can see the process is actually posted. This confirms the fact that the status is not get updated correctly post the batch server posted the report.

Reason: This presumably happened due to abnormal shutdown of the Batch Server.

Solution: I have  checked three tables named as below and found that DISTSTATUS is not updated in PSPRCSRQST and PSPRCSQUE. PS_CDM_LIST was having the DISTSTATUS updated correctly.

PS_CDM_LIST
PSPRCSRQST
PSPRCSQUE


SELECT CONTENTID, PRCSINSTANCE, DISTSTATUS, RQSTDTTM FROM PS_CDM_LIST WHERE PRCSINSTANCE ='3451281' ;

select PRCSINSTANCE, RUNSTATUS, DISTSTATUS from PSPRCSRQST where DISTSTATUS='7' and PRCSINSTANCE = '3451281' ;

select PRCSINSTANCE, RUNSTATUS, DISTSTATUS from PSPRCSQUE where DISTSTATUS='7' and PRCSINSTANCE = '3451281' ;


Updated the distribution status correctly in PSPRCSRQST and PSPRCSQUE which helped me to resolve the issue.