Company: Link Technologies
Case No: L11697. Project: 10.10: LinkSOFT Version 10.1
Logged By: Alvis (Link Technologies) on 27 Aug 2019 02:21PM
Priority: Medium
Product: Framework
Group: Software Defect
Time Taken: 4.00 (Weight: 4.00)
Version: 10.155.0117
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Development, Rashna, Sanjay
Resolve By: Tuesday, 27 August 2019 12:00 AM [1695 days since logged date]
Status: Closed
Subject: Error while upgrading a database from version 10.1
Summary:    

Bula Vinaka Alvis,

We are faced with the following error while trying to upgrade a client database:

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Violation of PRIMARY KEY constraint 'PK_HR_QUALIFICATION'. Cannot insert duplicate key in object 'dbo.HR_QUALIFICATION'. The duplicate key value is (FS, FFL).
The statement has been terminated.

--Populate qualification records for all companies to ensure employee data is displayed correctly.
INSERT INTO HR_QUALIFICATION
(
QUALIFICATION
,DESCRIPTION
,VOID
,VOID_WHO
,VOID_DATE
,COMMENT
,company_id
)
SELECT
q.QUALIFICATION
,q.DESCRIPTION
,q.VOID
,q.VOID_WHO
,q.VOID_DATE
,q.COMMENT
,c.company_id
FROM HR_QUALIFICATION q
CROSS JOIN SY_COMPANY c
WHERE NOT EXISTS (SELECT * FROM HR_QUALIFICATION z WHERE z.company_id = c.company_id and z.qualification = q.qualification)
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

The backup has been uploaded on FTP as "MCL_LINKSOFT-20082019_11164.zip".

Requesting if you can verify this.

Kind Regards
Aarti

Audit Notes:Edited by sanjay on 29/08/19 11:27. 
27 Aug 201902:26PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-08-2019 02:26 PM Time Taken: 2.00

Development work for this case has been completed.

The change will be available in version:10.149

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

  1. Corrected the upgrade script "09400-LINKSOFT Upgrade to 10000" to handle upgrading from version 9 and version 10.

2. Affected Areas:

  1. Upgrade database from version 9
  2. Upgrade database from version 10

4. Notes
5. Next Step
: UAT


27 Aug 201905:06PM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 27-08-2019 05:06 PM
Hi Rashna, 10.149 has been placed on FTP for Verification.

28 Aug 201912:52PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 28-08-2019 12:52 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
1Upgrade client database from version 949.006 to 10.149. This should be completed without errors

Pass.

Upgrade Time = 16 minutes 

2Upgrade client database from version 10.0.141 to 10.149. This should be completed without errors

Pass.

Upgrade Time = 32 minutes


Environment Details

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

Next Step

  1. Review and closure

    28 Aug 201902:46PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 28-08-2019 02:46 PM
    Thanks Rashna

    09 Oct 201908:17AM Comment 5 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - Cleared queue due to large number of calls
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L11697 in the subject line of all emails regarding this issue.

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