Company: Link Technologies
Case No: L12611. Project: 13.11: LinkSOFT version 13.11 - Improvements and Stabilisation
Logged By: Sanjay (Link Technologies) on 30 Sep 2021 11:54AM
Priority: Low
Product: Framework
Group: Enhancement
Time Taken: 26.00 (Weight: 30.00)
Version: 13.11.1021
Assigned To: Development
Circulation: Development, Sanjay
Resolve By: Tuesday, 05 October 2021 11:59 PM [911 days since logged date]
Status: Closed
Subject: Audit operation should not allow users to audit processing tables, log tables and Archive tables as these tables cannot be changed by the user
Summary:    Audit operation should not allow users to audit processing tables, log tables and Archive tables as these tables cannot be changed by the user
Audit Notes:Edited by sanjay on 19/10/21 10:56. Edited by sanjay on 19/10/21 10:52. Edited by sanjay on 18/10/21 15:47. Edited by sanjay on 18/10/21 13:30. 
12 Oct 202109:03AM Comment 1 by Sanjay (Link Technologies) Case L12611 added to project 13.11
18 Oct 202101:30PM Comment 2 by Sanjay (Link Technologies) Case L12611 added to project 13.1X
18 Oct 202103:46PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 20-10-2021 03:39 PM Time Taken: 22.00
PART A - Development work for this case has been completed.

1. The change will be available in version:13.11.1018

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

  1. Removed the following areas from Replication to avoid the user from choosing processing tables for Audit:
    1. Audit Maintenance and Data Tables
    2. POS Build items
    3. Error Logging tables, such as Depreciation Log, Event Log, Call Escalation Logs, Time and Timesheet Logs, VMS Logging etc
    4. Inventory Valuation and Valuation Analysis
    5. Replication Compare Data tables
    6. Archive and VOID/Deleted Records Tables for Integrations and processing functions
    7. Health Check Logs
    8. Processing Queue Tables
    9. System Controls where the user has no impact
    10. Temporary processing tables such as Import Processing

3. Affected Areas:

  1. Audit Data Setup and Processing

4. The issue was caused by:

  1. Improvement

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


18 Oct 202103:47PM Comment 4 by Sanjay (Link Technologies) ETC was changed from 05/10/2021 to 05/10/2021
19 Oct 202110:52AM Comment 5 by Sanjay (Link Technologies) Case L12611 added to project 13.11
21 Oct 202103:05PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-10-2021 02:53 PM Time Taken: 4.00
The following tests were performed:

Table 1 - Test Results
#Test Case DetailsPass/FailComments
 1Check if audit data, System Logs and Read-Only tables cannot be audited
Pass
 
 2Verify processing and user-editable tables can be audited
Pass
 
 3Add Audit for User Maintenance and Keep for 200 days
Pass
 
 4Verify audit data is deleted after 200 days
Pass
 

Environment Details

  1. OS version: Win10
  2. Application version: 13.11
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://
  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: L12611 in the subject line of all emails regarding this issue.

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