error when I fix issue...
see on log file:
2022-06-20 10:52:00.180 ** ERROR ** [V9.5.5] Exception-[22003] SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'validatedWork' at row 1
2022-06-20 10:52:00.180 ** ERROR ** [V9.5.5] For query : update budgetelement set validatedWork='-37.8' , assignedWork='-16.7' , leftWork='-17.925' , plannedWork='21.735' , assignedCost='-4895.84' , leftCost='-5991.1' , plannedCost='7690.43' , totalAssignedCost='-4895.84' , totalPlannedCost='7690.43' , totalLeftCost='-5991.1' where id=16
2022-06-20 10:52:00.180 ** ERROR ** [V9.5.5] Strack trace :
2022-06-20 10:52:00.180 ** ERROR ** [V9.5.5] #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:1825]
2022-06-20 10:52:00.180 ** ERROR ** [V9.5.5] #1 SqlElement->updateSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:1280]
2022-06-20 10:52:00.180 ** ERROR ** [V9.5.5] #2 SqlElement->saveSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:831]
2022-06-20 10:52:00.180 ** ERROR ** [V9.5.5] #3 SqlElement->save called at [/var/www/html/projeqtor/model/BudgetElement.php:208]
2022-06-20 10:52:00.180 ** ERROR ** [V9.5.5] #4 BudgetElement->save called at [/var/www/html/projeqtor/model/OrganizationMain.php:813]
2022-06-20 10:52:00.180 ** ERROR ** [V9.5.5] #5 OrganizationMain->updateSynthesis called at [/var/www/html/projeqtor/model/ProjectPlanningElementMain.php:275]
2022-06-20 10:52:00.180 ** ERROR ** [V9.5.5] #6 ProjectPlanningElementMain->save called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:2003]
2022-06-20 10:52:00.180 ** ERROR ** [V9.5.5] #7 SqlElement->saveDependantObjects called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:1938]
2022-06-20 10:52:00.180 ** ERROR ** [V9.5.5] #8 SqlElement->updateSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:1280]
2022-06-20 10:52:00.180 ** ERROR ** [V9.5.5] #9 SqlElement->saveSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:1085]
2022-06-20 10:52:00.181 ** ERROR ** [V9.5.5] #10 SqlElement->saveForced called at [/var/www/html/projeqtor/model/PlanningElement.php:1188]
2022-06-20 10:52:00.181 ** ERROR ** [V9.5.5] #11 PlanningElement->wbsSave called at [/var/www/html/projeqtor/model/PlanningElement.php:1200]
2022-06-20 10:52:00.181 ** ERROR ** [V9.5.5] #12 PlanningElement->wbsSave called at [/var/www/html/projeqtor/model/PlanningElement.php:1854]
2022-06-20 10:52:00.181 ** ERROR ** [V9.5.5] #13 PlanningElement->moveTo called at [/var/www/html/projeqtor/model/PlanningElement.php:1817]
2022-06-20 10:52:00.181 ** ERROR ** [V9.5.5] #14 PlanningElement->moveTo called at [/var/www/html/projeqtor/model/Consistency.php:220]
2022-06-20 10:52:00.181 ** ERROR ** [V9.5.5] #15 Consistency->fixOrder called at [/var/www/html/projeqtor/model/Consistency.php:139]
2022-06-20 10:52:00.181 ** ERROR ** [V9.5.5] #16 Consistency->checkWbs called at [/var/www/html/projeqtor/tool/adminFunctionalities.php:97]
2022-06-20 10:52:00.181 ** ERROR ** [V9.5.5] #17 include called at [/var/www/html/projeqtor/view/print.php:288]
Hi,
Very strange, you have negative values in your budgets ...
Consistency tries to fix BBS number of the budget, and this recalculated consolidated values from expenses, that seem to have a negative sum...
We'll have a look if we can fix Consistency, but sure you budget will have issue (they won't store negative values)