My Oracle Support Banner

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 NOVEMBER 05, 2019

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 and later
Information 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


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