Approval work items are failing because WorkflowCases are created without their corresponding TaskResults

Hi Sailors, experiencing one issue in IdentityIQ where, for certain access requests that generate approval work items, the system creates a taskResultId but the corresponding TaskResult object is not found in the IdentityIQ database - taskresults table. Only the WorkflowCase is created successfully and has the reference in workflow case the task result id.
As a result, approvers are unable to take action on some approval work items. When attempting to approve, the system displays the error:
“WorkflowCase without corresponding TaskResult.”
This issue appears intermittently and is affecting specific users and access request types. It results in:

Missing TaskResult records despite a taskResultId being generated
Workflow cases becoming incomplete or orphaned
Approvers being blocked from completing their assigned work items due to the missing TaskResult linkage. its intermittent so not a code issue. some times the access request has the task result id and also task result object also is present.

any leads on what could be root cause or reason for this.

which version of IIQ are you using?

How old are these work items?

Similar issue linked below suggesting task results may be deleted by the Days before task result deletion option in global settings

https://community.sailpoint.com/t5/IdentityIQ-Forum/How-to-cleanup-Workflow-cases-without-task-result/m-p/8966

@vinnysail Do you have any custom script to prune the task results? Normally pending workflow associated task results, can be cleaned up by deleting the workflowcases. Please check and share the details for further assistance.

@vinnysail was this issue resolved? I am also facing a similar issue for the workflows invoked via REST API.

Hi @vinnysail Check how many days your organization’s task result retention policy is, and you can find it under Global Settings → IdentityIQ Settings → Miscellaneous → Days before task result deletion:.

I think any manager is not approved access beyond this threshold; exceeding it would be causing the issue.

I hope this will help!.

Thanks,

PVR.

Thanks for your reply. Custom task was not pruning the task results

Thanks for your reply. We are not using these settings at the moment for pruning task results.

There was a database issue, which was causing the problem. Later, we found out this.

Hi @r_pragati

We are using 8.4 P2 version

There was a database issue, which was causing a problem. Once the database issue was resolved, we were not getting this problem.

For the old work items, we had to delete all the work flow cases.