Veridata Compare of DB2 To Oracle Fails With Agent Replied With Error Code Database Query Failed (Doc ID 1555262.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

OGG Veridata comparing DB2 z/OS to Oracle abend:

Error from source RHS. (Agent replied with error code Database query failed:
'[Oracle GoldenGate Veridata][DB2 JDBC Driver][DB2]DATA TYPE/LENGTH/VALUE OF
ARGUMENT 1 OF 09648     R\G IS INVALID' SQL<select "SCY_TP_CD", "SCY_KEY"
from "DBO"."HIER_SCY" x order by unicode_str("SCY_KEY", utf8),
unicode_str("SCY_TP_CD", utf8)> )

The Jagent log doesn't show any more info about the event.

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