org.hibernate.exception.ConstraintViolationException: could not execute statement

Administration & Troubleshooting
,
1

As part of joiner, there are couple of business roles assigning in our project for the users. While provisioning, we are getting the unique constraint violation error,

2022-01-17T00:40:13,519 WARN Workflow Event Thread 9 engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 1, SQLState: 23000
2022-01-17,00:40:13,520 INFO [stdout] (Workflow Event Thread 9) 2022-01-17T00:40:13,520 ERROR Workflow Event Thread 9 engine.jdbc.spi.SqlExceptionHelper:142 - ORA-00001: unique constraint (IDENTITYIQ.SYS_C0010787) violated

Here IDENTITYIQ.SYS_C0010787 refers to the index of the SPT_IDENTITY_ASSIGNED_ROLES table.

I have gone through the logs by each workflow step and found the error is coming at the provision step where step is calling the OOTB provisionProject method from IdentityLibrary.class.

Upon checking the logs we see that it is throwing unique contraint error while saving and committing the identity object in IIQEvalvator.class file.

Any help here is appriciated. Below is the provisioningProject sending to provision step and also logs.

provisioningProject :

Step result variable: project
<?xml version=‘1.0’ encoding=‘UTF-8’?>
<!DOCTYPE ProvisioningProject PUBLIC “sailpoint.dtd” “sailpoint.dtd”>
<ProvisioningProject identity=“X1011570”>
<Attributes>
<Map>
<entry key=“disableRetryRequest”>
<value>
<Boolean>true</Boolean>
</value>
</entry>
<entry key=“identityRequestId” value=“0000269181”/>
<entry key=“noApplicationTemplates” value=“false”/>
<entry key=“noFiltering” value=“false”/>
<entry key=“noLocking”>
<value>
<Boolean>true</Boolean>
</value>
</entry>
<entry key=“optimisticProvisioning” value=“false”/>
<entry key=“requester” value=“svc_apigeeuat_upa”/>
<entry key=“source” value=“LCM”/>
</Map>
</Attributes>
<ExpansionItems>
<ExpansionItem application=“Google Apps” cause=“Role” name=“Groups” operation=“Add” sourceInfo=“Google Apps - Access Request - Gmail Account” value=“01ljsd9k2iwceg6”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“givenName” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“PPeeta”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“familyName” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“Peeta”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“fullName” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“Priyanka Peeta”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“primaryEmail” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“ppeeta@test-woolworthsgroup.com.au”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“changePasswordAtNextLogin” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“true”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“suspended” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“false”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“organizationUnit” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Add” sourceInfo=“Google Apps” value=“/WoolworthsGroup/EnterpriseWorker/External”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“primaryAddress” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Add” sourceInfo=“Google Apps” value=“true”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“addressType” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Add” sourceInfo=“Google Apps” value=“work”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“emailAddress” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Add” sourceInfo=“Google Apps” value=“ppeeta@test-woolworthsgroup.com.au”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“isMailboxSetup” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“true”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“organizationName” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Add” sourceInfo=“Google Apps” value=“Other”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“department” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Add” sourceInfo=“Google Apps” value=“Hong Kong - Food Co Asia and Others”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“organizationLocation” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Add” sourceInfo=“Google Apps” value=“Hogans Corner Woolworths Supermarket 3189”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“primaryOrganization” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Add” sourceInfo=“Google Apps” value=“true”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“organizationTitle” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Add” sourceInfo=“Google Apps” value=“Tester”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“organizationCustomType” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Add” sourceInfo=“Google Apps” value=“work”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“isAdmin” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“false”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“isDelegatedAdmin” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“false”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“isEnrolledIn2Sv” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Add” sourceInfo=“Google Apps” value=“true”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“isEnforcedIn2Sv” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Add” sourceInfo=“Google Apps” value=“true”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“externalIdsType” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Add” sourceInfo=“Google Apps” value=“organization”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“externalIdsValue” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Add” sourceInfo=“Google Apps” value=“X1011570”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“customSchemas.WOWCustomSchema.EmployeeNumber” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“X1011570”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“customSchemas.WOWCustomSchema.SAPID” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“X1011570”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“customSchemas.IIQ_Test.entid” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“PP03164440881”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“customSchemas.IIQ_Test.entlogonid” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“X1011570”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“customSchemas.IIQ_Test.eimIdentityType” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“Enterprise Identity”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“customSchemas.IIQ_Test.eimIdentitySubType” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“Service Provider”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“customSchemas.SSO_Attributes.Primary_Store_ID” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps” value=“6385”/>
<ExpansionItem application=“Google Apps” cause=“ProvisioningPolicy” name=“password” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” operation=“Set” sourceInfo=“Google Apps”/>
</ExpansionItems>
<MasterPlan>
<ProvisioningPlan>
<AccountRequest application=“IIQ” op=“Modify”>
<AttributeRequest name=“assignedRoles” op=“Add” value=“Google Apps - Access Request - Gmail Account”/>
</AccountRequest>
<Attributes>
<Map>
<entry key=“flow” value=“External”/>
<entry key=“identityRequestId” value=“0000269181”/>
<entry key=“launcher” value=“svc_apigeeuat_upa”/>
<entry key=“requestType” value=“EXTERNAL FEATURE”/>
<entry key=“requester” value=“svc_apigeeuat_upa”/>
<entry key=“source” value=“LCM”/>
</Map>
</Attributes>
<Requesters>
<Reference class=“sailpoint.object.Identity” id=“8a181cf36ccdaa32016cd5ac54210bd7” name=“svc_apigeeuat_upa”/>
</Requesters>
</ProvisioningPlan>
</MasterPlan>
<ProvisioningPlan targetIntegration=“IIQ” trackingId=“873489cc1b9a49da82da5d179c566958”>
<AccountRequest application=“IIQ” op=“Modify”>
<AttributeRequest assignmentId=“TEMP:897bb1abefa445279a433a525c8d796f” name=“assignedRoles” op=“Add” value=“Google Apps - Access Request - Gmail Account”/>
</AccountRequest>
<Attributes>
<Map>
<entry key=“flow” value=“External”/>
<entry key=“identityRequestId” value=“0000269181”/>
<entry key=“launcher” value=“svc_apigeeuat_upa”/>
<entry key=“requestType” value=“EXTERNAL FEATURE”/>
<entry key=“requester” value=“svc_apigeeuat_upa”/>
<entry key=“source” value=“LCM”/>
</Map>
</Attributes>
<Requesters>
<Reference class=“sailpoint.object.Identity” id=“8a181cf36ccdaa32016cd5ac54210bd7” name=“svc_apigeeuat_upa”/>
</Requesters>
</ProvisioningPlan>
<ProvisioningPlan targetIntegration=“Google Apps” trackingId=“4d4b0c6e7dce4b55b4482f67d0ea4c19”>
<AccountRequest application=“Google Apps” assignmentIds=“TEMP:897bb1abefa445279a433a525c8d796f” nativeIdentity=“ppeeta@test-woolworthsgroup.com.au” op=“Create”>
<AttributeRequest name=“Groups” op=“Add”>
<Value>
<List>
<String>01ljsd9k2iwceg6</String>
</List>
</Value>
</AttributeRequest>
<AttributeRequest name=“givenName” op=“Set” value=“PPeeta”/>
<AttributeRequest name=“familyName” op=“Set” value=“Peeta”/>
<AttributeRequest name=“fullName” op=“Set” value=“Priyanka Peeta”/>
<AttributeRequest name=“primaryEmail” op=“Set” value=“ppeeta@test-woolworthsgroup.com.au”/>
<AttributeRequest name=“changePasswordAtNextLogin” op=“Set” value=“true”/>
<AttributeRequest name=“password” op=“Set”>
<Attributes>
<Map>
<entry key=“secret” value=“true”/>
</Map>
</Attributes>
</AttributeRequest>
<AttributeRequest name=“suspended” op=“Set” value=“false”/>
<AttributeRequest name=“organizationUnit” op=“Add” value=“/WoolworthsGroup/EnterpriseWorker/External”/>
<AttributeRequest name=“primaryAddress” op=“Add” value=“true”/>
<AttributeRequest name=“addressType” op=“Add” value=“work”/>
<AttributeRequest name=“emailAddress” op=“Add” value=“ppeeta@test-woolworthsgroup.com.au”/>
<AttributeRequest name=“isMailboxSetup” op=“Set” value=“true”/>
<AttributeRequest name=“organizationName” op=“Add” value=“Other”/>
<AttributeRequest name=“department” op=“Add” value=“Hong Kong - Food Co Asia and Others”/>
<AttributeRequest name=“organizationLocation” op=“Add” value=“Hogans Corner Woolworths Supermarket 3189”/>
<AttributeRequest name=“primaryOrganization” op=“Add” value=“true”/>
<AttributeRequest name=“organizationTitle” op=“Add” value=“Tester”/>
<AttributeRequest name=“organizationCustomType” op=“Add” value=“work”/>
<AttributeRequest name=“isAdmin” op=“Set” value=“false”/>
<AttributeRequest name=“isDelegatedAdmin” op=“Set” value=“false”/>
<AttributeRequest name=“isEnrolledIn2Sv” op=“Add” value=“true”/>
<AttributeRequest name=“isEnforcedIn2Sv” op=“Add” value=“true”/>
<AttributeRequest name=“externalIdsType” op=“Add” value=“organization”/>
<AttributeRequest name=“externalIdsValue” op=“Add” value=“X1011570”/>
<AttributeRequest name=“customSchemas.WOWCustomSchema.EmployeeNumber” op=“Set” value=“X1011570”/>
<AttributeRequest name=“customSchemas.WOWCustomSchema.SAPID” op=“Set” value=“X1011570”/>
<AttributeRequest name=“customSchemas.IIQ_Test.entid” op=“Set” value=“PP03164440881”/>
<AttributeRequest name=“customSchemas.IIQ_Test.entlogonid” op=“Set” value=“X1011570”/>
<AttributeRequest name=“customSchemas.IIQ_Test.eimIdentityType” op=“Set” value=“Enterprise Identity”/>
<AttributeRequest name=“customSchemas.IIQ_Test.eimIdentitySubType” op=“Set” value=“Service Provider”/>
<AttributeRequest name=“customSchemas.SSO_Attributes.Primary_Store_ID” op=“Set” value=“6385”/>
</AccountRequest>
<Attributes>
<Map>
<entry key=“flow” value=“External”/>
<entry key=“identityRequestId” value=“0000269181”/>
<entry key=“launcher” value=“svc_apigeeuat_upa”/>
<entry key=“requestType” value=“EXTERNAL FEATURE”/>
<entry key=“requester” value=“svc_apigeeuat_upa”/>
<entry key=“source” value=“LCM”/>
</Map>
</Attributes>
<Requesters>
<Reference class=“sailpoint.object.Identity” id=“8a181cf36ccdaa32016cd5ac54210bd7” name=“svc_apigeeuat_upa”/>
</Requesters>
</ProvisioningPlan>
<ProvisioningTarget assignmentId=“TEMP:897bb1abefa445279a433a525c8d796f” role=“Google Apps - Access Request - Gmail Account”>
<AccountSelection applicationId=“8a181cf66b26cd02016b26cea6170001” applicationName=“Google Apps” doCreate=“true”/>
</ProvisioningTarget>
</ProvisioningProject>

