There's the error within OIA

ERROR Error Importing Records from Staging Tables Error retrieving exception; nested exception is org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in com/vaau/rbacx/iam/db/dao/ibatis/maps/IamDbUser.xml. --- The error occurred while executing query. --- Check the select id from oia_staging_users . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/vaau/rbacx/iam/db/dao/ibatis/maps/IamDbUser.xml. --- The error occurred while executing query. --- Check the select id from oia_staging_users . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource

There are a few things that need to be taken. Firstly, you need to Integrate OIM and OIA 11g. The steps in question are steps 5 and 6 where you are concerned about. You also need to be are that the password and encrypted.password is in question. This was changed without notice within OIM 11g and OIM 11gR2.

Within the iam.contents file located within the WEB-INF directory, make sure you have selected the correct commons file. You can see below that the 11g commons file is selected. if you're using OIM 11gR2, select the other file.

Once you've selected the commons file, navigate to that selected file and make sure that either the password or encrypted.password line. If you're using the OIM encrypted file, then select the line as stated within the file.

About the author