qupdating function results in "server busy"
Aldevinas Katkus
1-14-19
version 8.4 2018-07-26 (build 84192014), Windows server and Windows clients.

I have a maintenance which generates PDF files from Invoices on the server. The number of PDF files generated is over 3000.
All users get the message "server busy" while the maintenance is running.

Why this happens?
I expected the maintenance to slow down a bit the performance, but it actually blocked all the users (about 10)
my code:

global
procedure GenInvPDFTrMn(record RcVc RepSpec)
begin
....
while (qupdating.GenInvPDFTrMn_Run(RepSpec,path,true,prevlooppos)) begin
prevlooppos=RepSpec.long1;
end;
LEnd:;
SetFileOnServer(false);
return;
end;
David Delač
1-15-19
Hello Aldevinas,

Thank you for your enquiry. Server becomes busy because he decides to do "his own stuff first". Best advice I can give is to have this maintenance run during the night so that server does not become busy.

What might help is having reports run on their own threads and this can be done in System >> Optional Features >> Performance >> Multi Thread and Forms on threads enabled.

Best Regards,
David D.
HansaWorld Support
Aldevinas Katkus
1-17-19
Created byDavid Delač13:21 15 Jan 2019
Hello Aldevinas, Thank you for your enquiry. Server becomes busy because he decides to do "his own stuff first". Best advice I can give is to have this maintenance run during the night so that server does not become busy. What might help is having repo
Threads were already configured. THe Maintenance works (or should) the same way as Sales Ledger>>maint>>OK Invoices (non stop). Though never tried to OK thousands of invoices with this maintenance.
Swati D.
12-24-19
Hi Aldevinas

Can they run the maintenance after hours?

Swati
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
Reino Botha
Please check your version of android if it is the same as the server you are connecting too. ...
08:24 21 Nov 2024
Bror-Erik Kotiranta
In NC you hace operations>>ai chats. They are used for these Br, Bror-Erik...
05:12 21 Nov 2024