Veridata 12.1.3 Compare Job Fails OGGV-60038: Database Query Failed: 'Metric Value For End-To-End Tracing Is Too Long (Doc ID 1947518.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

Customer has got a veridata server:

Oracle GoldenGate Veridata
12.1.3.0.0 OGGVDT_12.1.3.0.0_PLATFORMS_140616.1904

The jagents for the 2 databases to compare are:

10g : OGGVDT_12.1.3.0.0_PLATFORMS_140616.1904 built on Mon, 16 Jun 2014 19:38:59 -0700
12g : OGGVDT_12.1.3.0.0_PLATFORMS_140616.1904 built on Mon, 16 Jun 2014 19:38:59 -0700

The error comes for the 10g database - veridata-agent_10g.log.gz :

[2014-10-31T17:29:51.675-07:00] [veridata] [ERROR] [OGGV-60038] [oracle.veridata.agent] [tid: 59]
[ecid: 84ad0fce-61eb-404a-b118-49c5b175efa9-000007ff,0:2994:2:14:1]

Database query failed: 'metric value for end-to-end tracing is too long: Table: HHDOMESTIC.ACNT_MASTER_PREF' SQL<select "CUST_PREF_DEF_ID", "ACNT_MASTER_ID", "ACNT_GROUP_OVERRIDE", "VALUE" from "HHDOMESTIC"."ACNT_MASTER_PREF" x order by "CUST_PREF_DEF_ID", "ACNT_MASTER_ID">

In the report files for the error:

rpt\CompareHUQAdbs\00001007\HUQAnew12cGRP\CP_ACNT_ENT_SUBROLE_CD=ACNT_ENT_SUBROLE_CD.rpt :

2014-11-01 13:29:31 OGGV-00119: Agent remote message (101): OGGV-60038: Database query failed: 'metric value for end-to-end tracing is too long: Table: HHERO.ACNT_ENT_SUBROLE_CD' SQL<select "ACNT_ID", "ACNT_ENT_ROLE_CD", "ACNT_ENT_SUBROLE_CD", "ACNT_ENT_SUBROLE_NM", "ACNT_ENT_SUBROLE_DESC" from "HHERO"."ACNT_ENT_SUBROLE_CD" x order by "ACNT_ID", "ACNT_ENT_ROLE_CD", "ACNT_ENT_SUBROLE_CD">

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