Dear All,
I've got several error today when check coherence control :
Contrôle de la séquence du WBS
WBS en double pour [] #${3} et Projet #115
WBS '${1}' de Projet #115 est incorrect pour le premier de son parent (001 attendu)
Impossible de trouver le WBS de Project #115, parent de Activité #1470 - Ordre incorrect ?
Impossible de trouver le WBS de Project #115, parent de Activité #1471 - Ordre incorrect ?
Impossible de trouver le WBS de Project #115, parent de Activité #1472 - Ordre incorrect ?
Impossible de trouver le WBS de Project #115, parent de Activité #1475 - Ordre incorrect ?
correction not possible
I've got this error last weeks on test base when i update to last version and try to closed one employe contract and use new module for re-affectation.
but perhaps no link.
In final to avoid trouble, i don't close the employe "ressource" and contract and so on ...
Thanks for your support.
LR
project 115 is "PROJECT - periode d'absence"
and linked activities are
Congés payés (CP)
Repos Cadre (RTT)
Arrêt Maladie (AM)
Autres (A)
Associated log:
2023-03-31 11:21:28.897 ** ERROR ** [V10.3.1] Exception-[HY000] SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'projeqtor.st.sortOrder' which is not in SELECT list; this is incompatible with DISTINCT
2023-03-31 11:21:28.897 ** ERROR ** [V10.3.1] For query : SELECT DISTINCT st.name from status as st
left JOIN workflow as wf on wf.isLeaveWorkflow = 1
left join workflowstatus as wfs on wfs.idWorkflow = wf.id
where st.id = wfs.idStatusFrom or st.id = wfs.idStatusTo ORDER by st.sortOrder;
2023-03-31 11:21:28.898 ** ERROR ** [V10.3.1] Strack trace :
2023-03-31 11:21:28.898 ** ERROR ** [V10.3.1] #0 Sql->query called at [/var/www/projeqtor/model/LeaveTypeMain.php:736]
2023-03-31 11:21:28.898 ** ERROR ** [V10.3.1] #1 LeaveTypeMain->drawSendInfo called at [/var/www/projeqtor/model/LeaveTypeMain.php:1080]
2023-03-31 11:21:28.898 ** ERROR ** [V10.3.1] #2 LeaveTypeMain->drawSpecificItem called at [/var/www/projeqtor/view/objectDetail.php:1153]
2023-03-31 11:21:28.898 ** ERROR ** [V10.3.1] #3 drawTableFromObject called at [/var/www/projeqtor/view/objectDetail.php:361]
2023-03-31 11:21:32.960 ** ERROR ** [V10.3.1] Exception-[HY000] SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'projeqtor.st.sortOrder' which is not in SELECT list; this is incompatible with DISTINCT
2023-03-31 11:21:32.960 ** ERROR ** [V10.3.1] For query : SELECT DISTINCT st.name from status as st
left JOIN workflow as wf on wf.isLeaveWorkflow = 1
left join workflowstatus as wfs on wfs.idWorkflow = wf.id
where st.id = wfs.idStatusFrom or st.id = wfs.idStatusTo ORDER by st.sortOrder;
2023-03-31 11:21:32.961 ** ERROR ** [V10.3.1] Strack trace :
2023-03-31 11:21:32.961 ** ERROR ** [V10.3.1] #0 Sql->query called at [/var/www/projeqtor/model/LeaveTypeMain.php:736]
2023-03-31 11:21:32.961 ** ERROR ** [V10.3.1] #1 LeaveTypeMain->drawSendInfo called at [/var/www/projeqtor/model/LeaveTypeMain.php:1080]
2023-03-31 11:21:32.961 ** ERROR ** [V10.3.1] #2 LeaveTypeMain->drawSpecificItem called at [/var/www/projeqtor/view/objectDetail.php:1153]
2023-03-31 11:21:32.961 ** ERROR ** [V10.3.1] #3 drawTableFromObject called at [/var/www/projeqtor/view/objectDetail.php:361]
2023-03-31 11:21:33.805 ** ERROR ** [V10.3.1] Exception-[HY000] SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'projeqtor.st.sortOrder' which is not in SELECT list; this is incompatible with DISTINCT
2023-03-31 11:21:33.805 ** ERROR ** [V10.3.1] For query : SELECT DISTINCT st.name from status as st
left JOIN workflow as wf on wf.isLeaveWorkflow = 1
left join workflowstatus as wfs on wfs.idWorkflow = wf.id
where st.id = wfs.idStatusFrom or st.id = wfs.idStatusTo ORDER by st.sortOrder;
2023-03-31 11:21:33.806 ** ERROR ** [V10.3.1] Strack trace :
2023-03-31 11:21:33.806 ** ERROR ** [V10.3.1] #0 Sql->query called at [/var/www/projeqtor/model/LeaveTypeMain.php:736]
2023-03-31 11:21:33.806 ** ERROR ** [V10.3.1] #1 LeaveTypeMain->drawSendInfo called at [/var/www/projeqtor/model/LeaveTypeMain.php:1080]
2023-03-31 11:21:33.806 ** ERROR ** [V10.3.1] #2 LeaveTypeMain->drawSpecificItem called at [/var/www/projeqtor/view/objectDetail.php:1153]
2023-03-31 11:21:33.806 ** ERROR ** [V10.3.1] #3 drawTableFromObject called at [/var/www/projeqtor/view/objectDetail.php:361]
2023-03-31 11:21:35.111 ** ERROR ** [V10.3.1] Exception-[HY000] SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'projeqtor.st.sortOrder' which is not in SELECT list; this is incompatible with DISTINCT
2023-03-31 11:21:35.111 ** ERROR ** [V10.3.1] For query : SELECT DISTINCT st.name from status as st
left JOIN workflow as wf on wf.isLeaveWorkflow = 1
left join workflowstatus as wfs on wfs.idWorkflow = wf.id
where st.id = wfs.idStatusFrom or st.id = wfs.idStatusTo ORDER by st.sortOrder;
2023-03-31 11:21:35.111 ** ERROR ** [V10.3.1] Strack trace :
2023-03-31 11:21:35.111 ** ERROR ** [V10.3.1] #0 Sql->query called at [/var/www/projeqtor/model/LeaveTypeMain.php:736]
2023-03-31 11:21:35.111 ** ERROR ** [V10.3.1] #1 LeaveTypeMain->drawSendInfo called at [/var/www/projeqtor/model/LeaveTypeMain.php:1080]
2023-03-31 11:21:35.111 ** ERROR ** [V10.3.1] #2 LeaveTypeMain->drawSpecificItem called at [/var/www/projeqtor/view/objectDetail.php:1153]
2023-03-31 11:21:35.112 ** ERROR ** [V10.3.1] #3 drawTableFromObject called at [/var/www/projeqtor/view/objectDetail.php:361]
2023-03-31 11:21:36.876 ** ERROR ** [V10.3.1] Exception-[HY000] SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'projeqtor.st.sortOrder' which is not in SELECT list; this is incompatible with DISTINCT
2023-03-31 11:21:36.876 ** ERROR ** [V10.3.1] For query : SELECT DISTINCT st.name from status as st
left JOIN workflow as wf on wf.isLeaveWorkflow = 1
left join workflowstatus as wfs on wfs.idWorkflow = wf.id
where st.id = wfs.idStatusFrom or st.id = wfs.idStatusTo ORDER by st.sortOrder;
2023-03-31 11:21:36.876 ** ERROR ** [V10.3.1] Strack trace :
2023-03-31 11:21:36.876 ** ERROR ** [V10.3.1] #0 Sql->query called at [/var/www/projeqtor/model/LeaveTypeMain.php:736]
2023-03-31 11:21:36.877 ** ERROR ** [V10.3.1] #1 LeaveTypeMain->drawSendInfo called at [/var/www/projeqtor/model/LeaveTypeMain.php:1080]
2023-03-31 11:21:36.877 ** ERROR ** [V10.3.1] #2 LeaveTypeMain->drawSpecificItem called at [/var/www/projeqtor/view/objectDetail.php:1153]
2023-03-31 11:21:36.877 ** ERROR ** [V10.3.1] #3 drawTableFromObject called at [/var/www/projeqtor/view/objectDetail.php:361]
2023-03-31 11:21:37.666 ** ERROR ** [V10.3.1] Exception-[HY000] SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'projeqtor.st.sortOrder' which is not in SELECT list; this is incompatible with DISTINCT
2023-03-31 11:21:37.666 ** ERROR ** [V10.3.1] For query : SELECT DISTINCT st.name from status as st
left JOIN workflow as wf on wf.isLeaveWorkflow = 1
left join workflowstatus as wfs on wfs.idWorkflow = wf.id
where st.id = wfs.idStatusFrom or st.id = wfs.idStatusTo ORDER by st.sortOrder;
2023-03-31 11:21:37.666 ** ERROR ** [V10.3.1] Strack trace :
2023-03-31 11:21:37.666 ** ERROR ** [V10.3.1] #0 Sql->query called at [/var/www/projeqtor/model/LeaveTypeMain.php:736]
2023-03-31 11:21:37.666 ** ERROR ** [V10.3.1] #1 LeaveTypeMain->drawSendInfo called at [/var/www/projeqtor/model/LeaveTypeMain.php:1080]
2023-03-31 11:21:37.666 ** ERROR ** [V10.3.1] #2 LeaveTypeMain->drawSpecificItem called at [/var/www/projeqtor/view/objectDetail.php:1153]
2023-03-31 11:21:37.666 ** ERROR ** [V10.3.1] #3 drawTableFromObject called at [/var/www/projeqtor/view/objectDetail.php:361]
2023-03-31 11:21:38.924 ** ERROR ** [V10.3.1] Exception-[HY000] SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'projeqtor.st.sortOrder' which is not in SELECT list; this is incompatible with DISTINCT
2023-03-31 11:21:38.924 ** ERROR ** [V10.3.1] For query : SELECT DISTINCT st.name from status as st
left JOIN workflow as wf on wf.isLeaveWorkflow = 1
left join workflowstatus as wfs on wfs.idWorkflow = wf.id
where st.id = wfs.idStatusFrom or st.id = wfs.idStatusTo ORDER by st.sortOrder;
2023-03-31 11:21:38.924 ** ERROR ** [V10.3.1] Strack trace :
2023-03-31 11:21:38.924 ** ERROR ** [V10.3.1] #0 Sql->query called at [/var/www/projeqtor/model/LeaveTypeMain.php:736]
2023-03-31 11:21:38.925 ** ERROR ** [V10.3.1] #1 LeaveTypeMain->drawSendInfo called at [/var/www/projeqtor/model/LeaveTypeMain.php:1080]
2023-03-31 11:21:38.925 ** ERROR ** [V10.3.1] #2 LeaveTypeMain->drawSpecificItem called at [/var/www/projeqtor/view/objectDetail.php:1153]
2023-03-31 11:21:38.925 ** ERROR ** [V10.3.1] #3 drawTableFromObject called at [/var/www/projeqtor/view/objectDetail.php:361]
Try and move project 115 (set it as sub-project of another one, then back to its place) to force recalculation of its WBS