View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - consistency checks - 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)

  

 

 

consistency checks

More
21 Nov 2018 16:37 #1 by Durou C
consistency checks was created by Durou C
until the 7.3.0 version, I've a lot of error appears when i had consistency checks.

Projeqtor say that the anomaly is checked, but if i did a new scan, it's exactly the same.
Attachments:

Please Connexion or Create an account to join the conversation.

More
21 Nov 2018 16:39 #2 by Durou C
Replied by Durou C on topic consistency checks
extract of log file:

2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] For query : update planningelement set realWork='448.01338' , plannedWork='470.22941' , realCost='197434.74' , plannedCost='205507.53' , expectedProgress='28336' where id=2160
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1492]
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:986]
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] #3 SqlElement->save called at [/var/www/projeqtor/model/PlanningElement.php:413]
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] #4 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] #5 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] #6 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] #7 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] #8 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] #9 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] #10 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] #11 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/Assignment.php:232]
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] #12 Assignment->save called at [/var/www/projeqtor/model/Assignment.php:384]
2018-11-21 16:15:42.218 ***** ERROR ***** [V7.3.0] #13 Assignment->saveWithRefresh called at [/var/www/projeqtor/tool/saveImputation.php:134]
2018-11-21 16:15:52.219 ***** ERROR ***** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:15:52.219 ***** ERROR ***** [V7.3.0] For query : delete from kpihistory where idKpiDefinition=1 and refType='Project' and refId=376 and kpiDate='2018-11-21'
2018-11-21 16:15:52.219 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:15:52.219 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1819]
2018-11-21 16:15:52.219 ***** ERROR ***** [V7.3.0] #1 SqlElement->purgeSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:819]
2018-11-21 16:15:52.219 ***** ERROR ***** [V7.3.0] #2 SqlElement->purge called at [/var/www/projeqtor/model/KpiValue.php:85]
2018-11-21 16:15:52.219 ***** ERROR ***** [V7.3.0] #3 KpiValue->storeHistory called at [/var/www/projeqtor/model/KpiValue.php:77]
2018-11-21 16:15:52.219 ***** ERROR ***** [V7.3.0] #4 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:121]
2018-11-21 16:15:52.219 ***** ERROR ***** [V7.3.0] #5 KpiValue->calculateKpi called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:206]
2018-11-21 16:15:52.219 ***** ERROR ***** [V7.3.0] #6 ProjectPlanningElementMain->save called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:281]
2018-11-21 16:15:52.219 ***** ERROR ***** [V7.3.0] #7 ProjectPlanningElementMain->updateSynthesisProject called at [/var/www/projeqtor/model/PlanningElement.php:805]
2018-11-21 16:15:52.219 ***** ERROR ***** [V7.3.0] #8 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:15:52.219 ***** ERROR ***** [V7.3.0] #9 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:15:52.219 ***** ERROR ***** [V7.3.0] #10 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:15:52.220 ***** ERROR ***** [V7.3.0] #11 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:15:52.220 ***** ERROR ***** [V7.3.0] #12 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:15:52.220 ***** ERROR ***** [V7.3.0] #13 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:15:52.220 ***** ERROR ***** [V7.3.0] #14 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:15:52.220 ***** ERROR ***** [V7.3.0] #15 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:15:52.220 ***** ERROR ***** [V7.3.0] #16 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/Assignment.php:232]
2018-11-21 16:15:52.220 ***** ERROR ***** [V7.3.0] #17 Assignment->save called at [/var/www/projeqtor/tool/saveLeftWork.php:44]
2018-11-21 16:16:12.157 ===== TRACE ===== NEW CONNECTED USER 'fca' (using remember me feature)
2018-11-21 16:16:33.224 ***** ERROR ***** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:16:33.224 ***** ERROR ***** [V7.3.0] For query : update planningelement set needReplan='1' where id=1072
2018-11-21 16:16:33.224 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:16:33.224 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1492]
2018-11-21 16:16:33.224 ***** ERROR ***** [V7.3.0] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:986]
2018-11-21 16:16:33.224 ***** ERROR ***** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:798]
2018-11-21 16:16:33.224 ***** ERROR ***** [V7.3.0] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/PlanningElement.php:606]
2018-11-21 16:16:33.225 ***** ERROR ***** [V7.3.0] #4 PlanningElement->simpleSave called at [/var/www/projeqtor/model/ProjectMain.php:980]
2018-11-21 16:16:33.225 ***** ERROR ***** [V7.3.0] #5 ProjectMain->setNeedReplan called at [/var/www/projeqtor/model/Assignment.php:316]
2018-11-21 16:16:33.225 ***** ERROR ***** [V7.3.0] #6 Assignment->save called at [/var/www/projeqtor/model/Assignment.php:384]
2018-11-21 16:16:33.225 ***** ERROR ***** [V7.3.0] #7 Assignment->saveWithRefresh called at [/var/www/projeqtor/tool/saveImputation.php:134]
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] For query : insert into kpihistory ( idKpiDefinition , refType , refId , kpiType , kpiDate , day , week , month , year , kpiValue , weight , refDone ) values ('1', 'Project', '376', 'D', '2018-11-21', '20181121', '201847', '201811', '2018', '1.1811023622047', '1', '0')
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1193]
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] #1 SqlElement->insertSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:992]
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] #3 SqlElement->save called at [/var/www/projeqtor/model/KpiValue.php:90]
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] #4 KpiValue->storeHistory called at [/var/www/projeqtor/model/KpiValue.php:77]
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] #5 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:121]
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] #6 KpiValue->calculateKpi called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:206]
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] #7 ProjectPlanningElementMain->save called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:281]
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] #8 ProjectPlanningElementMain->updateSynthesisProject called at [/var/www/projeqtor/model/PlanningElement.php:805]
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] #9 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] #10 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] #11 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] #12 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:16:43.265 ***** ERROR ***** [V7.3.0] #13 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:16:43.266 ***** ERROR ***** [V7.3.0] #14 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:16:43.266 ***** ERROR ***** [V7.3.0] #15 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:16:43.266 ***** ERROR ***** [V7.3.0] #16 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:16:43.266 ***** ERROR ***** [V7.3.0] #17 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/Assignment.php:232]
2018-11-21 16:16:43.266 ***** ERROR ***** [V7.3.0] #18 Assignment->save called at [/var/www/projeqtor/tool/saveLeftWork.php:44]
2018-11-21 16:17:24.232 ***** ERROR ***** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:17:24.232 ***** ERROR ***** [V7.3.0] For query : update kpivalue set kpiValue='1.1144578313253' where id=88
2018-11-21 16:17:24.232 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:17:24.232 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1492]
2018-11-21 16:17:24.232 ***** ERROR ***** [V7.3.0] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:986]
2018-11-21 16:17:24.232 ***** ERROR ***** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:17:24.232 ***** ERROR ***** [V7.3.0] #3 SqlElement->save called at [/var/www/projeqtor/model/KpiValue.php:75]
2018-11-21 16:17:24.232 ***** ERROR ***** [V7.3.0] #4 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:121]
2018-11-21 16:17:24.232 ***** ERROR ***** [V7.3.0] #5 KpiValue->calculateKpi called at [/var/www/projeqtor/model/PlanningElement.php:608]
2018-11-21 16:17:24.232 ***** ERROR ***** [V7.3.0] #6 PlanningElement->simpleSave called at [/var/www/projeqtor/model/ProjectMain.php:980]
2018-11-21 16:17:24.232 ***** ERROR ***** [V7.3.0] #7 ProjectMain->setNeedReplan called at [/var/www/projeqtor/model/Assignment.php:316]
2018-11-21 16:17:24.232 ***** ERROR ***** [V7.3.0] #8 Assignment->save called at [/var/www/projeqtor/model/Assignment.php:384]
2018-11-21 16:17:24.232 ***** ERROR ***** [V7.3.0] #9 Assignment->saveWithRefresh called at [/var/www/projeqtor/tool/saveImputation.php:134]
2018-11-21 16:17:34.233 ***** ERROR ***** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:17:34.233 ***** ERROR ***** [V7.3.0] For query : update kpivalue set kpiValue='1.7566666666667' where id=77
2018-11-21 16:17:34.233 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:17:34.233 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1492]
2018-11-21 16:17:34.233 ***** ERROR ***** [V7.3.0] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:986]
2018-11-21 16:17:34.233 ***** ERROR ***** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:17:34.233 ***** ERROR ***** [V7.3.0] #3 SqlElement->save called at [/var/www/projeqtor/model/KpiValue.php:75]
2018-11-21 16:17:34.233 ***** ERROR ***** [V7.3.0] #4 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:234]
2018-11-21 16:17:34.233 ***** ERROR ***** [V7.3.0] #5 KpiValue->consolidate called at [/var/www/projeqtor/model/KpiValue.php:122]
2018-11-21 16:17:34.234 ***** ERROR ***** [V7.3.0] #6 KpiValue->calculateKpi called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:206]
2018-11-21 16:17:34.234 ***** ERROR ***** [V7.3.0] #7 ProjectPlanningElementMain->save called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:281]
2018-11-21 16:17:34.234 ***** ERROR ***** [V7.3.0] #8 ProjectPlanningElementMain->updateSynthesisProject called at [/var/www/projeqtor/model/PlanningElement.php:805]
2018-11-21 16:17:34.234 ***** ERROR ***** [V7.3.0] #9 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:17:34.234 ***** ERROR ***** [V7.3.0] #10 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:17:34.234 ***** ERROR ***** [V7.3.0] #11 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:17:34.234 ***** ERROR ***** [V7.3.0] #12 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:17:34.234 ***** ERROR ***** [V7.3.0] #13 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:17:34.234 ***** ERROR ***** [V7.3.0] #14 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:17:34.234 ***** ERROR ***** [V7.3.0] #15 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:17:34.234 ***** ERROR ***** [V7.3.0] #16 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:17:34.234 ***** ERROR ***** [V7.3.0] #17 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/Assignment.php:232]
2018-11-21 16:17:34.234 ***** ERROR ***** [V7.3.0] #18 Assignment->save called at [/var/www/projeqtor/tool/saveLeftWork.php:44]
2018-11-21 16:18:15.239 ***** ERROR ***** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:18:15.239 ***** ERROR ***** [V7.3.0] For query : delete from kpihistory where idKpiDefinition=1 and refType='Project' and refId=184 and kpiDate='2018-11-21'
2018-11-21 16:18:15.239 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:18:15.239 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1819]
2018-11-21 16:18:15.239 ***** ERROR ***** [V7.3.0] #1 SqlElement->purgeSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:819]
2018-11-21 16:18:15.239 ***** ERROR ***** [V7.3.0] #2 SqlElement->purge called at [/var/www/projeqtor/model/KpiValue.php:85]
2018-11-21 16:18:15.239 ***** ERROR ***** [V7.3.0] #3 KpiValue->storeHistory called at [/var/www/projeqtor/model/KpiValue.php:77]
2018-11-21 16:18:15.239 ***** ERROR ***** [V7.3.0] #4 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:121]
2018-11-21 16:18:15.239 ***** ERROR ***** [V7.3.0] #5 KpiValue->calculateKpi called at [/var/www/projeqtor/model/PlanningElement.php:608]
2018-11-21 16:18:15.239 ***** ERROR ***** [V7.3.0] #6 PlanningElement->simpleSave called at [/var/www/projeqtor/model/ProjectMain.php:980]
2018-11-21 16:18:15.239 ***** ERROR ***** [V7.3.0] #7 ProjectMain->setNeedReplan called at [/var/www/projeqtor/model/Assignment.php:316]
2018-11-21 16:18:15.239 ***** ERROR ***** [V7.3.0] #8 Assignment->save called at [/var/www/projeqtor/model/Assignment.php:384]
2018-11-21 16:18:15.239 ***** ERROR ***** [V7.3.0] #9 Assignment->saveWithRefresh called at [/var/www/projeqtor/tool/saveImputation.php:134]
2018-11-21 16:18:25.240 ***** ERROR ***** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:18:25.240 ***** ERROR ***** [V7.3.0] For query : delete from kpihistory where idKpiDefinition=1 and refType='Organization' and refId=1 and kpiDate='2018-11-21'
2018-11-21 16:18:25.240 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:18:25.240 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1819]
2018-11-21 16:18:25.240 ***** ERROR ***** [V7.3.0] #1 SqlElement->purgeSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:819]
2018-11-21 16:18:25.240 ***** ERROR ***** [V7.3.0] #2 SqlElement->purge called at [/var/www/projeqtor/model/KpiValue.php:85]
2018-11-21 16:18:25.240 ***** ERROR ***** [V7.3.0] #3 KpiValue->storeHistory called at [/var/www/projeqtor/model/KpiValue.php:77]
2018-11-21 16:18:25.240 ***** ERROR ***** [V7.3.0] #4 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:234]
2018-11-21 16:18:25.240 ***** ERROR ***** [V7.3.0] #5 KpiValue->consolidate called at [/var/www/projeqtor/model/KpiValue.php:122]
2018-11-21 16:18:25.240 ***** ERROR ***** [V7.3.0] #6 KpiValue->calculateKpi called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:206]
2018-11-21 16:18:25.240 ***** ERROR ***** [V7.3.0] #7 ProjectPlanningElementMain->save called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:281]
2018-11-21 16:18:25.240 ***** ERROR ***** [V7.3.0] #8 ProjectPlanningElementMain->updateSynthesisProject called at [/var/www/projeqtor/model/PlanningElement.php:805]
2018-11-21 16:18:25.240 ***** ERROR ***** [V7.3.0] #9 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:18:25.240 ***** ERROR ***** [V7.3.0] #10 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:18:25.240 ***** ERROR ***** [V7.3.0] #11 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:18:25.241 ***** ERROR ***** [V7.3.0] #12 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:18:25.241 ***** ERROR ***** [V7.3.0] #13 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:18:25.241 ***** ERROR ***** [V7.3.0] #14 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:18:25.241 ***** ERROR ***** [V7.3.0] #15 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:18:25.241 ***** ERROR ***** [V7.3.0] #16 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:18:25.241 ***** ERROR ***** [V7.3.0] #17 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/Assignment.php:232]
2018-11-21 16:18:25.241 ***** ERROR ***** [V7.3.0] #18 Assignment->save called at [/var/www/projeqtor/tool/saveLeftWork.php:44]
2018-11-21 16:19:06.245 ***** ERROR ***** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:19:06.245 ***** ERROR ***** [V7.3.0] For query : insert into kpihistory ( idKpiDefinition , refType , refId , kpiType , kpiDate , day , week , month , year , kpiValue , weight , refDone ) values ('1', 'Project', '184', 'D', '2018-11-21', '20181121', '201847', '201811', '2018', '1.1144578313253', '1', '0')
2018-11-21 16:19:06.245 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:19:06.245 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1193]
2018-11-21 16:19:06.246 ***** ERROR ***** [V7.3.0] #1 SqlElement->insertSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:992]
2018-11-21 16:19:06.246 ***** ERROR ***** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:19:06.246 ***** ERROR ***** [V7.3.0] #3 SqlElement->save called at [/var/www/projeqtor/model/KpiValue.php:90]
2018-11-21 16:19:06.246 ***** ERROR ***** [V7.3.0] #4 KpiValue->storeHistory called at [/var/www/projeqtor/model/KpiValue.php:77]
2018-11-21 16:19:06.246 ***** ERROR ***** [V7.3.0] #5 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:121]
2018-11-21 16:19:06.246 ***** ERROR ***** [V7.3.0] #6 KpiValue->calculateKpi called at [/var/www/projeqtor/model/PlanningElement.php:608]
2018-11-21 16:19:06.246 ***** ERROR ***** [V7.3.0] #7 PlanningElement->simpleSave called at [/var/www/projeqtor/model/ProjectMain.php:980]
2018-11-21 16:19:06.246 ***** ERROR ***** [V7.3.0] #8 ProjectMain->setNeedReplan called at [/var/www/projeqtor/model/Assignment.php:316]
2018-11-21 16:19:06.246 ***** ERROR ***** [V7.3.0] #9 Assignment->save called at [/var/www/projeqtor/model/Assignment.php:384]
2018-11-21 16:19:06.246 ***** ERROR ***** [V7.3.0] #10 Assignment->saveWithRefresh called at [/var/www/projeqtor/tool/saveImputation.php:134]
2018-11-21 16:19:16.288 ***** ERROR ***** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:19:16.288 ***** ERROR ***** [V7.3.0] For query : insert into kpihistory ( idKpiDefinition , refType , refId , kpiType , kpiDate , day , week , month , year , kpiValue , weight , refDone ) values ('1', 'Organization', '1', 'D', '2018-11-21', '20181121', '201847', '201811', '2018', '1.7566666666667', '3', '0')
2018-11-21 16:19:16.288 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:19:16.288 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1193]
2018-11-21 16:19:16.288 ***** ERROR ***** [V7.3.0] #1 SqlElement->insertSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:992]
2018-11-21 16:19:16.288 ***** ERROR ***** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:19:16.288 ***** ERROR ***** [V7.3.0] #3 SqlElement->save called at [/var/www/projeqtor/model/KpiValue.php:90]
2018-11-21 16:19:16.288 ***** ERROR ***** [V7.3.0] #4 KpiValue->storeHistory called at [/var/www/projeqtor/model/KpiValue.php:77]
2018-11-21 16:19:16.288 ***** ERROR ***** [V7.3.0] #5 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:234]
2018-11-21 16:19:16.288 ***** ERROR ***** [V7.3.0] #6 KpiValue->consolidate called at [/var/www/projeqtor/model/KpiValue.php:122]
2018-11-21 16:19:16.289 ***** ERROR ***** [V7.3.0] #7 KpiValue->calculateKpi called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:206]
2018-11-21 16:19:16.289 ***** ERROR ***** [V7.3.0] #8 ProjectPlanningElementMain->save called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:281]
2018-11-21 16:19:16.289 ***** ERROR ***** [V7.3.0] #9 ProjectPlanningElementMain->updateSynthesisProject called at [/var/www/projeqtor/model/PlanningElement.php:805]
2018-11-21 16:19:16.289 ***** ERROR ***** [V7.3.0] #10 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:19:16.289 ***** ERROR ***** [V7.3.0] #11 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:19:16.289 ***** ERROR ***** [V7.3.0] #12 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:19:16.289 ***** ERROR ***** [V7.3.0] #13 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:19:16.289 ***** ERROR ***** [V7.3.0] #14 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:19:16.289 ***** ERROR ***** [V7.3.0] #15 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:19:16.289 ***** ERROR ***** [V7.3.0] #16 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:19:16.289 ***** ERROR ***** [V7.3.0] #17 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:19:16.289 ***** ERROR ***** [V7.3.0] #18 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/Assignment.php:232]
2018-11-21 16:19:16.289 ***** ERROR ***** [V7.3.0] #19 Assignment->save called at [/var/www/projeqtor/tool/saveLeftWork.php:44]
2018-11-21 16:19:55.447 ***** ERROR ***** [V7.3.0] Exception-[40001] SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
2018-11-21 16:19:55.447 ***** ERROR ***** [V7.3.0] For query : update planningelement set realWork='241.77793' , plannedWork='353.60225' , marginWork='-86.37249' where id=1925
2018-11-21 16:19:55.447 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:19:55.447 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1492]
2018-11-21 16:19:55.447 ***** ERROR ***** [V7.3.0] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:986]
2018-11-21 16:19:55.447 ***** ERROR ***** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:19:55.447 ***** ERROR ***** [V7.3.0] #3 SqlElement->save called at [/var/www/projeqtor/model/PlanningElement.php:413]
2018-11-21 16:19:55.447 ***** ERROR ***** [V7.3.0] #4 PlanningElement->save called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:178]
2018-11-21 16:19:55.447 ***** ERROR ***** [V7.3.0] #5 ProjectPlanningElementMain->save called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:281]
2018-11-21 16:19:55.447 ***** ERROR ***** [V7.3.0] #6 ProjectPlanningElementMain->updateSynthesisProject called at [/var/www/projeqtor/model/PlanningElement.php:805]
2018-11-21 16:19:55.447 ***** ERROR ***** [V7.3.0] #7 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:19:55.447 ***** ERROR ***** [V7.3.0] #8 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:19:55.447 ***** ERROR ***** [V7.3.0] #9 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:19:55.447 ***** ERROR ***** [V7.3.0] #10 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:19:55.447 ***** ERROR ***** [V7.3.0] #11 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:19:55.448 ***** ERROR ***** [V7.3.0] #12 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:19:55.448 ***** ERROR ***** [V7.3.0] #13 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/persistence/SqlElement.php:1613]
2018-11-21 16:19:55.448 ***** ERROR ***** [V7.3.0] #14 SqlElement->saveDependantObjects called at [/var/www/projeqtor/model/persistence/SqlElement.php:1551]
2018-11-21 16:19:55.448 ***** ERROR ***** [V7.3.0] #15 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:986]
2018-11-21 16:19:55.448 ***** ERROR ***** [V7.3.0] #16 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:19:55.448 ***** ERROR ***** [V7.3.0] #17 SqlElement->save called at [/var/www/projeqtor/model/ActivityMain.php:397]
2018-11-21 16:19:55.448 ***** ERROR ***** [V7.3.0] #18 ActivityMain->save called at [/var/www/projeqtor/tool/saveObject.php:78]
2018-11-21 16:19:56.829 ===== TRACE ===== DISCONNECTED USER 'fca'
2018-11-21 16:24:53.121 ***** ERROR ***** [V7.3.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idStatus' in 'field list'
2018-11-21 16:24:53.121 ***** ERROR ***** [V7.3.0] For query : select * from status where id in (select distinct idStatus from indicatordefinition) order by sortOrder asc
2018-11-21 16:24:53.121 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:24:53.121 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2371]
2018-11-21 16:24:53.121 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:6703]
2018-11-21 16:24:53.121 ***** ERROR ***** [V7.3.0] #2 SqlElement->getExistingStatus called at [/var/www/projeqtor/view/objectList.php:169]
2018-11-21 16:24:53.121 ***** ERROR ***** [V7.3.0] #3 include called at [/var/www/projeqtor/view/objectMain.php:63]
2018-11-21 16:25:14.035 ***** ERROR ***** [V7.3.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idStatus' in 'field list'
2018-11-21 16:25:14.035 ***** ERROR ***** [V7.3.0] For query : select * from status where id in (select distinct idStatus from indicatordefinition) order by sortOrder asc
2018-11-21 16:25:14.035 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:25:14.035 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2371]
2018-11-21 16:25:14.035 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:6703]
2018-11-21 16:25:14.035 ***** ERROR ***** [V7.3.0] #2 SqlElement->getExistingStatus called at [/var/www/projeqtor/view/objectList.php:169]
2018-11-21 16:25:14.035 ***** ERROR ***** [V7.3.0] #3 include called at [/var/www/projeqtor/view/objectMain.php:63]
2018-11-21 16:25:19.387 ***** ERROR ***** [V7.3.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idStatus' in 'field list'
2018-11-21 16:25:19.387 ***** ERROR ***** [V7.3.0] For query : select * from status where id in (select distinct idStatus from delay) order by sortOrder asc
2018-11-21 16:25:19.387 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:25:19.388 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2371]
2018-11-21 16:25:19.388 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:6703]
2018-11-21 16:25:19.388 ***** ERROR ***** [V7.3.0] #2 SqlElement->getExistingStatus called at [/var/www/projeqtor/view/objectList.php:169]
2018-11-21 16:25:19.388 ***** ERROR ***** [V7.3.0] #3 include called at [/var/www/projeqtor/view/objectMain.php:63]
2018-11-21 16:25:24.381 ***** ERROR ***** [V7.3.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idStatus' in 'field list'
2018-11-21 16:25:24.381 ***** ERROR ***** [V7.3.0] For query : select * from status where id in (select distinct idStatus from delay) order by sortOrder asc
2018-11-21 16:25:24.381 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:25:24.381 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2371]
2018-11-21 16:25:24.381 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:6703]
2018-11-21 16:25:24.381 ***** ERROR ***** [V7.3.0] #2 SqlElement->getExistingStatus called at [/var/www/projeqtor/view/objectList.php:169]
2018-11-21 16:25:24.381 ***** ERROR ***** [V7.3.0] #3 include called at [/var/www/projeqtor/view/objectMain.php:63]
2018-11-21 16:26:01.898 ***** ERROR ***** [V7.3.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idStatus' in 'field list'
2018-11-21 16:26:01.898 ***** ERROR ***** [V7.3.0] For query : select * from status where id in (select distinct idStatus from emailtemplate) order by sortOrder asc
2018-11-21 16:26:01.898 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:26:01.898 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2371]
2018-11-21 16:26:01.898 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:6703]
2018-11-21 16:26:01.898 ***** ERROR ***** [V7.3.0] #2 SqlElement->getExistingStatus called at [/var/www/projeqtor/view/objectList.php:169]
2018-11-21 16:26:01.898 ***** ERROR ***** [V7.3.0] #3 include called at [/var/www/projeqtor/view/objectMain.php:63]
2018-11-21 16:26:06.698 ***** ERROR ***** [V7.3.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idStatus' in 'field list'
2018-11-21 16:26:06.698 ***** ERROR ***** [V7.3.0] For query : select * from status where id in (select distinct idStatus from emailtemplate) order by sortOrder asc
2018-11-21 16:26:06.698 ***** ERROR ***** [V7.3.0] Strack trace :
2018-11-21 16:26:06.698 ***** ERROR ***** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2371]
2018-11-21 16:26:06.698 ***** ERROR ***** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:6703]
2018-11-21 16:26:06.698 ***** ERROR ***** [V7.3.0] #2 SqlElement->getExistingStatus called at [/var/www/projeqtor/view/objectList.php:169]
2018-11-21 16:26:06.698 ***** ERROR ***** [V7.3.0] #3 include called at [/var/www/projeqtor/view/objectMain.php:63]

Please Connexion or Create an account to join the conversation.

More
21 Nov 2018 19:13 #3 by babynus
Replied by babynus on topic consistency checks
There are locks.

Fixing Consistency issues may jave impact on many items, more over if many issues are identified.
So try and execute consistency fixing without any other user connected.
Also try it after restart of db process.
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
22 Nov 2018 09:44 #4 by Durou C
Replied by Durou C on topic consistency checks
I had close the projeqtor application. I had restart projeqtor computer, i had restart service apache2
and, in admin mode, I had fixe the issues.
when I scan after fixed, they always all appears... I don't understand, what's wrond...
if I open some tickets with error, I can show more real time that nobody enter, projeqtor add real time alone in many tickets...
so all of real time are wrong.

Please Connexion or Create an account to join the conversation.

More
23 Nov 2018 17:56 #5 by Durou C
Replied by Durou C on topic consistency checks
I do not understand I have a lot of error.

Please Connexion or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.049 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.

Login Form