ODI Salesforce.com Technology Load Error "[SForce JDBC Driver][SForce]INVALID_LOGIN: Invalid username, password, security token; or user locked out." with Valid Credentials
(Doc ID 2462724.1)
Last updated on JUNE 16, 2022
Applies to:
Oracle Data Integrator - Version 12.2.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
When connecting to a SalesForce.com source from Oracle Data Integrator (ODI) 12.2.1, a connection test is successful with the user and password specified, however, the loading step in the LKM fails with the following error:
ODI-1217: Session <SESSION_NAME> (<ID>) fails with return code ODI-1298.
ODI-1226: Step <Physical_STEP> fails after 1 attempt(s).
ODI-1227: Task SERIAL-MAP_MAIN-<TASK> fails on the source connection .
ODI-1298: Serial task "SERIAL-MAP_MAIN-<TASK> (<ID2>)" failed because child task "SERIAL-<TASK2> (<ID3>)" is in error.
ODI-1298: Serial task "SERIAL-<TASK2> (<ID3>)" failed because child task "Insert new rows-LKM SQL to SQL (Built-In)-Load <DATABASE_AP> (<ID4>)" is in error.
Caused By: oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLDataException: [FMWGEN][SForce JDBC Driver][SForce]The maximum number of web service calls per statement has been exceeded. in statement [<SQL statement>]
at oracle.odi.runtime.agent.execution.sql.concurrent.FastJDBCRecordSet.call(FastJDBCRecordSet.java:348)
at oracle.odi.runtime.agent.execution.sql.concurrent.FastJDBCRecordSet.call(FastJDBCRecordSet.java:47)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLDataException: [FMWGEN][SForce JDBC Driver][SForce]The maximum number of web service calls per statement has been exceeded. in statement [<SQL statement>]
at weblogic.jdbc.sforcebase.ddcn.b(Unknown Source)
at weblogic.jdbc.sforcebase.ddcn.a(Unknown Source)
at weblogic.jdbc.sforcebase.ddcm.b(Unknown Source)
at weblogic.jdbc.sforcebase.ddcm.a(Unknown Source)
at weblogic.jdbc.sforcecloud.ddd.a(Unknown Source)
at weblogic.jdbc.sforcecloud.ddh.l(Unknown Source)
at weblogic.jdbc.sforcecloud.ddg.d(Unknown Source)
at weblogic.jdbc.sforcebase.ddc3.ab(Unknown Source)
at weblogic.jdbc.sforcebase.ddd1.next(Unknown Source)
at oracle.odi.runtime.agent.execution.sql.concurrent.FastJDBCRecordSet.call(FastJDBCRecordSet.java:328)
... 5 more
When the StmtCallLimit=0 option is added to the JDBC URL to specify a change from the default value of '20' to unlimited, the error changes to the following:
java.sql.SQLException: [FMWGEN][SForce JDBC Driver][SForce]INVALID_LOGIN: Invalid username, password, security token; or user locked out.
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
at com.sunopsis.sql.SnpsConnection.textConnection(SnpsConnection.java:1258)
...
Caused by: java.sql.SQLException: [FMWGEN][SForce JDBC Driver][SForce]INVALID_LOGIN: Invalid username, password, security token; or user locked out.
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
...
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 |
Contacting Salesforce |
Disable Error |
References |