Company: Link Technologies
Case No: L12859. Project: 14.60: LinkSOFT Version 14.60 - April 2023
Logged By: Sanjay (Link Technologies) on 09 Mar 2023 05:35PM
Priority: Low
Product: Framework
Group: Software Defect
Time Taken: 25.00 (Weight: 14.00)
Assigned To: Development
Circulation: Development, Sanjay
Resolve By: Wednesday, 22 March 2023 12:10 PM [406 days since logged date]
Status: Closed
Subject: Status of Processes in "Company Maintenance" and "Process Maintenance" in "Global Administration" does not correctly reflect if the system is using SQLAgent or LinkProcessService
Summary:    

Menu: Global Administration ~> Process Setup

This menu shows the status of the scheduler. We need to make the status clear so that users can understand what the scheduler is doing. Recommend the following:

  1. When the scheduler is DISABLED, the status should read "Not Active"
  2. If the Process SOurce is Invalid or Blank, we need a schedule restart. Change the status to "Check Scheduler"
  3. If the current time is before the "start time", status should read: "Waiting for start time"
  4. If the current time is AFTER the "END Time"  status should read: "Waiting for next start time"
  5. If the "last run time"  is within the Frequency, the status should be marked as "Running"
  6. If the "last run time" has past and is outside the Frequency (+ a small buffer), the status should be marked as "Check Scheduler" as this can mean the Scheduler has stopped and requires a restart.

Menu: Company Administration ~> Processes

This menu shows the status of each process. We need to make the status clear so that users can understand what the process is doing. Recommend the following:

  1. When the process is DISABLED, the status should read "Not Active"
  2. If the SQL Agent is running, we get the status  of the Agent and show the user
  3. If the Process has past its "Next Run Time", we mark the process as "Process Not Running". In this case, the scheduler needs to be reviewed.
Audit Notes:Edited by sanjay on 17/03/23 10:10. Edited by sanjay on 09/03/23 17:35. 
17 Mar 202310:12AM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 22-03-2023 12:10 PM Time Taken: 19.00 Notes: ETC extended from: 31/03/2023 to 22/03/2023
PART A - Development work for this case has been completed.

1. The change will be available in version:14.70

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

  1. Added changes to "Global Administration ~> Proces Setup" as defined in the case header
  2. Added changes to "Company Administration ~ >Processes" as defined in the case header

3. Affected Areas:

  1. Scheduler and Processes

4. The issue was caused by:

  1. Improvement

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


21 Mar 202302:25PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-03-2023 04:13 PM Time Taken: 6.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Turn off all Schedulers and Reset All Processes and recycle the App Pool
Process Scheduler should not have a "Source" and all should show as "Check Schedule"
Pass

2Enable Email Scheduler. Turn on "Windows Service"
Email Scheduler should be allocated the Process Service and start running
Pass

3Enable SQL Agent Schedule
The SQL Scheduler should not be allocated a Process Source until a scheduler is restarted
Pass

4Restart  Windows Service
SQL Scheduler should take control of the SQL Processes
Pass

5Stop all schedulers
The Process Setup should show "Check Scheduler"
Pass

Environment Details

  1. OS version: Win11
  2. Application version: 14.60
  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: L12859 in the subject line of all emails regarding this issue.

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