Issue with Non-Optimized AD Aggregation Post 8.4P1 Upgrade

[sathieshg]

we’re encountering issue with Active Directory non-optimized aggregation following the 8.4P1 upgrade.

Exception during aggregation. Reason: javax.persistence.TransactionRequiredException: Executing an update/delete query
javax.persistence.TransactionRequiredException: Executing an update/delete query

• This exception occurs only for non-optimized aggregations.

Has anyone else experienced this issue, or does anyone have insights into potential causes and solutions?

[pravin_ranjan (Kumar Ranjan)]

@sathieshg pls check this thread, let me know if that works

Account Aggregation Issue: Exception during aggregation. Reason: javax.persistence.TransactionRequir - Compass (sailpoint.com)

See this thread,

I checked with sailpoint team and they mentioned its an 8.4 PRODUCT bug. If we enable ''Disable optimization of unchanged accounts" then account aggregation will fail.

Please try to add “” in your taskDefinition from debug page and execute the task, issue will be resolve. I tried and it is working for me. If it fails with same error then increase the value number to 10000000.

FYI

Engineering Tracking Number (ETN) IIQETN-11462 has been opened for IdentityIQ 8.4. An ETA is not available at this time.

[Arun-Kumar]

@sathieshg

TransactionRequiredException

Add below entry in your taskdefintion and try.
<entry key=“maxConnectionAge” value=“1000000”/>

[sathieshg]

Thanks @Arun-Kumar , this solved the issue.