Error Logs :

2022-01-17T00:40:13,519 WARN Workflow Event Thread 9 engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 1, SQLState: 23000
2022-01-17,00:40:13,520 INFO [stdout] (Workflow Event Thread 9) 2022-01-17T00:40:13,520 ERROR Workflow Event Thread 9 engine.jdbc.spi.SqlExceptionHelper:142 - ORA-00001: unique constraint (IDENTITYIQ.SYS_C0010787) violated
2022-01-17,00:40:13,521 INFO [stdout] (Workflow Event Thread 9)
2022-01-17,00:40:13,521 INFO [stdout] (Workflow Event Thread 9) 2022-01-17T00:40:13,521 ERROR Workflow Event Thread 9 org.hibernate.internal.ExceptionMapperStandardImpl:39 - HHH000346: Error during managed flush [org.hibernate.exception.ConstraintViolationException: could not execute statement]
2022-01-17,00:40:13,549 INFO [stdout] (Workflow Event Thread 9) 2022-01-17T00:40:13,529 ERROR Workflow Event Thread 9 sailpoint.server.ScriptletEvaluator:145 - Step call threw an exception:
2022-01-17,00:40:13,569 INFO [stdout] (Workflow Event Thread 9) 2022-01-17T00:40:13,550 ERROR Workflow Event Thread 9 sailpoint.server.ScriptletEvaluator:146 - sailpoint.tools.GeneralException: org.hibernate.exception.ConstraintViolationException: could not execute statement
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersistenceManager.java:544)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.persistence.ClassPersistenceManager.commitTransaction(ClassPersistenceManager.java:207)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.server.InternalContext.commitTransaction(InternalContext.java:527)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.provisioning.IIQEvaluator.provision(IIQEvaluator.java:429)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.provisioning.PlanEvaluator.execute(PlanEvaluator.java:841)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.provisioning.PlanEvaluator.execute(PlanEvaluator.java:710)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Provisioner.execute(Provisioner.java:1694)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.workflow.IdentityLibrary.provisionProject(IdentityLibrary.java:3129)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at java.lang.reflect.Method.invoke(Method.java:498)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.server.ScriptletEvaluator.doCall(ScriptletEvaluator.java:136)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.server.ScriptletEvaluator.evalSource(ScriptletEvaluator.java:65)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.evalSource(Workflower.java:5975)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advanceStep(Workflower.java:5130)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advance(Workflower.java:4519)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.startCase(Workflower.java:3100)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcase(Workflower.java:5433)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcases(Workflower.java:5326)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advanceStep(Workflower.java:5117)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advance(Workflower.java:4519)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.startCase(Workflower.java:3100)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcase(Workflower.java:5433)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcases(Workflower.java:5326)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advanceStep(Workflower.java:5117)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advance(Workflower.java:4519)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.startCase(Workflower.java:3100)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcase(Workflower.java:5433)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcases(Workflower.java:5326)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advanceStep(Workflower.java:5117)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advance(Workflower.java:4519)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.startCase(Workflower.java:3100)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcase(Workflower.java:5433)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcases(Workflower.java:5326)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advanceStep(Workflower.java:5117)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advance(Workflower.java:4519)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.startCase(Workflower.java:3100)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcase(Workflower.java:5433)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcases(Workflower.java:5326)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advanceStep(Workflower.java:5117)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advance(Workflower.java:4519)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.assimilate(Workflower.java:4169)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.handleWorkItem(Workflower.java:7648)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.processEvent(Workflower.java:1888)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.processEvent(Workflower.java:1870)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.task.Housekeeper$WorkflowerThread.process(Housekeeper.java:2207)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.task.Housekeeper$WorkflowerThread.run(Housekeeper.java:2111)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1460)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:511)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3283)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2479)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:178)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:39)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:271)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:98)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersistenceManager.java:529)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) … 47 more
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
2022-01-17,00:40:13,570 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.persister.collection.AbstractCollectionPersister.insertRows(AbstractCollectionPersister.java:1575)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.action.internal.CollectionUpdateAction.execute(CollectionUpdateAction.java:85)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1454)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) … 56 more
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (IDENTITYIQ.SYS_C0010787) violated
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3897)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9) … 64 more
2022-01-17,00:40:13,571 INFO [stdout] (Workflow Event Thread 9)
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) 2022-01-17T00:40:13,571 ERROR Workflow Event Thread 9 sailpoint.api.Workflower:4558 - An unexpected error occurred: org.hibernate.exception.ConstraintViolationException: could not execute statement
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) sailpoint.tools.GeneralException: org.hibernate.exception.ConstraintViolationException: could not execute statement
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersistenceManager.java:544) ~[identityiq.jar:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.persistence.ClassPersistenceManager.commitTransaction(ClassPersistenceManager.java:207) ~[identityiq.jar:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.server.InternalContext.commitTransaction(InternalContext.java:527) ~[identityiq.jar:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.provisioning.IIQEvaluator.provision(IIQEvaluator.java:429) ~[identityiq.jar:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.provisioning.PlanEvaluator.execute(PlanEvaluator.java:841) ~[identityiq.jar:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.provisioning.PlanEvaluator.execute(PlanEvaluator.java:710) ~[identityiq.jar:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Provisioner.execute(Provisioner.java:1694) ~[identityiq.jar:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.workflow.IdentityLibrary.provisionProject(IdentityLibrary.java:3129) ~[identityiq.jar:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_181]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_181]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_181]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_181]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.server.ScriptletEvaluator.doCall(ScriptletEvaluator.java:136) ~[identityiq.jar:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.server.ScriptletEvaluator.evalSource(ScriptletEvaluator.java:65) ~[identityiq.jar:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.evalSource(Workflower.java:5975) ~[classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advanceStep(Workflower.java:5130) ~[classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advance(Workflower.java:4519) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.startCase(Workflower.java:3100) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcase(Workflower.java:5433) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcases(Workflower.java:5326) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advanceStep(Workflower.java:5117) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advance(Workflower.java:4519) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.startCase(Workflower.java:3100) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcase(Workflower.java:5433) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcases(Workflower.java:5326) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advanceStep(Workflower.java:5117) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advance(Workflower.java:4519) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.startCase(Workflower.java:3100) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcase(Workflower.java:5433) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcases(Workflower.java:5326) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advanceStep(Workflower.java:5117) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advance(Workflower.java:4519) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.startCase(Workflower.java:3100) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcase(Workflower.java:5433) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcases(Workflower.java:5326) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advanceStep(Workflower.java:5117) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advance(Workflower.java:4519) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.startCase(Workflower.java:3100) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcase(Workflower.java:5433) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.launchSubcases(Workflower.java:5326) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advanceStep(Workflower.java:5117) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.advance(Workflower.java:4519) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.assimilate(Workflower.java:4169) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.handleWorkItem(Workflower.java:7648) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.processEvent(Workflower.java:1888) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.api.Workflower.processEvent(Workflower.java:1870) [classes:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.task.Housekeeper$WorkflowerThread.process(Housekeeper.java:2207) [identityiq.jar:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) at sailpoint.task.Housekeeper$WorkflowerThread.run(Housekeeper.java:2111) [identityiq.jar:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,603 INFO [stdout] (Workflow Event Thread 9) Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1460) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:511) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3283) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2479) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:178) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:39) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:271) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:98) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersistenceManager.java:529) ~[identityiq.jar:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) … 47 more
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.persister.collection.AbstractCollectionPersister.insertRows(AbstractCollectionPersister.java:1575) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.action.internal.CollectionUpdateAction.execute(CollectionUpdateAction.java:85) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1454) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:511) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3283) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2479) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:178) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:39) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:271) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:98) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersistenceManager.java:529) ~[identityiq.jar:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) … 47 more
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (IDENTITYIQ.SYS_C0010787) violated
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9)
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc7.jar:12.1.0.1.0]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc7.jar:12.1.0.1.0]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) ~[ojdbc7.jar:12.1.0.1.0]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) ~[ojdbc7.jar:12.1.0.1.0]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) ~[ojdbc7.jar:12.1.0.1.0]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) ~[ojdbc7.jar:12.1.0.1.0]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) ~[ojdbc7.jar:12.1.0.1.0]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58) ~[ojdbc7.jar:12.1.0.1.0]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943) ~[ojdbc7.jar:12.1.0.1.0]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075) ~[ojdbc7.jar:12.1.0.1.0]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820) ~[ojdbc7.jar:12.1.0.1.0]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3897) ~[ojdbc7.jar:12.1.0.1.0]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361) ~[ojdbc7.jar:12.1.0.1.0]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.5.0.jar:2.5.0]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.5.0.jar:2.5.0]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,604 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.persister.collection.AbstractCollectionPersister.insertRows(AbstractCollectionPersister.java:1575) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.action.internal.CollectionUpdateAction.execute(CollectionUpdateAction.java:85) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1454) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:511) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3283) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2479) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:178) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:39) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:271) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:98) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) at sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersistenceManager.java:529) ~[identityiq.jar:8.0 Build 4b6d4894504-20210312-105619]
2022-01-17,00:40:13,605 INFO [stdout] (Workflow Event Thread 9) … 47 more

