View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [10.2.1]Imputations with Absences - ProjeQtOr
 
 

[10.2.1]Imputations with Absences

More
11 Jan 2023 19:41 - 11 Jan 2023 19:45 #1 by mikael.cordon@gmail.com
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.
 
Last edit: 11 Jan 2023 19:45 by mikael.cordon@gmail.com. Reason: Indents in logs

Please Log in or Create an account to join the conversation.

More
16 Jan 2023 11:05 - 16 Jan 2023 11:10 #2 by Arkhanje
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?
Last edit: 16 Jan 2023 11:10 by Arkhanje.

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.032 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

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