Company: Link Technologies
Case No: L11727. Project: 11.40: LinkSOFT Version 11.4
Logged By: Sanjay (Link Technologies) on 15 Oct 2019 08:31AM
Priority: High
Product: Framework
Group: Enhancement
Time Taken: 52.00 (Weight: 54.00)
Version: 11.4.0302
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Wednesday, 30 October 2019 05:01 PM [1652 days since logged date]
Status: Closed
Subject: Add Health Check functionality to allow the system to automatically verify system Status
Summary:    

Functionality needs to be added whereby the system is able to monitor and inform the user of the system status.

PART A - The following functionality is required:

  1. Add a new form in Company Administration called "Health Check"
  2. A background process running every 10 Minutes will perform checks and Insert/Update data in this form
  3. Users will be able to edit the entry and put notes, and mark the entry as Resolved
  4. If the entry is created and there has not been any user intervention, and the issue has been corrected, the entry should be marked as "Resolved" automatically
  5. Order by Date Created with "Resolved" items at the bottom of the list
  6. Date range filter on the top of the form will show all "UnReosolved" entries and Resolved entries within the specified date range.
  7. When the system log is sent out at the end of the day, the Health Check entries that are UNRESOLVED needs to be included on the top. Resolved entries that have not been sent previously can be included at the bottom.

Part B - The following checks needs to be performed for System Health Checks

  1. Recruitment - Applicants have created an application but not submitted the application in > N (default 5) days
  2. Employee Profile - Employee is active and has missing Information, such as Par Rate, Position etc
  3. Employee Profile - Pay team access has not been given to anyone
  4. Employee Profile - Employee has no leave allocations
  5. Employee Profile - Employee has no Standard Pay Entries
  6. Leave Management - Calander for a past month is OPEN after N (default 15) days
  7. Leave Management - Leave approvals have not been attended to in N (default 10) days
  8. Time and Attendance - Times entries for previous days have not been submitted in N (default 10) days
  9. Payroll Processing - ATO Single touch has not completed in N (default 2) days
  10. Payroll Processing - FMIS Integration Failure not resolved in N (default 2) days
  11. HRM Maintenance - Edit Questions have not been completed in N (Default 5) days
  12. Performance Appraisal - Outstanding Performance Measures not updated in N days (Default 10)
  13. Inventory - List of Items that do not have a Price Setup
  14. Inventory - GL Valuation Failed
  15. Point of Sales - Interaction Queue Failure not resolved in N days (default 2)
  16. Replication - Queue failures or Errors in the queue not resolved in N days (1)
  17. Replication - Compare Data has Failed Records
  18. Financials Portal - Approvals (for Request, Purchase etc) not actioned in N days (Default 5)
  19. Asset management - Assets for a previous month not depreciated in N days (default 10)
  20. Helpdesk - Calls not updates in N days (default 5)
  21. Helpdesk Survey - Organisation has calls, however, there are no surveys in the last N days (30)
  22. Helpdesk Survey - Organisation has a Score below N (Default 5). If zero, so not include (make this a rule)
  23. Business intelligence - Email queue failure
  24. Business intelligence - A large number of email is in the queue (> 100 Pending)
  25. Integration - Integration failure not resolved in N days (default 1)
  26. Company Administration - No organizations setup
  27. Company Administration - Processes failure
  28. Company Administration - Important processes that sould be enabled
  29. Global Administration - Company or Currency not setup
  30. Global Administration - User has failed password attempts > N (default 1)
  31. Global Administration - Licence will expire in N days (30 +)
  32. Global Administration - Database Backup Failures
  33. Global Administration - Database Storage Disk Space usage - When Less than 20% free should be flagged
  34. Global Administration - Backups have not performed in more than 24 hours
Audit Notes:Edited by sanjay on 30/10/19 15:38. Edited by sanjay on 30/10/19 13:32. Edited by sanjay on 29/10/19 16:52. Edited by alvis on 29/10/19 13:05. Edited by sanjay on 15/10/19 08:31. Edited by sanjay on 09/10/19 16:47. Edited by alvis on 19/09/19 14:33. Edited by sanjay on 13/09/19 08:16. 
13 Sep 201907:45AM Comment 1 by Sanjay (Link Technologies) Case 11727 added to project 11.00.BETA
13 Sep 201908:19AM Comment 2 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 13-09-2019 08:19 AM Time Taken: 16.00

The following tasks have been completed:

  1. New "Health Check" form created in "Company Administration" with Date Range filter
  2. Added basic rules to Health Check
  3. Added ability to Resolve cases and add notes
  4. Added Health Check results into Daily Log Notification

Next step - Implement Remaining workflow and Rules explained in Part A and B. 


19 Sep 201902:33PM Comment 3 by Alvis (Link Technologies) Case 11727 added to project 11.004.BETA
03 Oct 201903:53PM Comment 4 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 03-10-2019 03:53 PM Time Taken: 16.00

