GoldenGate Veridata Compare Error ORA-01801: OCI Error error executing fetch with error code 1801, Date Format Is Too Long For Internal Buffer
Last updated on JULY 17, 2017
Applies to:Oracle GoldenGate Veridata - Version 126.96.36.199 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Apr-2015***
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?
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