My Oracle Support Banner

E-IB: IB Subscription Dispatcher - ORA-01841: (full) Year Must Be Between -4713 And +9999, And Not Be 0 (Doc ID 2600332.1)

Last updated on OCTOBER 18, 2019

Applies to:

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

Symptoms

On :  8.56 version, Integration Broker

IB domain crashed with the below error.

ERROR
-----------------------

PSSUBDSP_dflt.17896 (1654) [2019-09-24T11:22:08.906] - - - (3) File: /vob/peopletools/src/pspubsub/statements.cppSQL error. Stmt #: 230  Error Position: 450  Return: 1841 - ORA-01841: (full) year must be between -4713 and +9999, and not be 0
Failed SQL stmt: SELECT IBTRANSACTIONID, IB_SEGMENTINDEX, IB_OPERATIONNAME, IB_NOTIF_SEQ, PUBNODE, QUEUENAME, QUEUESEQID, SUBQUEUE, ACTIONOWNER, IBPUBTRANSACTID, MACHINENAME, SLAVEPROCESSNAME, IB_SLAVEQUEUED, PROCESS_INSTANCE, PROCESSID, TO_CHAR(CAST((PUBLISHTIMESTAMP) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), SUBCONSTATUS, TO_CHAR(CAST((LASTUPDDTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF') FROM PSAPMSGSUBCON WHERE QUEUENAME=:1 AND LASTUPDDTTM >= TO_TIMESTAMP(:2,'YYYY-MM-DD-HH24.MI.SS.FF') ORDER BY SUBQUEUE, PUBLISHTIMESTAMP, QUEUESEQID, IB_SEGMENTINDEX, IB_NOTIF_SEQ



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Publish tens of thousands of messages from one Peoplesoft env to another env in a short time.


Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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