Company: Link Technologies
Case No: L10439. Project: 11.40: LinkSOFT Version 11.4
Logged By: Sanjay (Link Technologies) on 11 Sep 2019 09:13AM
Priority: Medium
Product: Framework
Group: New Feature
Time Taken: 29.00 (Weight: 32.00)
Version: 11.3.0902
Assigned To: Sanjay (Link Technologies)
Circulation: Development, Rashna, Sanjay
Resolve By: Friday, 07 June 2019 12:00 AM [1680 days since logged date]
Status: Closed
Subject: LinkWEB Backup Database Management
Summary:    

Add the ability to take backups to allow functionality transfer from Backoffice.

Payroll users currently have the ability to take backups, however, there is no visibility on what backups have been completed and how they can be managed.

To improve this functionality, we have agreed on the following design:

  1. Add a maintenance form to allow users to create backups
  2. A background process will perform the backup as some backups may take long
  3. A status on the backup entry will show what backups have been done
  4. User has the ability to see backups and maintain them
  5. Some backups may take some time, therefore users need to be aware that until the status is "Completed", the backup will not be usable
  6. Row-color: RED (incomplete backups) Black (Completed Backups) Grey (Expired Backups)
Audit Notes:Edited by sanjay on 11/09/19 09:13. 
04 Jun 201903:58PM Comment 1 by Sanjay (Link Technologies) Case 10439 added to project 11.0
11 Jun 201901:56PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 11-06-2019 01:56 PM Time Taken: 25.50

Development work for this case has been completed.

The change will be available in version: 11.0.20190611

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

  1. Add a maintenance form to allow users to create backups
  2. A background process will perform the backup as some backups may take longer.  Process ID was SYS001
  3. A status on the backup entry will show what backups have been done
  4. User has the ability to see backups and maintain them
  5. Some backups may take some time, therefore users need to be aware that until the status is "Completed", the backup will not be usable
  6. Row-color: RED (incomplete backups) Black (Completed Backups) Grey (Deleted)
  7. The backup path will be the SQL Server default path
  8. All backups including payroll automated backups (Pay Update) will be shown here

2. The issue was caused by:

  1. Improvement

3. Next Step:

  1. UAT

01 Jul 201909:18AM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 01-07-2019 09:18 AM Time Taken: 2.50
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
1Users with access should be able to create a backup under "Global Administration - Database Backup" Pass
2Add a new "Backup" description and "Retention Days" , the backup - "Server", "Database" and "File" path should be updated
Pass
3Process SYS001, should execute and create the backup. Review event log for errorPass
4The backup "completed" should have black font color.Pass
5Incomplete backups should have red font colorPass
6Validate that menu 241 has been removed from Backoffice Pass

Environment Details

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

Next Step: Documentation


    11 Sep 201909:13AM Comment 4 by Sanjay (Link Technologies) Case 10439 removed from project 11.00
    11 Sep 201909:13AM Comment 5 by Sanjay (Link Technologies) Case 10439 added to project 11.00
    19 Sep 201910:32AM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 19-09-2019 10:32 AM Time Taken: 1.00

    Hi Sanjay,

    Documentation has been updated at this link.

    Thanks
    Rashna


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

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