Table Locks on the No. Series Table

atankersley
atankersley Member Posts: 32
edited 2008-09-04 in Navision Attain
I am having a problem when a user runs a process and the procees needs to lock the No. Series Table. They get an error message and it blows the the process off. Most table locks just give a message and let the user wait untill the table is unlocked and the the process finishes. I need to be able to change the error message I am getting on the No. Series Table to the wait untill unlocked message if possible. Please help.
tank

Comments

  • kine
    kine Member Posts: 12,562
    SQL or Native? The Wait dialog is used on Native DB. The error dialog is used on MS SQL server. You cannot change that. You can only change the timeout period for MS SQL...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • atankersley
    atankersley Member Posts: 32
    Its a Native DB And I am getting this error message on other table also.
    tank
  • kine
    kine Member Posts: 12,562
    And can you post the error message text?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • atankersley
    atankersley Member Posts: 32
    "The Purchase Line table cannot be locked or changed because it is already locked by the user with USER ID RPATTER2. Wait until the user is finished and then try again."

    The user gets this message and then the process they were working on does not finish. The problem is the Puchase Post Process COMMITS part of the work but not all.
    tank

Categories