My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.