My Oracle Support Banner

Replication Fails With "Error ORA-01843: Not a Valid Month" (Doc ID 1299383.1)

Last updated on OCTOBER 22, 2019

Applies to:

Oracle GoldenGate - Version 10.4.0.50 and later
Information in this document applies to any platform.
***Checked for relevance on 04-Mar-2013***

Symptoms

Replicat fails with error ORA-01843: not a valid month.

OCI Error ORA-01843: not a valid month (status = 1843), SQL <INSERT INTO "SCHEMANAME"."TABLENAME"
("COL1","COL2","COL3","COL4","COL5","COL6","COL7","COL8","COL9>
Operation failed at seqno 114 rba 68317228
Discarding record on action DISCARD on error 1843
Problem replicating SCHEMNAME.TABLENAME to SCHEMANAME.TABLENAME
Mapping problem with insert record (target format)...
*
COL1 = 564096
COL2 = NULL
COL3 = 43
COL4 = 0
COL5 = 18
COL6 = 0
COL7 = 1138XX73
COL8 = 0000-00-00 00:00:00
COL9 = 0000-00-00 00:00:00
COL10 = 88001
COL11 = 88001
COL12 = 0
COL13 = 47278
STATUS = Accepted with Errors


For the two Date fields "COL8" and "COL9",  the value is invalid as "0000-00-00 00:00:00"

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
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.