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
Piotr Wycichowski
Is it something when a user tried to use any of AI commands in SERP? /Piotr W....
10:07 8 Nov 2024
Brittany McGrath
Thank you for your post Lilian. I see this post has been submitted twice and the second post is being addressed so I will close this duplicate. Thank you. ...
09:41 5 Nov 2024