Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

problem function ca...
 
Notifications
Clear all

problem function calculates resource planning

28 Posts
2 Users
0 Reactions
9,780 Views
(@gabriele-giovannelli)
Posts: 16
Active Member
Topic starter
 
[#6277]

Hello,
I have a somewhat complicated process management ... I have 186 projects and 315 subprojects. The activities are 1811 ....
When I click the button for programming the resource activities this does not work. Or rather ... if I select the individual projects from the drop-down menu it works and writes the records in the "plannedwork" table while if I select "all projects" it does not work (the scroll wheel turns to infinity) and deletes all the rows in the table " plannedwork ".
Is this normal?
Thanks a lot 🙂


 
Posted : 02 Oct 2019 11H05
(@babynus)
Posts: 14952
Member Admin
 

Have a look at lof files : projeqtor log file or php log file or apache log file.
Sure you have a Timeout.
Change your max_execution_time in PHP config file.


 
Posted : 02 Oct 2019 11H48
(@gabriele-giovannelli)
Posts: 16
Active Member
Topic starter
 

I set the variable max_execution_time = 0, but the behavior is the same as above.


 
Posted : 02 Oct 2019 12H59
(@gabriele-giovannelli)
Posts: 16
Active Member
Topic starter
 

I set the variable max_execution_time = 0, but the behavior is the same as above.


 
Posted : 03 Oct 2019 11H37
(@babynus)
Posts: 14952
Member Admin
 

di you restart PHP after update of php.ini ?


 
Posted : 03 Oct 2019 11H52
(@gabriele-giovannelli)
Posts: 16
Active Member
Topic starter
 

yes... 🙁


 
Posted : 03 Oct 2019 11H53
(@babynus)
Posts: 14952
Member Admin
 

So look for errors in Apache error log file or in php log file.


 
Posted : 03 Oct 2019 12H16
(@gabriele-giovannelli)
Posts: 16
Active Member
Topic starter
 

in Apache error log appears: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 32768 bytes) in Unknown on line 0, referer: http://localhost/projeqtor/view/main.php


 
Posted : 03 Oct 2019 12H44
(@babynus)
Posts: 14952
Member Admin
 

So it is memory that is too small.
Try and extend memory_limit in php.ini


 
Posted : 03 Oct 2019 13H38
(@gabriele-giovannelli)
Posts: 16
Active Member
Topic starter
 

I tried also with 8000M but it doesn't work ...


 
Posted : 03 Oct 2019 13H50
(@babynus)
Posts: 14952
Member Admin
 

and error is ?


 
Posted : 03 Oct 2019 13H51
(@gabriele-giovannelli)
Posts: 16
Active Member
Topic starter
 

PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 32768 bytes) in Unknown on line 0, referer: http://192.168.12.137/projeqtor/view/main.php


 
Posted : 03 Oct 2019 13H54
(@babynus)
Posts: 14952
Member Admin
 

And you need me to explain tthe error ?
Read it !
536870912 is 512M


 
Posted : 03 Oct 2019 14H03
(@gabriele-giovannelli)
Posts: 16
Active Member
Topic starter
 

I have read and tried also with 516M the same error always appears


 
Posted : 03 Oct 2019 14H06
(@gabriele-giovannelli)
Posts: 16
Active Member
Topic starter
 

But then could it be a bug?


 
Posted : 03 Oct 2019 15H56
(@babynus)
Posts: 14952
Member Admin
 

I have read and tried also with 516M the same error always appears

If 512M is not enough, I don't think 516M will have chance.
Try 4G, and restart PHP.


 
Posted : 03 Oct 2019 16H25
(@babynus)
Posts: 14952
Member Admin
 

But then could it be a bug?

I don't think so.
But there can be some inconsistency that leads to non ending loop.
Try and Check for inconsistency (in administration screen)


 
Posted : 03 Oct 2019 16H26
(@gabriele-giovannelli)
Posts: 16
Active Member
Topic starter
 

I also tried 8GB


 
Posted : 03 Oct 2019 16H28
(@babynus)
Posts: 14952
Member Admin
 

Please try again wth 8G and show error ...


 
Posted : 03 Oct 2019 16H29
(@gabriele-giovannelli)
Posts: 16
Active Member
Topic starter
 

Something is changed. Indeed there were errors of consistency that I set with the appropriate button. Now the errors are these:

[Thu Oct 03 14:56:36.728647 2019] [php7:error] [pid 2774] [client 192.168.12.1:62240] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 36864 bytes) in /var/www/html/projeqtor/model/PlannedWork.php on line 665, referer: http://192.168.12.137/projeqtor/view/main.php

[Thu Oct 03 14:56:36.734946 2019] [php7:error] [pid 2774] [client 192.168.12.1:62240] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 32768 bytes) in Unknown on line 0, referer: http://192.168.12.137/projeqtor/view/main.php


 
Posted : 03 Oct 2019 16H59
(@babynus)
Posts: 14952
Member Admin
 

Hi,

Try and change Global Parameter "Memory for PDF generation" (on tab system).
I did not expect this parameter to be used for planning, but it"s worth a try.


 
Posted : 03 Oct 2019 17H09
(@gabriele-giovannelli)
Posts: 16
Active Member
Topic starter
 

I have set et 8000 the global variable and now appear this :
[Thu Oct 03 16:37:40.348001 2019] [php7:error] [pid 3463] [client 192.168.12.1:63100] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) in /var/www/html/projeqtor/model/persistence/SqlElement.php on line 3016, referer: http://192.168.12.137/projeqtor/view/main.php
[Thu Oct 03 16:37:40.354904 2019] [php7:error] [pid 3463] [client 192.168.12.1:63100] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) in Unknown on line 0, referer: http://192.168.12.137/projeqtor/view/main.php

thank you very much for your kindness and patience


 
Posted : 03 Oct 2019 18H41
(@gabriele-giovannelli)
Posts: 16
Active Member
Topic starter
 

where can the problem be in:
/var/www/html/projeqtor/model/persistence/SqlElement.php on line 3016 ???


 
Posted : 04 Oct 2019 11H52
(@babynus)
Posts: 14952
Member Admin
 

The line is not important as it is memory issue.
The issue occurs when memory is full.
If you change few things on projects, issue will occur at different location.

Your issue is that your parameters are not taken into account : memory limit is always 512M and you need more to plan all the projects in one shot.


 
Posted : 14 Oct 2019 13H16
(@gabriele-giovannelli)
Posts: 16
Active Member
Topic starter
 

So how can I do it? Can't create many projects? is it a bug?


 
Posted : 14 Oct 2019 13H32
Page 1 / 2
Share:

Scroll to Top