SQL Stmt: SELECT R.PRCSINSTANCE ,R.ORIGPRCSINSTANCE ,R.RECURORIGPRCSINST,R.MAINJOBINSTANCE ,R.PRCSJOBSEQ ,R.PRCSJOBNAME ,R.PRCSNAME ,R.PRCSTYPE ,R.RECURNAME ,R.TIMEZONE ,R.PT_RETENTIONDAYS ,R.PTNONUNPRCSID FROM PSPRCSQUE R ,PS_PRCSRECUR S WITH (READUNCOMMITTED) WHERE ((R.RUNSTATUS IN ('9', '17') AND S.INITIATEWHEN = 1) OR (R.RUNSTATUS IN ('3','6', '7', '9','10','12', '17') AND S.INITIATEWHEN = 0)) AND R.INITIATEDNEXT = 0 AND R.RUNLOCATION = '2' AND R.RECURNAME > ' ' AND R.PRCSJOBSEQ = 0 AND R.RECURNAME = S.RECURNAMEĮxplain: Communication link failure I found the error messages in the c:\documents and settings\\psft\pt\8.51\appserv\prcs\HR90DMO\LOGS\stdout. So, my process monitor was showing everything hung in “Posting” status: The problem was that I had not set the PS_CFG_HOME environment variable plus I also did not have the report node configured for the Process Scheduler server definition. I have been having trouble with my newly upgraded PeopleTools 8.51 environment.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |