Technical Support

Lock Conflicts in Scheduler

Problem: On a network we are getting lock conflicts and locks are not being released.

Cause: Two users have attempted to access the same data record (day) at the same time and the first lock was not released.

The procedure files for the scheduler needs to be updated.

Solution: Release locks from the Scheduler file/form. Check the date of the compiled procedure. If it is dated prior to 7/12/95 force a recompile.

Keystrokes: To clear the locks

Log in as "MANAGER". From the MD VersaForm Main Menu:

Select item #6 - VersaForm XL Main Menu - press <Enter>

Select item #2 '"Filing" - press <Enter>

Accept the default directory or enter the path to the scheduler files - press <Enter>.

Type in "SCHEDULE.VFM" and press <Enter>. The schedule database form will be presented with a blank record.

Press <Esc> to bring up the menu then <U> for Utilities and then <L> for locks.

From this menu choose "U" for unlock locks.

When asked "Unlock File, Record, or All: (F/R/A)" – select "A" to unlock "ALL" locks then press <Enter>.

Finally, you will see "Enter User ID or "All" for all users:". Type "ALL" to remove locks for "ALL" users (you have to be logged in as "MANAGER" to do this).

You will be returned to Scheduler form. Press <ESC> to exit.

To recompile the code:

From the MD VersaForm Main Menu:

Select item #6 - VersaForm XL Main Menu - press <Enter>

Select item #8 "Enter or Change Procedures" and press <Enter>

Accept the default directory or enter the path to the scheduler files - press <Enter>.

Type in "ledger.vfm" and press <Enter>. The ledger database form will be presented with a blank record.

Type "use" and press <F6>. You will be taken to the record named "user cmd 1". If you don't see the term "schedule.leg" in the "Procedure" part of the record press <F6> until you do.

Press <F2> to recompile the procedure.

When the procedure is saved press <Alt+X> to return to the menu.

Notes: Only one person can be in a Scheduler record (day) at a time. Networks generally lock a specific record to the first person who accessed it. This protects the data from being destroyed.

References:

Related Topics:

Email your support questions to tech@versaform.com

This information is provided as a courtesy.  VersaForm Systems Corporation has provided this information "AS IS" without warranty of any kind – express or implied.  In no event shall VersaForm Systems Corporation be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages.