Error: A lock is expected on this folder. The current operation has been aborted

Phillip Morgan

Has any come across the above error before?

 

The stack trace mentsion Metastorm.Engine.connectors.DatabaseConnector.ProcessStoredProcedureError so I'm guessing it's at the database level.

However, I was unable to replicate the issue after setting a SQL Profiler session.

 

Any insights  would be much appreciated.

 

We're running MBPM 9.0.3.1623 with a separate Web, App and SQL 2005 database server.

 

No errors in the Windows Event Logs, SQL Logs.

Paul Denton

Hi,

 

We have seen a number of instances of this error cropping up.

 

The nature of the error is simple; a Refill, Submit or Cancel request has been sent for a oFolder when that folder is not in a status to recieve it.

 

You can see this with two users.

 

User A opens Folder 0001 and starts Action A, and then goes to lunch.

 

In the mean time the Folder Lock times out and User B opens Folder 0001 and start and completes an action (it does not have to be Action A).  Now the folder is no longer locked by anyone.

 

User A returns from lunch and attempts to submit the open Action A (for Folder 0001) on their desktop.  Provided their Session has no timed out they will see the "A lock is expected on this folder. The current operation has been aborted" error.

 

We have also seen instances where an application design has allowed for two submits to be send for a given action and the second submit would encouter the folder not locked and you ge the error.

 

Finally you have noted this as the result of server side caching (in IIS) in 9.0.3.5+.  A defect has been raised to investage this and a workaround exists where you can disable the server side form caching in the Web.Config file for the Web Client.

 

Look for the key:

 

<add key="OutputCacheTimeout" value="300" />

 

and change it to:

 

<add key="OutputCacheTimeout" value="0" />

 

Reset IIS and see if you are still getting the issue.