java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (RBACXSERVICE.PK_ACCT_ATTR_HIER_NODES) violated Occurs During Import (Doc ID 1516020.1)

Last updated on AUGUST 15, 2017

Applies to:

Oracle Identity Analytics - Version 5.0.3 and later
Information in this document applies to any platform.
Checked for relevance on 02-Jul-2014

Symptoms

When importing get the following error:

03:42:01,065 ERROR [XMLAccountFileReader] ---> Error occured file reading file:
java.lang.RuntimeException: Unable to import accounts
                        at com.vaau.rbacx.iam.file.xml.XMLAccountFileReader.importAccounts(XMLAccountFileReader.java:225)
                        at com.vaau.rbacx.iam.file.xml.XMLAccountFileReader.readInternal(XMLAccountFileReader.java:130)
                        at com.vaau.rbacx.iam.file.support.AbstractFileReader.read(AbstractFileReader.java:137)
                        at com.vaau.rbacx.iam.file.support.AbstractFileReader.run(AbstractFileReader.java:78)
                        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
                        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
                        at java.lang.Thread.run(Thread.java:662)
Caused by: org.springframework.dao.DataIntegrityViolationException: SqlMapClient operation; SQL [];   
--- The error occurred in com/vaau/rbacx/dao/ibatis/maps/AccountAttributeWrapper.xml.  
--- The error occurred while applying a parameter map.  
--- Check the insertAccountAttributeHierarchyNode-InlineParameterMap.  
--- Check the statement (update failed).  
--- Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (RBACXSERVICE2.PK_ACCT_ATTR_HIER_NODES) violated
; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/vaau/rbacx/dao/ibatis/maps/AccountAttributeWrapper.xml.  
--- The error occurred while applying a parameter map.  
--- Check the insertAccountAttributeHierarchyNode-InlineParameterMap.  
--- Check the statement (update failed).  
--- Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (RBACXSERVICE2.PK_ACCT_ATTR_HIER_NODES) violated

                        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:228)
                        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
                        at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
                        at com.vaau.rbacx.dao.ibatis.SqlMapAccountAttributeWrapperDao.insertAttributeHierarchyNodes(SqlMapAccountAttributeWrapperDao.java:172)
                        at com.vaau.rbacx.manager.AccountManagerImpl.insertAccountAttributeWrappers(AccountManagerImpl.java:1049)
                        at com.vaau.rbacx.manager.AccountManagerImpl.insertAccountAttributeWrappers(AccountManagerImpl.java:974)
                        at com.vaau.rbacx.manager.AccountManagerImpl.createAccounts(AccountManagerImpl.java:198)
                        at com.vaau.rbacx.manager.AccountManagerImpl.createOrUpdateAccounts(AccountManagerImpl.java:138)
                        at com.vaau.rbacx.core.support.RbacxDataImporterImpl.importAccounts(RbacxDataImporterImpl.java:708)
                        at sun.reflect.GeneratedMethodAccessor3993.invoke(Unknown Source)
                        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                        at java.lang.reflect.Method.invoke(Method.java:597)
                        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
                        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
                        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                        at $Proxy123.importAccounts(Unknown Source)
                        at com.vaau.rbacx.iam.file.xml.XMLAccountFileReader.importAccounts(XMLAccountFileReader.java:187)
                        ... 6 more
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/vaau/rbacx/dao/ibatis/maps/AccountAttributeWrapper.xml.  
--- The error occurred while applying a parameter map.  
--- Check the insertAccountAttributeHierarchyNode-InlineParameterMap.  
--- Check the statement (update failed).  
--- Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (RBACXSERVICE2.PK_ACCT_ATTR_HIER_NODES) violated

                        at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107)
                        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:393)
                        at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
                        at com.vaau.rbacx.dao.ibatis.SqlMapAccountAttributeWrapperDao$2.doInSqlMapClient(SqlMapAccountAttributeWrapperDao.java:179)
                        at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
                        ... 23 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (RBACXSERVICE2.PK_ACCT_ATTR_HIER_NODES) violated

                        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
                        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
                        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
                        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
                        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
                        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
                        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
                        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1009)
                        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
                        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
                        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
                        at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
                        at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
                        at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:80)
                        at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)
                        at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)
                        ... 27 more

Changes

Upgrade from Sun Role Manager 4.x to 5.0.3 or later.

Cause

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