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
Hello, Kindly please report the bug so that we can further investigate and resolve it. Thank you. Best regards, Benjamin...
11:31 3 May 2024
Hi, No changes should have been made that would increase client's HDB file. Please try to delete HANSA.HDB from client folder and reconnect to server and check if it will grow to 30MB again. ...
10:14 30 Apr 2024