java.sql.SQLException

tip

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • ODI : Load Plan Error : BI APPS 11.1.1.7.1
    via by user11156570,
  • ODI Load Plan in BI APPS 11.1.1.7.1
    via by user11156570,
  • Invalid username/password running Data Load Plan
    via by David Brenchley,
  • RE: Oracle Special Character Password
    via by Unknown author,
  • Oracle DBA Forums > Jdbc connection problem
    via by Unknown author,
    • java.sql.SQLException: ORA-01017: invalid username/password; logon denied at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144) at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73) at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:87) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) at com.sunopsis.sql.SnpsConnection.createConnection(SnpsConnection.java:520) at com.sunopsis.sql.SnpsConnection.connect(SnpsConnection.java:476) at oracle.odi.runtime.agent.execution.SessionExecutor.changeIsolationLevel(SessionExecutor.java:876) at oracle.odi.runtime.agent.execution.AbstractSessionTask.createSrcTargetConnectionsInFixedOrder(AbstractSessionTask.java:1747) at oracle.odi.runtime.agent.execution.AbstractSessionTask.getCollectDwgConnectConnection(AbstractSessionTask.java:759) at oracle.odi.runtime.agent.execution.AbstractSessionTask.getCollectDwgConnectConnection(AbstractSessionTask.java:730) at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:141) at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:111) at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:864) at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2024) at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.run(SessionExecutor.java:1951) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:391) at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1126) at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:503) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:436) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1021) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:682) at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:789) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:608) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:412) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:385) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:352) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:331) at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:228) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ... 1 more

    Users with the same issue

    treefolktreefolk
    21 times, last one,
    MichaelMichael
    1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor2 times, last one,
    77 more bugmates