REPLICAT ABENDS WITH: TIMESTAMP OUT OF RANGE: 148731180960000000 (Doc ID 1585406.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

There are a column in a table of datatype timestamp with timezone. We encounter problems with golden gate extract and have included "TRANLOGOPTIONS INCLUDEREGIONID" in the extract parameter file. This helps with the extract, but the replicat abends with:
OGG-01158 Oracle GoldenGate Capture for Oracle, ep1ft.prm: Timestamp out of range: 148731180960000000

the problem record is:
Column 59 (x003b), Len 38 (x0026)
0000 3030 3031 2d30 312d 3033 3a30 343a 3536 3a30 | ..0001-01-03:04:56:0
302e 3030 3030 3030 3030 3020 2b30 303a 3030 | 0.000000000 +00:00

from logminer, it is:
"CLIENT_TIME_FINISHED" = TO_TIMESTAMP_TZ('03-JAN-01 12.00.00 AM AMERICA/NEW_YORK')



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