0% found this document useful (0 votes)
25 views28 pages

Error AD

svdfsdsa

Uploaded by

Revanth
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
25 views28 pages

Error AD

svdfsdsa

Uploaded by

Revanth
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 28

Error : in JMC Active Directory Group Aggregation

Exception during aggregation of CN=CereCore Analysts,OU=Restricted Groups,OU=_JMC


Groups,OU=JMC Users and Computers,DC=jmc,DC=com. Reason:
org.hibernate.exception.ConstraintViolationException: could not execute statement
Exception during aggregation of CN=CereCore Level One Agents,OU=_JMC Groups,OU=JMC
Users and Computers,DC=jmc,DC=com. Reason:
org.hibernate.exception.ConstraintViolationException: could not execute statement
Exception during aggregation of CN=CereCore Provisioning Access,OU=_JMC
Groups,OU=JMC Users and Computers,DC=jmc,DC=com. Reason:
org.hibernate.exception.ConstraintViolationException: could not execute statement
Pruning cyclical group hierarchy: Active Directory: group
CN=CHC_Users_Group,OU=Groups,OU=ChangeHealthcare,OU=_Service Accounts,DC=jmc,DC=com
cannot inherit CN=CHC_Hemo_Group,OU=Groups,OU=ChangeHealthcare,OU=_Service
Accounts,DC=jmc,DC=com, cycle in []

Logs are belw :

2024-11-06T06:11:18,312 WARN Thread-15747 sailpoint.api.AccountGroupService:161 -


