Site workflow triggering content type reusable workflow

[kdorn]

Greetings,

I am working on an ISO9000 EMC type solution and I need a little help.

Here is an overview of the process

1. A document is put in Drop off library.
2. A review process takes place at the drop off library level
3. After the document is approved it gains a status of "Current" and the content organizer moves the document to the correct library.
4. This solution will eventually run across 9 sub sites and 10 individual libraries in each sub site. (I plan on building once in the main test site and then import workflows into each sub site

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

Thanks

[fhunth]

A possible cause could be that the item was created or edited by System Account

[kdorn]

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?

Thanks

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.