We have been using VS 2017 Shell version for BI development for a few months without problems but today it stopped unexpectedly and restarted on its own. After the restart, we got an error:
Could not load file or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies. The system cannot find the file specified.
After some googling, one of our developers decided to uninstall and re-install SSDT for VS 2017 from the Microsoft site, but the setup fails:
The configuration registry key could not be opened(0x800703F3)
I googled some more and found that a force uninstall could help but it did not.
Here is the part of the setup log when errors started:
[1F4C:3708][2018-05-08T17:40:36]e000: Error 0x800703f3: Process returned error: 0x3f3
[1F4C:3708][2018-05-08T17:40:36]e000: Error 0x800703f3: Failed to execute EXE package.
[2EBC:3250][2018-05-08T17:40:36]e000: Error 0x800703f3: Failed to configure per-machine EXE package.
[2EBC:3250][2018-05-08T17:40:36]i000: MainViewModel.OnPackageAction: Install Completed for package SQL Server Analysis Services (id: Microsoft.DataTools.AnalysisServices)
[2EBC:3250][2018-05-08T17:40:36]i319: Applied execute package: Microsoft.DataTools.AnalysisServices, result: 0x800703f3, restart: None
[2EBC:3250][2018-05-08T17:40:36]e000: Error 0x800703f3: Failed to execute EXE package.
[1F4C:3708][2018-05-08T17:40:36]i329: Removed package dependency provider: Microsoft.DataTools.AnalysisServices, package: Microsoft.DataTools.AnalysisServices
[1F4C:3708][2018-05-08T17:40:36]i351: Removing cached package: Microsoft.DataTools.AnalysisServices, from path: C:\ProgramData\Package Cache\9864EE5369359DB622D0234B6C6B7640B949140C\
[2EBC:3250][2018-05-08T17:40:36]i000: MainViewModel.OnPackageActionProgress: Percent completed: 100, Overall progress: 100
[1F4C:3708][2018-05-08T17:40:36]i372: Session end, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{f55a890f-6c82-4455-9bb5-2a902cdb7d87}, resume: None, restart: None, disable resume: No
[1F4C:3708][2018-05-08T17:40:36]i330: Removed bundle dependency provider: {f55a890f-6c82-4455-9bb5-2a902cdb7d87}
[1F4C:3708][2018-05-08T17:40:36]i352: Removing cached bundle: {f55a890f-6c82-4455-9bb5-2a902cdb7d87}, from path: C:\ProgramData\Package Cache\{f55a890f-6c82-4455-9bb5-2a902cdb7d87}\
[1F4C:3708][2018-05-08T17:40:36]i371: Updating session, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{f55a890f-6c82-4455-9bb5-2a902cdb7d87}, resume: None, restart initiated: No, disable resume: No
[2EBC:3250][2018-05-08T17:40:36]e000: MainViewModel.OnBundleAction: Bundle action failed: The configuration registry key could not be opened (0x800703F3)
[2EBC:3250][2018-05-08T17:40:36]i399: Apply complete, result: 0x800703f3, restart: None, ba requested restart: No
Any help would be highly appreciated.
Had same issue, this worked for me:
1.) Uninstall VS 2017.
2.) Uninstall VS Installer.
3.) Go to the directory 'C:\Program Files (x86)\Microsoft Visual Studio\Installer\resources\app\layout\' in Command Prompt and execute 'InstallCleanup.exe -f'.
4.) Delete all remaining files and folders having 'Visual Studio' in their name.
5.) Open https://docs.microsoft.com/en-us/visualstudio/productinfo/installing-an-earlier-release-of-vs2017 to download and install a 15.6 version of VS.
6.) Open https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017 to download and install the latest SSDT.
I downloaded SSDT for VS2017 Open CMD and ran the following commands
CD %userprofile%\Downloads
SSDT-Setup-ENU.exe /layout
When the download was finished there is a Payload folder I installed each of the components manually for SSIS which were
vsta_setup.exe
Microsoft.DataTools.IntegrationServices.VSIX
SSDTISSingleton.msi
SSISOneDesigner2012.msi
SSISOneDesigner2014.msi
SSISOneDesigner2016.msi
Works in VS2017 now. Will do until MS gets it sorted.
Looks like Microsoft is working on a fix.
See:
It seems someone know a solution for this:
Michael Mallit [MSFT] ยท The versions should be 1.15.3227. So please uninstall any VS instances, then uninstall the VS Installer through Add/Remove programs and verify C:\Program Files (x86)\Microsoft Visual Studio\Installer is removed and/or empty.
Thanks, Mike
Hope i've helped!
This is what worked for me based on what John Altamura wrote in: https://developercommunity.visualstudio.com/content/problem/246732/ssdt-1560-installer-the-configuration-registry-key.html
I have a simple solution for this:)
First uninstall all VS components that you have already installed.
Run VS17 installer again and select the required components. Exclude all the SSDT components from vs17 installer(Don't select ssdt components). Now go for installation.
After successful installation of visual studio, Run the SSDT installer with selected components(SSIS,SSRS,SSAS) for the above installed VS. Hopefully it will get succeeded as in my case.
There is already a VS update that fixes this issue.
User contributions licensed under CC BY-SA 3.0