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

Last updated on FEBRUARY 14, 2024

Applies to:

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

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