New Salesforce.com Tables Seem Hidden from Reverse Engineering in ODI 12c

Last updated on JULY 06, 2018

Applies to:

Symptoms

The new Salesforce.com API has introduced new tables, ie PRODUCTITEM and LOCATION in API 39.0. These tables are not included when reverse-engineering with ODI 12.2.1.2.6.

Also, for test purposes, when attempting to connect using the API version as part of salesforce jdbc URL, ie: "jdbc: weblogic: sforce: //test.salesforce.com/services/Soap/u/39.0", the following occurs:

oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: [FMWGEN][SForce JDBC Driver][SForce]weblogic.sforce.externals.org.apache.cxf.interceptor.Fault: Unmarshalling Error: unexpected element (uri:"urn:partner.soap.sforce.com", local:"chatterExternal"). Expected elements are <{urn:partner.soap.sforce.com}userTimeZone>, ....

Caused by: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: [FMWGEN][SForce JDBC Driver][SForce]weblogic.sforce.externals.org.apache.cxf.interceptor.Fault: Unmarshalling Error: unexpected element (uri:"urn:partner.soap.sforce.com", local:"orgDefaultCurrencyLocale"). Expected elements are <{urn:partner.soap.sforce.com}userTimeZone>,<{urn:partner.soap.sforce.com}userLanguage>,<{urn:partner.soap.sforce.com}userId>,<{urn:partner.soap.sforce.com}userName>,<{urn:partner.soap.sforce.com}currencySymbol>,<{urn:partner.soap.sforce.com}userFullName>,<{urn:partner.soap.sforce.com}roleId>,<{urn:partner.soap.sforce.com}organizationName>,<{urn:partner.soap.sforce.com}userLocale>,<{urn:partner.soap.sforce.com}accessibilityMode>,<{urn:partner.soap.sforce.com}userType>,<{urn:partner.soap.sforce.com}orgHasPersonAccounts>,<{urn:partner.soap.sforce.com}orgDisallowHtmlAttachments>,<{urn:partner.soap.sforce.com}userEmail>,<{urn:partner.soap.sforce.com}userUiSkin>,<{urn:partner.soap.sforce.com}orgDefaultCurrencyIsoCode>,<{urn:partner.soap.sforce.com}orgAttachmentFileSizeLimit>,<{urn:partner.soap.sforce.com}userDefaultCurrencyIsoCode>,<{urn:partner.soap.sforce.com}profileId>,<{urn:partner.soap.sforce.com}sessionSecondsValid>,<{urn:partner.soap.sforce.com}organizationId>,<{urn:partner.soap.sforce.com}organizationMultiCurrency>
at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor$1.doAction(TestDataServerProcessor.java:276)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:173)
at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor.doProcessRequest(TestDataServerProcessor.java:121)
... 24 more

The error above does not occur when the following URL is used: "jdbc: weblogic: sforce: //test.salesforce.com/services/Soap/u/34.0"

NOTE: Oracle recommends using a URL similar to this: "jdbc: weblogic: sforce: //test.salesforce.com" or "jdbc: weblogic: sforce: //login.salesforce.com", and the above URL is just used for test purposes

Changes

Cause