Need Help after converting navision database very slow,

agung_awip

Need Help after converting navision database very slow,
hello , i am agung from indonesia, i have problem with my navision, after upgrading my server from nav sp1 to nav sp3 , all my client going to slow when posting something and slow when priview report adn print, is there any solution for this, my server spec is intel xeon, 266 , 3 gig ram, 78 gig hdd, using sql server 2000.
the principal support told me to backup database from nav the delete the database, then restore it, but its still slow and now when posting something its pops warning " the value entry table can not be change because it is locked by another user wait until the user is finished and then try again" its happens to the major table likes value entry, item ledger entry and other. is there any sugestion of solution. please help me

SD-JR

Hi,

This is a pretty big question with many posts on MIBUSO and other forums to provide pointers.
1. Are you talking Nav 4.0 SP1 to 4.0 SP3?
2. How many users?
3. What size database?
4. What collation and configuration has been used on the new SQL DB?

You might look at (your locking issue may be overcome by enabling row level locking on the SQL DB)
http://dynamicsuser.net/blogs/stryk/arc ... erver.aspx

SD-JR

HI,

Cycle counting is not an option on Business essentials - not available on the licence (we have built an addon to allow a more manageble cycle count for business essentials).

For a basic stock take you need to use phys. inventory journal (form 392 - possibly on your warehousing menu - or just add form 392 to another menu).
In this form run functions - calculate Inventory - the online help should help you from here.