“This workflow is locked by another user and cannot be edited. Please try again later.” when trying to modify a workflow type in Microsoft Dynamics GP

INTRODUCTION

When trying to modify workflow, you are getting this message:

This workflow is locked by another user and cannot be edited.  Please try again later.

CAUSE

This message is typically caused by a user making a change to the workflow type at the same time, or the change is stuck in the workflow table.  When making a change, the workflow type is locked down in the WF00104 table, and when the change is saved, the record is dropped from this table. 

RESOLUTION

Use these steps in SQL Server Management Studio against the company database:

1.  Review the workflow table to see if the name of the workflow you are using is listed, to indicate the record is locked. 

select * from WF00104 where Workflow_Type_Name = 'xxxxxxxxxxxxx'  
--modify the placeholder for the workflow name

Example:
select * from WF00104 where Workflow_Type_Name = 'Payables Transaction Approval'

2.  If you found a record in this table and no other users are currently editing the workflow type, you can remove it from the table:

**Make sure to have a current backup of the company database before doing this step, and that no other user is actually modifying the workflow at the same time. 

Delete WF00104 where Workflow_Type_Name = 'xxxxxxxxxxxxx'
--modify the placeholder for the workflow name

Example:
Delete WF00104 where Workflow_Type_Name = 'Payables Transaction Approval'

3.  Now have the user go back into the Workflow Maintenance window and try to modify the workflow again. 
Propriedades

ID do Artigo: 4012573 - Última Revisão: 08/02/2017 - Revisão: 4

Microsoft Dynamics GP 2015, Microsoft Dynamics GP 2016, Workflow, Workflows for Microsoft Dynamics GP, Payables Management, Payables Management

Comentários