My Oracle Support Banner

Veridata Issue Selection Of Delta Processing Gives "ORA-00904: : invalid identifier issue" (Doc ID 2572465.1)

Last updated on SEPTEMBER 24, 2019

Applies to:

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

Symptoms

 The table is having 2 extra column on target.And compare jobs run fine and when they select delta processing its gives error as below :

2016-05-09 16:46:15 OGGV-00119: Agent remote message (101): OGGV-60038:
Database query failed: 'ORA-00904: : invalid identifier' SQL<select "ENTITYID", "ACTIVITY", "ADMINSTATE", TO_CHAR("CREATEDDATE", 'yyyy-MM-DD:hh24:mi:ss.FF6'), "CREATEDUSER", TO_CHAR("ENDDATE",
'yyyy-MM-DD:hh24:mi:ss.FF6'), "LABEL", TO_CHAR("LASTMODIFIEDDATE", 'yyyy-MM-DD:hh24:mi:ss.FF6'), "LASTMODIFIEDUSER", "NAME", "OBJECTSTATE", TO_CHAR("STARTDATE", 'yyyy-MM-DD:hh24:mi:ss.FF6'), "VALUE", "CHAROWNER","CHARACTERISTICSPECIFICATION", "MASTERVERSION", "BUSINESSINTERACTION" from "ABC"."AAAAAA" x WHERE entityid between 0 and 222222>

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.