2008R2 SP3 wont install

Trying to upgrade 2008R2 to SP3 on a Windows 7 machine

passes all the preflight checks and starts the install, then fails with 'update operation complete with failures'

Can anyone help?

The summary log says 

Instance ACT7 overall summary:
  Final result:                  The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
  Exit code (Decimal):           -2068024447
  Exit facility code:            1212
  Exit error code:               29569
  Exit message:                  The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
  Start time:                    2015-07-13 15:25:40
  End time:                      2015-07-13 15:26:11
  Requested action:              Patch
  Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20150713_152431\ACT7\sql_engine_core_inst_Cpu64_1.log
  Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.6000.34


Interesting bits in the sql_engine_core_inst_Cpu64_1.log (can't find how to attach the file sorry)

MSI (s) (24:E4) [15:26:09:466]: Doing action: FindRelatedProducts
Action ended 15:26:09: Do_LogInstallStart_64. Return value 1.
MSI (s) (24:E4) [15:26:09:466]: Skipping FindRelatedProducts action: not run in maintenance mode
Action start 15:26:09: FindRelatedProducts.
MSI (s) (24:E4) [15:26:09:466]: Doing action: AppSearch
Action ended 15:26:09: FindRelatedProducts. Return value 0.
Action start 15:26:09: AppSearch.
MSI (s) (24:E4) [15:26:09:466]: Note: 1: 1325 2: v2.0.50727 
MSI (s) (24:E4) [15:26:09:466]: Note: 1: 1325 2: EventLogMessages.dll 
MSI (s) (24:E4) [15:26:09:466]: PROPERTY CHANGE: Adding ASPNET_EVENTLOGDLL property. Its value is 'C:\Windows\Microsoft.NET\Framework64\v2.0.50727\EventLogMessages.dll'.
MSI (s) (24:E4) [15:26:09:466]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\\Setup 3: 2 
MSI (s) (24:E4) [15:26:09:466]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{FBD367D1-642F-47CF-B79B-9BE48FB34007} 3: 2 
MSI (s) (24:E4) [15:26:09:466]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE32\SOFTWARE\Microsoft\VisualStudio\9.0 3: 2 
MSI (s) (24:E4) [15:26:09:466]: Note: 1: 1325 2: SQLServer2008R2 
MSI (s) (24:E4) [15:26:09:466]: PROPERTY CHANGE: Adding SQLSETUPARPWRAPPER property. Its value is 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x64\SetupARP.exe'.
MSI (s) (24:E4) [15:26:09:466]: Doing action: RestoreSetupParams_64
Action ended 15:26:09: AppSearch. Return value 1.
MSI (s) (24:E4) [15:26:09:481]: Note: 1: 2235 2:  3: ExtendedType 4: SELECT `Action`,`Type`,`Source`,`Target`, NULL, `ExtendedType` FROM `CustomAction` WHERE `Action` = 'RestoreSetupParams_64' 
MSI (s) (24:B0) [15:26:09:481]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI65EF.tmp, Entrypoint: RestoreSetupParams
Action start 15:26:09: RestoreSetupParams_64.
<Func Name='LaunchFunction'>
Function=RestoreSetupParams
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: RestoreSetupParams
PerfTime Start: RestoreSetupParams : Mon Jul 13 15:26:09 2015
<Func Name='RestoreSetupParams'>
        Error Code: 0x80077381 (29569)
Windows Error Text:   Source File Name: sqlca\sqlcax.cpp
Compiler Timestamp: Wed Mar 31 02:36:24 2010
     Function Name: RestoreSetupParams
Source Line Number: 190

Error Code: 29569
MSI (s) (24!A0) [15:26:10:745]: Product: SQL Server 2008 R2 SP2 Database Engine Services -- Error 29569. SQL Server Setup failed to restore the instance id.
Error 29569. SQL Server Setup failed to restore the instance id.
<Failure Type='Fatal' Error='29569'>
<EndFunc Name='LaunchFunction' Return='29569' GetLastError='203'>
CustomAction RestoreSetupParams_64 returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Action ended 15:26:10: RestoreSetupParams_64. Return value 3.
Action ended 15:26:10: INSTALL. Return value 3.
Property(S): Installed = 00:00:00

July 13th, 2015 1:36am

share following
  • summary.txt
  • sql_as_Cpu32_1.log
  • sql_rs_Cpu32_1.log
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2015 6:11am

Hello,

Please share with us the content of the following file:

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20150713_152431\ACT7\sql_engine_core_inst_Cpu64_1.log

Repairing the instance may work on this scenario.

https://msdn.microsoft.com/en-us/library/Cc646006(v=sql.105).aspx  

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

July 13th, 2015 10:46am

Thank you, I will try that

Here is a link to the log 

https://onedrive.live.com/redir?resid=4A7A28F6B5C0295D!2218&authkey=!ABWn2OwBs8apKqk&ithint=file%2clog


Free Windows Admin Tool Kit Click here and download it now
July 14th, 2015 1:13am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics