| 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 |
| 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): - Corrected the upgrade script "09400-LINKSOFT Upgrade to 10000" to handle upgrading from version 9 and version 10.
2. Affected Areas: - Upgrade database from version 9
- Upgrade database from version 10
4. Notes:
5. Next Step: UAT |