2

Hi Bali,

We’ve seen the same error for the unique constraint on the pair (IDENTITY_ID, IDX) on SPT_IDENTITY_ASSIGNED_ROLES. Unfortunately I don’t have an answer for you, since I found your post while looking for a potential solution on Compass. We do, however, also use Oracle as system database platform, but I don’t if that is just a coincidence.

The last time we experienced this problem was during a manual refresh of a larger set of identities, but strangely the error only appeared on one particular host in this case. This one host was having some performance issues that meant that refresh operations on this host performed significantly worse than on its peers.

If I understand the default locking mechanism in IIQ correctly, any object locks will per default expire after 5 minutes. This might suggest that the problem can arise in situations where a lock is acquired in an initial step of a process, but if the entire process takes too long to complete (either through the complexity of the task or because of performance issues on a particular host) the lock may expire before the operation is completed, leaving the object in question open for modification by a different process.

I hope you find a solution to your problem!

Best,

Simon

3

Hello there!

We are also facing similar error in our environment during the deletion of prune identities.

Is this issue resolved for you? If so, can you please help me! How i can debug and fix it.

Error:

Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188)
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1460)

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint “FK6732A7DB56651F3A”. The conflict occurred in database “identityiq”, table “identityiq.spt_identity_dashboard”, column ‘identity_id’.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)

4

Hello Shiva,

I believe the problem you are experiencing is similar but not identical to the problem discussed above. It is a problem that I have also encountered, however.

If I’m correct, the problem you are seeing is caused by the built in deletion routines in IIQ, like the Terminator class, for some reason not always being able to delete associated resources like dashboards. Since the database imposes constraints that a row in the table spt_identity cannot be deleted as long as it is referenced by rows in another table like spt_identity_dashboard, the identity cannot be deleted as long as these associated resources remain.

In order to solve the problem, I had to manually delete the rows in spt_identity_dashboard that in turn had reference constraints to rows in the table spt_dashboard_reference.

You can delete these rows from the IIQ console with the SQL command, but please do so with the utmost care! Ensure you have a working backup before attempting this.

1. Lookup the id of the identity you wish to delete

2. Delete the rows in spt_dashboard_reference

sql “delete from SPT_DASHBOARD_REFERENCE where identity_dashboard_id in (select id from SPT_IDENTITY_DASHBOARD where identity_id = ‘[identity_ID]’)”

3. Delete the rows from spt_identity_dashboard

sql “delete from SPT_IDENTITY_DASHBOARD where identity_id = ‘[identity_ID]’”

4. Attempt to delete the identity through normal procedures