View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - coherence control error since last week - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

coherence control error since last week

More
31 Mar 2023 11:16 #1 by loicr
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

Please Connexion or Create an account to join the conversation.

More
31 Mar 2023 11:19 #2 by loicr
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)

Please Connexion or Create an account to join the conversation.

More
31 Mar 2023 11:24 #3 by loicr
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]

Please Connexion or Create an account to join the conversation.

More
06 Avr 2023 11:45 #4 by babynus
Try and move project 115 (set it as sub-project of another one, then back to its place) to force recalculation of its WBS

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.052 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.