| Subject: | Unable to Upgrade Bargain Box Database - BBOX-LINKSOFT-DEEMALL |
| Summary: | Hi Sanjay BBox database was being upgraded from V949 to V13 and we found the below error: Violation of PRIMARY KEY constraint 'PK_LT_FMS_PUR_RequestDetail'. Cannot insert duplicate key in object 'dbo.LT_FMS_PUR_RequestDetail'. The duplicate key value is (161144b0-523e-f9d9-2877-1f26f601e74b).
The statement has been terminated.
Database restored on QA8
Database Name: BBOX-LINKSOFT-DEEMALL |
| Audit Notes: | Edited by sanjay on 18/03/22 08:06. Edited by aarti on 11/03/22 14:25. |
| 11 Mar 2022 | 03:53PM Comment 1 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 11-03-2022 09:53 PM Time Taken: 1.00 |
| Hi Aarti, These are all data issues in the upgrade. Let's connect next week Tuesday 2 PM AEST and I can help resolve these |
|
| 16 Mar 2022 | 08:37AM Comment 2 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 16-03-2022 02:18 PM Time Taken: 4.00 |
| The issue here is that there are Purchase Requests that have the same Part Number repeating multiple times in the Purchase Request Details. We have resolved the script and placed a patch for this on FTP. Patch Number: LinkSOFT_13.30.0316.zip is located at this link. Aarti please confirm the issue has been resolved and assign this case to me for closure. thanks. |
|
| 16 Mar 2022 | 10:33AM Comment 3 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 16-03-2022 04:28 PM Time Taken: 1.00 |
| The following tests were performed:
Table 1 - Test Results
| No | Test Case | Expected Result | Pass/Fail | Comments | | 1 | Restored Database
| Pass
|
|
| | 2 | Applied Script
| Pass
|
|
| | 3 | Upgrade Database
| Fail
|
|
| | 4 | Upgrade Error
| Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
EXEC LT_SAA_DataMigration_PostUpgrade
Script File: 99998
|
|
| | 5 |
|
|
|
|
Environment Details - OS version: Win10
- Application version: 13.30
- Setup on:
- Server: LinkQA8
- Database: BBOX-LINKSOFT-DEEMALL
- LinkSOFT URL:
- Login Details: Standard username and password for user "admin"
Next Step: |
|
| 16 Mar 2022 | 10:52AM Comment 4 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 16-03-2022 04:46 PM Time Taken: 2.00 |
| Hi Aarti, the data conversion time taken will depend on the power of the server and also the connection timeout n the database utility. The default is 3600s = 1 hour. You should increase this for larger databases. The configuration file is located in the installed folder, file name: C:\Program Files (x86)\Link Technologies\Link Technologies - DatabaseUtility.exe.config Section to change: <add key="DataConnectionCommandTimeout" value="3600"/>. If you want to use 2 hours, use 7200 instead of 3600 |
|
| 17 Mar 2022 | 01:51PM Comment 5 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 17-03-2022 07:50 PM Time Taken: 2.00 |
| The following tests were performed:
Table 1 - Test Results
| No | Test Case | Expected Result | Pass/Fail | Comments | | 1 | Restored Database
| Pass
|
|
| | 2 | Applied Script
| Pass
|
|
| | 3 | Upgrade Database
| Pass
|
| 2 hours and 6 mins
| | 4 |
| |
|
| | 5 |
|
|
|
|
Environment Details - OS version: Win10
- Application version: 13.30
- Setup on:
- Server: LinkQA8
- Database: BBOX-LINKSOFT-DEEMALL
- LinkSOFT URL:
- Login Details: Standard username and password for user "admin"
Next Step: For closure |
|
| 18 Mar 2022 | 08:06AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 18-03-2022 02:05 PM |
| Thanks Aarti |
|