My Oracle Support Banner

E-PRCS: Child Jobs Of PSJob Complete But Parent Job Stays In Processing (Doc ID 2350924.1)

Last updated on AUGUST 17, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

An issue was encountered with PSJOBs which would run PSJOBs.  The child jobs would go to success, but the parent job itself remains in a processing state on the scheduler until the process is manually put on hold and restarted.

Coincided with database errors in master scheduler log:
File: E:\pt85512b-retail\peopletools\src\psschdlr\schedulermonitor.cppSQL error. Stmt #: 486 Error Position: 0 Return: 8603 - [Microsoft][SQL Server Native Client 11.0]Function sequence error (SQLSTATE S1010) 0
Failed SQL stmt: SELECT Q.PRCSINSTANCE, Q.SESSIONIDNUM, Q.ORIGPRCSINSTANCE, Q.JOBINSTANCE, Q.MAINJOBINSTANCE, Q.MAINJOBNAME, Q.PRCSITEMLEVEL, Q.PRCSJOBSEQ, Q.PRCSJOBNAME, Q.PRCSTYPE, Q.PRCSNAME, Q.PRCSPRTY, Q.RESTARTENABLED, Q.RUNDTTM, Q.LASTUPDDTTM, Q.PRCSSTARTDTTM, Q.GENPRCSTYPE, Q.RUNSTATUS, Q.OUTDESTTYPE, Q.RETRYCOUNT, Q.OPSYS, Q.SERVERNAMERUN, Q.SERVERASSIGN, Q.SCHEDULENAME, Q.PRCSCATEGORY, P.PRCSOUTPUTDIR, P.PRCSFILENAME, Q.DISTSTATUS, Q.TUXSVCID, Q.PT_RETENTIONDAYS, Q.PTNONUNPRCSID FROM PSPRCSQUE Q, PSPRCSPARMS P WITH (READUNCOMMITTED) WHERE Q.PRCSINSTANCE = P.PRCSINSTANCE AND ((Q.PRCSTYPE = 'PSJob' AND (Q.RUNSTATUS IN ('1', '7') OR (Q.RUNSTATUS IN ('8', '9', '10', '17') AND Q.DISTSTATUS IN ('1', '7')))) OR (Q.PRCSTYPE <> 'PSJob' AND (Q.RUNSTATUS IN ('1', '6', '7', '11', '18', '19') OR (Q.RUNSTATUS IN ('3', '10') AND Q.RETRYCOUNT <> -1)))) ORDER BY Q.PRCSINSTANCE ASC

(1) =================================Error===============================
(1) Database error encountered
(2) Info:
(2) Section:
(2) Info:
 
Issue was happening to multiple PSJOBs.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.