About Me

My photo
I am an MCSE in Data Management and Analytics, specializing in MS SQL Server, and an MCP in Azure. With over 19+ years of experience in the IT industry, I bring expertise in data management, Azure Cloud, Data Center Migration, Infrastructure Architecture planning, as well as Virtualization and automation. I have a deep passion for driving innovation through infrastructure automation, particularly using Terraform for efficient provisioning. If you're looking for guidance on automating your infrastructure or have questions about Azure, SQL Server, or cloud migration, feel free to reach out. I often write to capture my own experiences and insights for future reference, but I hope that sharing these experiences through my blog will help others on their journey as well. Thank you for reading!

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.. 
Labels: ,