SoftGrid: Installation program unable to read SQL. upgrade files for the configuration database

This was the error message that confronted one of TechNet Forum customers when they were trying to upgrade there VAS from 4.1.2.20 to 4.1.3.16. And its a really interesting issue! All you get when you try and upgrade is an error message saying "The installation program was unable to read the SQL. upgrade files for the […]

Share online:

This was the error message that confronted one of TechNet Forum customers when they were trying to upgrade there VAS from 4.1.2.20 to 4.1.3.16. And its a really interesting issue!

All you get when you try and upgrade is an error message saying "The installation program was unable to read the SQL. upgrade files for the configuration database".

This is due to the installation program being unable to read the SQL upgrade files for the configuration database, if you review your sft-server.log you should see an entry similar to ;

Couldn't open search handle for path ``C:\Program Files\Softricity\SoftGrid Server\schema\upgrade\*''.

Generally I have seen this where the customer had installed the SoftGrid VAS to an alternate location. For example E:\Microsoft\SoftGrid Server rather than the above path.

Reviewing the SoftGrid-server-setup.txt to spot the error and the installation rollback.

When we copied the data from the 'E:\Microsoft\SoftGrid Server\schema\upgrade' to the path 'C:\Program Files\Softricity\SoftGrid Server\schema\upgrade\*'' after we manually created the directory structure on C:. The installation then completed successfully.

There are several folders under the 'upgrade' folder and the number is based on how many upgrade the customer has done. The names there represent each version installed (3.1, 3.2 4.0 ect...). The data under the 'upgrade' folder is the data that needs to be moved\copied.

Also check the following keys and ensure the path is pointed to the correct installation. Editing may allow the application to install correctly. (But this has not been tested in full)

HCLM\Software\Microsoft\Windows\CurrentVersion\App Paths\SFTCore.exe
HCLM\Software\Microsoft\Windows\CurrentVersion\App Paths\SFTDispatcher.exe

Source:→ Microsoft

About The Author

Deepak Gupta is a IT & Web Consultant. He is the founder and CEO of diTii.com & DIT Technologies, where he's engaged in providing Technology Consultancy, Design and Development of Desktop, Web and Mobile applications using various tools and softwares. Sign-up for the Email for daily updates. Google+ Profile.