OBIA 11.1.1.7.1 with ODI Data Loading Error in HR Analytics : Uncategorized exception during repository access

Hi Gurus,

We are working with OBIA 11.1.1.7.1 (with ODI11g instead of Informatica, DAC). We have one with Installation and Configuration. Now we are loading data for only HR Analytics module from EBS source system.  All the system setups and connections are good and data loading process is going smoothly. But, we just got an error like below:

oracle.odi.core.repository.UncategorizedRepositoryAccessException: ODI-10182: Uncategorized exception during repository access.    
Connection has been administratively destroyed because the pool got too many consecutive failed connection tests, and failures to obtain replacement connections from the DBMS. Please see the server log entries at that time for more details. Reconnect. java.lang.Exception: It was destroyed at Wed Jul 10 01:29:17 IST 2013

Image

Please find the error message in below screenshot.

Image

Please see the complete Error Message here.

oracle.odi.core.repository.UncategorizedRepositoryAccessException: ODI-10182: Uncategorized exception during repository access.
Connection has been administratively destroyed because the pool got too many consecutive failed connection tests, and failures to obtain replacement connections from the DBMS. Please see the server log entries at that time for more details. Reconnect. java.lang.Exception: It was destroyed at Wed Jul 10 01:29:17 IST 2013
at weblogic.jdbc.common.internal.ConnectionEnv.destroy(ConnectionEnv.java:616)
at weblogic.common.resourcepool.ResourcePoolImpl.destroyResource(ResourcePoolImpl.java:1887)
at weblogic.common.resourcepool.ResourcePoolImpl.reclaimReservedResources(ResourcePoolImpl.java:1539)
at weblogic.common.resourcepool.ResourcePoolImpl.disablePool(ResourcePoolImpl.java:1515)
at weblogic.common.resourcepool.ResourcePoolImpl.processFailCountExceededDisableThreshold(ResourcePoolImpl.java:1829)
at weblogic.common.resourcepool.ResourcePoolImpl.incrementResetFailCount(ResourcePoolImpl.java:1815)
at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1322)
at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1236)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResourceInternal(ResourcePoolImpl.java:460)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:352)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:339)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:491)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:384)
at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:125)
at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:454)
at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:538)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:498)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:491)
at org.springframework.jdbc.datasource.UserCredentialsDataSourceAdapter.doGetConnection(UserCredentialsDataSourceAdapter.java:162)
at org.springframework.jdbc.datasource.UserCredentialsDataSourceAdapter.getConnection(UserCredentialsDataSourceAdapter.java:133)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:99)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
at oracle.odi.core.security.SecurityManager.retrieveUserGuid(SecurityManager.java:625)
at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:471)
at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:252)
at oracle.odi.repex.model.platform.SecurityService.login(SecurityService.java:22)
at oracle.odi.em.utils.AuthUtil.authenticate(AuthUtil.java:59)
at oracle.odi.em.utils.AuthUtil$EMAuthenticatedAction.execute(AuthUtil.java:182)
at oracle.odi.em.mbeans.impl.AgentRunTime.fetchMasterRepoId(AgentRunTime.java:436)
at oracle.odi.em.mbeans.impl.AgentRunTime.reInitializeJndiMasterRepoIdMap(AgentRunTime.java:86)
at oracle.odi.em.scheduler.ReinitializerBean.reInitializeJndiMasterRepoIdMap(ReinitializerBean.java:77)
at oracle.odi.em.scheduler.ReinitializerBean.reInitJndiMasterRepoIdMap(ReinitializerBean.java:65)
at oracle.odi.em.scheduler.ReinitializerBean.run(ReinitializerBean.java:42)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)

