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 JULY 17, 2017

Applies to:

Oracle GoldenGate Veridata - Version 1.0.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Apr-2015***

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

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