About Me

My photo
I am MCSE in Data Management and Analytics with specialization in MS SQL Server and MCP in Azure. I have over 13+ years of experience in IT industry with expertise in data management, Azure Cloud, Data-Canter Migration, Infrastructure Architecture planning and Virtualization and automation. Contact me if you are looking for any sort of guidance in getting your Infrastructure provisioning automated through Terraform. I sometime write for a place to store my own experiences for future search and read by own blog but can hopefully help others along the way. Thanks.

Failed to open file C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\devenv.exe.config.tmp

Issue:-

SQL Server 2008 R2 setup failed while update from SP1 to CU5



Reviewed summary.txt and found in summary.txt pointed this line..

Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20151003_081157\PWS\sql_bids_Cpu64_1.log.

Reviewed sql_bids_Cpu64_1.log with search string 


  Return value 3 or at Microsoft. [Very Very Important]

return value 3 pointed me here.. 

it says " The setup has encountered an unexpected error while Updating Installed Files." and the file Name was ---> C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\devenv.exe.config.tmp

<Func Name='LaunchFunction'>
Function=Do_sqlFileSR
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileSR
PerfTime Start: Do_sqlFileSR : Sat Oct 03 10:22:53 2015
<Func Name='Do_sqlFileSR'>
Failed to open file C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\devenv.exe.config.tmp
Error Code: 1603
MSI (s) (7C!24) [10:23:11:208]: Product: SQL Server 2008 R2 SP1 BI Development Studio -- Error 29528. The setup has encountered an unexpected error while Updating Installed Files. The error is: The system cannot find the file specified.


Error 29528. The setup has encountered an unexpected error while Updating Installed Files. The error is: The system cannot find the file specified.

<Failure Type='Fatal' Error='1603'>
<EndFunc Name='LaunchFunction' Return='1603' GetLastError='203'>
CustomAction Do_sqlFileSR_64 returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
MSI (s) (7C:A0) [10:23:11:224]: User policy value 'DisableRollback' is 0
MSI (s) (7C:A0) [10:23:11:224]: Machine policy value 'DisableRollback' is 0

Action ended 10:23:11: InstallFinalize. Return value 3.

Resolution:-
=============

On the same server, go to location -->C:\program files(x86) \Microsoft Visual Studio 9.0\Common7\IDE

Confirm that "devenv.exe.config.tmp" exists in the following path:

C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\devenv.exe.config.tmp 

- if not Copy the followiing
******From location  program files(x86) \Microsoft Visual Studio 9.0\Common7\IDE\Devenv.exe.config


******To location C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\  

              Devenv.exe.config - Rename to Devenv.exe.config.tmp in location -->:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\


The same will apply to C:\Program Files (x86)\Microsoft Visual Studio 10.0


After renaming of file Devenv.exe.config to  Devenv.exe.config.tmp, execute the setup again, setup will run successfully.




Thanks for Reading..