The question for me is: why the capacity of pool is used only on end of month ? I have tested to force the start date on eatch resource of the pool, without impact 🙁
Because the pool is made from resources.
And the resources already work on other tasks.
Sum of work planned for all resources and for the pool cannot be more than sum of capacity of the resources.
The pool is not an extra resource.
Thanks but the last line "total" for the pool show never the full ETP capacity (3 ETP) exept the end of mounth (29/04) The calculation split my activity "TAT TCO MRO (Weekly)" with 1,84 total VS 3 days ETP maximum available..
I have create an picture for explain:
Of course, planned work on the Pool can only use avalability of the resources of the pool that is not already used.
Sum of planned work for Poll + Resources can not be more than sum of availability for resources.
Let's take an example : You have 2 resources RA and RB, with capacity =1, taking part to a pool P.
RA is booked for the week : | 1.0 | 1.0 | 1.0 | 1.0 | 0,5 |
RA is booked for the week : | 1.0 | 0.5 | 0.5 | 0.0 | 0,0 |
P can be booked max to the week : | 0.0 | 0.5 | 0.5 | 1.0 | 1,5 |
thanks for your answer, but if you look the last line "Total" the sum of all affectations is 3 days but the maximum of the pool is 4. (i repet all ressources is only affected on the broject, without direct affectation, only via the pool).
Why the calculation don't use the full pool capacity ?
It won't use more than what resources can do.
Also when you assign pool to activities, you take part of pool capacity (for instance 1 FTE) so you may not use full pool capacity.
Also, you may have dependencies, planning modes, and so on, that will have resource not fully busy.
Thanks,
I have create a test: New ressources, whitout other affectation, new ressources are in this pool "planification". All tasks are affected to the pool and only this pool. When i modify the pool with aditional ressource by aditional ressource, the result (after planning calcul) is coherent with 1, 2, 3 and 4 ETP, after the result is same (same for day planification and days available for the pool). I don't anderstand why numbers of days avaibale and planned days don't bouge after more 4 ETP. have you a limitation ? see the complete screens shots of all simulations in attachement.
Sorry, but seeing just availability result is not significant to me.
Could you please reproduce use case on Demo ?
Hello, Yes i can reprocuce with a online version.
Hello,
after an other test with the last version, i have this trace in log: (You can send me an email bruno.villedieu@gmail.com for some precisions in french for this use case complex)
2019-05-23 14:49:50.148 ===== TRACE ===== Error for planning mode '16' not found in Planning Mode table
2019-05-23 14:52:16.908 ===== TRACE ===== Error for planning mode '16' not found in Planning Mode table
2019-05-23 14:53:34.550 ===== TRACE ===== Error for planning mode '16' not found in Planning Mode table
2019-05-23 14:57:40.366 ===== TRACE ===== Error for planning mode '16' not found in Planning Mode table
2019-05-23 15:02:30.513 ===== TRACE ===== sendMailIfMailable : Mails without dest
2019-05-23 15:02:40.515 ===== TRACE ===== sendMailIfMailable : Mails without dest
2019-05-23 15:04:38.498 ===== TRACE ===== Error for planning mode '16' not found in Planning Mode table
2019-05-23 16:36:53.127 ** ERROR ** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:36:53.127 ** ERROR ** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from work t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 33) and t1.idProject not in (0, 39) and year='2019' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:36:53.127 ** ERROR ** [V8.0.3] Strack trace :
2019-05-23 16:36:53.127 ** ERROR ** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:36:53.127 ** ERROR ** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:36:53.127 ** ERROR ** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from plannedwork t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 33) and t1.idProject not in (0, 39) and year='2019' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:36:53.127 ** ERROR ** [V8.0.3] Strack trace :
2019-05-23 16:36:53.127 ** ERROR ** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:36:57.311 ** ERROR ** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:36:57.311 ** ERROR ** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from work t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 33) and t1.idProject not in (0, 39) and year='2019' and month='201905' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:36:57.311 ** ERROR ** [V8.0.3] Strack trace :
2019-05-23 16:36:57.311 ** ERROR ** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:36:57.311 ** ERROR ** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:36:57.311 ** ERROR ** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from plannedwork t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 33) and t1.idProject not in (0, 39) and year='2019' and month='201905' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:36:57.311 ** ERROR ** [V8.0.3] Strack trace :
2019-05-23 16:36:57.311 ** ERROR ** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:37:52.081 ** ERROR ** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:37:52.081 ** ERROR ** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from work t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 2, 32, 33, 34, 35, 36, 37, 38, 30) and t1.idProject not in (0, 39) and year='2019' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:37:52.081 ** ERROR ** [V8.0.3] Strack trace :
2019-05-23 16:37:52.081 ** ERROR ** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:37:52.081 ** ERROR ** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:37:52.081 ** ERROR ** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from plannedwork t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 2, 32, 33, 34, 35, 36, 37, 38, 30) and t1.idProject not in (0, 39) and year='2019' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:37:52.081 ** ERROR ** [V8.0.3] Strack trace :
2019-05-23 16:37:52.081 ** ERROR ** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:37:54.206 ** ERROR ** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:37:54.206 ** ERROR ** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from work t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 2, 32, 33, 34, 35, 36, 37, 38, 30) and t1.idProject not in (0, 39) and year='2019' and month='201905' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:37:54.206 ** ERROR ** [V8.0.3] Strack trace :
2019-05-23 16:37:54.206 ** ERROR ** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:37:54.207 ** ERROR ** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ject=t2.id group by month, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:37:54.207 ** ERROR ** [V8.0.3] For query : select sum(work) as sumWork, month as scale , t1.idProject as idproject from plannedwork t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 2, 32, 33, 34, 35, 36, 37, 38, 30) and t1.idProject not in (0, 39) and year='2019' and month='201905' and t1.idProject=t2.id group by month, t1.idProject order by t2.sortOrder asc
2019-05-23 16:37:54.207 ** ERROR ** [V8.0.3] Strack trace :
2019-05-23 16:37:54.207 ** ERROR ** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:39:07.603 ===== TRACE ===== DISCONNECTED USER 'Thomas'
2019-05-23 16:40:01.956 ** ERROR ** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...oject=t2.id group by week, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:40:01.956 ** ERROR ** [V8.0.3] For query : select sum(work) as sumWork, week as scale , t1.idProject as idproject from work t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 2, 32, 33, 34, 35, 36, 37, 38, 30) and t1.idProject not in (0, 39) and year='2019' and t1.idProject=t2.id group by week, t1.idProject order by t2.sortOrder asc
2019-05-23 16:40:01.956 ** ERROR ** [V8.0.3] Strack trace :
2019-05-23 16:40:01.956 ** ERROR ** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
2019-05-23 16:40:01.956 ** ERROR ** [V8.0.3] Exception-[42803] SQLSTATE[42803]: Grouping error: 7 ERROR: column "t2.sortorder" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...oject=t2.id group by week, t1.idProject order by t2.sortOrd...
^
2019-05-23 16:40:01.957 ** ERROR ** [V8.0.3] For query : select sum(work) as sumWork, week as scale , t1.idProject as idproject from plannedwork t1, project t2 where ((t1.idProject not in (0) or t1.idProject is null ) and (t1.idProject not in (0) or t1.idProject is null or (1=4) ) and (t1.idProject not in (0) or t1.idProject is null or (1=3) )) and t1.idProject in (0, 2, 32, 33, 34, 35, 36, 37, 38, 30) and t1.idProject not in (0, 39) and year='2019' and t1.idProject=t2.id group by week, t1.idProject order by t2.sortOrder asc
2019-05-23 16:40:01.957 ** ERROR ** [V8.0.3] Strack trace :
2019-05-23 16:40:01.957 ** ERROR ** [V8.0.3] #0 Sql->query called at [/var/www/html/report/globalWorkPlanning.php:135]
Ticket #4033 recorded