I am having an issue with the SSDT installation for VS2017.
I have ran the installer three times, once basic, once following VS update and the last following some minor windows updates.
All 3 times the logs stumble at the same point, anyone know what this .exe it is trying to run is (I am running the installer with Admin...). I read somewhere for a similar error that it might be the SDK but I am able to run this locally, any nice workarounds to having this installed out there?
[29BC:A138][2017-09-26T09:28:00]i000: MainViewModel.OnPackageActionProgress: Percent completed: 50, Overall progress: 4
[1EC4:6DB0][2017-09-26T09:28:00]e000: Error 0x800703e9: Process returned error: 0x3e9
[1EC4:6DB0][2017-09-26T09:28:00]e000: Error 0x800703e9: Failed to execute EXE package.
[29BC:A138][2017-09-26T09:28:00]e000: Error 0x800703e9: Failed to configure per-machine EXE package.
[29BC:A138][2017-09-26T09:28:00]i000: MainViewModel.OnPackageAction: Install Completed for package SQL Server Analysis Services (id: Microsoft.DataTools.AnalysisServices)
[29BC:A138][2017-09-26T09:28:00]i319: Applied execute package: Microsoft.DataTools.AnalysisServices, result: 0x800703e9, restart: None
[29BC:A138][2017-09-26T09:28:00]e000: Error 0x800703e9: Failed to execute EXE package.
[1EC4:6DB0][2017-09-26T09:28:00]i351: Removing cached package: Microsoft.DataTools.AnalysisServices, from path: C:\ProgramData\Package Cache\9864EE5369359DB622D0234B6C6B7640B949140C\
[29BC:A138][2017-09-26T09:28:00]i000: MainViewModel.OnPackageActionProgress: Percent completed: 100, Overall progress: 100
[1EC4:6DB0][2017-09-26T09:28:00]i372: Session end, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{5d5d6235-5c8c-4377-9a75-1b6368850657}, resume: None, restart: None, disable resume: No
[1EC4:6DB0][2017-09-26T09:28:00]i330: Removed bundle dependency provider: {5d5d6235-5c8c-4377-9a75-1b6368850657}
[1EC4:6DB0][2017-09-26T09:28:00]i352: Removing cached bundle: {5d5d6235-5c8c-4377-9a75-1b6368850657}, from path: C:\ProgramData\Package Cache\{5d5d6235-5c8c-4377-9a75-1b6368850657}\
[1EC4:6DB0][2017-09-26T09:28:00]i371: Updating session, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{5d5d6235-5c8c-4377-9a75-1b6368850657}, resume: None, restart initiated: No, disable resume: No
[29BC:A138][2017-09-26T09:28:00]e000: MainViewModel.OnBundleAction: Bundle action failed: Recursion too deep; the stack overflowed (0x800703E9)
[29BC:A138][2017-09-26T09:28:00]i399: Apply complete, result: 0x800703e9, restart: None, ba requested restart: No
[29BC:6724][2017-09-26T09:28:04]i000: MainViewModel.OpenUrl: Opening url: C:\Users\RTOMPS~1\AppData\Local\Temp\SsdtSetup\SSDT-Setup-ENU_20170926092556.log
The answer from Nick is very helpful, but I still failed at SSDT-Setup-ENU.exe /repair
with the same error Error 0x800703e9: Failed to execute EXE package.
.
Then I tried it with a very straightforward way: (Disable UserAccountControl first)
SSDT-Setup-ENU.exe
to c:\temp
and execute SSDT-Setup-ENU.exe /layout
to download a local copy of the bundle.C:\temp\redist
and double click NDP461-KB3102438-Web.exe
C:\temp\payload
and double click vsta_setup.exe
This is the most likely link I came to when I got the same message in my log:
Applying execute package: Microsoft.DataTools.AnalysisServices, action: Install, path: C:\ProgramData\Package Cache\9864EE5369359DB622D0234B6C6B7640B949140C\VSIXBootstrapper.exe, arguments: '"C:\ProgramData\Package Cache\9864EE5369359DB622D0234B6C6B7640B949140C\VSIXBootstrapper.exe" /q /admin /instanceIds:"fc3f0e2c" /logFile:"C:\Users\a_nzchuk\AppData\Local\Temp\SsdtSetup\SSDT-Setup-ENU_20171205113839_002_Microsoft.DataTools.AnalysisServices.log" "payload\Microsoft.DataTools.AnalysisServices.vsix"'
MainViewModel.OnPackageActionProgress: Percent completed: 50, Overall progress: 17
MainViewModel.OnPackageActionProgress: Percent completed: 50, Overall progress: 17
...........
...
Error 0x800707d3: Process returned error: 0x7d3
Error 0x800707d3: Failed to execute EXE package.
Error 0x800707d3: Failed to configure per-machine EXE package.
MainViewModel.OnPackageAction: Install Completed for package SQL Server Analysis Services (id: Microsoft.DataTools.AnalysisServices)
Applied execute package: Microsoft.DataTools.AnalysisServices, result: 0x800707d3, restart: None
So I'll document my findings here.
In my start menu I had Visual Studio 2017 (SSDT). It ran OK but didn't have any BI projects available
This is what I did from an Administrator elevated command prompt:
SSDT-Setup-ENU.exe
into C:\temp (rather than a user specific download folder which the admin user may not have access to)SSDT-Setup-ENU.exe /layout
to pre-download support and redist files (this was after a required restart)SSDT-Setup-ENU.exe /repair
to try and repair the install. It gave me a button Repair that I clicked.SSDT-Setup-ENU.exe /repair
again. Selected Modify. Noted that only SQL Server Database was ticked, but none of the others (SSAS, SSIS, SSRS)After this, when I reran VS2017, it had the BI projects and allowed me to create a 1400 SSAS solution
Previous failed installations left VS2017 recognising that the installation was present in Visual Studio Installer. I removed the installation, restarted and the re-install was successful...
For SSDT for VS2018, Version 15.5.2 same failed at execute exe. only do 1. SSDT-Setup-ENU.exe /layout 2. SSDT-Setup-ENU.exe /repair (tick SSAS/SSRS/SSIS based on your requirement)
and this already works. I think MS also do some job for this.
EDIT: This might not be relevant any more since SSDT 15.8.2 is now out.
In my case, I was on VS 2017 15.7.2 and I can't complete the installation in SSDT 15.6. What I did was to install SSDT 2017 15.7.0 and it worked.
Make sure to uninstall previous SSDT installations via the VS installer or Control Panel also the Microsoft Reporting Services Projects and Microsoft Aanalysis Services Projects extensions first if you have them before launching the installer.
Edit: I think my Python issue is a subset of Jeff Leach's comment about repairing Visual Studio. So, I would probably look at any Visual Studio errors you had while installing and try and fix them before trying to install SSDT. For the time being I would NOT update Visual Studio or its installer to the newest versions (15.7 and 1.16) because of known bugs with SSDT 2017. They are working on a fix that will be out with 15.7.2 but it's not out yet.
Info for the edit:
I found that Daniel's method worked, but I had to install Python manually to be successful.
After successfully installing the .msis in the payload directory I tried to install the Analysis Services VSIX and I wasn't successful because the installer couldn't install Python 3.6.3. I found the page at the bottom and did the following to successfully install the Analysis, Integration, and Reporting VSIXs.
Just to do control testing, I installed Reporting Services with the /repair option and was successful. I think the main issue was the Python error. I think if I would've had Python installed everything would've gone smoothly. This is very frustrating because I got this same Python "error" when first installing Visual Studio 2017 (15.6.7)...expect the "error" was just a caution and didn't prevent me from using Visual Studio. But somehow it prevented the install of SSDT 2017.
I hope none of y'all have to go through this like I did today at work!
Info that helped solve this:
I had the same error 0x800703e9 installing SSDT with the SSRS option checked. After trying some of the previous good suggestions unsuccessfully, including using the /layout option to download the package locally, I found that the Visual Studio installer portion of the package needed a reboot to finish. After the reboot, I was able to run Microsoft.DataTools.ReportingServices.VSIX successfully.
I have a similar problem with different error code, but the same
"Failed to execute EXE package problem".
I tried all the solution above to no avail. But, after creating an installation layout out of SSDT-Setup-ENU.exe
and then trying to execute vsta_setup.exe
as suggested by Daniel. I get to the underlying error message, it's has something to do with Android NDK
believe it or not, and since I'm from Syria, any change to these packages should be done through a VPN
connection. So the solution was to run Visual Studio 2017 installation layout, remove all these ugly android packages "Android SDKs and NDKs and even the emulators, yes, a nuclear solution since I don't have a VPN connection", and then run SSDT-Setup-ENU.exe /repair
. Everything worked just fine.
I hope this might save someone's time after it wasted mine.
My installation came also with a error. I tried the several things mentioned above, but it didn't help. So I was guessing that it could be the disk space of my VirtualBox VM. I made the C:
drive bigger and that was the trick.
SSDT requiere:
Hard disk space: up to 130 GB
of available space, depending on features installed; typical installations require 20-50 GB
of free space.
My ssdt_setup_enu runs to a setup failed. I'm using release 15.9
Product release information is here: log excerpt 1
[2F6C:2F70][2019-04-27T15:30:55]i001: Burn v3.11.0.1528, Windows v10.0 (Build 17763: Service Pack 0), path: C:\Users\albert\AppData\Local\Temp\{828655F7-4AB9-4C42-A9DB-1BEC6D4EC19D}\.cr\SSDT-Setup-ENU.exe
[2F6C:2F70][2019-04-27T15:30:55]i000: Initializing string variable 'ProductVersionVar' to value '14.0.16186.0'
[2F6C:2F70][2019-04-27T15:30:55]i000: Initializing string variable 'HeaderText' to value 'Release 15.9.0'
Errors, log excerpt 2
[332C:32B8][2019-04-27T15:34:28]e000: Error 0x80070002: Failed to find payload: Microsoft.DataTools.IntegrationServices in working path: C:\Users\albert\AppData\Local\Temp\{B3B89D58-13A8-48A3-BA76-2F7FE585FE4D}\Microsoft.DataTools.IntegrationServices and unverified path: C:\ProgramData\Package
Cache\.unverified\Microsoft.DataTools.IntegrationServices
[332C:32B8][2019-04-27T15:34:28]e000: Error 0x80070002: Failed to cache payload: Microsoft.DataTools.IntegrationServices
[2F6C:28C8][2019-04-27T15:34:28]e314: Failed to cache payload: Microsoft.DataTools.IntegrationServices from working path: C:\Users\albert\AppData\Local\Temp\{B3B89D58-13A8-48A3-BA76-2F7FE585FE4D}\Microsoft.DataTools.IntegrationServices, error: 0x80070002.
More errors
[332C:2D6C][2019-04-27T16:13:21]e000: Error 0x800707d3: Process returned error: 0x7d3
[332C:2D6C][2019-04-27T16:13:21]e000: Error 0x800707d3: Failed to execute EXE package.
[2F6C:2F70][2019-04-27T16:13:21]e000: Error 0x800707d3: Failed to configure per-machine EXE package.
[2F6C:2F70][2019-04-27T16:13:21]i000: MainViewModel.OnPackageAction: Install Completed for package SQL Server Integration Services (id: Microsoft.DataTools.IntegrationServices)
[2F6C:2F70][2019-04-27T16:13:21]i319: Applied execute package: Microsoft.DataTools.IntegrationServices, result: 0x800707d3, restart: None
Github issue at https://github.com/MicrosoftDocs/visualstudio-docs/issues/2592
Their latest project download (dated 4/2019) at https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects&ssr=false#overview
I have Visual Studio 2019 installed and was attempting to add SSDT to VS 2019. I have not tried adding to SSDT to a new instance of VS 2017 yet. No resolution being proposed. Some of the references pertain to older releases.
User contributions licensed under CC BY-SA 3.0