While installing security patch KB 948109 on the sql server 2005, the installation of the patch may fail. In order to find the cause of the failure we need to look into the setup bootstrap logs which are located in the following location
C:Progarm FilesMicrosoft Sql Server90Setup BootstrapLOGHotfixSummary.txt
One of the cause of the failure can be Error 11032 which is reported in the summary.txt as shown
***********************************************************************
Product Installation Status
Product : SQL Server Database Services 2005 (SQLCMSP6)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB948109_sqlrun_sql.msp.log
Error Number : 11032
Error Description : Unable to install Windows Installer MSP file
———————————————————————–
Product : SQL Server Analysis Services 2005 (SQLCMSP6)
Product Version (Previous): 3042
Product Version (Final) : 3068
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB948109_sqlrun_as.msp.log
Error Number : 0
Error Description :
———————————————————————————-
Product : SQL Server Reporting Services 2005 (SQLCMSP6)
Product Version (Previous): 3042
Product Version (Final) : 3068
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB948109_sqlrun_rs.msp.log
Error Number : 0
Error Description :
———————————————————————–
CAUSE:
====================
During the installation of the Hotfix (948109 in my case) the Windows installer looks for the folder FTData in the location c:Program filesMicrosoft sql serverMSSQL.XMSSQLFTdata.
However if the FTData folder has been willingly or unknowingly deleted from the location c:Program filesMicrosoft sql serverMSSQL.XMSSQL. then the setup of the HotFix may fail with error 11032 and following error will reported in the HotFix.log and SQL9_Hotfix_KB948109_sqlrun_sql.msp.log.
HotFix.log
=====
18/2008 18:08:30.614 Registry: Opened registry key “SoftwarePoliciesMicrosoftWindowsInstaller”
08/18/2008 18:08:30.632 Registry: Cannot read registry key value “Debug”
08/18/2008 18:10:02.595 MSP returned 1603: A fatal error occurred during installation.
08/18/2008 18:10:03.057 Registry: Opened registry key “SoftwarePoliciesMicrosoftWindowsInstaller”
08/18/2008 18:10:03.075 Registry: Cannot read registry key value “Debug”
08/18/2008 18:10:04.205 Copy Engine: Error, unable to install MSP file: e:73ee7eecf2f2f0aa67706f3eHotFixSQLFilessqlrun_sql.msp
08/18/2008 18:10:04.222 The following exception occurred: Unable to install Windows Installer MSP file Date: 08/18/2008 18:10:04.222 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 807
08/18/2008 18:10:09.275 Watson: Param1 = Unknown
08/18/2008 18:10:09.344 Watson: Param2 = 0x2b18
08/18/2008 18:10:09.378 Watson: Param3 = Unknown
08/18/2008 18:10:09.446 Watson: Param4 = 0x0
08/18/2008 18:10:09.481 Watson: Param5 = copyengine.cpp@807
08/18/2008 18:10:09.498 Watson: Param6 = Unknown
08/18/2008 18:10:09.515 Watson: Param7 = SQL9
08/18/2008 18:10:09.532 Watson: Param8 = @
08/18/2008 18:10:09.566 Watson: Param9 = x86
08/18/2008 18:10:09.583 Watson: Param10 = 3068
08/18/2008 18:10:09.601 Installed product: SQL9
08/18/2008 18:10:09.618 Installing product: OLAP9
08/18/2008 18:10:09.875 Registry: Opened registry key “SoftwareMicrosoftWindowsCurrentVersionUninstall”
08/18/2008 18:10:09.926 Installing instance: SQLCMSP6
08/18/2008 18:10:09.960 Installing target: KDESQLDBOP6
08/18/2008 18:10:09.995 Stopping service: MSOLAP$SQLCMSP6
08/18/2008 18:10:17.103 Stopped service: MSOLAP$SQLCMSP6
08/18/2008 18:10:17.137 Installing file: sqlrun_as.msp
08/18/2008 18:10:17.154 Copy Engine: Creating MSP install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB948109_sqlrun_as.msp.log
08/18/2008 18:10:17.171 Registry: Opened registry key “SoftwarePoliciesMicrosoftWindowsInstaller”
08/18/2008 18:10:17.189 Registry: Cannot read registry key value “Debug”
08/18/2008 18:11:23.909 MSP returned 0: The action completed successfully.
SQL9_Hotfix_KB948109_sqlrun_sql.msp.log.
==================================
MSI (s) (48:50) [18:24:03:651]: Executing op: CustomActionSchedule(Action=CAFTEInstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1025,Source=BinaryData,Target=InstallFTERef,CustomActionData=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef|C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData)
MSI (s) (48:9C) [18:24:03:667]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI416.tmp, Entrypoint: InstallFTERef
FTECa.DLL: INFO: FTE: InstallFTERef(), Entering…
FTECa.DLL: INFO: FTE: GetFTERefInstallParams: FTERef : C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTDataFTECa.DLL: ERROR: FTE: InstallFTERef: Fail to create FTERef file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTDatanoiseCHS.txt, Err=3
MSI (s) (48:50) [18:24:04:763]: User policy value ‘DisableRollback’ is 0
MSI (s) (48:50) [18:24:04:763]: Machine policy value ‘DisableRollback’ is 0
Action ended 18:24:04: InstallFinalize. Return value 3.
RESOLUTION/WORKAROUND:
====================
We need to create empty FTData folder in the location C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData (in my case) and rerun the setup and the setup runs fine without any errors
it worked thanks aton
This worked. THANK YOU!!!!!!!!!!!!!!!!!!!!!!!