Hello,
We started using absence module and imputations, but each time we save imputations with an absence in the week, the following error is raised :
2023-01-11 19:27:18.642 ** ERROR ** [V10.2.1] Exception-[23502] SQLSTATE[23502]: Not null violation: 7 ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « idproject » dans la relation « work » DETAIL: La ligne en échec contient (821, 30, null, null, null, null, 1.00000, 2023-01-11, 20230111, 202302, 202301, 2023, null, 0.00, null, null, 40, 31, 2023-01-11 19:27:18, 0). 2023-01-11 19:27:18.642 ** ERROR ** [V10.2.1] For query : update work set inputuser='31' , inputdatetime='2023-01-11 19:27:18' , idproject = NULL, reftype = NULL, refid = NULL, cost='0' where id=821 2023-01-11 19:27:18.642 ** ERROR ** [V10.2.1] Strack trace : 2023-01-11 19:27:18.642 ** ERROR ** [V10.2.1] #0 Sql->query called at [/opt/projeqtoretude/model/persistence/SqlElement.php:1854] 2023-01-11 19:27:18.642 ** ERROR ** [V10.2.1] #1 SqlElement->updateSqlElement called at [/opt/projeqtoretude/model/persistence/SqlElement.php:1308] 2023-01-11 19:27:18.642 ** ERROR ** [V10.2.1] #2 SqlElement->saveSqlElement called at [/opt/projeqtoretude/model/persistence/SqlElement.php:853] 2023-01-11 19:27:18.642 ** ERROR ** [V10.2.1] #3 SqlElement->save called at [/opt/projeqtoretude/model/GeneralWork.php:172] 2023-01-11 19:27:18.642 ** ERROR ** [V10.2.1] #4 GeneralWork->save called at [/opt/projeqtoretude/model/Work.php:237] 2023-01-11 19:27:18.642 ** ERROR ** [V10.2.1] #5 Work->save called at [/opt/projeqtoretude/model/ImputationLine.php:1615] 2023-01-11 19:27:18.642 ** ERROR ** [V10.2.1] #6 ImputationLine->save called at [/opt/projeqtoretude/tool/saveImputation.php:205]
This error was already here in version 10.1.4.
Hello,
We have no errors on the use of absences on our side.
What system are you using exactly. Because the absence and imputations module does not exist... it's either you use the HR module or the simple absence system.
Can you describe the steps of your manipulations?
Put some screenshots of the imputations? or the screen where you submit your leave?