Post#20: Orphaned Work Items via Workflow

When you use workflow for Transactions in DAX there may be a possibility where the user who submits the transaction deletes the transaction instead of recalling the approval before deletion.

This will cause the approval work item to sit in the approver’s queue and will display an error when the approver tries to either view the originating transaction or approve the work item.

The error displayed is:

Data record not found


When this occurs the easiest way to solve the issue is to ask the user for the screenshot of their Home–>Common–>Work Items–>Work Items assigned to me  screen.

This is required as you will need to Filter for the user, and status as pending along with the created date and time in the WorkflowWorkItemTable.

Open the table via AOT and filter for the 3 fields as shown below.


Now you need to update the status field as Completed instead of pending. This will now not show up in the “users work items assigned to me” screen.

Issue Resolved.

Thank you and keep DAXing.




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s