Perform Maintenance Pruning Task Failure

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Which IIQ version are you inquiring about?

Version 8.4

Share all details related to your problem, including any error messages you may have received.

Hi All,

When “Perform Maintenance Pruning” task running it is getting failed with this error. Please anyone can guide me why i am getting this error and how to resolve this error.

Object pruning failed with : org.hibernate.exception.JDBCConnectionException: could not execute statement
Object pruning failed with : org.hibernate.exception.JDBCConnectionException: could not prepare statement
Object pruning failed with : JDBC begin transaction failed:
Certification archiving failed with : JDBC begin transaction failed:

Thanks,
Bhagat

2

Please provide the xml of this task instance you are running or parameters you selected in the instance, is it just prune related parameters selected or anything else?

Can you uncheck Archive and prune certifications and run this once and see if the error occurs? Also can you share the complete log trace from server.

3

Hi, we tried unchecking all the tick boxes and found that we are getting error in prune requests.

image
image1007×905 26.8 KB

strong text

4

So if you uncheck pure requests, the job is working fine?

please provide the detailed log from server, there might be some data related constraint at DB level for particular bad data

5

@bhagatchahar : Is it possible to share details if any particular provisioning request was initiated (JBDC transaction) ? I have faced similar issues in the past where, due to native identity issue PRIM task was failing.

As suggested by Mr Satish, do share the complete log details :slight_smile:

6

Hi
When i unchecked the prune request it is getting successful. but i have to keep it checked.
these are things i am getting in logs for this error.

ERROR QuartzScheduler_Worker-3 engine.jdbc.spi.SqlExceptionHelper:142 - SQL Server did not return a response. The connection has been closed.
ERROR QuartzScheduler_Worker-3 sailpoint.task.Housekeeper:656 - HouseKeeper error pruning objects…
sailpoint.tools.GeneralException: org.hibernate.exception.JDBCConnectionException: could not execute statement

ERROR QuartzScheduler_Worker-3 sailpoint.task.Housekeeper:1426 - Object pruning failed with : org.hibernate.exception.JDBCConnectionException: could not execute statement
ERROR QuartzScheduler_Worker-3 sailpoint.persistence.HibernatePersistenceManager:498 - Unable to check isolation level
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

ERROR QuartzScheduler_Worker-3 sailpoint.task.Housekeeper:1426 - Object pruning failed with : org.hibernate.exception.JDBCConnectionException: could not prepare statement

ERROR QuartzScheduler_Worker-3 sailpoint.task.Housekeeper:656 - HouseKeeper error pruning objects…
sailpoint.tools.GeneralException: JDBC begin transaction failed:

ERROR QuartzScheduler_Worker-3 sailpoint.task.Housekeeper:1426 - Object pruning failed with : JDBC begin transaction failed:

ERROR QuartzScheduler_Worker-3 sailpoint.task.Housekeeper:1426 - Certification archiving failed with : JDBC begin transaction failed:

ERROR QuartzScheduler_Worker-3 sailpoint.api.TaskManager:1007 - Exception: [JDBC begin transaction failed: ]
sailpoint.tools.GeneralException: JDBC begin transaction failed:

7

@bhagatchahar
There is something wrong in your old request objects, if we can find which request object is causing that issue, that can help us fix the error

Can you please confirm in System Configuration, what is the value of below configuration

  <entry key="requestMaxAge" value=""/>

Also when was this task successful last time with this checked

Also for now to unblock things, better to create two instances of this pruning one with uncheck this and check all other configurations you need and the other one with just checked this one, so that it will not block other pruning objects