| Subject: | Upgrading Database from LinkSOFT V15.51 to V15.90 takes a long time |
| Summary: | Bula With reference to case T14346, since we need to reproduce the issue on latest version, we are upgrading Goodman Fielders database on our QA environment. However, we are unable to upgrade from version 15,5 to 15.90. The upgrade times out during the upgrade on the below form. The timeout value on Link Technologies - DatabaseUtility.exe config file has been changed to the maximum value of 9999. Figure 1.1 Upgrade SCR where GFI's upgrade times out are 2 hours 47 minutes 
Server: LINKQA5
Database: Client-GFI-LinkSOFT |
| Audit Notes: | Edited by sanjay on 16/01/26 11:10. Edited by sanjay on 14/11/25 12:41. |
| 12 Nov 2025 | 11:17AM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 13-11-2025 11:09 AM Time Taken: 1.00 Notes: ETC extended from: 12/11/2025 to 13/11/2025 |
| Hi Vineet,
The reason you are getting a "timeout" is because you have over 30 "audits" enabled. Givenm the size of the database, you will need a very powerful server to audit the entire upgrade process. Before upgrading, please turn off ALL audits. You can enable them after upgrade. See documentation on upgrade. Let me know if you need help with this.
regards
Sanjay |
|
| 13 Nov 2025 | 02:20PM Comment 2 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 14-11-2025 02:14 PM Time Taken: 1.00 Notes: ETC extended from: 13/11/2025 to 14/11/2025 |
| Bula Sanjay I removed all audit and ran the upgrade again yesterday. This timeout out at 7.54pm. --------------------------- Warning --------------------------- Caution!!. Another upgrade is in progress. Upgrade Status: 12/11/2025 7:54:22 PM - Upgrade Failed. Machine: LINKQA8-LBS2 User: lbssupport --------------------------- OK ---------------------------
Requesting if you could have a look at the LINKQA5 database for Goodman Fielder. Thanks
Vineet Ram
222 0085 |
|
| 14 Nov 2025 | 08:38AM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 18-11-2025 08:33 AM Time Taken: 4.00 |
| Morning Vineet, here's an update for case T14359:
Remember to do these on all upgrades, particularly on those with a lot of history data: - Reindex
- Remove Audits
- Apply most recent patch on Installation folder (LinkSOFT_15.90.251107)
You can use these two URL to test: - http://10.0.0.15/Client-GFI-LinkSOFT/
- http://10.0.0.15/Client-GFI-LinkSOFT-1551/
Upgrade should take approx. 10 min. Here is the screenshot from our trial upgrade:
Figure 1 - GFI Upgrade Completed  |
|
| 14 Nov 2025 | 12:40PM Comment 4 by Sanjay (Link Technologies) Case L13220 added to project 16.00 |
| 14 Nov 2025 | 12:44PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 19-11-2025 04:41 PM Time Taken: 4.00 Notes: ETC extended from: 14/11/2025 to 19/11/2025 |
| The following changes has been included in LinkSOFT 15.90.251107: - Replace "Table Variable" with "Temporary Table" when performing Large Data Conversion
- Index 1. above to improve performance
|
|