Problem With Terminal Server And Batch Posting

JohnieG

Hi to all,
I have a terminal server with Navision 4 SP2 client installed that serves 4 users simultaneously. The Database is installed in a separate machine running SQL 2000 SP4. The terminal users are inputing sales shipments and invoices during the day and in a certain period they are running a sales batch post process.
My problem is that when one user starts the batch posting the Sales Header table is being locked preventing all other users from working with that table. I understand that this is a standard Navision method but it is also quite annoying. ](*,)
Is there any way that I can overcome this problem or do I have to learn to leave with it (as i have read to simillar posts)? Could it be helpful to install NAS in order to increase Database Object Case or the Terminal Server is a better solution for my infrastructure?Any suggestions are more than welcome...

ara3n

We have a client on sql and it they posts orders. The users still can create orders without issues. The users do not post the order, but NAS posts the orders. So all they they is set the flag, that the order is ready to post. I would suggest using this solution. NAS can post them at night or at certain time.

kine

And of course, optimalization can lead to short posting times and minimal periods of locks...

JohnieG

First of all thank you all for your replies.
The problem is getting more difficult because the batch posting must be done in a very short time period. If we have concluded inputing the shipments and invoices the batch posting must start afterwards. The idea is that after the posting the stock for the specified location has been altered so we can proceed to the next days sales or purchase orders. So I can't implement a solution for posting the transactions late at night.
The only viable solution is to mark those transactions that have been checked and are ready to be posted and let NAS post them with some kind of serial order. My only problem is that still i don't have any idea on how to do this :oops:

ara3n

A few questions, how long have you been using nav?
how big is the db.
What kind of Hardware configuration.

How much development experience do you have, or do you think you should contact your NSC?

JohnieG

I am using NAV for the past six months (the company started from January). I have been working with databases for the past three years. I have started with Oracle 8i and for the past year I took a brief look of SQL 2005. But for the past six months I am working intensively with NAV. Everybody starts from somewhere and please forgive me if my questions maybe silly or pretty obvious!
The Database Size viewed from inside NAV Database Information is 2642112 KB. The Terminal Server is a Xeon 3,2 Mhz with 4 GB Ram. It has only a Navision Client installed and about 10 terminal users which are running NAV(4 of them pretty intensivelly). The Database Server is equivalent to the Terminal Server with 2 proccesors and 4 GB of Ram (2GB Dedicated on SQL 2000 SP4 ).
I hope these info are helpful....

Besides that the kind of solution that I temporarily applied was to add a 2 seconds delay after each transaction post made through the batch posting method. In that way I believe that I have created a "time window" that other transactions could be posted without problem. Any better ideas are more than welcome....

kine

We are using same solution for some customers. Just adding commit after each posting and adding sleep to prevent "starvation" of other sessons.

kriki

[Topic moved from Navision Attain forum to Navision forum]

JohnieG

Thanks for the topic transposition Kriki. It was in the wrong section from the beggining.
If I may add one more question...
Is there a way that I can increase the amount of the Navision Object Cache on the Terminal Server's clients. Or even more generally, how can I increase the amount of the Navision Object Cache in a client that works alongside with a SQL 2000 SP4 Database? I believe that this kind of action will result in the decrease of the client's response times. Am I wrong?

kriki

JohnieG wrote:

Is there a way that I can increase the amount of the Navision Object Cache on the Terminal Server's clients. Or even more generally, how can I increase the amount of the Navision Object Cache in a client that works alongside with a SQL 2000 SP4 Database? I believe that this kind of action will result in the decrease of the client's response times. Am I wrong?

You can set it in Tools=>Options=>Object Cache (KB). If you the exit, it will be saved in the zupfile.
You can also put something in the shortcut to start Navision: "OBJECTCACHE=30000" to put the object cache to 30000

It can help the client's response times in case the user uses a lot of Navision functions (or there are some BIG objects the user uses). In general the standard provided by Navision is good enough.
Remember also that this increases the memory used by each Navision session on the Terminal server.