Forum

Forums
Requests
Ask questions
Leave Period ISSUE
 
Notifications
Clear all

Leave Period ISSUE

 
Ask questions
Last Post by babynus 6 years ago
2 Posts
2 Users
0 Reactions
1,566 Views
RSS
 Wx
(@projwx)
Posts: 8
Active Member
Topic starter
 
[#7136]

Hi,

I spend hours prior to contact you but I couldn't figure out what I was doing wrong.
1) I enabled/disabled HR modules.
2) I created leave types in "parameters --> leave period parameters --> type of leave". As I'm french, I created CP, RTT and so on. (picture 1)
3) These leaves are automatically linked with my unique administrative project (picture 2). This Administrative has no "project code" (picture 3)
4) In the "imputation" everything is detected (picture 4).
5) In the "Leave", no type apears (picture 5)
6) In the "calendar" I can't double-click to add leaves (pictures 6)
7) When I add a leave period thanks to HR module, it works and incremented the imputation
8) In the board I have an error (picture 7)
9) Log :
2020-12-29 17:54:46.353 ===== TRACE ===== NEW CONNECTED USER 'Alexandre'
2020-12-29 18:01:31.281 ** ERROR ** [V8.6.5] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'customearnedrulesofemploymentcontracttype.scope' in 'where clause'
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    For query : select count(*) as cpt from customearnedrulesofemploymentcontracttype where customearnedrulesofemploymentcontracttype.idLeaveType= '11' and customearnedrulesofemploymentcontracttype.scope= 'CustomEarnedRulesOfEmploymentContract'
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    Strack trace :
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    #0 Sql->query called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:2775]
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    #1 SqlElement->countSqlElementsFromCriteria called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:5030]
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    #2 SqlElement->deleteControl called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:1859]
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    #3 SqlElement->deleteSqlElement called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:989]
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    #4 SqlElement->delete called at [/share/CACHEDEV1_DATA/Web/Reporting/model/LeaveTypeMain.php:537]
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    #5 LeaveTypeMain->delete called at [/share/CACHEDEV1_DATA/Web/Reporting/tool/deleteObject.php:65]
2020-12-29 18:01:31.283 ** ERROR ** [V8.6.5] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'leavetypeofemploymentcontracttype.scope' in 'where clause'
2020-12-29 18:01:31.283 ** ERROR ** [V8.6.5]    For query : select count(*) as cpt from leavetypeofemploymentcontracttype where leavetypeofemploymentcontracttype.idLeaveType= '11' and leavetypeofemploymentcontracttype.scope= 'LeaveTypeOfEmploymentContract'
2020-12-29 18:01:31.283 ** ERROR ** [V8.6.5]    Strack trace :
2020-12-29 18:01:31.284 ** ERROR ** [V8.6.5]    #0 Sql->query called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:2775]
2020-12-29 18:01:31.284 ** ERROR ** [V8.6.5]    #1 SqlElement->countSqlElementsFromCriteria called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:5030]
2020-12-29 18:01:31.284 ** ERROR ** [V8.6.5]    #2 SqlElement->deleteControl called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:1859]
2020-12-29 18:01:31.284 ** ERROR ** [V8.6.5]    #3 SqlElement->deleteSqlElement called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:989]
2020-12-29 18:01:31.284 ** ERROR ** [V8.6.5]    #4 SqlElement->delete called at [/share/CACHEDEV1_DATA/Web/Reporting/model/LeaveTypeMain.php:537]
2020-12-29 18:01:31.284 ** ERROR ** [V8.6.5]    #5 LeaveTypeMain->delete called at [/share/CACHEDEV1_DATA/Web/Reporting/tool/deleteObject.php:65]
2020-12-29 18:16:20.885 ===== TRACE ===== DISCONNECTED USER 'Alexandre'
2020-12-29 18:16:27.331 ===== TRACE ===== NEW CONNECTED USER 'Alexandre'
2020-12-29 18:41:00.808 ** ERROR ** [V8.6.5] ERROR **
2020-12-29 18:41:00.808 ** ERROR ** [V8.6.5] on file '/share/CACHEDEV1_DATA/Web/Reporting/view/dashboardEmployeeManager.php' at line (614)
2020-12-29 18:41:00.808 ** ERROR ** [V8.6.5] cause = Undefined offset: 1
2020-12-29 18:41:08.391 ** ERROR ** [V8.6.5] ERROR **
2020-12-29 18:41:08.392 ** ERROR ** [V8.6.5] on file '/share/CACHEDEV1_DATA/Web/Reporting/view/dashboardEmployeeManager.php' at line (614)
2020-12-29 18:41:08.392 ** ERROR ** [V8.6.5] cause = Undefined offset: 1

10) I read a lot concerning LEAVESYST and IsLeaveMngProject. Database screenshot in picture 8. The Administrative project has IsLeaveMngProject set to 1.

Need HELP 😉
Many thnaksHi,

