Hello.
I am attempting to install the first of the cumulative hotfix packages ( SQL2005-KB918222-x64-ENU.exe) after applying Service Pack 1 to a SQL Server 2005 std edn 64-bit installation. The service pack installed no problem but the hot fix fails with the following errors in the log file below.
I have installed the 32-bit versions of the hotfix packages onto a different server and I did not get these errors.
Any help on how to sort this out would be much appreciated!
08/23/2006 15:03:44.592 ================================================================================
08/23/2006 15:03:44.608 Hotfix package launched
08/23/2006 15:03:45.842 Product discovery successfully completed during the install process for MSSQLSERVER
08/23/2006 15:03:45.858 SP Level check successfully completed during the install process for MSSQLSERVER
08/23/2006 15:03:45.889 Product language check successfully completed during the install process for MSSQLSERVER
08/23/2006 15:03:45.905 Product version check successfully completed during the install process for MSSQLSERVER
08/23/2006 15:03:45.920 Command-line instance name check completed during the install process
08/23/2006 15:03:45.936 Baseline build check completed during the install process
08/23/2006 15:03:52.107 Attempting to install instance: MSSQLSERVER
08/23/2006 15:03:52.154 Attempting to install target: SRVLEBIZTALK
08/23/2006 15:03:52.170 Attempting to check for locked files: sqlrun_sql.msp
08/23/2006 15:03:52.232 Attempting to check for locked files: \\SRVLEBIZTALK\d$\dd32a156dacc8dbe70a862647d70\hotfixsql\Files\sqlrun_sql.msp
08/23/2006 15:03:52.248 Creating MSP locked file check log at: C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB918222_sqlrun_sql.msp.out
08/23/2006 15:04:02.107 MSP returned 1602: The user cancels installation.
08/23/2006 15:04:02.310 Successfully checked file: \\SRVLEBIZTALK\d$\dd32a156dacc8dbe70a862647d70\hotfixsql\Files\sqlrun_sql.msp
08/23/2006 15:04:02.326 Successfully opened registry key: System\CurrentControlSet\Control\Session Manager
08/23/2006 15:04:02.357 Failed to read registry key: PendingFileRenameOperations
08/23/2006 15:04:02.373 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xmlfilt.dll
08/23/2006 15:04:02.388 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\ThaWBrkr.dll
08/23/2006 15:04:02.435 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\query.dll
08/23/2006 15:04:02.451 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\nls400.dll.
--
It carries on with errors like the above but my post will be massive if I include it all, so below is the last few lines of the log file.
--
08/23/2006 15:04:07.591 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\Microsoft.SqlSac.Public.dll
08/23/2006 15:04:07.653 Attempting to install file: sqlrun_sql.msp
08/23/2006 15:04:07.700 Attempting to install file: \\SRVLEBIZTALK\d$\dd32a156dacc8dbe70a862647d70\hotfixsql\Files\sqlrun_sql.msp
08/23/2006 15:04:07.716 Creating MSP install log file at: C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB918222_sqlrun_sql.msp.log
08/23/2006 15:04:07.732 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
08/23/2006 15:04:07.747 Failed to read registry key: Debug
08/23/2006 15:05:11.197 MSP returned 1603: A fatal error occurred during installation.
08/23/2006 15:05:11.212 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
08/23/2006 15:05:11.244 Failed to read registry key: Debug
08/23/2006 15:05:11.259 Unable to install MSP file: \\SRVLEBIZTALK\d$\dd32a156dacc8dbe70a862647d70\hotfixsql\Files\sqlrun_sql.msp
08/23/2006 15:05:11.275 The following exception occurred: Unable to install Windows Installer MSP file Date: 08/23/2006 15:05:11.275 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 856
08/23/2006 15:05:11.322
08/23/2006 15:05:11.353 Product Status Summary:
08/23/2006 15:05:11.369 Product: SQL Server Database Services 2005 (64-bit)
08/23/2006 15:05:11.384 MSSQLSERVER - Failure
08/23/2006 15:05:11.415 Details: Unable to install Windows Installer MSP file
These "failed to read associated hotfix version" error messages are misleading and do not necessary denote a failed install. I've had lots of successful installs that also contained these messages. Can you search you %WINDIR%\hotfix\hotfixsql\Files\sqlrun_sql.msp log for the text string "value 3" and see if there is a more descriptive message?
Thanks,
Sam Lester (MSFT)
Are you installing the hotfixes in the correct order?
SQL Server 2005
SQL Server 2005 Analysis Services
SQL Server 2005 Integration Services
SQL Server 2005 Notification Services
SQL Server 2005 Reporting Services
SQL Server 2005 Tools
http://support.microsoft.com/kb/919224/
|||I am also getting the same error with Enterprise Edition on a cluster while installing build 2153.
The first remote node is successful and then the local node fails
11/02/2006 16:26:51.032 ================================================================================
11/02/2006 16:26:51.042 Hotfix package launched
11/02/2006 16:26:53.009 Product discovery successfully completed during the install process for MSSQLSERVER
11/02/2006 16:26:53.020 SP Level check successfully completed during the install process for MSSQLSERVER
11/02/2006 16:26:53.030 Product language check successfully completed during the install process for MSSQLSERVER
11/02/2006 16:26:53.040 Product version check successfully completed during the install process for MSSQLSERVER
11/02/2006 16:26:53.227 Product discovery successfully completed during the install process for VSQL06
11/02/2006 16:26:53.237 SP Level check successfully completed during the install process for VSQL06
11/02/2006 16:26:53.258 Product language check successfully completed during the install process for VSQL06
11/02/2006 16:26:53.268 Product version check successfully completed during the install process for VSQL06
11/02/2006 16:26:53.278 Command-line instance name check completed during the install process
11/02/2006 16:26:53.320 Baseline build check completed during the install process
11/02/2006 16:27:49.750 Attempting to install instance: MSSQLSERVER
11/02/2006 16:27:49.781 Enumerating passive cluster nodes
11/02/2006 16:27:49.812 Patching available passive node: FMEZ1TMP201
11/02/2006 16:27:49.823 Attempting to patch running passive node: FMEZ1TMP201
11/02/2006 16:27:49.833 Waiting for first successfully completed passive node
11/02/2006 16:27:49.916 Successfully created remote folder for product instance target \\FMEZ1TMP201
11/02/2006 16:27:51.666 Successfully transferred payload to remote product instance target \\FMEZ1TMP201
11/02/2006 16:27:51.676 Successfully transferred payload to remote product instance target \\FMEZ1TMP201
11/02/2006 16:27:51.718 Successfully created new scheduled task for product instance target \\FMEZ1TMP201
11/02/2006 16:27:52.453 Successfully saved new scheduled task for product instance target \\FMEZ1TMP201
11/02/2006 16:27:52.484 Successfully created scheduled task for product instance target \\FMEZ1TMP201
11/02/2006 16:27:52.505 Successfully started scheduled task for product instance target \\FMEZ1TMP201
11/02/2006 16:27:52.515 Successfully started scheduled task for product instance target \\FMEZ1TMP201
11/02/2006 16:30:23.543 Scheduled task for product instance target has completed
11/02/2006 16:30:23.563 Waiting for exit code from scheduled task for product instance target \\FMEZ1TMP201
11/02/2006 16:30:28.581 Received exit code 0 from scheduled task for product instance target \\FMEZ1TMP201
11/02/2006 16:30:28.591 Result code for scheduled task for product instance target has been received
11/02/2006 16:30:28.611 Removed scheduled task for product instance target \\FMEZ1TMP201
11/02/2006 16:30:28.911 Successfully removed remote folder for product instance target \\FMEZ1TMP201
11/02/2006 16:30:28.931 Remote process completed for product instance target
11/02/2006 16:30:28.941 Exit code for passive node: FMEZ1TMP201 = 0
11/02/2006 16:30:30.941 First successful passive node has been completed
11/02/2006 16:30:30.961 Attempting to install target: FMEZ1TMP200
11/02/2006 16:30:35.190 Attempting to check for locked files: sqlrun_sql.msp
11/02/2006 16:30:35.240 Attempting to check for locked files: \\FMEZ1TMP200\c$\4abf7684d30ce4aeb614ce\hotfixsql\Files\sqlrun_sql.msp
11/02/2006 16:30:35.260 Creating MSP locked file check log at: C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB918222_sqlrun_sql.msp.out
11/02/2006 16:31:03.862 MSP returned 1602: The user cancels installation.
11/02/2006 16:31:04.101 Successfully checked file: \\FMEZ1TMP200\c$\4abf7684d30ce4aeb614ce\hotfixsql\Files\sqlrun_sql.msp
11/02/2006 16:31:04.121 Successfully opened registry key: System\CurrentControlSet\Control\Session Manager
11/02/2006 16:31:04.141 Failed to read registry key: PendingFileRenameOperations
11/02/2006 16:31:04.151 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xmlfilt.dll
~~~~~~~~
~~~~~~~~
11/02/2006 16:31:08.180 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\Microsoft.SqlSac.Public.dll
11/02/2006 16:31:08.300 Attempting to install file: sqlrun_sql.msp
11/02/2006 16:31:08.360 Attempting to install file: \\FMEZ1TMP200\c$\4abf7684d30ce4aeb614ce\hotfixsql\Files\sqlrun_sql.msp
11/02/2006 16:31:08.370 Creating MSP install log file at: C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB918222_sqlrun_sql.msp.log
11/02/2006 16:31:08.380 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
11/02/2006 16:31:08.400 Failed to read registry key: Debug
11/02/2006 16:33:02.798 MSP returned 1603: A fatal error occurred during installation.
11/02/2006 16:33:03.098 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
11/02/2006 16:33:03.108 Failed to read registry key: Debug
11/02/2006 16:33:03.128 Unable to install MSP file: \\FMEZ1TMP200\c$\4abf7684d30ce4aeb614ce\hotfixsql\Files\sqlrun_sql.msp
11/02/2006 16:33:03.138 The following exception occurred: Unable to install Windows Installer MSP file Date: 11/02/2006 16:33:03.138 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 856
11/02/2006 16:33:03.218
11/02/2006 16:33:03.228 Product Status Summary:
11/02/2006 16:33:03.248 Product: SQL Server Database Services 2005 (64-bit)
11/02/2006 16:33:03.258 MSSQLSERVER - Failure
11/02/2006 16:33:03.278 Details: Unable to install Windows Installer MSP file
11/02/2006 16:33:03.288 VSQL06 - Not Selected
11/02/2006 16:33:03.308
11/02/2006 16:37:36.262 Hotfix package closed
Any ideas?
|||From the hotfix log it may appear that these two issues are the same, however, 1603 is a generic error code for MSP installation which basically just means the install failed. You have to look specifically in the log generated for the MSP to determine the actual cause of failure.
It turns out though that the log with the error for both reports will be located here:
C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB918222_sqlrun_sql.msp.log
You can determine this from these lines in the hotfix log:
11/02/2006 16:31:08.300 Attempting to install file: sqlrun_sql.msp
11/02/2006 16:31:08.360 Attempting to install file: \\FMEZ1TMP200\c$\4abf7684d30ce4aeb614ce\hotfixsql\Files\sqlrun_sql.msp
11/02/2006 16:31:08.370 Creating MSP install log file at: C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB918222_sqlrun_sql.msp.log
As Sam suggests, search for "value 3" to try and locate the specific issue causing the failure in both cases. Once you have located it, please post the details so we can troubleshoot this further. Thanks!!
|||
bobbins wrote:
Hello.
I am attempting to install the first of the cumulative hotfix packages ( SQL2005-KB918222-x64-ENU.exe) after applying Service Pack 1 to a SQL Server 2005 std edn 64-bit installation. The service pack installed no problem but the hot fix fails with the following errors in the log file below.
I have installed the 32-bit versions of the hotfix packages onto a different server and I did not get these errors.
Any help on how to sort this out would be much appreciated!
08/23/2006 15:03:44.592 ================================================================================
08/23/2006 15:03:44.608 Hotfix package launched
08/23/2006 15:03:45.842 Product discovery successfully completed during the install process for MSSQLSERVER
08/23/2006 15:03:45.858 SP Level check successfully completed during the install process for MSSQLSERVER
08/23/2006 15:03:45.889 Product language check successfully completed during the install process for MSSQLSERVER
08/23/2006 15:03:45.905 Product version check successfully completed during the install process for MSSQLSERVER
08/23/2006 15:03:45.920 Command-line instance name check completed during the install process
08/23/2006 15:03:45.936 Baseline build check completed during the install process
08/23/2006 15:03:52.107 Attempting to install instance: MSSQLSERVER
08/23/2006 15:03:52.154 Attempting to install target: SRVLEBIZTALK
08/23/2006 15:03:52.170 Attempting to check for locked files: sqlrun_sql.msp
08/23/2006 15:03:52.232 Attempting to check for locked files: \\SRVLEBIZTALK\d$\dd32a156dacc8dbe70a862647d70\hotfixsql\Files\sqlrun_sql.msp
08/23/2006 15:03:52.248 Creating MSP locked file check log at: C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB918222_sqlrun_sql.msp.out
08/23/2006 15:04:02.107 MSP returned 1602: The user cancels installation.
08/23/2006 15:04:02.310 Successfully checked file: \\SRVLEBIZTALK\d$\dd32a156dacc8dbe70a862647d70\hotfixsql\Files\sqlrun_sql.msp
08/23/2006 15:04:02.326 Successfully opened registry key: System\CurrentControlSet\Control\Session Manager
08/23/2006 15:04:02.357 Failed to read registry key: PendingFileRenameOperations
08/23/2006 15:04:02.373 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xmlfilt.dll
08/23/2006 15:04:02.388 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\ThaWBrkr.dll
08/23/2006 15:04:02.435 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\query.dll
08/23/2006 15:04:02.451 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\nls400.dll.--
It carries on with errors like the above but my post will be massive if I include it all, so below is the last few lines of the log file.
--
08/23/2006 15:04:07.591 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\Microsoft.SqlSac.Public.dll
08/23/2006 15:04:07.653 Attempting to install file: sqlrun_sql.msp
08/23/2006 15:04:07.700 Attempting to install file: \\SRVLEBIZTALK\d$\dd32a156dacc8dbe70a862647d70\hotfixsql\Files\sqlrun_sql.msp
08/23/2006 15:04:07.716 Creating MSP install log file at: C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB918222_sqlrun_sql.msp.log
08/23/2006 15:04:07.732 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
08/23/2006 15:04:07.747 Failed to read registry key: Debug
08/23/2006 15:05:11.197 MSP returned 1603: A fatal error occurred during installation.
08/23/2006 15:05:11.212 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
08/23/2006 15:05:11.244 Failed to read registry key: Debug
08/23/2006 15:05:11.259 Unable to install MSP file: \\SRVLEBIZTALK\d$\dd32a156dacc8dbe70a862647d70\hotfixsql\Files\sqlrun_sql.msp
08/23/2006 15:05:11.275 The following exception occurred: Unable to install Windows Installer MSP file Date: 08/23/2006 15:05:11.275 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 856
08/23/2006 15:05:11.322
08/23/2006 15:05:11.353 Product Status Summary:
08/23/2006 15:05:11.369 Product: SQL Server Database Services 2005 (64-bit)
08/23/2006 15:05:11.384 MSSQLSERVER - Failure
08/23/2006 15:05:11.415 Details: Unable to install Windows Installer MSP file
No comments:
Post a Comment