My Oracle Support Banner

ODI Reverse Engineering with Salesforce Tables Causes Multiple "[FMWGEN][SForce JDBC Driver]" Errors (Doc ID 2425138.1)

Last updated on JULY 27, 2018

Applies to:

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


In Oracle Data Integrator (ODI) Studio, after the creation of a second data server to the same Salesforce instance and modifying the connection URL, the following errors may occur while testing the connection:

oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: [FMWGEN][SForce JDBC Driver][SForce]The configuration options used to open the database do not match the options used to create the database.

 java.sql.SQLException: [FMWGEN][SForce JDBC Driver][SForce]The value for connection option customsuffix is invalid.




To view full details, 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 a vibrant support community of peers and Oracle experts.