ProjeQtOr free project management software - HR module - several faults - ProjeQtOr
 

HR module - several faults

More
30 Jun 2020 08:45 - 30 Jun 2020 08:51 #1 by zygglo
I observe many incorrect symptoms and error messages in the HR module.
1. The Leave rights earned list for one of the Leaves types is not presented (the spinning wheel continues to spin).
2. You cannot delete the Leaves period (I modified the Leaves workflow allowing to change the status from submitted to recorded), so I can't delete the dependent Leaves type or Employment contract type as well).
3. Several screen forms are faulty (only one section visible, incorrect arrangement of fields).
4. On the profile of one of the Employees i see thousands of Leaves rights earned records.

I describe only a few of the dozen or so symptoms. HR module seem to be unstable at all.
Today's log attached.

Can you suggest a solution?
Zygmunt
Last edit: 30 Jun 2020 08:51 by zygglo.

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

More
30 Jun 2020 09:45 #2 by babynus
Replied by babynus on topic HR module - several faults
Hi,

Sure HR modules required some improvments.
Your remarks are recorded on ticket #4758.

Babynus
Administrator of ProjeQtOr web site

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

More
30 Jun 2020 21:05 #3 by zygglo
Replied by zygglo on topic HR module - several faults
We spent some hours diagnosing ...
I want to share my thoughts.
1. The "employeeleaveearned" table was filled with records (last id over 340000). As the statuses "is an employee" were deleted in turn for all employees (about 30), the records disappeared. All employees reset - only one record left - for Resource as Leaves Manager.
2. Then we plan to turn on "is an employee" sequentially for Resource. This will result in the appearance of records in the "employeeleaveearned" array, according to the "Employment contract type" and "Leaves types" settings.

We will carefully add more employees watching the increase in records in "employeeleaveearned".
Hints would be very helpful:
a) how to reduce the ID from the current value of 346225 to real (justified by the amount of real data). I'm guessing that the parameter (something like "LastID") is stored in at least one of the arrays.
b) what mechanism (stored procedure?) implements adding records in "employeeleaveearned"?

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

More
01 Jul 2020 09:30 #4 by babynus
Replied by babynus on topic HR module - several faults
Hi,

a) how to reduce the ID from the current value of 346225 to real (justified by the amount of real data). I'm guessing that the parameter (something like "LastID") is stored in at least one of the arrays.

This is managed by the DB.
MySql :
ALTER TABLE employeeleaveearned AUTO_INCREMENT = 1;
PostgreSql
ALTER SEQUENCE employeeleaveearned_id_seq START WITH 1;

b) what mechanism (stored procedure?) implements adding records in "employeeleaveearned"?

There is no stored procedure.
All is done through PHP.
Have a look at object "Resource", method save(), when isEmployee is checked, some specific function may be called.

Babynus
Administrator of ProjeQtOr web site

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

Moderators: babynusprotion
Time to create page: 0.047 seconds