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;
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Latest Posts
David Delač
Hi Gastón, Please report a bug in our issue tracker and attach test database that you can repeat this in so I can have a look. Paste subject here once done...
09:46 14 May 2025
Paul Timms
From what I've read, using these will store the updated records in memory and then write them to the database in bulk, instead of each record writing to the database in turn. So perhaps there&apo...
17:53 29 Apr 2025