Veridata Compare Fails On Interval Datatype Ora-01877: String Is Too Long For Internal Buffer (Doc ID 1936796.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate Veridata - Version 11.2.1.0.3 and later
Information in this document applies to any platform.

Symptoms

Veridata v12.1.3.0.0 server compare of INTERVAL datatype fails with:
2014-10-17 10:54:23 OGGV-00119: Agent remote message (101): OGGV-60038:
Database query failed: 'ORA-01877: string is too long for internal
buffer' SQL<select "USER_ACCOUNT_ID_FK", "SYNC_DATE", TO_CHAR
("USER_ACCOUNT_TIME"), TO_CHAR("QTO_USER_ACCOUNT_TIME"), TO_CHAR
("INTERVIEW_STATE_TIME"), TO_CHAR("RETURN_INFO_TIME"), TO_CHAR
("ORDER_TRACKING_TIME"), TO_CHAR("USER_ACCOUNT_DELETE_TIME"), TO_CHAR
("QTO_USER_ACCOUNT_DELETE_TIME"), TO_CHAR("INTERVIEW_STATE_DELETE_TIME"),
TO_CHAR("RETURN_INFO_DELETE_TIME"), TO_CHAR
("ORDER_TRACKING_DELETE_TIME"), TO_CHAR("FULL_SYNC_TIME"),
"USER_ACCOUNT_COUNT", "QTO_USER_ACCOUNT_COUNT", "INTERVIEW_STATE_COUNT",
"RETURN_INFO_COUNT", "ORDER_TRACKING_COUNT", "USER_ACCOUNT_DELETE_COUNT",
"QTO_USER_ACCOUNT_DELETE_COUNT", "INTERVIEW_STATE_DELETE_COUNT",
"RETURN_INFO_DELETE_COUNT", "ORDER_TRACKING_DELETE_COUNT", "SYNC_FAILED"
from "OGG"."SGG_TTO12_A_A_SYNC_HISTORY" x order by
"USER_ACCOUNT_ID_FK">

Comparison terminated with errors.

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