PeopleSoft Process Scheduler

Processes Stuck at Queued 

There are a number of reasons why a process might be stuck at queued. The most obvious is that the process scheduler is down (check the Servers tab in the process monitor). Beyond this, there are some useful troubleshooting that apply:
Check the following tables:

• PSPRCSRQST 
• PSPRCSQUE 
• PSPRCSPARMS

The row count should be the same in both tables. If one is out of sync with the other, then it can help to remove orphaned instances in of the tables. Restarting the process scheduler and clearing the process scheduler cache will also fix a number of issues.

Run status

In the PeopleTools 8.4x look at the translates on the field RUNSTATUS or use the query.

select FIELDVALUE, XLATLONGNAME 
from PSXLATITEM 
where FIELDNAME = 'RUNSTATUS'

Here's a summary of the run status translates (from PeopleTools 8.49). Note that not all of these are active.





















Value
Status
1
Cancel
2
Delete
3
Error
4
Hold
5
Queued
6
Initiated
7
Processing
8
Cancelled
9
Success
10
Not Successful
11
Posted
12
Unable to Post
13
resend
14
Posting
15
Content Generated
16
Pending
17
Success with Warning
18
Blocked
19
Restart

The following query will give you a summary of the process run statuses in your process request table:


select     
    RUNSTATUS,
    (
        select  XLATSHORTNAME
        from    PSXLATITEM
        where   FIELDNAME = 'RUNSTATUS'
        and     FIELDVALUE = RUNSTATUS
    ) as RUNSTATUS_DESCR,
    count(PRCSINSTANCE)
from  
    PSPRCSRQST
group by 
    RUNSTATUS
order by 
    RUNSTATUS;

Summary of requested processes by process status.


The following query will give you a summary of the requested processes by process status.



select
    RQST.RUNSTATUS,
    RQST.PRCSTYPE,
    (
        select XLAT.XLATLONGNAME
        from PSXLATITEM XLAT
        where XLAT.EFFDT = (
            select max(XLAT_ED.EFFDT)
            from PSXLATITEM XLAT_ED
            where XLAT_ED.FIELDNAME = XLAT.FIELDNAME
            and XLAT_ED.FIELDVALUE = XLAT.FIELDVALUE
        ) and XLAT.FIELDNAME = 'RUNSTATUS'
        and XLAT.FIELDVALUE = RQST.RUNSTATUS
    ) as RUNSTATUS_XLAT,
    count(RQST.PRCSINSTANCE) as TOTAL_PROCESSES,
    min(RUNDTTM) as FIRST_OCCURRED,
    max(RUNDTTM) as LAST_OCCURRED
from PSPRCSRQST RQST
group by RQST.RUNSTATUS, RQST.PRCSTYPE
order by RUNSTATUS_XLAT, RQST.PRCSTYPE

Distribution

The following tables store information about the distribution of process scheduler output to users or roles.

PS_PRCSDEFNCNTDIST
Distribution settings for process definitions.

PS_PRCSJOBCNTDIST
Distribution settings for jobs.

PS_PRCSRQSTDIST
Distribution settings by process instance. Join to PS_CDM_FILE_LIST on the process instance to get the file names.

PS_PRCSRUNCNTLDIST
Distribution by operator ID and run control.

Taken from http://peoplesoft.wikidot.com