User Received Lock Message on NSCTLFIL 000000100 in Sales Desk

User Received Lock Message on NSCTLFIL 000000100 in Sales Desk

Release Date: 7/10/2019
Version: 7.0 & Up

Q - A user received this lock message when searching for a customer. We never see locks on the NSCTLFIL and I know they can cause issues for everyone if they happen. I do not know what user DUDA was doing.  See sample screen below:


The user switched to another Elliott session to do the customer search and did not get the message.

A - NSCTLFIL record 100 contains the counter for “Sales Desk Next Quote Number.”  Therefore, it is essential for Sales Desk’s operation to get the next quote number. The process requires placing a lock on NSCTLFIL record 100 and increasing the counter, then releasing the lock. We can’t say what happened in this case. Typically, the lock is temporary in a split second and released immediately after, so you should not experience this type of locking message.  It is possible that user DUDA locked NSCTLFIL record 100 in a special scenario without releasing it.

If this problem does not get resolved, the typical solution is to ask user DUDA to exit out of Elliott. That will usually ckear all the locks created by that user. Then come back to Elliott again. If that does not work, go to the PSQL Monitor and clear the user session for DUDA.


EMK


    • Related Articles

    • Feature - Sales Promotion Desk

      Release Date - 8/30/16 Sales Promotion Desk Introduction In Elliott Business Software, Item Master table, we have the following fields that allow users to put an item on sale: Start Sale Date End Sale Date Sale Price If customers purchase this item ...

    • Feature - Sales Desk Trial Lock Logic to Prevent Locking Storm

      Release Date: 06/17/20 Version: 8.5 & Up In larger Elliott installations with hundreds of salespeople and multiple warehouse locations to ship from, a special deadlock condition occurs in Sales Desk when multiple salespeople are competing for the ...

    • Btrieve Error USE on COP Lock File

      Q - Today, for whatever reason, we experienced a large amount of locking issues in the warehouse. Several times today we ran into the problem with printing invoices where we received a message "Btrieve Error USE on COP Lock File," and it stops ...

    • How to Lock a Sales Order from Being Changed

      Q - We know that printing an invoice or selecting the order for billing will lock the order and prevent anyone from changing anything on the order from that point on. Are there any other ways to prevent users from changing orders without having to ...

    • Use Report Desk and Receive Message - Unable to Connect to Data Table NSCTLFIL_2

      Release Date: 09/25/2021 Version: 8.6 & Up Q - When I used Report Desk for the first time, I received the message "Unable to connect to data table NSCTLFIL_2". See sample screen below: A - This may be caused by two things: Your Elliott database is ...