Solution: do check if the TLS 1.0 is blocked in the PC, if so it will not allow you to install / proceed further. Export and delete the folder "Client" and re-run the setup
Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client
SSDT 2017 keeps failling with 'Incorrect function' error
I am installing SSDT 2017 on Windows 10 but fails with the message "Incorrect function 0x80070001."
I have done below things to fix but none of them worked:
- I have updated Visual Studio 2017 to the lastest version and then tried for installation.
- I've tried making sure my machine is completely updated, restarting and trying the install again.
- I've tried running the installer as an administrator.
I've taken a look at the log file and the part where it starts to error out is here:
[22B8:22F0][2020-08-19T20:30:22]w343: Prompt for source of package: SSISOneDesigner2012, payload: SSISOneDesigner2012, path: D:\Chaitanya\Software\payload\SSISOneDesigner2012.msi
[22B8:22F0][2020-08-19T20:30:22]i338: Acquiring package: SSISOneDesigner2012, payload: SSISOneDesigner2012, download from: https://go.microsoft.com/fwlink/?LinkId=2086272&clcid=0x409
[22B8:22F0][2020-08-19T20:30:34]e000: Error 0x80070002: Failed attempt to download URL: 'https://go.microsoft.com/fwlink/?LinkId=2086272&clcid=0x409' to: 'C:\Users\ADMINI~1\AppData\Local\Temp{EE38CD8E-1E70-41D9-A814-BF0EE823C70E}\SSISOneDesigner2012'
[22B8:22F0][2020-08-19T20:30:34]e000: Error 0x80070002: Failed to acquire payload from: 'https://go.microsoft.com/fwlink/?LinkId=2086272&clcid=0x409' to working path: 'C:\Users\ADMINI~1\AppData\Local\Temp{EE38CD8E-1E70-41D9-A814-BF0EE823C70E}\SSISOneDesigner2012'
[22B8:22F0][2020-08-19T20:30:34]e313: Failed to acquire payload: SSISOneDesigner2012 to working path: C:\Users\ADMINI~1\AppData\Local\Temp{EE38CD8E-1E70-41D9-A814-BF0EE823C70E}\SSISOneDesigner2012, error: 0x80070002.
[22B8:22F0][2020-08-19T20:30:34]i000: MainViewModel.OnPackageAction: Install CompletedDownload for package SQL Server Integration Services 2012 (id: SSISOneDesigner2012)
[22B8:22BC][2020-08-19T20:30:34]e000: Error 0x80070002: Failed while caching, aborting execution.
[1A6C:1DB0][2020-08-19T20:30:34]i372: Session end, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall{30f45070-2990-48d3-8aae-2f881aa6907f}, resume: None, restart: None, disable resume: No
[1A6C:1DB0][2020-08-19T20:30:34]i330: Removed bundle dependency provider: {30f45070-2990-48d3-8aae-2f881aa6907f}
[1A6C:1DB0][2020-08-19T20:30:34]i352: Removing cached bundle: {30f45070-2990-48d3-8aae-2f881aa6907f}, from path: C:\ProgramData\Package Cache{30f45070-2990-48d3-8aae-2f881aa6907f}\
[1A6C:1DB0][2020-08-19T20:30:34]i371: Updating session, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall{30f45070-2990-48d3-8aae-2f881aa6907f}, resume: None, restart initiated: No, disable resume: No
[22B8:22BC][2020-08-19T20:30:34]e000: MainViewModel.OnBundleAction: Bundle action failed: The system cannot find the file specified (0x80070002)
[22B8:22BC][2020-08-19T20:30:34]i399: Apply complete, result: 0x80070002, restart: None, ba requested restart: No
[22B8:22F8][2020-08-19T20:31:37]i000: MainViewModel.OpenUrl: Opening url: C:\Users\ADMINI~1\AppData\Local\Temp\SsdtSetup\SSDT-Setup-ENU_20200819202739.log
Any help will be appreciated, I am stuck with this error.
5 answers
Sort by: Newest
-
Lin_Rao 6 Reputation points
2021-11-18T18:16:40.9+00:00 -
Chaitanya Joshi 1 Reputation point
2020-09-04T07:55:35.053+00:00 Hi Mona,
I have already installed SQ Server 2014 and SSMS, still the same error.
Best Regards,
Chaitanya -
Monalv-MSFT 5,896 Reputation points
2020-08-31T06:29:05.603+00:00 Hi Chaitanya Joshi,
May I know if you install SQL Server and SSMS?
If not, please download SQL Server and SSMS first.
May I know if you can download Visual Studio 2019 and SQL Server Integration Services Projects?
Best Regards,
Mona----------
If the response is helpful, please click "Accept Answer" and upvote it.
-
Chaitanya Joshi 1 Reputation point
2020-08-26T08:30:26.773+00:00 Thank you for your response. I tried with standalone installer, but found same error.
The logs I found are below:
[2AD4:4680][2020-08-26T13:47:08]i000: MainViewModel.OnPackageActionProgress: Percent completed: 100, Overall progress: 49
[2AD4:4680][2020-08-26T13:47:08]i000: MainViewModel.OnPackageAction: Install CompletedDownload for package Microsoft Visual Studio Tools for Applications 2017 (id: VSTA2017)
[2AD4:4680][2020-08-26T13:47:08]i000: MainViewModel.OnPackageAction: Install StartedDownload for package SQL Server Integration Services 2012 (id: SSISOneDesigner2012)
[2684:0D48][2020-08-26T13:47:08]e000: Error 0x80070002: Failed to find payload: SSISOneDesigner2012 in working path: C:\Users\ADMINI~1\AppData\Local\Temp{14FCE06C-BAAF-4E42-8B47-9A2BAEE1EBFA}\SSISOneDesigner2012 and unverified path: C:\ProgramData\Package Cache.unverified\SSISOneDesigner2012
[2684:0D48][2020-08-26T13:47:08]e000: Error 0x80070002: Failed to cache payload: SSISOneDesigner2012
[2AD4:4680][2020-08-26T13:47:08]e314: Failed to cache payload: SSISOneDesigner2012 from working path: C:\Users\ADMINI~1\AppData\Local\Temp{14FCE06C-BAAF-4E42-8B47-9A2BAEE1EBFA}\SSISOneDesigner2012, error: 0x80070002.
[2AD4:4680][2020-08-26T13:47:08]e349: Application requested retry of payload: SSISOneDesigner2012, encountered error: 0x80070002. Retrying...
[2684:0D48][2020-08-26T13:47:09]i305: Verified acquired payload: SSISOneDesigner2012 at path: C:\ProgramData\Package Cache.unverified\SSISOneDesigner2012, moving to: C:\ProgramData\Package Cache{DB97C76B-9116-42C5-8814-0041856EB9E6}v11.4.7001.0\payload\SSISOneDesigner2012.msi.
[2AD4:4680][2020-08-26T13:47:09]i000: MainViewModel.OnPackageActionProgress: Percent completed: 100, Overall progress: 53
[2AD4:4680][2020-08-26T13:47:09]i000: MainViewModel.OnPackageAction: Install CompletedDownload for package SQL Server Integration Services 2012 (id: SSISOneDesigner2012)
[2AD4:4680][2020-08-26T13:47:09]i000: MainViewModel.OnPackageAction: Install StartedDownload for package SQL Server Integration Services 2014 (id: SSISOneDesigner2014)
[2684:0D48][2020-08-26T13:47:09]e000: Error 0x80070002: Failed to find payload: SSISOneDesigner2014 in working path: C:\Users\ADMINI~1\AppData\Local\Temp{14FCE06C-BAAF-4E42-8B47-9A2BAEE1EBFA}\SSISOneDesigner2014 and unverified path: C:\ProgramData\Package Cache.unverified\SSISOneDesigner2014
[2684:0D48][2020-08-26T13:47:09]e000: Error 0x80070002: Failed to cache payload: SSISOneDesigner2014
[2AD4:4680][2020-08-26T13:47:09]e314: Failed to cache payload: SSISOneDesigner2014 from working path: C:\Users\ADMINI~1\AppData\Local\Temp{14FCE06C-BAAF-4E42-8B47-9A2BAEE1EBFA}\SSISOneDesigner2014, error: 0x80070002.
[2AD4:4680][2020-08-26T13:47:09]e349: Application requested retry of payload: SSISOneDesigner2014, encountered error: 0x80070002. Retrying...
[2684:0D48][2020-08-26T13:47:10]i305: Verified acquired payload: SSISOneDesigner2014 at path: C:\ProgramData\Package Cache.unverified\SSISOneDesigner2014, moving to: C:\ProgramData\Package Cache{D5D68C12-ECF0-49BB-9722-DA964B722E08}v12.2.5556.0\payload\SSISOneDesigner2014.msi.
[2AD4:4680][2020-08-26T13:47:10]i000: MainViewModel.OnPackageActionProgress: Percent completed: 100, Overall progress: 58
[2AD4:4680][2020-08-26T13:47:10]i000: MainViewModel.OnPackageAction: Install CompletedDownload for package SQL Server Integration Services 2014 (id: SSISOneDesigner2014)
[2AD4:4680][2020-08-26T13:47:10]i000: MainViewModel.OnPackageAction: Install StartedDownload for package SQL Server Integration Services 2016 (id: SSISOneDesigner2016)
[2684:0D48][2020-08-26T13:47:10]e000: Error 0x80070002: Failed to find payload: SSISOneDesigner2016 in working path: C:\Users\ADMINI~1\AppData\Local\Temp{14FCE06C-BAAF-4E42-8B47-9A2BAEE1EBFA}\SSISOneDesigner2016 and unverified path: C:\ProgramData\Package Cache.unverified\SSISOneDesigner2016
[2684:0D48][2020-08-26T13:47:10]e000: Error 0x80070002: Failed to cache payload: SSISOneDesigner2016
[2AD4:4680][2020-08-26T13:47:10]e314: Failed to cache payload: SSISOneDesigner2016 from working path: C:\Users\ADMINI~1\AppData\Local\Temp{14FCE06C-BAAF-4E42-8B47-9A2BAEE1EBFA}\SSISOneDesigner2016, error: 0x80070002.
[2AD4:4680][2020-08-26T13:47:10]e349: Application requested retry of payload: SSISOneDesigner2016, encountered error: 0x80070002. Retrying...
[2684:0D48][2020-08-26T13:47:11]i305: Verified acquired payload: SSISOneDesigner2016 at path: C:\ProgramData\Package Cache.unverified\SSISOneDesigner2016, moving to: C:\ProgramData\Package Cache{A16CB865-1DD2-4FFC-910D-DC926ED448E3}v13.1.4495.10\payload\SSISOneDesigner2016.msi.
[2AD4:4680][2020-08-26T13:47:12]i000: MainViewModel.OnPackageActionProgress: Percent completed: 100, Overall progress: 68
[2AD4:4680][2020-08-26T13:47:12]i000: MainViewModel.OnPackageAction: Install CompletedDownload for package SQL Server Integration Services 2016 (id: SSISOneDesigner2016)
[2AD4:4680][2020-08-26T13:47:12]i000: MainViewModel.OnPackageAction: Install StartedDownload for package Microsoft SQL Server 2012 Analysis Management Objects (id: SQL_AS_AMO2012)
[2684:0D48][2020-08-26T13:47:12]e000: Error 0x80070002: Failed to find payload: SQL_AS_AMO2012 in working path: C:\Users\ADMINI~1\AppData\Local\Temp{14FCE06C-BAAF-4E42-8B47-9A2BAEE1EBFA}\SQL_AS_AMO2012 and unverified path: C:\ProgramData\Package Cache.unverified\SQL_AS_AMO2012
[2684:0D48][2020-08-26T13:47:12]e000: Error 0x80070002: Failed to cache payload: SQL_AS_AMO2012
[2AD4:4680][2020-08-26T13:47:12]e314: Failed to cache payload: SQL_AS_AMO2012 from working path: C:\Users\ADMINI~1\AppData\Local\Temp{14FCE06C-BAAF-4E42-8B47-9A2BAEE1EBFA}\SQL_AS_AMO2012, error: 0x80070002. -
Monalv-MSFT 5,896 Reputation points
2020-08-26T01:33:43.463+00:00 Hi Chaitanya Joshi,
Please try to download SSDT for VS 2017 (standalone installer).
Best Regards,
Mona----------
If the response is helpful, please click "Accept Answer" and upvote it.