Company: Link Technologies
Case No: L12951. Project: 15.00: LinkSOFT Version 15.00
Logged By: Sanjay (Link Technologies) on 21 Sep 2023 02:30PM
Priority: Low
Product: Framework
Group: Enhancement
Time Taken: 18.00 (Weight: 1.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay
Resolve By: Friday, 29 September 2023 04:42 PM [214 days since logged date]
Status: Closed
Subject: SQL Process Scheduler should run the longest waiting job first
Summary:    When the SQL Scheduler picks up jobs to run, we should run the "Oldest Waiting Job" first
Audit Notes:Edited by sanjay on 22/09/23 16:20. Edited by sanjay on 22/09/23 15:07. 
21 Sep 202302:32PM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 29-09-2023 02:30 PM Time Taken: 6.00
PART A - Development work for this case has been completed.

1. The change will be available in version: 15.00

2. The following changes were made(Include Database object names, Program classes, and any other relevant information):

  1. When getting the list of processes to run, we order the list by the "Next Run Date" to get the longest waiting task on the top of the list

3. Affected Areas:

  1. SQL Process Order

4. The issue was caused by:

  1. Improvement

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


22 Sep 202303:35PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 29-09-2023 03:34 PM Time Taken: 6.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Review the list of processes to execute (across Multiple Companies) and ensure that the older process gets the highest priority

Pass

Environment Details

  1. OS version: Win11
  2. Application version: 14.
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


22 Sep 202304:44PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 29-09-2023 04:42 PM Time Taken: 4.00 Notes: ETC extended from: 21/09/2023 to 29/09/2023

** Need to change SQL Process Execute method to ignore "Data Returns" from Processes Scripts. This is causing a "result" error in the logs which is unnecessary.

I have created a new function to Execute SQL Commands. "UtilityDAL.ExecuteSQLCommand" - Testing Required.


26 Sep 202304:44PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-10-2023 04:42 PM Time Taken: 2.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Enable multiple processes in different companies
Each process should run based on the longest waiting one running first
Pass

Environment Details

  1. OS version: Win11
  2. Application version: 15.00
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


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

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