Certain times, we find
distribution status for a huge number of processes is Not Posted, which could
happen for many reasons. In this case, resending the content from PIA process
monitor page for each single process is not efficient and is very time
consuming.
Solution:
We can update few tables
playing role in sending the output reports to report repository .Run the below
update statements on the database :
UPDATE PSPRCSRQST SET DISTSTATUS=7 where DISTSTATUS=4;
UPDATE PSPRCSQUE SET DISTSTATUS=7 where DISTSTATUS=4;
UPDATE PS_CDM_LIST SET DISTSTATUS = '8',TRANSFERINSTANCE = 0 WHERE DISTSTATUS=4;
After updating the
distribution status in respective tables, distribution agent takes up the
request and posts the files to report repository.UPDATE PSPRCSQUE SET DISTSTATUS=7 where DISTSTATUS=4;
UPDATE PS_CDM_LIST SET DISTSTATUS = '8',TRANSFERINSTANCE = 0 WHERE DISTSTATUS=4;
