GoldenGate Veridata Compare Error ORA-01801: OCI Error error executing fetch with error code 1801, Date Format Is Too Long For Internal Buffer
(Doc ID 1456244.1)
Last updated on MARCH 05, 2024
Applies to:
Oracle GoldenGate Veridata - Version 1.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Running OGG Veridata, I received an error on one of the compare tables:
Error from source RHS. (RHS_NSortImp::sorter() failed for an unknown reason)
Error from target RHS. (Agent replied with error code OCI Error error executing fetch with error code 1801 (status = 1801-ORA-01801: date format is too long for internal buffer), SQL<SELECT x."PAYMENT_AMOUNT",x."DUE_DATE",x."BANK_RTN",x."ACCOUNT_TYPE_DESCRIPTION",x."ACCOUNT_NUMBER",x."CANCEL_CONFIRMATION_ID",x."ACH_SEC_CODE",x."ACH_TRANSACTION_CODE",x."ACH_TRACE_NUMBER",x."RELEASE> (from target host))
How can I get around this?
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 |