Veridata Compare of DB2 To Oracle Fails With Agent Replied With Error Code Database Query Failed
Last updated on JULY 17, 2017
Applies to:Oracle GoldenGate Veridata - Version 220.127.116.11 and later
Information in this document applies to any platform.
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.
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