Company: Link Technologies
Case No: L11713. Project: 10.10: LinkSOFT Version 10.1
Logged By: Alvis (Link Technologies) on 10 Sep 2019 08:32AM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 5.00 (Weight: 5.00)
Version: 10.155.0117
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Irfaz Ahmad, Rashna, Sanjay
Resolve By: Friday, 06 September 2019 12:00 AM [1689 days since logged date]
Status: Closed
Subject: BIOMETRIC entries are marked as failed on Timesheet Log
Summary:    

Bula Team,

NEWWORLD has a scenario whereby the Timesheet Log process for 8:00am had failed yesterday (04/09/2019) and even today (05/09/2019), Time Entries are sitting as 'Failed'. Upon checking the event log the below message was displayed for the reason for failure

ID

EntryDate

WhoEntered

Module

LogMessage

Status

Resolution

ResolutionDate

Machine

LogData

T1

T2

T3

N1

N2

N3

CFD

EmailNotificationID

26724004

2019-09-02 08:14:08.000

NT AUTHORITY\SYSTEM

LBO

Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

ERROR

NULL

NULL

BIOMETRIC01

NULL

LT_ESS_TimesheetImportLog_PROCESS

NULL

NULL

NULL

NULL

NULL

T1=Procedure

1

 

NEWWORLD is currently on version 10.1.4.8.

To resolve this issue our team had advised the client to delete the failed batch for reprocessing however, as soon as the batch for 315 entries was deleted it marked all the entries in the TNA Database as unprocessed. (150,000)

Kindly requesting if you could review this in version 10.150 

Copy of the DB has been uploaded to the FTP site. (NEWWORLD_LINKSOFT_11250 and NEWWORLD_TNA_11250) 

Kind Regards
Irfaz Ahmad

Audit Notes:Edited by alvis on 10/09/19 08:32. Edited by alvis on 06/09/19 15:22. Edited by alvis on 06/09/19 15:17. 
06 Sep 201908:05AM Comment 1 by Sanjay (Link Technologies) Assigned To: Irfaz Ahmad Followup Date: 06-09-2019 08:05 AM

Hi Ifraz,

I cannot find the backups on FTP.

regards
Alvis


06 Sep 201911:41AM Comment 2 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 06-09-2019 11:41 AM
I found the backups. It was moved by Rashna to another folder.

06 Sep 201903:17PM Comment 3 by Alvis (Link Technologies) Case 11713 added to project 10.150
06 Sep 201903:21PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 06-09-2019 03:21 PM Time Taken: 4.00

Development work for this case has been completed.

The change will be available in version:10.150 & 11.003

1. The following changes were made(Include Database object names, Program classes and any other relevant information):

  1. Changed process ESS021, ESS022 & ESS023 to verify if either of the processes is running before executing the process.
  2. Corrected "Timesheet log delete" process to correctly mark the entries as unprocessed in the TNA database.

2. Affected Areas:

  1. Timesheet Import ~> Timesheet Log. Import timesheet from TNA database, then delete the entries imported. This should mark the entries that were imported as unprocessed.

3. Notes: 

With the setup for Time and Attendance, I have found the following issues:

  1. There are about 135,000 entries in the staging table which causes the computations to take a long time to complete. To resolve this do the following:
    1. Mark the entries in "Timesheet" menu as completed OR
    2. Enable process ESS023 - Automatically archive timesheet entries. Recommend to have the archive days as 30.
  2. Process ESS021 - Timesheet Import Process is scheduled to run every hour. Running this process every hour would make the "Timesheet" menu unusable as the system would be rebuilding the timesheet values every hour. Recommend to run this once at 7 am.
  3. Process ESS022 - Timesheet Import Manual Compute is scheduled to run every day at 8 am. This process is used to compute timesheet values when the control values have changed such as editing shift time start, end, etc. The frequency of this process should be changed to "Manual" and should be used only to manually recompute entries.

The DeadLock error is caused when both process ESS021 and ESS022 runs at the same time. We have added checks in version 10.150 to prevent executing when either of the processes is executing.

4. Next Step: UAT



06 Sep 201907:46PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 09-09-2019 12:00 AM Time Taken: 1.00
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1

Update client database to version 10150.

  1. Archive TNA data over 30 days
Pass. This process ran for 40 minutes.
2

Import the data from TNA database. 

  1. Data  import should not fail.
  2. Process ESS02 should be executed without errors. 
Pass.  This process ran for 15 minutes.

Note

The backup provided only had 15 unprocessed entries hence UAT is limited to this. 

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 10.150
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: CLIENT-NEWWORLD-TNA  and CLIENT-NEWWORLD-LINKSOFT

Next Step: 

  1. Closure

    07 Sep 201902:29PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 07-09-2019 02:29 PM
    Thanks Rashna

    10 Sep 201908:32AM Comment 7 by Alvis (Link Technologies) Case 11713 removed from project 10.150
    10 Sep 201908:32AM Comment 8 by Sanjay (Link Technologies) Case 11713 added to project 10.150
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L11713 in the subject line of all emails regarding this issue.

    Document size: 19.7 KB
    For call complaints, please contact the Managing Director of the company using this form.