1 Reply Latest reply on Oct 11, 2011 8:02 PM by 848486

    Error Executing Interface using batch file

    848486
      Hi All,

      I am currently using a batch file to execute particular interface from remote location.
      The steps I used before executing are
      1. I have created the scenario for the interface.
      2. I have used this in the batch file to run the interface.
      3. I have mapped the network drive to get the startscen.bat file.

      The error which was generated was (Z - mapped server name)


      Z:\ODI\oracledi\agent\bin>startscen.bat Sample_interface 001 Sample_context -NAME=Sample_AGENT
      OracleDI: Starting scenario SAMPLE_INTERFACE 001 in context SAMPLE_CONTEXT .
      ..
      2011-10-11 10:06:45.404 ERROR ODI-1132 Agent SAMPLE_AGENT encountered an warning: O
      DI-1419: Warning connecting to Agent SAMPLE_AGENT: JDBC connection error occurs whi
      le connecting to the work repository WORKREP.
      ODI-1419: Warning connecting to Agent SAMPLE_AGENT: JDBC connection error occurs wh
      ile connecting to the work repository WORKREP.
      Caused By: oracle.odi.core.config.WorkRepositoryResourceFailureException: org.sp
      ringframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connecti
      on; nested exception is java.sql.SQLException: Exception occurred while getting
      connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection f
      rom Datasource
      at oracle.odi.core.repository.Repository.getWorkRepository(Repository.ja
      va:150)
      at oracle.odi.core.OdiInstance.createWorkRepository(OdiInstance.java:512
      )
      at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:565)
      at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:529)
      at oracle.odi.StartScen.main(StartScen.java:163)
      Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not
      get JDBC Connection; nested exception is java.sql.SQLException: Exception occurr
      ed while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot
      get Connection from Datasource
      at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(Dat
      aSourceUtils.java:82)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
      524)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:58
      8)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:61
      3)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:64
      5)
      at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:111)
      at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:121)
      at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:136)
      at oracle.odi.core.repository.support.RepositoryUtils$RepositoryInfoSour
      ce.loadRepositoryInfo(RepositoryUtils.java:179)
      at oracle.odi.core.repository.support.RepositoryUtils.loadWorkRepository
      Info(RepositoryUtils.java:379)
      at oracle.odi.core.repository.Repository.getWorkRepository(Repository.ja
      va:148)
      ... 4 more
      Caused by: java.sql.SQLException: Exception occurred while getting connection: o
      racle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasourc
      e
      at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnect
      ion(LoginTimeoutDatasourceAdapter.java:133)
      at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnectio
      n(LoginTimeoutDatasourceAdapter.java:62)
      at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(D
      ataSourceUtils.java:113)
      at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(Dat
      aSourceUtils.java:79)
      ... 14 more
      Caused by: java.sql.SQLException: Exception occurred while getting connection: o
      racle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasourc
      e
      at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:
      541)
      at oracle.ucp.jdbc.PoolDataSourceImpl.throwSQLException(PoolDataSourceIm
      pl.java:587)
      at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.j
      ava:668)
      at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.j
      ava:613)
      at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.j
      ava:607)
      at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionPr
      ocessor.run(LoginTimeoutDatasourceAdapter.java:217)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:44
      1)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
      utor.java:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
      .java:908)
      at java.lang.Thread.run(Thread.java:619)
      Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection fr
      om Datasource
      at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(U
      CPErrorHandler.java:421)
      at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(U
      CPErrorHandler.java:389)
      at oracle.ucp.jdbc.DriverConnectionFactoryAdapter.createConnection(Drive
      rConnectionFactoryAdapter.java:133)
      at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPool
      Internal.createOnePooledConnectionInternal(UniversalConnectionPoolImpl.java:1570
      )
      at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPool
      Internal.access$600(UniversalConnectionPoolImpl.java:1378)
      at oracle.ucp.common.UniversalConnectionPoolImpl.createOnePooledConnecti
      on(UniversalConnectionPoolImpl.java:445)
      at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithout
      CountingRequests(UniversalConnectionPoolImpl.java:302)
      at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(Univer
      salConnectionPoolImpl.java:129)
      at oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPoo
      l.java:119)
      at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.j
      ava:655)
      ... 9 more
      Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon de
      nied

      at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.ja
      va:70)
      at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:1
      33)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
      :206)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
      at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthentica
      te.java:799)
      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:368)
      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
      508)
      at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio
      n.java:33)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
      at oracle.ucp.jdbc.DriverConnectionFactoryAdapter.createConnection(Drive
      rConnectionFactoryAdapter.java:129)
      ... 16 more

      Thank you,

      Regards
      Rav