Completed system health check for the following:

  1. Recruitment - Applicants have created an application but not submitted the application in > N (default 5) days
  2. Employee Profile - Employee is active and has missing Information, such as Par Rate, Position etc
  3. Employee Profile - Pay team access has not been given to anyone
  4. Employee Profile - Employee has no leave allocations
  5. Employee Profile - Employee has no Standard Pay Entries
  6. Leave Management - Calander for a past month is OPEN after N (default 15) days
  7. Leave Management - Leave approvals have not been attended to in N (default 10) days
  8. Time and Attendance - Times entries for previous days have not been submitted in N (default 10) days
  9. Payroll Processing - ATO Single touch has not completed in N (default 2) days
  10. Payroll Processing - FMIS Integration Failure not resolved in N (default 2) days
  11. HRM Maintenance - Edit Questions have not been completed in N (Default 5) days
  12. Performance Appraisal - Outstanding Performance Measures not updated in N days (Default 10)
  13. Inventory - List of Items that do not have a Price Setup
  14. Inventory - GL Valuation Failed
  15. Point of Sales - Interaction Queue Failure not resolved in N days (default 2)
  16. Replication - Queue failures or Errors in the queue not resolved in N days (1)
  17. Replication - Compare Data has Failed Records
  18. Financials Portal - Approvals (for Request, Purchase etc) not actioned in N days (Default 5)
  19. Asset management - Assets for a previous month not depreciated in N days (default 10)

04 Oct 201911:48AM Comment 5 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 04-10-2019 11:48 AM Time Taken: 4.00

Completed the following:

  1. Helpdesk - Calls not updates in N days (default 5)
  2. Helpdesk Survey - Organisation has calls, however, there are no surveys in the last N days (30)
  3. Helpdesk Survey - Organisation has a Score below N (Default 5). If zero, so not include (make this a rule)
  4. Business intelligence - Email queue failure
  5. Business intelligence - A large number of email is in the queue (> 100 Pending)

04 Oct 201902:27PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 04-10-2019 02:27 PM Time Taken: 4.00

Completed the following:

  1. Integration - Integration failure not resolved in N days (default 1)
  2. Company Administration - No organizations setup
  3. Company Administration - Processes failure
  4. Company Administration - Important processes that sould be enabled
  5. Global Administration - Company or Currency not setup
  6. Global Administration - User has failed password attempts > N (default 1)
  7. Global Administration - Licence will expire in N days (30 +)
  8. Global Administration - Database Backup Failures
  9. Global Administration - Database Storage Disk Space usage - When Less than 20% free should be flagged
  10. Global Administration - Backups have not performed in more than 24 hours

09 Oct 201904:47PM Comment 7 by Sanjay (Link Technologies) Case 11727 removed from project 11.004.BETA
09 Oct 201904:47PM Comment 8 by Alvis (Link Technologies) Case 11727 added to project 11.004.BETA
15 Oct 201908:31AM Comment 9 by Sanjay (Link Technologies) Case 11727 removed from project 11.004.BETA
15 Oct 201908:31AM Comment 10 by Sanjay (Link Technologies) Case 11727 added to project 11.004.BETA
22 Oct 201902:51PM Comment 12 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 24-10-2019 06:50 PM Time Taken: 2.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

Add a new form in Company Administration called "Health Check"

Pass
2

A background process running every 10 Minutes will perform checks and Insert/Update data in this form

Fails.

Process SYS007 executes but does not update details under "Company Administration- Health Check".

3

Users will be able to edit the entry and put notes, and mark the entry as Resolved

Pass
4

If the entry is created and there has not been any user intervention, and the issue has been corrected, the entry should be marked as "Resolved" automatically

Pass
5

Order by Date Created with "Resolved" items at the bottom of the list

Pass
6

Date range filter on the top of the form will show all "UnReosolved" entries and Resolved entries within the specified date range.

Pass
7

When the system log is sent out at the end of the day, the Health Check entries that are UNRESOLVED needs to be included on the top. Resolved entries that have not been sent previously can be included at the bottom.

Fails,

Process SYS005 executes but does not update details under "Business Intelligence -- Email Log"


Environment Details

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

Next Step

  1. Review

29 Oct 201901:05PM Comment 13 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 29-10-2019 05:03 PM Time Taken: 4.00

Development work for this case has been completed.

The change will be available in version:11.4.1029

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

  1. Corrected issue with process SYS007 System health check
  2. Refactored email log alert to always include "System Health Check" information on the top.

2. Affected Areas:

  1. Process SYS007 System health check
  2. Email Log Alert

3. The issue was caused by:

  1. Improvement

4. Notes
5. Next Step
: UAT


30 Oct 201911:34AM Comment 14 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 30-10-2019 03:32 PM Time Taken: 2.00
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
oTest DescriptionPass/Fail
1

A background process running every 10 Minutes will perform checks and Insert/Update data in this form

Pass
2

Refactored email log alert to always include "System Health Check" information on the top. 

Fails,

Process SYS005 executes but does not update details under "Business Intelligence -- Email Log"



Environment Details

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

Next Step

  1. Review

    30 Oct 201901:30PM Comment 15 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 30-10-2019 05:01 PM Time Taken: 2.00 Notes: Edited by alvis on 30/10/19 13:41. 

    Development work for this case has been completed.

    The change will be available in version:11.4.1030

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

    1. Process SYS005 checks if an email address is entered before executing the process. We have added additional checks to log message for the process when email address is not setup.

    2. Affected Areas:

    1. Process SYS005

    3. The issue was caused by:

    1. Improvement

    4. Notes
    5. Next Step
    : UAT


    31 Oct 201909:17AM Comment 16 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 31-10-2019 12:20 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

    Process SYS005 checks if an email address is entered before executing the process.
     We have added additional checks to log message for the process when email address is not setup.

    1. Enable the process without entering an email address. This should update the "Event Log"
    2. Enable the process and enter the email address as "rashna@linktechnologies.com.au". This update "" Email Log" and send the email.
    Pass

    Environment Details

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

    Next Step

    1. Documentation

      03 Dec 201901:08PM Comment 17 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 03-12-2019 05:07 PM Time Taken: 1.00

      Hi Sanjay, 

      Documentation updated under LinkWeb Applications Portal - Company Administration - Health_Check.

      Thanks
      Rashna


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

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