Administration Form and message "Folder not locked for action"

Gustavo Gutierrez

Hi, I've been searching vastly for this message and obviously found a number of post which did not provide me with a solution or to be a similar problem.

 

I have an Administration Form that shows the folders of a certain process on a Folder Grid and there is a drop down field that holds the name of the columns displayed in the grid as options and there is a radio field with "asc" and "desc" as options, as you are figuring out this two elements enable the user to sort the rows of the grid according the desired column.

 

Here is the funny (and headache maker) thing, this simple function worked fine until last week, after that, I get the error mentioned " Fail to commit action. Folder not locked for action" and there is no sign of errors in Elog Table just a warning in the windows event viewer saying " Action -  nameofaction  - failed, the folder  idofthefolder  is currently locked by  username " .

 

If a limit the recordset grabbed by the engine by adding  " top 62 " before the text of the first column of the grid, the sort function works like a charm with any of the combination of the dropdown values and the radio field. I really don't know if I might blame a folderid, cause everything seems fine in the both process and efolder tables. Administration Forms of other process are not affected.

 

The number of process instances are barely above 500, as a mention, if a limit that number to 62, works as it usually did. I'm not making inserts, updates or deletes, just reading the process table to show the total of folders generated to date. Also, folderids displayed in warnings not exist in either efolder or process tables.

 

Any help would be really appreciated as I've exhausted my resources.

Paul Denton

Hi,

 

The "Folder not locked for action" message should not be related (in theory) to the content of the form.

 

Basically an Admin form is exactly the same as a blank form, a folder is created to process the admin form.  In the case of the admin for the folder is removed with the admin form is submitted.  But while you are working on it, it functions the same as a blank form. 

 

After starting the Admin Form when you are adjusting the filters for your grid what you are basically doing is sending refill requests to the engine to refill the form contents.  When this engine recieves the refill request the first thing it does is validate the user's session ID, after that it validates that this folder is locked for this action (the current action name) by that user ID.  If if that check fails you get back a the error  "Folder not locked for action". 

 

I would suggest contacting the helpdesk to allow them to work through this problem with you.

 

Paul...

Gustavo Gutierrez

Thanks for the quick reply; looking forward for whatever comments arise, Im just adding the next information:

 

I've tried adding NOLOCK and READPAST to the table name with no luck, got same error as posted, the windows event viewer displays two types of warning as I'm monitoring it in detail now:

   First one.
   Action -  nameofaction  - failed, the folder 0000000000000000000000000045330  is currently locked by  username .
  
   Second one.
   Attempt to open folder  0000000000000000000000000045330  failed, the folder was not found.

I'll contact helpdesk anyway, thanks again.

Gustavo Gutierrez

Hi,

I'd set up a trace and found that a stored procedure was returning the error described, no further research was done as I later wrote the username and password into the grid properties, this was the solution although didn't satisfy me cause other administrative forms don't shown this "issue" even though all forms  have same property values defined (blanks username/pwd) and the other reason is that when I was limiting the number of results displayed there were no errors at all.

It seems to me that is likely to be a bug rather than anything else but maybe I'm wrong and need more learning and I'm just trying to "close" this post while contributing with some knowledge.

Thanks.