| Subject: | Absent Report takes time to generate |
| Summary: | Hi Sanjay,
Our Client LTA has advised that it takes a lot of time to generate Timesheet Import Log Report, filtered by Absentees. The below standards were needed to generate absent report for western region, but took more than 20 minutes to process yet the report was not generated on site. 
I have the set up in QA2, database is in QA4 - CLIENT-LTA-LINKSOFT, VERSION 8180.00.
Sanjeet and Vineet have reviewed for missing indexes but there are none. Please refer to the following table:
Timesheet Import Log Report Generation | Time Entry Date | Button Selected | Time Taken | 08/08/2017 – 08/08/2017 | View Crystal Report | 20 seconds | 08/08/2017 – 08/08/2017 | View PDF | 28 seconds | 01/10/2016 – 01/10/2017 | View PDF | Report keeps running for more than 2 hours and doesn’t generate anything | 01/10/2016 – 30/09/2017 | View Crystal Report | 30 minutes 26 seconds (Displays error as in Fig 1.0 below) |
Figure 1.0
Please if you could address this case.
Regards,
Fariha
|
| Audit Notes: | |
| 08 Nov 2017 | 08:03AM Comment 1 by Alvis (Link Technologies) Case 8897 added to project 8.19 |
| 08 Nov 2017 | 11:01AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 08-11-2017 11:01 AM Time Taken: 4.00 |
| Hi Fariha, We have redesigned the function that extracts absentees data. It now takes 2min to process 1-year data. Updates are in 8.19 and 8.18.002 (on ftp) regards
Alvis |
|
| 08 Nov 2017 | 02:02PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 09-11-2017 12:00 AM Time Taken: 1.00 |
| Hi Alvis, I tested the case with database CLIENT-LTA-LINKSOFT-8897 on QA4. - Accessed application from QA1.
- Applied updates 8180-LINKSOFT_Upgrade_to_8180.002.zip from ftp.
- Ran the report for 01/10/2016 to 30/10/2017.
- Report Filter - Absentees.
Report under PDF view was not generated, it was running over 15 minutes. Report under view Crystal Report gives below error in the 9th minute. Figure 1: Error 
|
|
| 09 Nov 2017 | 11:46AM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 09-11-2017 11:46 AM |
| Hi Rashna, I was able to generate the report. see screenshot below: 
|
|
| 09 Nov 2017 | 03:40PM Comment 5 by Fariha Kauser Tafsil (Link Fiji) Assigned To: Alvis (Link Technologies) Followup Date: 10-11-2017 12:00 AM Time Taken: 2.00 |
| Hi Alvis,
Further to our skype conversation, I am unable to generate the Timesheet Log Report, filtered by Absentees with the "View PDF" button. The setup is in QA2 and database - CLIENT-LTA-LINKSOFT is in QA4.
Please refer to the following table:
Timesheet Import Log Report Generation | Time Entry Date | Button Selected | Time Taken | 08/08/2017 – 08/08/2017 | View Crystal Report | 2 seconds | 08/08/2017 – 08/08/2017 | View PDF | 5 seconds | 01/10/2016 – 30/10/2017 | View PDF | Report does not generate(refer to figure 1.0) | 01/10/2016 – 30/10/2017 | View Crystal Report | 2 minutes 16 seconds |
Figure 1.0
I have advised client that we will apply a temporary update on site in order to generate the yearly Report with "View Crystal report" and once you have the solution for generating yearly report with "View PDF" button, we can update Client accordingly.
Regards,
Fariha
|
|
| 10 Nov 2017 | 01:25PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 10-11-2017 01:25 PM Time Taken: 2.00 |
| I have extended the javascript timeout to resolve the issue. The update will be available in 819. Regards
Sanjay |
|
| 17 Nov 2017 | 10:00AM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 17-11-2017 10:00 AM Time Taken: 1.00 |
| Tested in QA1 with database LINKSOFT. Version 819.Beta 1 Table 1 - Summarised list of issues | No | Issue Description | Resolved? | | 1 | Generate report for 08/08/2017 to 08/11/2017 for all employees under View Crystal (Absentees filtered) | Passed report generated in 2 minutes and 3 seconds | | 2 | Generate report for 08/08/2017 to 08/08/2017 for all employees under View Crystal (Absentees filtered) | Passed report generated in 10 seconds | | 3 | Generate report for 08/08/2017 to 08/11/2017 for all employees under PDF (Absentees filtered) | Passed report generated in 2 minutes and 40 seconds | | 4 | Generate report for 08/08/2017 to 08/08/2017 for all employees under PDF (Absentees filtered) | Passed report generated in 12 seconds | | 5 | Generate report for 01/10/2016 to 01/10/2017 for all employees under PDF (Absentees filtered) . Report filtered by Territory , Grouped By Cost Centre and Employee Status | Passed report generated in 1 minutes and 28 seconds | | 6 | Generate report for 01/10/2016 to 01/10/2017 for all employees under View Crystal(Absentees filtered) Report filtered by Territory , Grouped By Cost Centre and Employee Status | Passed report generated in 1 minutes and 24 seconds | | 7 | Generate report for 01/10/2016 to 01/10/2017 for all employees under PDFl(Absentees filtered) Report filtered by Territory , Grouped By Cost Centre , Employee Status and New Page Per Group as yes.
| Passed report generated in 2 minutes and 34 seconds
| | 8 | Generate report for 01/10/2016 to 01/10/2017 for all employees under View Crystal (Absentees filtered) Report filtered by Territory , Grouped By Cost Centre , Employee Status and New Page Per Group as yes.
| Passed report generated in 2 minutes and 35 seconds
| | 9 | Generate report for 01/10/2016 to 01/10/2017 for Active and leave employees under PDF (Absentees filtered)
Report filtered by Employee Status as Active and Leave
| Passed report generated in 7 minutes and 01 seconds | | 10 | Generate report for 01/10/2016 to 01/10/2017 for all employees under View Crystal (Absentees filtered)
Report filtered by Employee Status as Active and Leave
| Passed report generated in 4 minutes and 01 seconds |
|
|
| 09 Oct 2019 | 08:14AM Comment 8 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019 |