Access Request with status: "Waiting n days"

[leo_22 (Leonardo Oliveira)]

Which IIQ version are you inquiring about?

8.4

Please share any images or screenshots, if relevant.

The environment has some access requests whose status has been like the one in the image “Waiting for n days.” I need to remove all requests with this behavior.

The database table for the same request has the executionStatus and completionStatus fields without a defined value.

Is there a native way to handle this case?

[aleksander_jachowicz]

Depending on what kind of clean up you are doing there are multiple way this can be done.

In spite of language, it look like an Identity request pending an approval which means there is a workflowCase somewhere with workItems.

Cleanest way would be to deny these workItems, workflowCase will finish and IdentityRequest will be closed.

If you want to do this dirty way find workflowCase for this workItem and just delete that, it will remove workItems also, the you will have to delete the IdentityRequest too as that will stay.

All of this can be done manually in debug or in the code (which is a bit more work but you may end up with a nice clean up role for the future)

[sunnyajmera]

Depending on how frequently these requests occur and how many are pending right now, I’d recommend implementing a rule. This rule can either be scheduled to automatically handle requests pending approval for over, say, 90 days, or run manually on an ad hoc basis when needed. This is how I have always done in the past.