Company: Link Technologies
Case No: L12139. Project: 12.20: LinkSOFT Version 12.2
Logged By: Sanjeet (Link Business Solutions) on 12 Jan 2021 04:17PM
Priority: High
Product: Payroll & HR
Group: Enhancement
Time Taken: 6.00 (Weight: 6.00)
Version: 12.22.0113
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Irfaz Ahmad, New World, Rashna, Sanjay, Sanjeet
Resolve By: Wednesday, 13 January 2021 11:59 PM [1192 days since logged date]
Status: Closed
Subject: Time Entry Log report takes to long
Summary:    

Hi Team,

Please note that after the upgrade of LINKSOFT Time Entry log report won't generate.

Please assist

Audit Notes:Edited by sanjeet on 14/01/21 10:14. Edited by sanjeet on 13/01/21 15:02. Edited by sanjeet on 13/01/21 14:50. 
12 Jan 202104:14PM Comment 1 by Sanjeet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 12-01-2021 04:11 PM

A copy of the database has been upload on FTP for diagnostic with filename "CLIENT-IGA-LINKSOFT.bak".

Executing the stored procedure via management studio takes 24 minutes to run. Below is the script we tried.

exec "LINKSOFT"."dbo"."LT_ESS_RPT_TimesheetImportLog";1 {ts '2021-01-04 16:13:53'}, {ts '2021-01-10 16:13:53'}, '', '', 'A', '', '', 'vit', '', '', '', '', '', 'admin'

go


13 Jan 202102:13PM Comment 2 by Alvis (Link Technologies) Case L12139 added to project 12.2
13 Jan 202102:18PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 13-01-2021 06:13 PM Time Taken: 4.00

PART A - Development work for this case has been completed.

1. The change will be available in version:12.22.0113 & 12.30

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

  1. Performed performance diagnostics on the client's database
  2. Identified the report extraction was slow due to Territory/Branch/Cost Centre filter changes.
  3. Refactored the report extraction to filter Territory/Branch/Cost Centre on each transactional table used in data extraction

3. Affected Areas:

  1. Timesheet Import Log report - filter using Territory/Branch/Cost Centre 

4. The issue was caused by:

  1. Performance Improvements

5. Notes: 
6. Next Step: UAT

----------------------

PART B - Development Reference:

1. Changes implemented was according to the approved design (Y/N):

2. Variations to the approved design:


13 Jan 202102:50PM Comment 4 by Sanjeet (Link Business Solutions) ETC was changed from 13/01/2021 to 13/01/2021
14 Jan 202110:14AM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 14-01-2021 01:24 PM Time Taken: 2.00

UAT Testing by Sanjay/Alvis

Setup:

  1. Started with a clean Win 2019 environment
  2. Downloaded and installed 12.22.0113 from Link Web site
  3. Restored IGA DB on LinkQA4 and upgraded from 12.22.1216 December build
  4. Upgraded to 12.22.0113
  5. Enabled Process "SYS008" - Database Defragmentation
  6. Generated "TNA Timesheet (Import Log)Report" for 
    1. Date Range: 04/01/2021 to 10/01/2021
    2. Employee Status "Active"
    3. Branch "VIT"

Results:

  1. THe Report took 3 minutes 29 sec to complete
  2. Results verified

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12139 in the subject line of all emails regarding this issue.

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