My Oracle Support Banner

"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 JUNE 29, 2018

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

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.