I have been having trouble with my newly upgraded PeopleTools 8.51 environment. 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.
=================================Error=============================== Message: Database error encountered Info: Section: Info: 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 Explain: [Microsoft][SQL Server Native Client 10.0]Communication link failure ===================================================================== =================================Error=============================== Message: Database error encountered Info: Section: Info: SQL Stmt: SELECT Q.PRCSINSTANCE ,Q.JOBINSTANCE ,Q.MAINJOBINSTANCE ,Q.SESSIONIDNUM ,Q.OPRID ,Q.OUTDESTTYPE ,Q.GENPRCSTYPE,Q.PRCSTYPE,Q.TUXSVCID,P.PRCSOUTPUTDIR FROM PSPRCSQUE Q ,PSPRCSPARMS P WITH (READUNCOMMITTED) WHERE Q.RUNSTATUS = :1 AND Q.SERVERNAMERUN = :2 AND Q.PRCSINSTANCE = P.PRCSINSTANCE Explain: [Microsoft][SQL Server Native Client 10.0]Shared Memory Provider: No process is on the other end of the pipe. =====================================================================
I knew about the PS_CFG_HOME variable, but I had just skipped it in my rush to just get something working. What I didn’t realize is that it would prevent me from seeing even an SQR. So, I fixed my PS_CFG_HOME variable:
I also copied the files from the appserv directory under documents and settings to the one in my PS_Home where I configured my PS_CFG_HOME. See this post for more information. That part is important because it needs the configuration files in the new locations. Then, I deleted the Cache, the logs, and the log_output to clean things up. The app server still wouldn’t start, so I tried to reconfigure it. That’s when I received this error:
Enter selection (1-26, h, or q): 13 Warning: no changes detected, some configuration files will not be updated. Loading configuration... CMDTUX_CAT:111: ERROR: TUXCONFIG (C:\Documents and Settings\psadmin\psft\pt\8.51 \appserv\HR90DMO\PSTUXCFG) of machine SKPHCM90 must be the same as the TUXCONFIG environment variable (E:\psoft\HR90DMO\appserv\HR90DMO\PSTUXCFG) CMDTUX_CAT:867: ERROR: tmloadcf: Above errors found during syntax checking ==============ERROR!================ Unable to load the configuration! Check the TUXEDO log for details. ==============ERROR!================ ==============ERROR!================ Unable to load the Domain configuration! Check the TUXEDO log for details. ==============ERROR!================
This thread claims that you have to set the TUXCONFIG variable. I didn’t think that you did have to set it, so I did a little more experimenting.
I went to check the Report Node (PeopleTools > Process Scheduler > Report Node). The port number was wrong on the URL, so I had to fix that (it should probably match the port number on your browser as you are logged in):