My Oracle Support Banner

OGG Replicat Abends with ORA-01841: (full) Year Must be Between -4713 and +9999, and not be 0 (Doc ID 1411303.1)

Last updated on JANUARY 26, 2018

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


Oracle GoldenGate (OGG) Replicat abends with following error

WARNING OGG-01154 SQL error 1841 mapping HR.STAFF_CERTIFIC
ATE to HR.STAFF_CERTIFICATE OCI Error ORA-01841: (full) year must be between -47
13 and +9999, and not be 0 (status = 1841), SQL <UPDATE "HR"."STAFF_CERTIFICATE"RTIFICATE_TYPE" = :b0 AND "EMPLOYEE_NO" = :b1 AND "RELEASE_DATE" = :b2>.


The issue happens with invalid year . Eg a year value of 0000

The error can be reproduced as following

insert into STAFF_CERTIFICATE values ('CN', 'a', 'b', 'c', 'd', sysdate, sysdate, 1, 'e', sysdate);
update STAFF_CERTIFICATE set employee_no='1020209371';
set d.release_date= to_date('0001-01-01', 'yyyy-mm-dd')-365
where d.employee_no='1020209371' and d.certificate_type='CN'


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

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