Subject: | User is unable to generate the Time sheet Import Log Report for a week |
Summary: | .Tomasi called and advised that users are unable to generate the Time sheet Import Log Report for a week. Date range - 15/01/2018 to 19/01/2018, report is genearted for all employees. Error : Time Out Version 8.1.8 |
Audit Notes: | |
01 Feb 2018 | 09:10AM Comment 1 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 01-02-2018 09:10 AM Time Taken: 1.00 |
| Hi Alvis, We have tested the case internally. The database has been upgraded to 8.2.9 as restored as CLIENT_LINKSOFT_PAFCO. This is restored on QA4 Error:
|
|
01 Feb 2018 | 09:34AM Comment 2 by Alvis (Link Technologies) Case 9082 added to project 8.3 |
01 Feb 2018 | 09:43AM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 02-02-2018 12:00 AM |
| Hi Alvis,
We have tested the case internally.
The database has been upgraded to 8.2.9 as restored as CLIENT_LINKSOFT_PAFCO. This is restored on QA4 This is an issue with both view Crystal and PDF.
Error:
|
|
05 Feb 2018 | 04:48PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 05-02-2018 04:48 PM Time Taken: 1.00 |
| Hi Rashna, We have refactored the procedure and added some indexes to improve performance. Please UAT in 8.3 regards Alvis |
|
06 Feb 2018 | 11:22AM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 06-02-2018 11:22 AM |
| Hi Rashna, this change is ready for UAT in LinkSOFT Versio 8.3.000 which is on our FTP site at this address: \\10.0.0.9\ftp\LinkSoftware\LinkSOFT\83 |
|
08 Feb 2018 | 11:10AM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 09-02-2018 12:00 AM Time Taken: 1.00 |
| QA Results Step 1 - Developer will perform test based on test cases provided Step 2 - Product expert to complete Product QA based on test cases.
Test cases are provided on the case header before the case is approved for development. Test Results Summary Note: Report has been successfully tested in the demo database. o | Issue Description | PACFO DB | 1 | Generate report for 01/01/2018 to 01/05/2018 for all employees under View Crystal (Absentees filtered) | Untested. Upgrade fails | 2 | Generate report for 01/01/2018 to 01/05/2018 for all employees under View PDF (Absentees filtered) |
| 3 | Generate report for 01/01/2018 to 01/05/2018 for all employees under Crsytal (Absentees filtered) |
| 4 | Generate report for 01/01/2018 to 01/05/2018 for all employees under PDF (Absentees filtered) |
| 5 | Generate report for 01/01/2018 to 31/01/2017 for all employees under PDF (Absentees filtered) . Report filtered by Territory , Grouped By Cost Centre and Employee Status |
| 6 | Generate report for 01/01/2018 to 31/01/2017 for all employees under View Crystal(Absentees filtered) |
| 7 | Generate report for 01/01/2018 to 31/01/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.
|
| 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.
|
| 9 | Generate report for 01/01/2018 to 31/01/2017 for Active and leave employees under PDF (Absentees filtered)
Report filtered by Employee Status as Active and Leave
|
| 10 | Generate report for 01/01/2018 to 31/01/2017 for all employees under View Crystal (Absentees filtered)
|
| 10 | Generate report for 01/01/2017 to 20/01/2018 filtered by Active employees and absent |
|
QA Environment Details - OS version:Windows 7
- Application version: 8300.00DV
- Database (Demo/New/Client): CLIENT_PAFCO_LINKSOFT on QA4
- Client is on QA1.
Steps to reproduce failed scenarios: - Restore PAFCO database
- Upgrade database from Database Utility
- Error. Attached is notepad with full error
Note: Client is 8110, we require an individual script to resolve the case on site.
Figure 1: Upgrade Error
|
|
09 Feb 2018 | 02:31PM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 09-02-2018 02:31 PM Time Taken: 1.00 |
| Hi Rashna, The issue has been resolved in 8.3.1.0 DEV. regards Alvis |
|
13 Feb 2018 | 01:38PM Comment 8 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 13-02-2018 01:38 PM |
| Please proceed with UAT. |
|
15 Feb 2018 | 09:29AM Comment 9 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 16-02-2018 12:00 AM Time Taken: 2.00 |
| o | Issue Description | PACFO DB | 1 | Generate report for 01/01/2018 to 01/05/2018 for all employees under View Crystal (Absentees filtered) | Time Taken - 35.78 seconds, 282 pages. | 2 | Generate report for 01/01/2018 to 01/05/2018 for all employees under View PDF (Absentees filtered) | Failed- Nothing Happens. PDF reports are not generating | 3 | Generate report for 01/01/2018 to 01/05/2018 for all employees under Crystal | Time Taken -15.15 seconds, 27 pages generated | 4 | Generate report for 01/01/2018 to 01/05/2018 for all employees under PDF | PDF reports are not generating
| 5 | Generate report for 01/01/2018 to 31/01/2018 for all employees under PDF
| PDF reports are not generating
| 6 | Generate report for 01/01/2018 to 31/01/2018 for all employees under Crystal
| Time Taken -2:01.39, 250 pages generated. | 7 | Generate the report for 01/01/2018 to 31/01/2018 for all employees under PDF (Absentees filtered). | PDF reports are not generating
| 8 | Generate report for 01/01/2018 to 31/01/2018 for all employees under View Crystal(Absentees filtered) | Time Taken -2:50.14, 1378 pages generated.
| 7 | Generate report for 01/01/2018 to 31/01/2018 for all employees under PDFl(Absentees filtered) Report filtered by Territory, Grouped By Cost Centre, Employee Status and New Page Per Group as yes.
| PDF reports are not generating
| 8 | Generate report for 01/10/2018 to 31/01/2018 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.
| Time Taken -7.38 seconds, 23 pages generated.
| 9 | Generate report for 01/01/2018 to 31/01/2017 for Active and leave employees under PDF (Absentees filtered)
Report filtered by Employee Status as Active and Leave
| PDF reports are not generating
| 10 | Generate report for 01/01/2018 to 28/02/2018 filtered by Active employees and absent | Time Taken -3:20.98 seconds, 250 pages generated.
|
QA Environment Details - OS version:Windows 7
- Application version: 8.3.2.0
- Database (Demo/New/Client): CLIENT_PAFCO_LINKSOFT on QA3
- Client is on QA3
|
|
15 Feb 2018 | 03:33PM Comment 10 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 15-02-2018 03:33 PM |
| View PDF has been logged in case 9109. Please verify in beta3. |
|
16 Feb 2018 | 03:54PM Comment 11 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 16-02-2018 03:54 PM Time Taken: 1.00 |
| System tests completed. Please proceed with UAT. |
|
19 Feb 2018 | 04:10PM Comment 12 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 19-02-2018 04:10 PM Time Taken: 1.00 |
| Hi Alvis I have tested the case, reports are now generated without errors. Also, reports are generated in a timely manner. Refer to Table 1 for details. However, as requested in 6, can we get a patch for the client. The client is on version 8110.
QA Results Step 1 - Developer will perform test based on test cases provided Step 2 - Product expert to complete Product QA based on test cases.
Test cases are provided on the case header before the case is approved for development. Test Results Summary Table 1 - Summarised list of issues Issue Description | PACFO DB | Pass/Fail | 1 | Generate report for 01/01/2018 to 19/02/2018 for all employees under View Crystal (Absentees filtered) | Time Taken 4:55.57, 2327 pages
| 2 | Generate report for 01/01/2018 to 19/02/2018 for all employees under View PDF (Absentees filtered) | Time Taken 5:58.70, 2327 pages | 3 | Generate report for 01/01/2018 to 19/02/2018 for all employees under Crystal | Time Taken 2:18.87, 250 pages generated
| 4 | Generate the report for 01/01/2018 to 19/02/2018 for all employees under PDF | Time Taken 2:17.56, 250 pages generated.
| 5 | Generate the report for 01/01/2018 to 07/01/2018 for all employees under PDF. Data for a week
| Time Taken 0:17.04, 31 pages generated.
| 6 | Generate the report for 01/01/2018 to 07/01/2018 for all employees under Crystal. Data for a week.
| Time Taken 0:14.10, 31 pages generated.
| 7 | Generate the report for 01/01/2018 to 07/01/2018 for all employees under PDF (Absentees filtered). | Time Taken 1:04.47, 375 pages generated.
| 8 | Generate the report for 01/01/2018 to 07/01/2018 for all employees under View Crystal(Absentees filtered) | Time Taken 0:53.59, 375 pages generated.
| 7 | Generate the report for 01/01/2018 to 31/01/2018 for all employees under PDF(Absentees filtered) Report filtered by Territory, Grouped By Cost Centre, Employee Status and New Page Per Group as yes.
| Time Taken 0:12.87, 26 pages generated.
| 8 | Generate the report for 01/10/2018 to 31/01/2018 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.
| Time Taken 0:11.11, 26 pages generated.
| 9 | Generate the report for 01/01/2018 to 31/01/2018 for Active and leave employees under PDF (Absentees filtered)
Report filtered by Employee Status as Active and Leave
| Time Taken 2:18.81, 250 pages generated
|
QA Environment Details - OS version:Windows 7
- Application version:9.2.3.0
- Database (Demo/New/Client): Demo LINKSOFT8935on QA4
- Client on QA1
Steps to reproduce failed scenarios:
|
|
19 Feb 2018 | 04:25PM Comment 13 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 19-02-2018 04:25 PM Time Taken: 1.00 |
| Hi Rashna, We have prepared an update for version 8.290.005. You can download this update from ftp. |
|
20 Feb 2018 | 10:29AM Comment 14 by Rashna (Edge Business Solutions) Assigned To: Fariha Kauser Tafsil (Link Fiji) Followup Date: 20-02-2018 10:29 AM Time Taken: 0.50 |
| Hi Fariha Please test the case with 8.2.9.05. Add a test plan for areas tested. Once the case has been passed, assign the case to Sanjay to review and close. Regards Rashnaa |
|
26 Feb 2018 | 07:45AM Comment 15 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 26-02-2018 12:00 AM Time Taken: 0.25 |
| Bula Vinaka Guys We will upgrade client from 8.11 to 930 once the version has been released as opposed to 8.29. Proceeding to closing this case as comment 12 has the details of test result in version 930. Regards Vineet Ram
|
|
09 Oct 2019 | 08:14AM Comment 16 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 |