at oracle.odi.core.datasource.dwgobject.support.DataSourceDefinitionFactory.getDataSourceDefinition(DataSourceDefinitionFactory.java:72)
at oracle.odi.core.datasource.dwgobject.support.DwgConnectConnectionCreatorImpl.createDwgConnectConnection(DwgConnectConnectionCreatorImpl.java:80)
at com.sunopsis.dwg.dbobj.SnpSession.createDwgConnectConnection(SnpSession.java:3986)
at com.sunopsis.dwg.dbobj.SnpSessTask.getDefaultDwgConnectConnection(SnpSessTask.java:513)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.getExecutor(SnpSessTaskSql.java:2960)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2901)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1895)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:512)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1068)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:137)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:662)
Caused by: com.sunopsis.dwg.SQLMasterReposException: Connection has been administratively destroyed because the pool got too many consecutive failed connection tests, and failures to obtain replacement connections from the DBMS. Please see the server log entries at that time for more details. Reconnect. java.lang.Exception: It was destroyed at Wed Jul 10 01:29:17 IST 2013
at weblogic.jdbc.common.internal.ConnectionEnv.destroy(ConnectionEnv.java:616)
at weblogic.common.resourcepool.ResourcePoolImpl.destroyResource(ResourcePoolImpl.java:1887)
at weblogic.common.resourcepool.ResourcePoolImpl.reclaimReservedResources(ResourcePoolImpl.java:1539)
at weblogic.common.resourcepool.ResourcePoolImpl.disablePool(ResourcePoolImpl.java:1515)
at weblogic.common.resourcepool.ResourcePoolImpl.processFailCountExceededDisableThreshold(ResourcePoolImpl.java:1829)
at weblogic.common.resourcepool.ResourcePoolImpl.incrementResetFailCount(ResourcePoolImpl.java:1815)
at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1322)
at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1236)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResourceInternal(ResourcePoolImpl.java:460)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:352)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:339)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:491)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:384)
at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:125)
at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:454)
at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:538)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:498)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:491)
at org.springframework.jdbc.datasource.UserCredentialsDataSourceAdapter.doGetConnection(UserCredentialsDataSourceAdapter.java:162)
at org.springframework.jdbc.datasource.UserCredentialsDataSourceAdapter.getConnection(UserCredentialsDataSourceAdapter.java:133)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:99)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
at oracle.odi.core.security.SecurityManager.retrieveUserGuid(SecurityManager.java:625)
at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:471)
at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:252)
at oracle.odi.repex.model.platform.SecurityService.login(SecurityService.java:22)
at oracle.odi.em.utils.AuthUtil.authenticate(AuthUtil.java:59)
at oracle.odi.em.utils.AuthUtil$EMAuthenticatedAction.execute(AuthUtil.java:182)
at oracle.odi.em.mbeans.impl.AgentRunTime.fetchMasterRepoId(AgentRunTime.java:436)
at oracle.odi.em.mbeans.impl.AgentRunTime.reInitializeJndiMasterRepoIdMap(AgentRunTime.java:86)
at oracle.odi.em.scheduler.ReinitializerBean.reInitializeJndiMasterRepoIdMap(ReinitializerBean.java:77)
at oracle.odi.em.scheduler.ReinitializerBean.reInitJndiMasterRepoIdMap(ReinitializerBean.java:65)
at oracle.odi.em.scheduler.ReinitializerBean.run(ReinitializerBean.java:42)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)

at weblogic.jdbc.common.internal.ConnectionEnv.checkIfEnabled(ConnectionEnv.java:1128)
at weblogic.jdbc.wrapper.PoolConnection.checkConnection(PoolConnection.java:63)
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:100)
at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:551)
at com.sunopsis.sql.SnpsQuery.getPreparedStatement(SnpsQuery.java:975)
at com.sunopsis.sql.SnpsQuery.getPreparedStatement(SnpsQuery.java:1016)
at com.sunopsis.sql.SnpsQuery.updateExecStatement(SnpsQuery.java:1850)
at com.sunopsis.sql.SnpsQuery.executeQuery(SnpsQuery.java:595)
at com.sunopsis.dwg.dbobj.generated.GeneratedSnpAgent.getObjectLst(GeneratedSnpAgent.java:789)
at com.sunopsis.dwg.dbobj.SnpAgent.getAgentByName(SnpAgent.java:153)
at com.sunopsis.dwg.dbobj.SnpDatasource.getSnpDatasourceByIConnectAndAgentName(SnpDatasource.java:50)
at oracle.odi.core.datasource.dwgobject.support.DataSourceDefinitionFactory.getDataSourceDefinition(DataSourceDefinitionFactory.java:60)
… 17 more
—————————-

We are new to ODI, so, we are unable to find the solution to resolve the issue. Please guide me on this.

Thanks in Advance.

Raghu Nagadasari

Advertisements

About raghunagadasari

Working with a MNC on BI Applications 7.9.6x, OBIA 11.1.1.7.1. Having work exp on EBS, Oracle Apps, ODI, Informatica, OBIEE, Pl/sql,
This entry was posted in OBIA 11.1.1.7.1, ODI. Bookmark the permalink.

1 Response to OBIA 11.1.1.7.1 with ODI Data Loading Error in HR Analytics : Uncategorized exception during repository access

  1. tkprasad4u says:

    Hi Raghu,

    We are facing the same issue, can you please let us know how this issue got fixed..?

    Thank you,
    Prasad

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s