Address ID table locked by another user

idiotidiot Member Posts: 651
I have confirmed that the user is not using this table at all, however if the system is in a busy state (processing transactions), it will show "Address ID table is locked by another user".
This error has occurred on a couple of users at different sites. NAV 4.0, SP1, SP2 with SQL 2000, 2005 setups.

How important is this table and why should the system lock this table?
It is understood if Sales Line or Item Ledger Entry table were locked, but Address ID?
NAV - Norton Anti Virus

ERP Consultant (not just Navision) & Navision challenger

Comments

  • kinekine Member Posts: 12,562
    I do not know such a table. It must be some customization/Addon.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • idiotidiot Member Posts: 651
    Table 28003 NAVAP4.00
    NAV - Norton Anti Virus

    ERP Consultant (not just Navision) & Navision challenger
  • ara3nara3n Member Posts: 9,256
    Looks like a modification.

    Are there any records in the table?
    I suggest to contact the ISV that developed this.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • idiotidiot Member Posts: 651
    This table came with the NAV CD.
    The table is not used & no modifications of any sort. Even in Cronus it does not contain any sample records. :-k
    NAV - Norton Anti Virus

    ERP Consultant (not just Navision) & Navision challenger
  • ara3nara3n Member Posts: 9,256
    It's not part of NAV NA, 28K range is probably some localization What is the version list of the object.

    I suggest to use developer toolkit on how it is used and look at the code on why you would get locks.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.