PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Process Scheduler - Jobsets are not getting scheduled in PeopleTools 8.50

edited Aug 2, 2019 10:07AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered
After upgrading to PeopleTools 8.50, certain Scheduled Jobsets are not initiated by the Master Scheduler.
In the Master Scheduler log, mstrschdlr_ddmm.log, it shows this error message:

PSMSTPRC.5272 (0) [12/06/10 00:00:26 VP1@MACHINENAME](1) =================================Error===============================
PSMSTPRC.5272 (0) [12/06/10 00:00:26 VP1@MACHINENAME](1) Database error encountered
PSMSTPRC.5272 (0) [12/06/10 00:00:26 VP1@MACHINENAME](2) Info:
PSMSTPRC.5272 (0) [12/06/10 00:00:26 VP1@MACHINENAME](2) Section:
PSMSTPRC.5272 (0) [12/06/10 00:00:26 VP1@MACHINENAME](2) Info:
PSMSTPRC.5272 (0) [12/06/10 00:00:26 VP1@MACHINENAME](2) SQL Stmt: SELECT RUNSTATUS FROM PSPRCSQUE WHERE PRCSINSTANCE = :1
PSMSTPRC.5272 (0) [12/06/10 00:00:26 VP1@MACHINENAME](2) =====================================================================
PSMSTPRC.5272 (0) [12/06/10 00:00:26 VP1@MACHINENAME](1) =================================Error===============================
PSMSTPRC.5272 (0) [12/06/10 00:00:26 VP1@MACHINENAME](1) Database error encountered
PSMSTPRC.5272 (0) [12/06/10 00:00:26 VP1@MACHINENAME](2) Info:
PSMSTPRC.5272 (0) [12/06/10 00:00:26 VP1@MACHINENAME](2) Section:
PSMSTPRC.5272 (0) [12/06/10 00:00:26 VP1@MACHINENAME](2) Info:
PSMSTPRC.5272 (0) [12/06/10 00:00:26 VP1@MACHINENAME](2) SQL Stmt: SELECT I.SCHEDULENAME,I.JOBNAMESRC,%DateTimeOut(I.NEXTSTARTDTTM),%DateTimeOut(I.RECURDTTM),I.CURRENTJOBINSTANCE FROM PS_SCHDLDEFNINFO I, PS_SCHDLDEFN S WHERE I.NEXTSTARTDTTM <= %CURRENTDATETIMEIN AND S.SCHEDULESTATUS = '1' AND I.SCHEDULENAME = S.SCHEDULENAME AND I.JOBNAMESRC = S.JOBNAMESRC

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center