Affected Version: BioStar v2.8 or above


Issue Description

The user search in the user group of Time Attendance is not able to search as follows.

[Fig 1- Cannot find the user in selected user group]


Cause

There is no perm_id because the data in the perm_id column in the user table is not synchronized.


Relevant Log Data of BioStar 2 TA server

File Location: YYYY-MM-DD_c#_ta-error.log in C:\Program Files\BioStar 2(x64)\ta\logs


 error: failed to login
{ id: undefined, message: 'perm_id is required.', message_key: 'REQUIRED_FIELD', language: 'en', status_code: 'REQUIRED_FIELD' }
{ id: undefined, message: 'perm_id is required.', message_key: 'REQUIRED_FIELD', language: 'en', status_code: 'REQUIRED_FIELD' }
 

How To Solve

1.  Stop BioStar 2 TA service

2. Run the below query in Heidi SQL or MySQL Workbench

(Maria DB Query)

  1. UPDATE biostar_tna.sync_last_index
    SET last_sync_index = 0
    WHERE table_name like 't_usr';

3. Start BioStar 2 TA Service
4. Wait for about 10 mins until the user information is synchronized to BioStar 2 TA

5. Confirm the issue