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
David Delač
Hi Piotr, The log entry:
2024-12-14 08:40:43 0.000 CallHal(IsHansaWorldCustomer) appears because the server is running with the verbosity=debug-detailed setting in its parameters.txt file. Thi...
09:43 16 Dec 2024
Brittany McGrath
Hi Vaughn, I can confirm this has been fixed now and is live in Standard ERP 2024-11-20 Version: 85556786. Thank you. ...
10:04 10 Dec 2024