Company: Link Technologies
Case No: L12103. Project: 12.30: LinkSOFT Version 12.30
Logged By: Sanjay (Link Technologies) on 11 Dec 2020 09:51AM
Priority: High
Product: Framework
Group: Enhancement
Time Taken: 19.00 (Weight: 19.00)
Version: 12.30
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Friday, 18 December 2020 11:59 PM [1224 days since logged date]
Status: Closed
Subject: Improve performance of Processes configured in "Company Administration ~> Processes"
Summary:    

Performance monitoring on Processes hows that the processing power used to implement processes.

Proposed design:

  1. Consolidate jobs so there are fewer calls to the database
  2. We should not touch processes that are not due to run based on the next run date
  3. Cleanup the "Company Administration ~> Process" form
    1. Place Template description and Process code in the Details field
    2. Add Process Group to consolidate jobs
    3. Default sort should be:  Module "SYS", followed by other modules
Audit Notes:Edited by sanjay on 14/12/20 08:04. Edited by sanjay on 11/12/20 09:51. Edited by sanjay on 11/12/20 08:57. 
11 Dec 202009:16AM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 11-12-2020 12:57 PM Time Taken: 1.00

Proposed Design

  1. Create a single group for processes so that we minimise the number of DB Calls
  2. On each process, we add the duration of the last run. Users can use this to determine if processes should be seperated
  3. The group name will be editble

11 Dec 202001:42PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 11-12-2020 03:59 PM Time Taken: 16.00

PART A - Development work for this case has been completed.

1. The change will be available in version:12.30.1211

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

  1. Add a new field named: ProcessGroup to "Company Administration ~> Processes"
  2. Process Groups allows processes to be grouped together. Having multiple process groups allows users to control how many parallel processes can run. Keep in mind that this will also add a processing load to your system.
  3. LinkSOFT by default will have "Process Group" as Blank, therefore all processes will run under a single SQL Agent Job in a single thread
  4. When a user enters a value in "Process Group", the LinkSOFT system will create a separate agent job using the "Process Group" Name.
  5. Replication processes will have a separate "SQL Agent Job" with the name "Replication" at the end.
  6. SQL Agent jobs will be added and deleted based on "Process Group" names
  7. Process group names are not affected by the "Windows Process Service" as the Process service is single-threaded.
  8. During the upgrade, all jobs will be deleted and a single job created named Link Technologies - {DatabaseName} - LinkADMIN

3. Affected Areas:

  1. "Company Administration ~> Processes"

4. The issue was caused by:

  1. Performance Improvement

5. Notes: Users should create a separate "Process Group" for processes that consistently take more than 5 seconds.
6. Next Step
: UAT

----------------------

PART B - Development Reference:

1. Changes implemented was according to the approved design (Y/N): Yes

2. Variations to the approved design: Added column to show how long the last execution took, so users can create a separate group is a process that takes too long or for Urgent Processes, such as Replication.


14 Dec 202008:04AM Comment 3 by Sanjay (Link Technologies) ETC was changed from 18/12/2020 to 18/12/2020
23 Dec 202004:13PM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 23-12-2020 08:04 PM Time Taken: 1.00
System test and documentation has been completed.

29 Dec 202002:37PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 29-12-2020 05:41 PM 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
  1. Add a new field named: ProcessGroup to "Company Administration ~> Processes"
  2. Users should be able to "Add, Edit" and "Delete" process group name
Pass
2
  1. When a user enters a value in "Process Group", the LinkSOFT system will create a separate agent job using the "Process Group" Name.

Update the "Process Group" as "Helpdesk Processes" for process HEL003

Pass
3
  1. Replication processes will have a separate "SQL Agent Job" with the name "Replication" at the end.
  • Enable process POS008
  • Validate that a job is created as "Link Technologies - LINKSOFT-DEMO-123 - LinkReplication".  
Pass
4
  1. SQL Agent jobs will be added and deleted based on "Process Group" names
  • Update the "Process Group" name for HEL003 from "Helpdesk Processes" to "HEL" this should update the SQL job name.
  • Remove the "Process Group" name from process HEL003. This should delete the process from SQL jobs 
Pass
5
  1. During the upgrade, all jobs will be deleted and a single job created named Link Technologies - {DatabaseName} - LinkADMIN
  • Upgrade LinkSOFT-DEMO-1222 database to version 12.3.
  • Validate all process with name LINKSOFT-DEMO-1222 has been removed.
  • Validate that a new process is created as "Link Technologies - LINKSOFT-DEMO-1222 - LinkAdmin" 
Pass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 12.30.1224BETA
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-123

Next Step

  1. For Closure

    04 Jan 202103:24PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 04-01-2021 07:24 PM
    Thanks Rashna 

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

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