Company: Link Technologies
Case No: L12107. Project: 12.30: LinkSOFT Version 12.30
Logged By: Sanjay (Link Technologies) on behalf of Alvis (Link Technologies) on 08 Dec 2020 01:23PM
Priority: Low
Product: Framework
Group: Enhancement
Time Taken: 5.00 (Weight: 8.00)
Version: 12.30
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Sunday, 13 December 2020 11:59 PM [1227 days since logged date]
Status: Closed
Subject: Add a feature to check for the SQL API version. Once the version has been verified then continue with the integration.

Add a feature to check for the SQL API version. Once the version has been verified then continue with the integration.

This is a common mistake done by consultants. They upgrade LinkSOFT, however, forget to apply the integration scripts to FMIS database.

Audit Notes:Edited by alvis on 09/02/21 16:52. 
15 Dec 202008:10AM Comment 1 by Sanjay (Link Technologies) Case L12107 added to project 12.3
18 Dec 202001:02PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-12-2020 01:00 PM Time Taken: 4.00

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

1. The change will be available in version:12.30

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

  1. Added SQL API version 
  2. When the system collects or pushes data using SQL API, the API version is verified before proceeding.

3. Affected Areas:

  1. Jiwa 6
  2. Jiwa 7
  3. Epicor 7.4
  4. Customizations for Vodafone, coca-cola

4. The issue was caused by:

  1. improvements

5. Notes
6. Next Step


PART B - Development Reference:

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

2. Variations to the approved design:n/a

24 Dec 202009:37AM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 30-12-2020 09:35 AM
Please proceed with UAT 

07 Jan 202101:14PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 13-01-2021 01:10 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

Restored an Epicor Control database on Qa4

Enable integration in LinkSOFT and ran the process FMIS Import.

This should update the "Event log" to show the missing integration procedure

Ran the DB integration script, this should start importing the file

Tested the same with

  1. Microsoft AX
  2. JIWA 6 and JIWA 7 on QA6 was functional


Environment Details

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

Next Step

  1. For Closure

    11 Jan 202104:44PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 13-01-2021 04:44 PM
    Thanks Rashna

    09 Feb 202104:52PM Comment 6 by Alvis (Link Technologies) ETC was changed from 13/12/2020 to 13/12/2020
    If you have any queries regarding this support incident, please email and include the Case No: L12107 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