PeopleSoft-进程挂了不能通过页面重启的解决方案

发表于 分类于 本文字数： 1.3k 阅读时长 ≈ 1 分钟
如果遇到进程跑着跑着，一直不结束，通过页面无法重启进程，同时又必须得让进行接着上次的断点继续跑，那么需要采用以下的解决方案解决。

Solution 1:

If the issue occurs due to a disabled e-mail address/Oprid, remove the Oprid from the Application Engine’s notification list and submit the Application Engine process from scratch.

Solution 2:

To resolve this problem, take any of the following steps:

  1. Update these two tables to set the RETRYCOUNT field appropriately.

a) UPDATE PSPRCSRQST SET RETRYCOUNT=’-1’ WHERE PRCSINSTANCE=##
UPDATE PSPRCSQUE SET RETRYCOUNT=’-1’ WHERE PRCSINSTANCE=##

b) Navigate to PeopleTools - Process Monitor - Details for the affected process - choose to Restart the process.

OR

  1. Restart the Application Engine from the Command line:

a) Connect to the NT machine as the Windows id of the user starting the Oracle Proc Mgr.

b) Set these two environment variables:

Set PS_SERVDIR=%PS_HOME%\appserv\prcs\DBNAME
Set PS_SERVER_CFG=%PS_SERVDIR%\psprcs.cfg

c) Navigate to the server bin directory:

cd %PS_HOME%\bin\server\winx86

d) Run the Application Engine using the parameter list for the failed process instance.

psae -CT DBTYPE -CD DBNAME -CO -CP -I -R -AI

OR

  1. Submit the process again from scratch after deleting the information from the following tables:

DELETE FROM PS_AERUNCONTROL WHERE PROCESS_INSTANCE=##
DELETE FROM PS_AERUNCONTROLPC WHERE PROCESS_INSTANCE=##
DELETE FROM PS_AETEMPTBLMGR WHERE PROCESS_INSTANCE=##

Warning, this approach might not be the best one as the application tables may have been updated with information - ie process information, flags that will be lost once the delete statements are run.

KEYWORDS:
E-RD/PRCS, Process Scheduler, Post-Failure steps