"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 NOVEMBER 16, 2021
Applies to:
Oracle Data Integrator - Version 12.1.2.0.0 to 12.2.1.3.2 [Release 12c]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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |