My Oracle Support Banner

A "Ghost" Attribute is Added by Reverse Engineering to the ODI 12c Model But it Does not Exist in Salesforce (Doc ID 2278545.1)

Last updated on SEPTEMBER 04, 2020

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


Using Salesforce with Oracle Data Integrator (ODI)

After a sandbox refresh, ODI reverse-engineering adds attributes which do not exist in Salesforce to some of the Salesforce Models.

For example, in a model there is an attribute (column) called added which does not exist in Salesforce.

If this unwanted attribute is then deleted from the Salesforce Model, an error message is signaled when you right click on the entity (Datastore) and chose "View Data" from the pop-up menu:

java.sql.SQLException: [FMWGEN][SForce JDBC Driver][SForce]INVALID_FIELD:
ERROR at Row:1:Column:3494
No such column '<COLUMN_NAME2>__c' on entity '<TABLE_NAME>'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names. in statement [select * from SFORCE.ACCOUNT]
  at weblogic.jdbc.sforcebase.ddcn.b(Unknown Source)
  at weblogic.jdbc.sforcebase.ddcn.a(Unknown Source)
  at weblogic.jdbc.sforcebase.ddcm.b(Unknown Source)
  at weblogic.jdbc.sforcebase.ddcm.a(Unknown Source)
  at weblogic.jdbc.sforcecloud.ddd.a(Unknown Source)
  at weblogic.jdbc.sforcecloud.ddh.p(Unknown Source)
  at weblogic.jdbc.sforcebase.ddez._(Unknown Source)
  at weblogic.jdbc.sforcebase.ddez.z(Unknown Source)
  at weblogic.jdbc.sforcebase.dddu.executeQuery(Unknown Source)
  at com.borland.dx.sql.dataset.o.f(Unknown Source)
  at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)
  at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
  at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)
  at com.borland.dx.sql.dataset.QueryDataSet.refresh(Unknown Source)
  at com.sunopsis.graphical.frame.edit.AbstractEditFrameGridBorland.initialize(
  at com.sunopsis.graphical.frame.edit.AbstractEditFrameGridBorland.(
  at com.sunopsis.graphical.frame.edit.EditFrameTableData.(
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
  at java.lang.reflect.Constructor.newInstance(
  at ...

To reproduce the behavior:

  1. Reverse-engineer Salesforce objects
  2. Observe that there is a new attribute added to the corresponding Datastores. However, the attribute actually doesn't exist on the Salesforce back-end server
  3. Remove the additional attribute from the Salesforce model in ODI
  4. Right-click on the Model (or Datastore) and select "View Data". Notice the error.


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

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