E-PRCS: Scheduled Jobset Using Recurrence Does Not Run, Fails With Error: "Database error encountered ORA-01841: (full) year must be between -4713 and +9999, and not be 0" (Doc ID 1116784.1)

Last updated on JUNE 01, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 to 8.53 [Release 8.4]
PeopleSoft Enterprise PT PeopleTools - Version 8.4 to 8.50 [Release 8.4]
Information in this document applies to any platform.

Symptoms

Environment
- Production Environment.
- PeopleTools release 8.50.09.
- Application release HRMS and Campus Solutions 8.9.

Issue
- Scheduling and creation of Schedule JobSets led to the event.
- Created Schedule JobSet and tried to run the Schedule.
- Run Now feature is working.

Impact
- Schedule JobSets do not run at scheduled time and date.
- Issue affects all users attempting to run Schedule JobSets.

Expect JobSets to run child PSJob at scheduled time and date.

The issue can be reproduced at with the following steps:
1. PeopleTools, Process Scheduler, Schedule JobSet Definitions.
2. Add Recurrence.
3. Change Status to Active.
4. Observe the error:

=================================Error===============================
Message: Database error encountered
Info:
Section:
Info:
SQL Stmt: SELECT RUNSTATUS FROM PSPRCSQUE WHERE PRCSINSTANCE = :1
=====================================================================
=================================Error===============================
Message: Database error encountered
Info:
Section:
Info:
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
=====================================================================

PSMSTPRC.19695 (0) [11/27/12 05:30:57 PSAPPS@server](1) Database error encountered
PSMSTPRC.19695 (0) [11/27/12 05:30:57 PSAPPS@server](2)  Info:
PSMSTPRC.19695 (0) [11/27/12 05:30:57 PSAPPS@server](2)  Section:
PSMSTPRC.19695 (0) [11/27/12 05:30:57 PSAPPS@server](2)  Info:
PSMSTPRC.19695 (0) [11/27/12 05:30:57 PSAPPS@server](2)  SQL Stmt: UPDATE PS_SCHDLDEFNINFO SET NEXTSTARTDTTM = TO_TIMESTAMP(:1,'YYYY-MM-DD-HH24.MI.SS.FF'),RECURDTTM = TO_TIMESTAMP(:2,'YYYY-MM-DD-HH24.MI.SS.FF') WHERE SCHEDULENAME = :3 AND JOBNAMESRC = :4
PSMSTPRC.19695 (0) [11/27/12 05:30:57 PSAPPS@server](2)  Explain:  ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Cause

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 hundreds of Community platforms