Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[10.2.1]Imputations...
 
Notifications
Clear all

[10.2.1]Imputations with Absences

2 Posts
2 Users
0 Reactions
1,519 Views
(@mikael-cordongmail-com)
Posts: 6
Active Member
Topic starter
 
[#8699]

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.
 


 
Posted : 11 Jan 2023 21H41
(@marylene)
Posts: 592
Contributor Admin
 

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?


 
Posted : 16 Jan 2023 13H05
Share:

Scroll to Top