I am working on an ISO9000 EMC type solution and I need a little help.
Here is an overview of the process
The issue is that these documents need to be reviewed annually so there is a document expiration date field and a calculated column called 90 days prior to review date.
I have a site level workflow that queries each of the individual libraries within the site and looks for items that meet the condition [90 days prior to review less than or equal to Today]
This workflow will then change the status of these items to "Due for Review"
I also have a Reusable workflow attached to the content type that should be executed when and items status is "Due for Review" and [90 Days prior to review less than or equal to Today]
My issue is this when an item gets put in the correct library after approval and the site level workflow changes the status to "Due for Review" my reusable workflow does not fire.
Does anyone have any suggestions as to how to get this to work?
Reapproval workflow trigger:
Reapproval Run If Statement
We currently have this whole workflow running as a nintex service account.
UPDATE: I did manage to get this to fire correctly after I made some modifications to the triggering mechanism. I am currently working on the section to delete the item after the task is marked complete. I keep getting an error "the workflow could not delete the list item. I suspect that this is because this is a records library. Any ideas on how to bypass the records library lock for the workflow only?
|4/27/2018 2:52 PM||Task Completed||BIZ\SVC-NASPNXSWU1-BIZ||Task responded to by BIZ\SVC-NASPNXSWU1-BIZ.||Continue|
|4/27/2018 2:52 PM||Comment||System Account||Pausing until 12/31/1899 7:00:00 PM|
|4/27/2018 2:55 PM||Comment||BIZ\SVC-NASPNXSWU1-BIZ||Workflow is operating on a document that is not checked in. Waiting for the document to be checked in to the server.|
|4/27/2018 2:55 PM||Comment||System Account||Pausing complete|
|4/27/2018 2:55 PM||Comment||BIZ\SVC-NASPNXSWU1-BIZ||The document has been checked in.|
|4/27/2018 2:55 PM||Error||System Account||The workflow could not delete the list item. Make sure the list exists and the user has permissions to delete items in the list.||Unknown error|
|4/27/2018 2:55 PM||Error||System Account||An error has occurred in Wf-ReApproval.|
|4/27/2018 3:28 PM||Workflow Cancelled||BIZ\SVC-NASPNXSWU1-BIZ||Workflow Wf-ReApproval was canceled by BIZ\SVC-NASPNXSWU1-BIZ.|