"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 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

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)

Changes

 

Cause

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