I spend hours prior to contact you but I couldn't figure out what I was doing wrong.
1) I enabled/disabled HR modules.
2) I created leave types in "parameters --> leave period parameters --> type of leave". As I'm french, I created CP, RTT and so on. (picture 1)
3) These leaves are automatically linked with my unique administrative project (picture 2). This Administrative has no "project code" (picture 3)
4) In the "imputation" everything is detected (picture 4).
5) In the "Leave", no type apears (picture 5)
6) In the "calendar" I can't double-click to add leaves (pictures 6)
7) When I add a leave period thanks to HR module, it works and incremented the imputation
8) In the board I have an error (picture 7)
9) Log :
2020-12-29 17:54:46.353 ===== TRACE ===== NEW CONNECTED USER 'Alexandre'
2020-12-29 18:01:31.281 ** ERROR ** [V8.6.5] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'customearnedrulesofemploymentcontracttype.scope' in 'where clause'
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    For query : select count(*) as cpt from customearnedrulesofemploymentcontracttype where customearnedrulesofemploymentcontracttype.idLeaveType= '11' and customearnedrulesofemploymentcontracttype.scope= 'CustomEarnedRulesOfEmploymentContract'
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    Strack trace :
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    #0 Sql->query called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:2775]
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    #1 SqlElement->countSqlElementsFromCriteria called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:5030]
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    #2 SqlElement->deleteControl called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:1859]
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    #3 SqlElement->deleteSqlElement called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:989]
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    #4 SqlElement->delete called at [/share/CACHEDEV1_DATA/Web/Reporting/model/LeaveTypeMain.php:537]
2020-12-29 18:01:31.282 ** ERROR ** [V8.6.5]    #5 LeaveTypeMain->delete called at [/share/CACHEDEV1_DATA/Web/Reporting/tool/deleteObject.php:65]
2020-12-29 18:01:31.283 ** ERROR ** [V8.6.5] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'leavetypeofemploymentcontracttype.scope' in 'where clause'
2020-12-29 18:01:31.283 ** ERROR ** [V8.6.5]    For query : select count(*) as cpt from leavetypeofemploymentcontracttype where leavetypeofemploymentcontracttype.idLeaveType= '11' and leavetypeofemploymentcontracttype.scope= 'LeaveTypeOfEmploymentContract'
2020-12-29 18:01:31.283 ** ERROR ** [V8.6.5]    Strack trace :
2020-12-29 18:01:31.284 ** ERROR ** [V8.6.5]    #0 Sql->query called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:2775]
2020-12-29 18:01:31.284 ** ERROR ** [V8.6.5]    #1 SqlElement->countSqlElementsFromCriteria called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:5030]
2020-12-29 18:01:31.284 ** ERROR ** [V8.6.5]    #2 SqlElement->deleteControl called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:1859]
2020-12-29 18:01:31.284 ** ERROR ** [V8.6.5]    #3 SqlElement->deleteSqlElement called at [/share/CACHEDEV1_DATA/Web/Reporting/model/persistence/SqlElement.php:989]
2020-12-29 18:01:31.284 ** ERROR ** [V8.6.5]    #4 SqlElement->delete called at [/share/CACHEDEV1_DATA/Web/Reporting/model/LeaveTypeMain.php:537]
2020-12-29 18:01:31.284 ** ERROR ** [V8.6.5]    #5 LeaveTypeMain->delete called at [/share/CACHEDEV1_DATA/Web/Reporting/tool/deleteObject.php:65]
2020-12-29 18:16:20.885 ===== TRACE ===== DISCONNECTED USER 'Alexandre'
2020-12-29 18:16:27.331 ===== TRACE ===== NEW CONNECTED USER 'Alexandre'
2020-12-29 18:41:00.808 ** ERROR ** [V8.6.5] ERROR **
2020-12-29 18:41:00.808 ** ERROR ** [V8.6.5] on file '/share/CACHEDEV1_DATA/Web/Reporting/view/dashboardEmployeeManager.php' at line (614)
2020-12-29 18:41:00.808 ** ERROR ** [V8.6.5] cause = Undefined offset: 1
2020-12-29 18:41:08.391 ** ERROR ** [V8.6.5] ERROR **
2020-12-29 18:41:08.392 ** ERROR ** [V8.6.5] on file '/share/CACHEDEV1_DATA/Web/Reporting/view/dashboardEmployeeManager.php' at line (614)
2020-12-29 18:41:08.392 ** ERROR ** [V8.6.5] cause = Undefined offset: 1

10) I read a lot concerning LEAVESYST and IsLeaveMngProject. Database screenshot in picture 8. The Administrative project has IsLeaveMngProject set to 1.

Need HELP 😉
Many thnaks

  

 


 
Posted : 29 Dec 2020 20H52
 babynus
(@babynus)
Posts: 14952
Member Admin
 

Issue recorded as tickets #5149


 
Posted : 04 Jan 2021 10H57
Forum Jump:
  Previous Topic
Next Topic  
Share:

Scroll to Top