mibuso.com

Microsoft Business Solutions online community
It is currently Thu Apr 24, 2014 2:12 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: [Solved] table purchase line is locked
PostPosted: Mon Jan 23, 2012 11:01 am 
Offline

Joined: Fri May 29, 2009 1:23 pm
Posts: 30
Location: Zagreb
Country: Croatia (hr)
Hi,
we have NAV 5.0 and we using sql server 2005.

In one company when user wants to press F9 Statistics, error appers "The Purchase Line table cannot be changed because it is locked by another user. Wait until the user is finished and then try again".

I have checked in file/database/information --> blocking user Id, also I have executed procedure to see who's blocking table, but I do not get any information.

Can any suggest how to check what's going on ?


Top
 Profile E-mail  
 
 Post subject: Re: table purchase line is locked
PostPosted: Mon Jan 23, 2012 2:02 pm 
Offline

Joined: Fri May 29, 2009 1:23 pm
Posts: 30
Location: Zagreb
Country: Croatia (hr)
problem is solved.
one user has started two clients. After loggin off all users from nav, one user was still had one session opened (something like zombie process).

After I killed that process everything is normally.

But, I still don't know why I didn't saw which user was lock the table.


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: