Company: Link Technologies
Case No: L11830. Project: 11.40: LinkSOFT Version 11.4
Logged By: Sanjay (Link Technologies) on 15 Nov 2019 10:46AM
Priority: High
Product: Framework
Group: Enhancement
Time Taken: 19.00 (Weight: 19.00)
Version: 11.4.0302
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay, Sanjeet
Resolve By: Friday, 15 November 2019 01:17 PM [1616 days since logged date]
Status: Closed
Subject: Database Size issue for High Volume Transaction Sites
Summary:    There is a database size issue for high volume transaction sites. The problem seems to be around two tables:
  1. FRCS TaxIntegration
  2. Replication Data History

The following two changes will be done:

  1. Review the tax integration table and reduce the data required - set the configuration to store "All" or "Required" data
  2. Review the ReplicationHistory table. - set configuration to Archive data after "N" days

Figure 1 - Database usage by the table

Audit Notes:Edited by sanjay on 29/11/19 16:02. Edited by alvis on 29/11/19 16:01. Edited by sanjay on 15/11/19 10:46. Edited by sanjay on 15/11/19 10:21. Edited by sanjay on 15/11/19 08:07. Edited by sanjay on 15/11/19 08:07. 
15 Nov 201909:49AM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 15-11-2019 01:17 PM Time Taken: 16.00

Development work for this case has been completed.

The change will be available in version:11.4.1115

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

  1. Enhanced SYS004 to cleanup the Order Tax Integration table. Remove duplicate Image fields like QR Code, VerificationURL, etc. Items not required by FRCS AUDIT Specifications
  2. Added "Days to keep" for each "Cleanup type"
  3. Set defaults to 365 days for logs and 30 days for FRCS redundant audit fields

2. Affected Areas:

  1. Replication Logs, Event Logs, Mail Logs, Order Tax Interaction

3. The issue was caused by:

  1. Improvement

4. Notes
5. Next Step
: UAT


15 Nov 201910:21AM Comment 2 by Sanjay (Link Technologies) Case L11830 added to project 11.004
02 Dec 201912:36PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 02-12-2019 04:06 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
1Validate that process SYS004 is executed without errorsPass
2Set the "Days to keep" as 1 for replication history data. Replication data has "Date Create" as 30/11/2019. This entry should be archived Pass
3Set the "Days to keep" as 1 for tax intgerationdata. ata has "Fiscal Invoice Date" as 30/11/2019. This QR code, verification VR and verification image fields are set to "Null"
Pass
4Validate that the "Event Log"entries and "Mail Log"entries are archived.Pass

Environment Details

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

Next Step

  1. Documentation

    02 Dec 201901:27PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 02-12-2019 05:27 PM Time Taken: 1.00

    Hi Sanjay, 

    Documentation has been updated under "Linkweb Portal - Company Administration - Process".

    Thanks
    Rashna


    Attachments:
    General Documents - Case: L11830:Extra Lautoka Disk Usuage.pdf
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L11830 in the subject line of all emails regarding this issue.

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