Veridata Issue Selection Of Delta Processing Gives "ORA-00904: : invalid identifier issue"
(Doc ID 2572465.1)
Last updated on JANUARY 11, 2023
Applies to:
Oracle GoldenGate Veridata - Version 12.2.1.0.0 and laterInformation 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", "PRIMARYVERSION", "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 |