URGENT : locking of table if a session dies

Hey all, actually we have added an information system in our billing. For giving informations to customers our call center uses a one table to identify this customer. Now it happened that the pc hang up when a users was looking for a customer (while updating a filed in this table). The result was that no other user could use this table because of the message “table is locked by user XXXXX”. But the session of this user has died and there was no way to kill this session (we’re using DE2.50). Is there a way to avoid this situation or to make sure the table is given free if a session dies ?! thanks in advance

Did you search the forum? http://www.navision.net/forum/topic.asp?TOPIC_ID=5990&SearchTerms=killing,session http://www.navision.net/forum/topic.asp?TOPIC_ID=4246&SearchTerms=killing,session http://www.navision.net/forum/topic.asp?TOPIC_ID=3846&SearchTerms=killing,session http://www.navision.net/forum/topic.asp?TOPIC_ID=2914&SearchTerms=killing,session good luck!

Are you running on SQL or a native database? If native, you might also check out the KeepAliveTime TCP/IP parameter on your server. See http://www.navision.net/forum/topic.asp?TOPIC_ID=4246&SearchTerms=keepalivetime for more info. Erm… I just noticed that this link is also on Emiel’s link list. [:I] Anyways - this parameter has significant impact on throwing out “dead” sessions.

sorry, i didn’t. Of course i should read and search before writing… you’re right. sorry for that and thanks for your hint

I can just confirm that we have the exakt same problem and so far as I know there is just the KeepAliveTime or killing the session that resolve the problem (Of course rebooting the Navision server or service also helps…). Best regards Daniel

Yup… in case you’re stopped and your users cannot work the easiest and most effective way it’s always restarting the navision server service (and if the user has low knowledge about windows administration… restarting the own navision server). Regards,