| Subject: | Timesheet import executing processes ESS021, ESS022 & ESS023 |
| Summary: | Timesheet import executing processes ESS021, ESS022 & ESS023 When processes ESS021, ESS022 or ESS023 has failed to execute because either of the processes was still executing, the process completes with success and changes the next run date. Change the process so that it fails to execute and log the reason so that it can re-attempt to run in 10 minutes. |
| Audit Notes: | Edited by alvis on 30/10/19 15:26. Edited by alvis on 30/10/19 15:25. Edited by alvis on 09/10/19 10:19. Edited by alvis on 08/10/19 13:12. |
| 03 Oct 2019 | 01:16PM Comment 1 by Alvis (Link Technologies) Case 11781 added to project 10.153 |
| 03 Oct 2019 | 01:19PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 03-10-2019 01:19 PM Time Taken: 1.00 |
| Development work for this case has been completed. The change will be available in version:10.153 and 11.004 1. The following changes were made(Include Database object names, Program classes and any other relevant information): - Changed processes ESS021, ESS022, and ESS023 to raise an error and fail when either of the processes is still executing. The processes framework will log the reason for failure and re-attempt in 10 minutes.
2. Affected Areas: - Processes ESS021, ESS022, and ESS023
3. The issue was caused by: - Improvement
4. Notes:
5. Next Step: UAT |
|
| 08 Oct 2019 | 01:12PM Comment 3 by Alvis (Link Technologies) Case 11781 removed from project 10.153 |
| 08 Oct 2019 | 01:12PM Comment 4 by Sanjay (Link Technologies) Case 11781 added to project 10.153 |
| 09 Oct 2019 | 09:26AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 11-10-2019 09:26 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 | No | Test Description | Pass/Fail | | 1 | Execute process ESS021 and ESS022 at the same time at 9/10/2019 at 8.00am. This should fail, as only one process should execute at a single time | Pass | | 2 | The event log should be updated with the above failure and state that ESS021, ESS022 and ESS23 can not run at the same time | Pass | | 3 | Now set the run time as below - ESS021 - 9/10/2019 at 8.00am
- ESS023 - 9/10/2019 at 10.00am
Process ESS021 should excute at 8am. ESS023 should run at 10.00am | Fails Both processes fail to execute. |
Environment Details - OS version: Windows Server 2012
- Application version: 10.153
- Setup: Demo
- Server : 10.0.0.14
- Database: LINKSOFT-DEMO-10-RASHNA
Next Step: - Review
|
|
| 09 Oct 2019 | 10:23AM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 11-10-2019 10:23 AM Time Taken: 2.00 |
| Development work for this case has been completed. The change will be available in version:11.004 1. The following changes were made(Include Database object names, Program classes and any other relevant information): - Added additional checks to verify process status. If the status is "executing" then the process will fail and log the error.
2. Affected Areas: - Processes ESS021, ESS022, and ESS023
3. The issue was caused by: - The SQL agent is executing every 10 seconds, however, the process is not executed until the next run date.
4. Notes:
5. Next Step: UAT |
|
| 09 Oct 2019 | 02:43PM Comment 7 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 11-10-2019 02:43 PM |
| Proceed with UAT |
|
| 09 Oct 2019 | 03:41PM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 11-10-2019 03:41 PM Time Taken: 1.00 |
| Table 1 - Summarised list of issues | No | Test Description | Pass/Fail | | 1 | Execute process ESS021 and ESS022 at the same time at 9/10/2019 at 8.00am. This should fail, as only one process should execute at a single time | Pass | | 2 | The event log should be updated with the above failure and state that ESS021, ESS022 and ESS23 can not run at the same time | Pass | | 3 | The process should pick the failed process ESS022 and execute it again | Pass | | 4 | Now set the run time as below - ESS021 - 9/10/2019 at 8.00am
- ESS023 - 9/10/2019 at 10.00am
Process ESS021 should excute at 8am. ESS023 should run at 10.00am | Pass. |
Environment Details - OS version: Windows Server 2012
- Application version: 10.153
- Setup: Demo
- Server : 10.0.0.14
- Database: LINKSOFT-DEMO-10-RASHNA
Next Step: - Review
|
|