Forum

[SOLVED] Leave type...
 
Notifications
Retirer tout

[SOLVED] Leave type creation error

15 Posts
2 Utilisateurs
0 Reactions
8,317 Vu
(@karl-binet)
Posts: 128
Active Member
Début du sujet
 
[#6557]

Hello,

i have V8.3.3,

I'm trying to configure the Leave module,

when i try to create a leave type i'm getting this error

From what i understand i need to create an activity type, but the code shown in error message can't by type in the code field in the activity type.

Can you help please

Regards


 
Posté : 12 Mar PM 16:033
(@babynus)
Posts: 14952
Membre Admin
 

Did you try to desactivate / reactivate thje module (the type should be created automatically)


 
Posté : 19 Mar PM 20:033
(@karl-binet)
Posts: 128
Active Member
Début du sujet
 

Hi

Thanks for your reply, you were right, by disabling/enabling the module the type were created automaticly

Regards


 
Posté : 20 Mar PM 16:033
(@karl-binet)
Posts: 128
Active Member
Début du sujet
 

Oups got happy too soon,

I'm still getting an error

Even tought the Type were created, i'm still getting the same error.

Any idea ?


 
Posté : 20 Mar PM 16:033
(@babynus)
Posts: 14952
Membre Admin
 

Look at Atcivities Type.
Select "closed" checkbox to see closed type.
You must have one (and one only) type with code "LEAVESYST"
If you have several ones, delete extra ones


 
Posté : 25 Mar PM 17:033
(@karl-binet)
Posts: 128
Active Member
Début du sujet
 

see attach file for all my activity type,

I have only one type with code "leave"

i dot not have any type with the code "leavesyst"


 
Posté : 27 Mar PM 15:033
(@babynus)
Posts: 14952
Membre Admin
 

So sure, you need to add (or change existing) to have type with code "LEAVESYST"


 
Posté : 30 Mar AM 02:033
(@karl-binet)
Posts: 128
Active Member
Début du sujet
 

Hi,

tks for your reply, yes i would love to do that, but here what happens when i try to change the code from "LEAVE" to "LEAVESYST"

Regards


 
Posté : 1 Avr PM 15:044
(@babynus)
Posts: 14952
Membre Admin
 

Hi,

Don't know how you got there, but it seems only issue is db update
UPDATE type SET code='LEAVESYST" where id=407


 
Posté : 4 Avr PM 20:044
(@karl-binet)
Posts: 128
Active Member
Début du sujet
 

Hi,

Thanks for your reply,

I did update the DB, i now have the code LEAVESYST for my activity type,

Now when i try again to create a new Leave Type, i'm getting this error

Regards

here is the inscription in the log file

2020-04-06 10:31:36.504 ** ERROR ** [V8.3.3] Exception-[HY000] SQLSTATE[HY000]: General error: 1364 Field 'idProject' doesn't have a default value
2020-04-06 10:31:36.504 ** ERROR ** [V8.3.3] For query : insert into assignment ( refType , refId , idResource , uniqueResource , idle , isNotImputable , optional , isResourceTeam , surbooked , hasSupport ) values ('Activity', '7778', '27', '0', '0', '0', '0', '0', '0', '0')
2020-04-06 10:31:36.504 ** ERROR ** [V8.3.3] Strack trace :
2020-04-06 10:31:36.504 ** ERROR ** [V8.3.3] #0 Sql->query called at [/var/www/html/model/persistence/SqlElement.php:1295]
2020-04-06 10:31:36.504 ** ERROR ** [V8.3.3] #1 SqlElement->insertSqlElement called at [/var/www/html/model/persistence/SqlElement.php:1077]
2020-04-06 10:31:36.504 ** ERROR ** [V8.3.3] #2 SqlElement->saveSqlElement called at [/var/www/html/model/persistence/SqlElement.php:883]
2020-04-06 10:31:36.504 ** ERROR ** [V8.3.3] #3 SqlElement->saveForced called at [/var/www/html/model/Assignment.php:386]
2020-04-06 10:31:36.504 ** ERROR ** [V8.3.3] #4 Assignment->simpleSave called at [/var/www/html/model/LeaveTypeMain.php:346]
2020-04-06 10:31:36.504 ** ERROR ** [V8.3.3] #5 LeaveTypeMain->save called at [/var/www/html/tool/saveObject.php:78]


 
Posté : 6 Avr PM 18:044
(@babynus)
Posts: 14952
Membre Admin
 

You don't have the expected Leave project.
Difficult to manage all of this manually.

I suggest to : disable HR module
Then re-enable it and be sure all is "automaticelly" created.

You may try with new instance of back-up to be sure.


 
Posté : 8 Avr AM 10:044
(@karl-binet)
Posts: 128
Active Member
Début du sujet
 

Hello,

Thanks for your reply, i can disable/enable again the module, but already tried it when you ask me to do it at the beginning of this post.

Will try it again and let you know

regards


 
Posté : 15 Avr PM 17:044
(@karl-binet)
Posts: 128
Active Member
Début du sujet
 

Hello,

Ok so i tried disabling/enabling the module, no success

The first time i disabled/enabled the module, I was able to create an activity type with LEAVESYST code.
I was also able to create a Leave TYPe
But i was not able to set a RESSOURCE as an EMPLOYEE

got this error again.

so, I disabled/enables again

i was now able to set a RESSOURCE as an EMPLOYEE
but now, i can't create a leave Type
getting this error again

so now, i don't really know what to do more

i tried on to separate instance of projector and i'm always getting stuck at some point with the same error.

Any idea ?

Regards


 
Posté : 27 Mai PM 18:055
(@babynus)
Posts: 14952
Membre Admin
 

OK, let's investigate step by step

Do you have Activity Type with code 'LEAVESYST' => it is the leave activity type TYPE
Do you have Activity with the leave activity type ? => it is the Leave activity
What is the project of thses activities ? => it is the Leave Project
When you look at the leave project, you should not see tha allocation of reource part.
This is because this project is check 'isLEaveProject' in the DB.
It you don't get such a project, you must create it.
Moreover, there must be only one project of this kind... delete extra ones.


 
Posté : 31 Mai PM 21:055
(@karl-binet)
Posts: 128
Active Member
Début du sujet
 

Hello

I finally got it working, all that was missing is a project with 'isLEaveProject' set to 1 in the DB. I created a new project, set the value to 1. And everything is working now.

Thanks for your help

Regards


 
Posté : 10 Juin PM 16:066
Share:
Retour en haut