Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

“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


View products that this article applies to.

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.

↑ Back to the top


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. 

↑ Back to the top


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. 

↑ Back to the top


Keywords: kberrmsg, kbinfo, kbprb, kb, kbMBSpartner, kbMBSmigrate, vkball

↑ Back to the top

Article Info
Article ID : 4012573
Revision : 4
Created on : 2/8/2017
Published on : 2/8/2017
Exists online : False
Views : 267