Veridata Compare Error The Conversion From Nvarchar To BinaryStream Is Unsupported (Doc ID 1680255.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

Veridata 11.2.1.0.202 compare of Oracle NCLOB to SqlServer NVARCHAR using
CLOB format fails with:

2014-05-27 10:51:14 Agent remote message (101): Database query failed: 'The conversion from nvarchar to BinaryStream is unsupported.' SQL<select
"GRADEBOOK_GRADE_PK1", "PK1", "QTI_RESULT_DATA_PK1", "LINKREFID", "SCORE", "GRADE", "STUDENT_COMMENTS", "INSTRUCTOR_COMMENTS", "FEEDBACK_FORMAT_TYPE", "COMMENT_PUBLIC_IND", "EXEMPT_IND", "OVERRIDE_IND", "INSTRUCTOR_NOTES", "NOTES_FORMAT_TYPE", "STATUS", "ATTEMPT_DATE", "DATE_ADDED", "DATE_MODIFIED", "LATEST_IND", "GROUP_ATTEMPT_PK1", "STUDENT_SUBMISSION", "TEXT_FORMAT_TYPE",
"FIRST_GRADED_DATE", "LAST_GRADED_DATE" from "BBL"."ATTEMPT" x WHERE
(DATE_MODIFIED > getdate() - 2) AND (S_SOURCE_DB = 'BBLEARN_CRSF')>

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