Access Request, filtered items and DB lock

[rabshrestha (Rabindra Shrestha)]

Which IIQ version are you inquiring about?

Version 8.X

Please share any images or screenshots, if relevant.

Please share any other relevant files that may be required (for example, logs).

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

Hi all,

we are encountering an issue during task PIRM task execution specifically for the access requests with all filtered items as attached. Thus, the request has nothing to provision. For such requests, the completion status does not change to success and then causes long running PIRM task session ultimately causing DB block issue. For resolution, we are manually setting the status to success and then running the PIRM tasks.

Has anyone encountered such issue?

[enistri_devo (Emanuele Nistri)]

Hi @rabshrestha,

I suggest you to check what happen when PRIM runs; check the logs and the administrator console.
Maybe you have a rule what cause the block or does something wrong or the workflow.

Here you can find the guide for log activation:
https://community.sailpoint.com/t5/Working-With-Support-Knowledge/Log4j-Support-Guide/ta-p/137421

I recommend the HQL logs

[ashutosh08 (Ashutosh Singh)]

Hi @rabshrestha,

Can you confirm if the access is being assigned or not?

If not, then can you confirm are you using OOTB LCM or you are using customized version of it? If there is some customization then you need to isolate that why your access is being filtered out.

You may enable the log in workflow by setting trace=true variable.

Let us know your finding to get further input.

Thanks