Hello,
I am using 11.0.1 version of the ProjeQtor. The Planning and Activity pages take forever to load the data. They load quite fine on individual logins (as they have dedicated and limited data only
), but for the admin login it takes minutes and sometime it doesn't load the data at all.
Hello,
could you give us more clues?
Capture the browser console, configure your servers...
things that might help us understand why your admin session is having issues
Hello,
Does your webserver meet the "size of server" recommandation ? Of course it depends on the number of activities and projects you manage, etc.
Following are my server configurations:
OS: Windows
PHP version: 7.4.26
MySQL version: 5.7.36
RAM: 8GB
All the php.ini configurations which are mentioned here: https://www.projeqtor.org/en/product-en/technical-en/64-setup-en/412-product-prerequisites-en are already setup on our server.
Furthermore, I am attaching a short video displaying the browser console and Network calls. Please download the video recording from this url: https://we.tl/t-YYLfCDRWFr
Hi,
Thanks for the Video.
I don't know how many lines you try and display in the Gantt view, but it seems your server is not happy with the volumetrics : it takes 38s to build the data.
So possibly with other concurrent access, you may get a Timeout.
First check CPU of your server : the server should have several CPUs, possibly more than two depending on number of connected user.
NB : your IT can explain your CPU is not loaded at it just gets an average load for several minutes, and if it does not examine the load when hevy requests CPU may appear not loaded.
Also check for CPU speed : the faster the better.
Then you can apply number on lines restrictions : you possibly don't need to see 5000 lines in the Gantt view.
So try and select a project in the project selector to restrict number on lines, or lower "number on lines to display in thez Gantt view" in the Global Parameters screen.
Hello,
Thank you for your answer.
First, we have a dedicated system to run the ProjeQtor. So, I am 100% sure there is no issue of CPU or RAM or space or bandwidth. The hardware configurations are more than what it's needed to run a php based program. I have already provided my system specification in the above reply.
Second, we do not have any concurrent users more than 10 at any given time. And none of them do any heavy activity in the ProjeQtor on the same day at the same time.
Third, I changed the parameter "max items to display in Gantt Planning" to 1000 from 4000. The screen at "Activities" still not loading even after 10minutes!
This seems a very serious optimization issue in the product. And as I am not able to add any new activity, the whole purpose of using ProjeQtor is nullified. Please help to resolve the issue as soon as possible.
Do you have any error logged in projeqtor log file, or in php error log file or in apache error log file ?
Hello,
I am attaching the error logs of php and apache. There are no error logs on ProjeQtor's side regarding this page break. In the console, the request just goes to the forever loading mode.
Hello
So...
Server ran out of threads to serve requests. Consider raising the ThreadsPerChild setting
It would already be a good idea to increase the number of threads authorized on your server. Depending on the number of users, some will stay at the door..
PHP Warning: Unknown: Input variables exceeded 5000. To increase the limit change max_input_vars in php.ini. in Unknown on line 0
it seems that you display a lot of imputation lines... we recommend 4000 minimum but on our servers we set them to 50000.
Apparently 4000 is not enough for you. You must probably have errors in the ProjeQtOr logs too.
Now, is it really necessary to see so many lines on the imputations... to think about it, we have many display options for these lines
failed: Permission denied (13) in E:wampwwwprojeqtorprojeqtortoolprojeqtor.php on line 47
When you connect and perform manipulations on the application, PHP must write to a file and you do not have rights to it, so php does not have the rights to write where it should write...
Overall, you will need to review the configuration of your server.
And be careful with security, it seems that requests are being made to your databases
'E:/wamp/www/projeqtor/projeqtor/info.php' not found or unable to stat
'E:/wamp/apps/adminer4.8.1/adminer.php' not found or unable to stat
...
