Subject: | Unable to generate the "Roster Schedule Report" in PAFCO database |
Summary: | Issue: Unable to generate the "Roster Schedule Report" in PAFCO database Error: Error in database vendor code. |
Audit Notes: | Edited by sanjay on 05/03/19 09:13. |
05 Nov 2018 | 01:42PM Comment 1 by Rashna (Edge Business Solutions) Case 9691 added to project 10.1 |
05 Nov 2018 | 04:56PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 05-11-2018 04:56 PM Time Taken: 1.00 |
| Development work for this case has been completed. The change will be available in version: 10.1.1.2 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Changed report extraction procedure to handle employees having 0 hours per pay.
|
|
06 Nov 2018 | 07:49AM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 06-11-2018 07:49 AM Time Taken: 2.00 |
| Hi Alvis, QA Results Tests carried out according to requirements specified on the case header Test Results Summary Table 1 - Summarised list of issues No | Test Description | Pass/Fail | 1 | Generate the report for company 1001 and roster code LTRS000145 (existing roster in the db) | Failed. When the report is generated with the "Company" and "Schedule" as the filters. The date defaults to the current date and the report does not display any data. Message - No Records to Display | 2 | Create a new schedule with roster code 61. The Roster Schedule Report should display the data. | Pass. Report generated since the date filters were of the current date. |
Environment Details - OS version: Windows Server 2012
- Application version:10.1.1.2
- Setup: Demo
- Server : 10.0.0.10
- Database: CLIENT-PAFCO-LINKSOFT
Steps to reproduce failed scenarios: - Generate the Roster Schedule Report with filters company = 1001 and schedule = LTRS000145
Next Step: for correction. Regards Sanjay and Rashna
|
|
07 Nov 2018 | 11:32AM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 07-11-2018 11:32 AM Time Taken: 4.00 |
| Development work for this case has been completed. The change will be available in version: 10.1.1.3 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Added the following notes on the report:
If the dates are not selected, the current date is used. The default for "week start" is Monday. If the "Date From" and "Date To" spans multiple weeks, the report will display each week as a section in the report. The code above the shift start and end time is the "shift code".
Added * to "Date From" and "Date To" to indicate that date is required. Refactored report extraction procedure to improve performance. Report with a month date range takes approximately 20s to generate.
2. The issue was caused by: - N/A
3. Next Step - UAT
|
|
08 Nov 2018 | 07:46AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 08-11-2018 07:46 AM Time Taken: 1.00 |
| Hi Sanjay QA Results Tests carried out according to requirements specified on the case header Test Results Summary Table 1 - Summarised list of issues No | Test Description | Pass/Fail | 1 | Validate that the report notes is updated | Pass | 2 | Validate that the date filter is marked as required. | Pass | 3 | Generate the Roster Schedule for dates: 01/01/2017 to 31/01/2017 01/01/2017 to 28/01/2017 01/01/2017 to 28/01/2017 The report should be generated in a timely manner. | Pass. 01/01/2017 to 31/01/2017 - Report generated in 12.89 secs. Pages = 123 01/01/2017 to 28/01/2017 - Report generated in 11.47 secs. Pages = 114 01/01/2017 to 28/01/2017 - Report generated in 18.89 secs. Pages = 208
| 4 | Validate that the report is split by week when generated by month. | Pass |
Environment Details - OS version: Windows Serve 2012
- Application version: 10.1.1.3
- Setup: Demo
- Server : 10.0.0.10
- Database: CLIENT-PAFCO-LINKSOFT
Steps to reproduce failed scenarios:
Next Step: for closure
|
|
08 Nov 2018 | 08:48AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 08-11-2018 08:48 AM |
| Thanks Rashna |
|
09 Oct 2019 | 08:14AM Comment 7 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 |