Company: Link Technologies
Case No: L11781. Project: 10.10: LinkSOFT Version 10.1
Logged By: Alvis (Link Technologies) on 08 Oct 2019 01:12PM
Priority: Low
Product: Payroll & HR
Group: Enhancement
Time Taken: 5.00 (Weight: 5.00)
Version: 10.155.0117
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Thursday, 03 October 2019 12:00 AM [1653 days since logged date]
Status: Closed
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 201901:16PM Comment 1 by Alvis (Link Technologies) Case 11781 added to project 10.153
03 Oct 201901: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):

  1. 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:

  1. Processes ESS021, ESS022, and ESS023

3. The issue was caused by:

  1. Improvement

4. Notes
5. Next Step
: UAT


08 Oct 201901:12PM Comment 3 by Alvis (Link Technologies) Case 11781 removed from project 10.153
08 Oct 201901:12PM Comment 4 by Sanjay (Link Technologies) Case 11781 added to project 10.153
09 Oct 201909: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
NoTest DescriptionPass/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
2The event log should be updated with the above failure and state that ESS021, ESS022 and ESS23 can not run at the same timePass
3

Now set the run time as below

  1. ESS021 - 9/10/2019 at 8.00am
  2. 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

  1. OS version: Windows Server 2012
  2. Application version: 10.153
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-10-RASHNA

Next Step

  1. Review

    09 Oct 201910: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):

    1. Added additional checks to verify process status. If the status is "executing" then the process will fail and log the error.

    2. Affected Areas:

    1. Processes ESS021, ESS022, and ESS023

    3. The issue was caused by:

    1. 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 201902: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 201903: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

    Test Results Summary

    Table 1 - Summarised list of issues
    NoTest DescriptionPass/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
    2The event log should be updated with the above failure and state that ESS021, ESS022 and ESS23 can not run at the same timePass
    3The process should pick the failed process ESS022 and execute it againPass
    4

    Now set the run time as below

    1. ESS021 - 9/10/2019 at 8.00am
    2. ESS023 - 9/10/2019 at 10.00am

    Process ESS021 should excute at 8am. ESS023 should run at 10.00am

    Pass.


    Environment Details

    1. OS version: Windows Server 2012
    2. Application version: 10.153
    3. Setup: Demo
    4. Server : 10.0.0.14
    5. Database: LINKSOFT-DEMO-10-RASHNA

    Next Step

    1. Review

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

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