Perform Identity Request Maintenance DB Blocking Issue

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Which IIQ version are you inquiring about?

Version 8.1

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

We are having DB blocking issue while running PIRM task. This happens once a while. Is there a way we can see in loggers what IdentityRequest is being refreshed?
We manually cancel the identityRequest from debug, however it takes time to find the request.

2

Hi @ganesh_kandel5050,
Refer this community post and enable the loggers to get deeper on the issue.

https://community.sailpoint.com/t5/IdentityIQ-Forum/Perform-Identity-Request-Maintenance-hangs/m-p/252409#M188380

3

Hi @ganesh_kandel5050,

you can try to active the hql logs too:

image
image533×131 12 KB

I think, if you have a lock/block problem on db with this task, when sp try to delete one or more record, founds a corrupted record or a missing foreing key.