Hi,
I found an error during the agent stop.
The same error occurred when launching an odi package in which a second package was lauched.
This occurs randomly.
I have also restart Agent Service.
The version of ODI is 11.1.1.6.
The repository is on Oracle 11gR2 and it is installed on the same machine of ODI Agent.
Error :
[odi] [ERROR] [] [oracle.odi.agent] [tid: 10] [ecid: ********************] ODI-10181: Uncategorized configuration exception. [[
Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call oracle.odi.core.config.UncategorizedConfigurationException: ODI-10181: Uncategorized configuration exception.
Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call
at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:594)
at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:521)
at oracle.odi.KillAgent.run(KillAgent.java:134)
at oracle.odi.KillAgent.main(KillAgent.java:190)
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:329)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:405)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:413)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:421)
at oracle.odi.core.security.support.PasswordStorageConfigurationDao.getPasswordStorageConfiguration(PasswordStorageConfigurationDao.java:63)
at oracle.odi.core.security.support.csf.CsfUtils$1.create(CsfUtils.java:73)
at org.springframework.util.CachingMapDecorator.get(CachingMapDecorator.java:152)
at oracle.odi.core.security.support.csf.CsfUtils.getPasswordStorageConfiguration(CsfUtils.java:98)
at oracle.odi.core.security.support.csf.CsfUtils.isUsingCsf(CsfUtils.java:137)
at com.sunopsis.dwg.dbobj.SnpConnect.getObjectFieldsFromDb(SnpConnect.java:1286)
at com.sunopsis.dwg.dbobj.generated.GeneratedSnpConnect.getObjectByIdent(GeneratedSnpConnect.java:1074)
at com.sunopsis.dwg.dbobj.DwgConnectConnection.createMasterDwgConnectConnection(DwgConnectConnection.java:120)
at com.sunopsis.dwg.dbobj.DwgConnectConnection.createMasterDwgConnectConnection(DwgConnectConnection.java:167)
at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:126)
at oracle.odi.core.OdiInstance.createMasterRepository(OdiInstance.java:491)
at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:544)
... 3 more
Caused by: java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
... 19 more
Can you help me ?
Thank's in advance.