Error Executing Interface using batch file
848486Oct 11 2011 — edited Oct 11 2011Hi 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