Duplicate account group found for : Active DirectorymemberOfCN=KB4 Exclusion
Group,OU=_JMC Groups,OU=JMC Users and Computers,DC=jmc,DC=com
2024-11-06T06:11:18,312 WARN Thread-15747 engine.jdbc.spi.SqlExceptionHelper:137 -
SQL Error: 2627, SQLState: 23000
2024-11-06T06:11:18,312 ERROR Thread-15747 engine.jdbc.spi.SqlExceptionHelper:142 -
Violation of UNIQUE KEY constraint 'UK_prmbsvo2fb4pei4ff9a5m2kso'. Cannot insert
duplicate key in object 'identityiq.spt_managed_attribute'. The duplicate key value
is (14cdb7217eab52b07706b6e5743783beaabbf42e).
2024-11-06T06:11:18,327 ERROR Thread-15747 sailpoint.api.Aggregator:1860 -
Exception during aggregation of CN=CereCore Analysts,OU=Restricted Groups,OU=_JMC
Groups,OU=JMC Users and Computers,DC=jmc,DC=com. Reason:
org.hibernate.exception.ConstraintViolationException: could not execute statement
sailpoint.tools.GeneralException:
org.hibernate.exception.ConstraintViolationException: could not execute statement
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:553) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.persistence.ClassPersistenceManager.commitTransaction(ClassPersistenceMan
ager.java:207) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.server.InternalContext.commitTransaction(InternalContext.java:557)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.createAccountGroup(Aggregator.java:5930)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.getInheritedGroup(Aggregator.java:6281)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.assignHierarchy(Aggregator.java:6169)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.refreshAccountGroup(Aggregator.java:6120)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateGroup(Aggregator.java:5800)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.api.Aggregator.aggregationPartitionedGroups(Aggregator.java:5595)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateGroups(Aggregator.java:5318)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateApplication(Aggregator.java:2659)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.phaseAggregate(Aggregator.java:2571)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.execute(Aggregator.java:2221) [identityiq.jar:8.2
Build 37a86433aae-20210701-135613]
at
sailpoint.request.AggregationRequestExecutor.execute(AggregationRequestExecutor.jav
a:95) [identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.request.RequestHandler.run(RequestHandler.java:163)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.ConstraintViolationException: could not execute statement
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
54) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
81) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
88) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1366)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute
statement
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConvers
ionDelegate.java:109) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLE
xceptionConverter.java:42) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:11
3) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99
) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetRetur
nImpl.java:200) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3302) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3823) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:10
7) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(Abstra
ctFlushingEventListener.java:348) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventLis
tener.java:40) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener
(EventListenerGroupImpl.java:102) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of UNIQUE KEY
constraint 'UK_prmbsvo2fb4pei4ff9a5m2kso'. Cannot insert duplicate key in object
'identityiq.spt_managed_attribute'. The duplicate key value is
(14cdb7217eab52b07706b6e5743783beaabbf42e).
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerExce
ption.java:262) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.ja
va:1632) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(
SQLServerPreparedStatement.java:602) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(S
QLServerPreparedStatement.java:524) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7375)
~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection
.java:3206) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.j
ava:247) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement
.java:222) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPrep
aredStatement.java:473) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPrepar
edStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPrepar
edStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetRetur
nImpl.java:197) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3302) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3823) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:10
7) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(Abstra
ctFlushingEventListener.java:348) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventLis
tener.java:40) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener
(EventListenerGroupImpl.java:102) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
2024-11-06T06:11:18,343 ERROR Thread-15747 sailpoint.api.Aggregator:5625 -
Exception during aggregation (Last group was: CN=CereCore Analysts,OU=Restricted
Groups,OU=_JMC Groups,OU=JMC Users and
Computers,DC=jmc,DC=com)org.hibernate.exception.ConstraintViolationException: could
not execute statement
sailpoint.tools.GeneralException:
org.hibernate.exception.ConstraintViolationException: could not execute statement
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:553) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.persistence.ClassPersistenceManager.commitTransaction(ClassPersistenceMan
ager.java:207) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.server.InternalContext.commitTransaction(InternalContext.java:557)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.createAccountGroup(Aggregator.java:5930)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.getInheritedGroup(Aggregator.java:6281)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.assignHierarchy(Aggregator.java:6169)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.refreshAccountGroup(Aggregator.java:6120)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateGroup(Aggregator.java:5800)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.api.Aggregator.aggregationPartitionedGroups(Aggregator.java:5595)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateGroups(Aggregator.java:5318)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateApplication(Aggregator.java:2659)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.phaseAggregate(Aggregator.java:2571)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.execute(Aggregator.java:2221) [identityiq.jar:8.2
Build 37a86433aae-20210701-135613]
at
sailpoint.request.AggregationRequestExecutor.execute(AggregationRequestExecutor.jav
a:95) [identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.request.RequestHandler.run(RequestHandler.java:163)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.ConstraintViolationException: could not execute statement
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
54) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
81) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
88) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1366)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute
statement
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConvers
ionDelegate.java:109) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLE
xceptionConverter.java:42) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:11
3) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99
) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetRetur
nImpl.java:200) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3302) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3823) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:10
7) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(Abstra
ctFlushingEventListener.java:348) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventLis
tener.java:40) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener
(EventListenerGroupImpl.java:102) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of UNIQUE KEY
constraint 'UK_prmbsvo2fb4pei4ff9a5m2kso'. Cannot insert duplicate key in object
'identityiq.spt_managed_attribute'. The duplicate key value is
(14cdb7217eab52b07706b6e5743783beaabbf42e).
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerExce
ption.java:262) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.ja
va:1632) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(
SQLServerPreparedStatement.java:602) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(S
QLServerPreparedStatement.java:524) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7375)
~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection
.java:3206) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.j
ava:247) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement
.java:222) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPrep
aredStatement.java:473) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPrepar
edStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPrepar
edStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetRetur
nImpl.java:197) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3302) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3823) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:10
7) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(Abstra
ctFlushingEventListener.java:348) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventLis
tener.java:40) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener
(EventListenerGroupImpl.java:102) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
2024-11-06T06:11:18,343 WARN Thread-15747 sailpoint.api.AccountGroupService:161 -
Duplicate account group found for : Active DirectorymemberOfCN=KB4 Exclusion
Group,OU=_JMC Groups,OU=JMC Users and Computers,DC=jmc,DC=com
2024-11-06T06:11:18,359 WARN Thread-15747 engine.jdbc.spi.SqlExceptionHelper:137 -
SQL Error: 2627, SQLState: 23000
2024-11-06T06:11:18,359 ERROR Thread-15747 engine.jdbc.spi.SqlExceptionHelper:142 -
Violation of UNIQUE KEY constraint 'UK_prmbsvo2fb4pei4ff9a5m2kso'. Cannot insert
duplicate key in object 'identityiq.spt_managed_attribute'. The duplicate key value
is (14cdb7217eab52b07706b6e5743783beaabbf42e).
2024-11-06T06:11:18,359 ERROR Thread-15747 sailpoint.api.Aggregator:1860 -
Exception during aggregation of CN=CereCore Level One Agents,OU=_JMC Groups,OU=JMC
Users and Computers,DC=jmc,DC=com. Reason:
org.hibernate.exception.ConstraintViolationException: could not execute statement
sailpoint.tools.GeneralException:
org.hibernate.exception.ConstraintViolationException: could not execute statement
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:553) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.persistence.ClassPersistenceManager.commitTransaction(ClassPersistenceMan
ager.java:207) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.server.InternalContext.commitTransaction(InternalContext.java:557)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.createAccountGroup(Aggregator.java:5930)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.getInheritedGroup(Aggregator.java:6281)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.assignHierarchy(Aggregator.java:6169)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.refreshAccountGroup(Aggregator.java:6120)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateGroup(Aggregator.java:5800)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.api.Aggregator.aggregationPartitionedGroups(Aggregator.java:5595)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateGroups(Aggregator.java:5318)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateApplication(Aggregator.java:2659)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.phaseAggregate(Aggregator.java:2571)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.execute(Aggregator.java:2221) [identityiq.jar:8.2
Build 37a86433aae-20210701-135613]
at
sailpoint.request.AggregationRequestExecutor.execute(AggregationRequestExecutor.jav
a:95) [identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.request.RequestHandler.run(RequestHandler.java:163)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.ConstraintViolationException: could not execute statement
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
54) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
81) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
88) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1366)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute
statement
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConvers
ionDelegate.java:109) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLE
xceptionConverter.java:42) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:11
3) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99
) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetRetur
nImpl.java:200) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3302) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3823) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:10
7) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(Abstra
ctFlushingEventListener.java:348) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventLis
tener.java:40) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener
(EventListenerGroupImpl.java:102) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of UNIQUE KEY
constraint 'UK_prmbsvo2fb4pei4ff9a5m2kso'. Cannot insert duplicate key in object
'identityiq.spt_managed_attribute'. The duplicate key value is
(14cdb7217eab52b07706b6e5743783beaabbf42e).
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerExce
ption.java:262) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.ja
va:1632) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(
SQLServerPreparedStatement.java:602) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(S
QLServerPreparedStatement.java:524) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7375)
~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection
.java:3206) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.j
ava:247) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement
.java:222) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPrep
aredStatement.java:473) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPrepar
edStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPrepar
edStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetRetur
nImpl.java:197) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3302) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3823) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:10
7) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(Abstra
ctFlushingEventListener.java:348) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventLis
tener.java:40) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener
(EventListenerGroupImpl.java:102) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
2024-11-06T06:11:18,359 ERROR Thread-15747 sailpoint.api.Aggregator:5625 -
Exception during aggregation (Last group was: CN=CereCore Level One Agents,OU=_JMC
Groups,OU=JMC Users and
Computers,DC=jmc,DC=com)org.hibernate.exception.ConstraintViolationException: could
not execute statement
sailpoint.tools.GeneralException:
org.hibernate.exception.ConstraintViolationException: could not execute statement
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:553) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.persistence.ClassPersistenceManager.commitTransaction(ClassPersistenceMan
ager.java:207) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.server.InternalContext.commitTransaction(InternalContext.java:557)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.createAccountGroup(Aggregator.java:5930)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.getInheritedGroup(Aggregator.java:6281)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.assignHierarchy(Aggregator.java:6169)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.refreshAccountGroup(Aggregator.java:6120)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateGroup(Aggregator.java:5800)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.api.Aggregator.aggregationPartitionedGroups(Aggregator.java:5595)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateGroups(Aggregator.java:5318)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateApplication(Aggregator.java:2659)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.phaseAggregate(Aggregator.java:2571)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.execute(Aggregator.java:2221) [identityiq.jar:8.2
Build 37a86433aae-20210701-135613]
at
sailpoint.request.AggregationRequestExecutor.execute(AggregationRequestExecutor.jav
a:95) [identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.request.RequestHandler.run(RequestHandler.java:163)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.ConstraintViolationException: could not execute statement
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
54) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
81) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
88) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1366)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute
statement
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConvers
ionDelegate.java:109) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLE
xceptionConverter.java:42) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:11
3) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99
) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetRetur
nImpl.java:200) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3302) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3823) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:10
7) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(Abstra
ctFlushingEventListener.java:348) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventLis
tener.java:40) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener
(EventListenerGroupImpl.java:102) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of UNIQUE KEY
constraint 'UK_prmbsvo2fb4pei4ff9a5m2kso'. Cannot insert duplicate key in object
'identityiq.spt_managed_attribute'. The duplicate key value is
(14cdb7217eab52b07706b6e5743783beaabbf42e).
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerExce
ption.java:262) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.ja
va:1632) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(
SQLServerPreparedStatement.java:602) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(S
QLServerPreparedStatement.java:524) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7375)
~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection
.java:3206) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.j
ava:247) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement
.java:222) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPrep
aredStatement.java:473) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPrepar
edStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPrepar
edStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetRetur
nImpl.java:197) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3302) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3823) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:10
7) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(Abstra
ctFlushingEventListener.java:348) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventLis
tener.java:40) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener
(EventListenerGroupImpl.java:102) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
2024-11-06T06:11:18,374 WARN Thread-15748 sailpoint.api.ManagedAttributer:898 -
More than one matching ManagedAttribute: 0a0a3033813b161781813b501ff50022, CN=KB4
Exclusion Group,OU=_JMC Groups,OU=JMC Users and Computers,DC=jmc,DC=com, group,
memberOf
2024-11-06T06:11:18,374 WARN Thread-15747 sailpoint.api.AccountGroupService:161 -
Duplicate account group found for : Active DirectorymemberOfCN=KB4 Exclusion
Group,OU=_JMC Groups,OU=JMC Users and Computers,DC=jmc,DC=com
2024-11-06T06:11:18,374 WARN Thread-15747 engine.jdbc.spi.SqlExceptionHelper:137 -
SQL Error: 2627, SQLState: 23000
2024-11-06T06:11:18,374 ERROR Thread-15747 engine.jdbc.spi.SqlExceptionHelper:142 -
Violation of UNIQUE KEY constraint 'UK_prmbsvo2fb4pei4ff9a5m2kso'. Cannot insert
duplicate key in object 'identityiq.spt_managed_attribute'. The duplicate key value
is (14cdb7217eab52b07706b6e5743783beaabbf42e).
2024-11-06T06:11:18,374 ERROR Thread-15747 sailpoint.api.Aggregator:1860 -
Exception during aggregation of CN=CereCore Provisioning Access,OU=_JMC
Groups,OU=JMC Users and Computers,DC=jmc,DC=com. Reason:
org.hibernate.exception.ConstraintViolationException: could not execute statement
sailpoint.tools.GeneralException:
org.hibernate.exception.ConstraintViolationException: could not execute statement
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:553) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.persistence.ClassPersistenceManager.commitTransaction(ClassPersistenceMan
ager.java:207) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.server.InternalContext.commitTransaction(InternalContext.java:557)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.createAccountGroup(Aggregator.java:5930)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.getInheritedGroup(Aggregator.java:6281)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.assignHierarchy(Aggregator.java:6169)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.refreshAccountGroup(Aggregator.java:6120)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateGroup(Aggregator.java:5800)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.api.Aggregator.aggregationPartitionedGroups(Aggregator.java:5595)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateGroups(Aggregator.java:5318)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateApplication(Aggregator.java:2659)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.phaseAggregate(Aggregator.java:2571)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.execute(Aggregator.java:2221) [identityiq.jar:8.2
Build 37a86433aae-20210701-135613]
at
sailpoint.request.AggregationRequestExecutor.execute(AggregationRequestExecutor.jav
a:95) [identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.request.RequestHandler.run(RequestHandler.java:163)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.ConstraintViolationException: could not execute statement
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
54) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
81) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
88) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1366)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute
statement
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConvers
ionDelegate.java:109) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLE
xceptionConverter.java:42) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:11
3) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99
) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetRetur
nImpl.java:200) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3302) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3823) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:10
7) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(Abstra
ctFlushingEventListener.java:348) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventLis
tener.java:40) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener
(EventListenerGroupImpl.java:102) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of UNIQUE KEY
constraint 'UK_prmbsvo2fb4pei4ff9a5m2kso'. Cannot insert duplicate key in object
'identityiq.spt_managed_attribute'. The duplicate key value is
(14cdb7217eab52b07706b6e5743783beaabbf42e).
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerExce
ption.java:262) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.ja
va:1632) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(
SQLServerPreparedStatement.java:602) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(S
QLServerPreparedStatement.java:524) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7375)
~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection
.java:3206) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.j
ava:247) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement
.java:222) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPrep
aredStatement.java:473) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPrepar
edStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPrepar
edStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetRetur
nImpl.java:197) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3302) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3823) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:10
7) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(Abstra
ctFlushingEventListener.java:348) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventLis
tener.java:40) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener
(EventListenerGroupImpl.java:102) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
2024-11-06T06:11:18,390 ERROR Thread-15747 sailpoint.api.Aggregator:5625 -
Exception during aggregation (Last group was: CN=CereCore Provisioning
Access,OU=_JMC Groups,OU=JMC Users and
Computers,DC=jmc,DC=com)org.hibernate.exception.ConstraintViolationException: could
not execute statement
sailpoint.tools.GeneralException:
org.hibernate.exception.ConstraintViolationException: could not execute statement
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:553) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.persistence.ClassPersistenceManager.commitTransaction(ClassPersistenceMan
ager.java:207) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.server.InternalContext.commitTransaction(InternalContext.java:557)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.createAccountGroup(Aggregator.java:5930)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.getInheritedGroup(Aggregator.java:6281)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.assignHierarchy(Aggregator.java:6169)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.refreshAccountGroup(Aggregator.java:6120)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateGroup(Aggregator.java:5800)
~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at
sailpoint.api.Aggregator.aggregationPartitionedGroups(Aggregator.java:5595)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateGroups(Aggregator.java:5318)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.aggregateApplication(Aggregator.java:2659)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.phaseAggregate(Aggregator.java:2571)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.api.Aggregator.execute(Aggregator.java:2221) [identityiq.jar:8.2
Build 37a86433aae-20210701-135613]
at
sailpoint.request.AggregationRequestExecutor.execute(AggregationRequestExecutor.jav
a:95) [identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
at sailpoint.request.RequestHandler.run(RequestHandler.java:163)
[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.ConstraintViolationException: could not execute statement
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
54) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
81) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:1
88) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1366)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute
statement
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConvers
ionDelegate.java:109) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLE
xceptionConverter.java:42) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:11
3) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99
) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetRetur
nImpl.java:200) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3302) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3823) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:10
7) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(Abstra
ctFlushingEventListener.java:348) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventLis
tener.java:40) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener
(EventListenerGroupImpl.java:102) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of UNIQUE KEY
constraint 'UK_prmbsvo2fb4pei4ff9a5m2kso'. Cannot insert duplicate key in object
'identityiq.spt_managed_attribute'. The duplicate key value is
(14cdb7217eab52b07706b6e5743783beaabbf42e).
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerExce
ption.java:262) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.ja
va:1632) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(
SQLServerPreparedStatement.java:602) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(S
QLServerPreparedStatement.java:524) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7375)
~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection
.java:3206) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.j
ava:247) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement
.java:222) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPrep
aredStatement.java:473) ~[mssql-jdbc-8.4.1.jre8.jar:?]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPrepar
edStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPrepar
edStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetRetur
nImpl.java:197) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3302) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersist
er.java:3823) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:10
7) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(Abstra
ctFlushingEventListener.java:348) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventLis
tener.java:40) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener
(EventListenerGroupImpl.java:102) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.jav
a:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:238
0) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(
JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorI
mpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40)
~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransacti
onCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionC
oordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.ja
va:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at
sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersis
tenceManager.java:538) ~[identityiq.jar:8.2 Build 37a86433aae-20210701-135613]
... 14 more
2024-11-06T06:11:18,781 WARN Thread-15747 sailpoint.api.Aggregator:1868 - Pruning
cyclical group hierarchy: Active Directory: group
CN=CHC_Users_Group,OU=Groups,OU=ChangeHealthcare,OU=_Service Accounts,DC=jmc,DC=com
cannot inherit CN=CHC_Hemo_Group,OU=Groups,OU=ChangeHealthcare,OU=_Service
Accounts,DC=jmc,DC=com, cycle in []
2024-11-06T06:11:25,899 ERROR Thread-15748 sailpoint.server.InternalContext:166 -
owner set :: group/memberOf/CN=Public Folder Management,OU=Microsoft Exchange
Security Groups,DC=jmc,DC=com

You might also like