I have a table which has 2 columns date data type. When i am trying to replicate data by goldengate i am getting an error.
column names are open_date and closed_date (date data type) , is there any invisible junk characters or any invalid data on these columns ? there are around 400k records in the table. how do i find what is causing the issue ?
DB Versiion is 19.11
Error :
2025-08-28 09:25:37 ERROR OGG-00663 OCI Error ORA-01801: date format is too long for internal buffer
Help: https://docs.oracle.com/error-help/db/ora-01801/ (status = 1801), SQL <SELECT x."BE_ID",x."TEXT",x."STATUS",x."OPEN_DATE",x."ASSIGNED_REP",x."CLOSE_DATE",x."ACHIEVED_REP",x."FUNCTION",x."ASSIGN_ID",x."LINK_ASSIGN_ID",x."COMPANY",x."FUND",x."FIRM",x."LP",x."THIRD_PARTY",x."SEQ" FROM
After analysing GodenGate trail file , data lenght of the column is shows 24 (open_date and closed_date) for all records.
Column 0 (0x0000), Length 10 (0x000a) BE_ID.
Column 1 (0x0001), Length 48 (0x0030) TEXT.
0000 2c57 6562 7369 7465 2075 6e64 6572 2063 ,Website under c
0010 6f6e 7374 7275 6374 696f 6e20 6173 206f onstruction as of
0020 302f 3136 2f32 3030 312e 0a 02/16/2001.
Column 2 (0x0002), Length 9 (0x0009) STATUS.
0000 436c 6f73 6520 2020 20 Close
Column 3 (0x0003), Length 24 (0x0018) OPEN_DATE.
0000 3136 2d4d 4152 2d32 3030 3120 3030 3a30 16-MAR-2001 00:0
0010 303a 3030 0:00
Column 4 (0x0004), Length 7 (0x0007) ASSIGNED_REP.
0000 4f56 59 OVY
Column 5 (0x0005), Length 24 (0x0018) CLOSE_DATE.
0000 3136 2d4f 4354 2d32 3030 3220 3139 3a30 16-OCT-2002 19:0
0010 303a 3030 0:00
Column 6 (0x0006), Length 7 (0x0007) ACHIEVED_REP.
0000 5443 43 TCC
Column 7 (0x0007), Length 10 (0x000a) FUNCTION.
0000 0001 0002 0003 .......
Column 8 (0x0008), Length 10 (0x000a) ASSIGN_ID.
0000 .......... ..........
Column 9 (0x0009), Length 10 (0x000a) LINK_ASSIGN_ID.
0000 .......... ..........
Column 10 (0x000a), Length 4 (0x0004) COMPANY.
ffff 0000
Column 11 (0x000b), Length 4 (0x0004) FUND.
ffff 0000
Column 12 (0x000c), Length 4 (0x0004) FIRM.
ffff 0000
Column 13 (0x000d), Length 4 (0x0004) LP.
ffff 0000
Column 14 (0x000e), Length 4 (0x0004) THIRD_PARTY.
ffff 0000
Column 15 (0x000f), Length 4 (0x0004) SEQ.
0000 0003
Logdump 49 >
Thanks
Jhil