One of our clients is having a problem posting any journal entry in one company. They have around 10 companies but the problem is happening in only one company. The issue started when the client actually tried posting a Depreciation run that had more than 10000 lines and canceled it in between the process. Since then when any user tries posting transactions the progress bar goes up to 50% and then locks up and does not respond. If the user ends the session and logs back into Navision the Journal Entries are posted. Is there any hotfix for this issue? The client is on Version 3.10, and SQL Server 2000.
It does not look like a performance issue on the SQL Server side as in other companies the user is able to post transactions without any problems.