Network problem??

madalina

Hello everyone,

I have a problem at a client who is using Nav 2.60 with SQL.
One a week they launch a treatment that prints about 5000 invoices for their customers. As you can imagine this process lasts a few hours, especially with them having to supply the printer with new paper once at 500 pages, but, this is not their problem. The problem is that the process stops due to some errors. Until now there are 3 types of error that occur randomly as far as i can tell. One error says that the connections to the server is lost, another that the operating system has failed and another that some forbiden memory register is trying to be accesed. I am not network expert, i am merely a navision programmer and in this case i really don't know what to do. I don't see any problem with the treatment but before i can be sure could you please tell me if you have encountered similiar problems or if you have an ideea about the real cause of my problem.

Thanks.
M

ara3n

Here is what I would suggest you do. This is obviously a fin.exe issue.
I would split the report into two reports.
Report 1 will filter report 2 to print one invoice at a time (or more. till 500?).
Then ask the user do you want to continue? and print the next 500 invoices.
This will create separate print jobs.

The issue is memory on fin.exe and you need to split the job so that navision can clear the memory of the report.

madalina

Hi ara3n.

Well in fact there are more than 2 reports, there is one report that calls different other reports depending on the document type and specifiications. So you see, in fact there is some report that is called 5000 times or so.. and i cannot help that, because there is a certain order in which the client wants the documents to be printed so that he doesn't have to sort them afterwards so i can't just call 3 reports one time each with the proper filters on the rec they receive as parameter.
I could howerver make a count in the main report and count to 500 and them stop and ask for further confirmation, if that really helps..

M.

ara3n

Is there an option to do an executable upgrade to a newer version?

madalina

Didn't discuss the issue really. Other than this problem navision works just fine. I don't think un upgrade is an option, not an easy one anyway, not with the amount of dev that has been done for this client. It's huge.

ara3n

No you are not upgrading the objects, just install a newer client. I would go with 3.7b client.

madalina

And do you think that this upgrade will solve the problem will help? Won't it be the same thing really?

kine

Be sure, that you have enough free space on your harddisk where temporary files are located!!!

ara3n

I would test it and run about 100 test on the new client.

Also try to increase the cache on the client.

madalina

ok.. i will do that.. how much can i increase the cache in navision so that it doesn't block the post?

ara3n

I believe in 2.6 the default cache was 8 Megs?
Changing it to 32 Megs wouldn't hurt anything.