This discussion is archived
0 Replies Latest reply: Jun 8, 2010 11:47 AM by 807573 RSS

SRM Dataload error during accounts import

807573 Oracle ACE
Currently Being Moderated
The SRM dataload (dataload synchronizes the users,accounts,roles and policy data b/w identity manager and SRM) is getting error out, due to which the latest data is not getting imported into SRM system. We are using Weblogic JDBC datasource to connect to Oracle Database, from the error message it seems to be related to JDBC datasource connectionpool size. So we tried by increasing the connection pool size from 15 to 25 but still the dataload failed with same error messages in rbacx.logs.

Here is sample error message from rbacx.logs,

08:03:25,974 ERROR [LuceneSearchProvider] Unable to update Index. Continuing...
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in com/vaau/rbacx/dao/ibatis/maps/Role.xml.
--- The error occurred while executing query.
--- Check the SELECT ROLES.* FROM ROLES, GLOBALUSER_ROLES WHERE ROLES.ROLEKEY = GLOBALUSER_ROLES.ROLEKEY AND GLOBALUSER_ROLES.GLOBALUSERKEY = ? AND GLOBALUSER_ROLES.STATUS_ID IN ( ? ) .
--- Check the SQL Statement (preparation failed).
--- Cause: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool SRMDataSource to allocate to applications, please increase the size of the pool and retry..
     at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:124)
     at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
     at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
     at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:249)
     at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:296)
     at com.vaau.rbacx.dao.ibatis.SqlMapGlobalUserRoleDao.getRolesByGlobalUser(SqlMapGlobalUserRoleDao.java:38)
     at com.vaau.rbacx.idw.manager.UserManagerImpl.getRolesByGlobalUser(UserManagerImpl.java:125)
     at com.vaau.rbacx.search.manager.impl.providers.LuceneSearchProvider.indexItem(LuceneSearchProvider.java:548)
     at com.vaau.rbacx.search.manager.impl.providers.LuceneSearchProvider.access$400(LuceneSearchProvider.java:53)
     at com.vaau.rbacx.search.manager.impl.providers.LuceneSearchProvider$Indexer.run(LuceneSearchProvider.java:347)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/vaau/rbacx/dao/ibatis/maps/Role.xml.
--- The error occurred while executing query.
--- Check the SELECT ROLES.* FROM ROLES, GLOBALUSER_ROLES WHERE ROLES.ROLEKEY = GLOBALUSER_ROLES.ROLEKEY AND GLOBALUSER_ROLES.GLOBALUSERKEY = ? AND GLOBALUSER_ROLES.STATUS_ID IN ( ? ) .
--- Check the SQL Statement (preparation failed).
--- Cause: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool SRMDataSource to allocate to applications, please increase the size of the pool and retry..
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
     at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
     at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
     at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
     at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298)
     at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
     ... 7 more
Caused by: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool SRMDataSource to allocate to applications, please increase the size of the pool and retry..
     at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:251)
     at weblogic.jdbc.pool.Driver.connect(Driver.java:160)
     at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:642)
     at weblogic.jdbc.jts.Driver.connect(Driver.java:124)
     at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:338)
     at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
     at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210)
     at $Proxy86.prepareStatement(Unknown Source)
     at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:494)
     at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:176)
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
     ... 13 more


Does anyone faced the similar issue during dataload ? any suggestions to resolve the issue ?

Thanks in advance!
Laxmi