"ODI-26039: Connection failed. INVALID_LOGIN: User name, password, security token valid, or blocked user " When Testing Salesforce.com Data Server Connection

(Doc ID 2314143.1)

Last updated on OCTOBER 11, 2017

Applies to:

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


When attempting to test the connection to an Oracle Data Integrator (ODI) 12c Data Server created under Salesforce.com technology in ODI Topology, the following error is observed even after passing the correct username and password of Salesforce.com:

ODI-26039: Connection failed.

Exception Stack Trace:
oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: [FMWGEN] [SForce JDBC Driver] [SForce] INVALID_LOGIN: User name, password, security token valid, or blocked user.
  at oracle.odi.runtime.agent. invocation. RemoteRuntimeAgentInvoker. invoke (RemoteRuntimeAgentInvoker.java: 439)
  at oracle.odi: runtime: agent. InternalRemoteRuntimeAgentInvoker. invoke (invocation. support. InternalRemoteRuntimeAgentInvoker.java: 162)
  at oracle.odi: runtime: agent. invocation. RemoteRuntimeAgentInvoker. invokeTestDataServer (RemoteRuntimeAgentInvoker.java: 1118)
  at com. sunopsis. graphical. dialog. SnpsDialogTestConnet. remoteTestConn (SnpsDialogTestConnet.java: 664)
  at com. sunopsis. graphical. dialog. SnpsDialogTestConnet $9. not (SnpsDialogTestConnet.java: 622)
  at oracle.odi.ui.framework.AbsUIRunnableTask.run (AbsUIRunnableTask.java: 258)
  at oracle.ide.dialogs.ProgressBar.run (ProgressBar.java: 961)
  at java.lang.Thread.run (Thread.java: 745)




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 hundreds of Community platforms