Hi all,
I have a Laserfiche workflow and one of the activities is to link to entries. What i have done is "Search the Repository", and then "For Each Entry" => "Create Link"=> "Assign Field Values".
The workflow seems to work fine when there are just a couple of files to be linked. The problem is when this entry needs to be linked with more than 500 entries. The user receives an error message "Entry Locked", the activity "For each Entry" gets stuck in that iteration and the workflow does not continue. All the entries get locked by the same user, even is the user logs out from Laserfiche.
The only way I found to fix it is by going to the Admin Console, see the first entry that is locked and release its lock. The workflow continues and the entries get linked.
My questions are: Why this is happening and if there is a way to avoid this issue from happening again?
Is it that the server does not have enough resources or a problem with the Workflow itself?
Attached are the server specs. It is also running SQL Server.
Laserfiche 9.0.2
Workflow Designer 9.0.2
I would appreciate any suggestions,
Andres