Error Importing Role Grants From OIM To OIA (Doc ID 1583604.1)

Last updated on NOVEMBER 09, 2016

Applies to:

Oracle Identity Analytics - Version 11.1.1.5.1 to 11.1.1.5.6 [Release 11gR2]
Information in this document applies to any platform.

Goal

While importing role grants from OIM into OIA, an error message as below occurs.

Error Importing RoleGrants Records from Staging Tables; nested exception is org.springframework.dao.DeadlockLoserDataAccessException: SqlMapClient operation; SQL []; --- The error occurred in com/vaau/rbacx/dao/ibatis/maps/GlobalUser_Role.xml. --- The error occurred while applying a parameter map. --- Check the updatingExistingStaleAssociations-InlineParameterMap. --- Check the statement (update failed). --- Cause: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource ; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/vaau/rbacx/dao/ibatis/maps/GlobalUser_Role.xml. --- The error occurred while applying a parameter map. --- Check the updatingExistingStaleAssociations-InlineParameterMap. --- Check the statement (update failed). --- Cause: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms