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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.