Extracting Sql: Failed Install of SQL Server 2005 SP1 CTP

Hello,

We are attempting to install the CTP for SQL Server 2005 SP1 and receive the following error message in the log:

The following exception occurred: Unable to install Windows Installer MSP file Date: 03/24/2006 14:19:40.562 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 856This is

then followed by this failure with the Database Services:

Product: Database Services Database Services (RTM 1399 ENU)- Failure Details: Unable to install Windows Installer MSP file

I also found the following entry in the SQL9_Hotfix_KB913090_sqlrun_sqlmsp.log file:

SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.

Thanks in advance for any assistance, --John

This is puzzling. We found and fixed one bug generating the first error before releasing the CTP. Could you describe your installation and post a link to the setup log files? I think someone will need to pore over them to understand the problem.|||

Could you go ahead and log a bug using: http://lab.msdn.microsoft.com/ProductFeedback ?

|||I'm getting the same error with the final release.|||

Kevin, can you attach your msp log as well? The file is SQL9_Hotfix_KB913090_sqlrun_sql.msp.log. Are you applying SP1 to an RTM install or did you apply a previous SP1 build along the way?

Thanks,
Samuel Lester (MSFT)

|||Samuel, I just attempted to run the new SP1 and got the same problem as the original post (regarding "dm_exec_query_resource_semaphore"). I also found in the log file the same problem with the object named dm_exec_query_memory_grants.|||

Glenn, can you supply me with the log file I referenced above? This may help us determine why the object seems to be having permission issues.

Thanks,
Samuel Lester (MSFT)

|||I'm getting the same error, here's the tail of my log file (the whole thing is about 9MB, cant really post that :/)

Property(S): SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.
Property(S): UpgradeInstruction = Connect to SQL instance SRVHAM14 as sysadmin
Launch SQL statement USE master
Launch script file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\sysdbupg.sql
Launch script file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\DbEngine_hotfix_install.sql
Launch script file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\repl_hotfix_install.sql
Stop service MSSQLSERVER
MSI (s) (20:A4) [13:56:22:544]: Product: Microsoft SQL Server 2005 (64-bit) - Update 'Service Pack 1 for SQL Server Database Services 2005 (64-bit) ENU (KB913090)' could not be installed. Error code 1603. Additional information is available in the log file C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.log.

MSI (s) (20:A4) [13:56:22:544]: Note: 1: 1729
MSI (s) (20:A4) [13:56:22:544]: Transforming table Error.

MSI (s) (20:A4) [13:56:22:544]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (20:A4) [13:56:22:544]: Transforming table Error.

MSI (s) (20:A4) [13:56:22:544]: Transforming table Error.

MSI (s) (20:A4) [13:56:22:544]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (20:A4) [13:56:22:544]: Transforming table Error.

MSI (s) (20:A4) [13:56:22:544]: Transforming table Error.

MSI (s) (20:A4) [13:56:22:544]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (20:A4) [13:56:22:544]: Transforming table Error.

MSI (s) (20:A4) [13:56:22:544]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (20:A4) [13:56:22:560]: Product: Microsoft SQL Server 2005 (64-bit) -- Configuration failed.

MSI (s) (20:A4) [13:56:22:560]: Attempting to delete file C:\WINDOWS\Installer\4aaf165.msp
MSI (s) (20:A4) [13:56:22:575]: Cleaning up uninstalled install packages, if any exist
MSI (s) (20:A4) [13:56:22:575]: Post-install cleanup: removing installer file 'C:\WINDOWS\Installer\4aaf165.msp'
MSI (s) (20:A4) [13:56:22:575]: MainEngineThread is returning 1603
MSI (s) (20:98) [13:56:22:575]: Destroying RemoteAPI object.
MSI (s) (20:0C) [13:56:22:575]: Custom Action Manager thread ending.
=== Logging stopped: 21/04/2006 13:56:22 ===
MSI (c) (58:60) [13:56:22:606]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (58:60) [13:56:22:606]: MainEngineThread is returning 1603
=== Verbose logging stopped: 21/04/2006 13:56:22 ===

|||Little more, first time the error shows up in the logs:

SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect
sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.
sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english.

<Started SQL statement: Fri Apr 21 13:56:07 2006> USE master
SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batch
sqlstate=01000, level=0, state=1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.

<Finished SQL statement: Fri Apr 21 13:56:07 2006>
<Started SQL script: Fri Apr 21 13:56:07 2006> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\sysdbupg.sql
Open file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\sysdbupg.sql in Unicode mode
SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batch
sqlstate=01000, level=0, state=1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.

SQL_ERROR (-1) in OdbcStatement::execute_batch
sqlstate=42000, level=16, state=1, native_error=15151, msg=[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.
sqlstate=42000, level=16, state=1, native_error=15151, msg=[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_memory_grants', because it does not exist or you do not have permission.

|||Ok, some more digging into the upgrade scripts reveals this as the offending query (sysdbupg.sql):

-- Grant SELECT on Shiloh views to PUBLIC (only if they were not explicitely denied)
--
use master
go

set nocount on
set implicit_transactions off
set ansi_nulls on -- default for osql (consistent for suites)
set quoted_identifier on -- Force all ye devs to do this correctly!
go

-- temporary grant select to QE dmv
GRANT SELECT on sys.dm_exec_query_resource_semaphores TO PUBLIC
GRANT SELECT on sys.dm_exec_query_memory_grants TO PUBLIC

The error tells us that either these dont exist, or we dont have permission to them... And I believe they don't exist (certainly not post failed upgrade anyway). If there's another part of the upgrade that's supposed to create those table valued functions, it isn't doing so.
|||

Hey,

I also am getting this error on attempting to install Microsoft SQL Server 2005 Service Pack 1. :(

That is "Unable to install Windows Installer MSP file" .

I do not see any "SQL9_Hotfix_KB913090_sqlrun_sql.msp.log" file.

On my system it is "Redist9_Hotfix_KB913090_SqlSupport.msp.log". At least according to the event log:

"Product: Microsoft SQL Server Setup Support Files (English) - Update '{EE92F683-5F5C-4970-BB0B-9AC591B60268}' could not be installed. Error code 1642. Additional information is available in the log file C:\WINNT\Hotfix\Redist9\Logs\Redist9_Hotfix_KB913090_SqlSupport.msp.log."

So here is the log file:

=== Verbose logging started: 4/21/2006 12:23:36 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:\WINNT\system32\msiexec.exe ===
MSI (c) (A4:58) [12:23:36:625]: Resetting cached policy values
MSI (c) (A4:58) [12:23:36:625]: Machine policy value 'Debug' is 0
MSI (c) (A4:58) [12:23:36:625]: ******* RunEngine:
******* Product: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
******* Action:
******* CommandLine: **********
MSI (c) (A4:58) [12:23:36:625]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (A4:58) [12:23:36:625]: Grabbed execution mutex.
MSI (c) (A4:58) [12:23:36:640]: Cloaking enabled.
MSI (c) (A4:58) [12:23:36:640]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (A4:58) [12:23:36:640]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (4C:6C) [12:23:36:640]: Grabbed execution mutex.
MSI (s) (4C:EC) [12:23:36:640]: Resetting cached policy values
MSI (s) (4C:EC) [12:23:36:640]: Machine policy value 'Debug' is 0
MSI (s) (4C:EC) [12:23:36:640]: ******* RunEngine:
******* Product: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
******* Action:
******* CommandLine: **********
MSI (s) (4C:EC) [12:23:36:640]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (4C:EC) [12:23:36:656]: End dialog not enabled
MSI (s) (4C:EC) [12:23:36:656]: Original package ==> C:\WINNT\Installer\1f5f617.msi
MSI (s) (4C:EC) [12:23:36:656]: Package we're running from ==> C:\WINNT\Installer\1f5f617.msi
MSI (s) (4C:EC) [12:23:36:656]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
MSI (s) (4C:EC) [12:23:36:656]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (4C:EC) [12:23:36:656]: MSCOREE already loaded, using loaded copy
MSI (s) (4C:EC) [12:23:36:671]: File will have security applied from OpCode.
MSI (s) (4C:EC) [12:23:36:718]: Original patch ==> d:\857d69c78de19fc05980be8d2cc8\HotFixSqlSupport\Files\SqlSupport.msp
MSI (s) (4C:EC) [12:23:36:718]: Patch we're running from ==> C:\WINNT\Installer\1f5f686.msp
MSI (s) (4C:EC) [12:23:36:718]: SOFTWARE RESTRICTION POLICY: Verifying patch --> 'd:\857d69c78de19fc05980be8d2cc8\HotFixSqlSupport\Files\SqlSupport.msp' against software restriction policy
MSI (s) (4C:EC) [12:23:36:718]: Note: 1: 2262 2: DigitalSignature 3: -2147287038
MSI (s) (4C:EC) [12:23:36:718]: SOFTWARE RESTRICTION POLICY: d:\857d69c78de19fc05980be8d2cc8\HotFixSqlSupport\Files\SqlSupport.msp is not digitally signed
MSI (s) (4C:EC) [12:23:36:718]: SOFTWARE RESTRICTION POLICY: d:\857d69c78de19fc05980be8d2cc8\HotFixSqlSupport\Files\SqlSupport.msp is permitted to run at the 'unrestricted' authorization level.
MSI (s) (4C:EC) [12:23:36:718]: SequencePatches starts. Product code: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}, Product version: 9.00.2047.00, Upgrade code: {3A91FA19-A197-467C-850F-0AFE90899371}, Product language 1033
MSI (s) (4C:EC) [12:23:36:718]: PATCH SEQUENCER WARNING: d:\857d69c78de19fc05980be8d2cc8\HotFixSqlSupport\Files\SqlSupport.msp patch will not be sequenced because it does not contain any transform that may apply to product!
MSI (s) (4C:EC) [12:23:36:718]: SequencePatches returns success.
MSI (s) (4C:EC) [12:23:36:718]: Final Patch Application Order:
MSI (s) (4C:EC) [12:23:36:718]: Other Patches:
MSI (s) (4C:EC) [12:23:36:718]: Unknown\Absent: {EE92F683-5F5C-4970-BB0B-9AC591B60268} - d:\857d69c78de19fc05980be8d2cc8\HotFixSqlSupport\Files\SqlSupport.msp
MSI (s) (4C:EC) [12:23:36:734]: Product: Microsoft SQL Server Setup Support Files (English) - Update '{EE92F683-5F5C-4970-BB0B-9AC591B60268}' could not be installed. Error code 1642. Additional information is available in the log file C:\WINNT\Hotfix\Redist9\Logs\Redist9_Hotfix_KB913090_SqlSupport.msp.log.

MSI (s) (4C:EC) [12:23:36:734]: Note: 1: 1708
MSI (s) (4C:EC) [12:23:36:734]: Note: 1: 2729
MSI (s) (4C:EC) [12:23:36:734]: Note: 1: 2729
MSI (s) (4C:EC) [12:23:36:734]: Product: Microsoft SQL Server Setup Support Files (English) -- Installation failed.

MSI (s) (4C:EC) [12:23:36:734]: Attempting to delete file C:\WINNT\Installer\1f5f686.msp
MSI (s) (4C:EC) [12:23:36:750]: MainEngineThread is returning 1642
The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer an
d that you have the correct upgrade patch.
C:\WINNT\Installer\1f5f617.msi
MSI (c) (A4:58) [12:23:36:750]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (A4:58) [12:23:36:750]: MainEngineThread is returning 1642
=== Verbose logging stopped: 4/21/2006 12:23:36 ===

Yes I am sure I am installing the right patch. Just downloaded from here:

http://www.microsoft.com/downloads/details.aspx?familyid=CB6C71EA-D649-47FF-9176-E7CAC58FD4BC&displaylang=en

At the start of setup it even shows that it can update all the installed products to SP1.

So far I have tried everything. I even completely uninstalled Visual Studio 2005 professional, along with .net 2.0, etc. Everything on the uninstall page:

http://msdn.microsoft.com/vstudio/express/support/uninstall/

So I started all over again, and once again SP1 fails to install with the same error as everyone else. :(

Any help would be great.

Thanks a lot,

Will

|||

After you get the 'dm_exec_query_resource_semaphores' error and the installer cancels out, can you try to apply SP1 a second time? Does that attempt also fail with the same message?

Thanks,
Samuel Lester (MSFT)

|||

Samuel,

I too am getting the MSP error. I did sucessfully install SP1 to SQL 2005 Express prior to my attempt to update SQL 2005 Developer Edition. I have uninstalled SQL 2005 Express and tried to apply SP1 to SQL 2005 Server DE, but get the same error.

I have logs - where would you like me to mail them?

bill burrows

|||

Samuel, the site http://lab.msdn.microsoft.com/ProductFeedback would not allow me to post this issue. So, I have included the following lines from the log file SQLSetup0012_<mycomputername>_SQL.log:

SQL_ERROR (-1) in OdbcStatement::execute_batch

sqlstate=42000, level=16, state=1, native_error=15151, msg=[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.

sqlstate=42000, level=16, state=1, native_error=15151, msg=[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_memory_grants', because it does not exist or you do not have permission.

Error Code: 0x80073b2f (15151)

Windows Error Text: Source File Name: lib\odbc_statement.h

Compiler Timestamp: Wed Oct 26 16:37:41 2005

Function Name: OdbcStatement::execute_batch@.sysdbupg.sql@.2

Source Line Number: 91

Error Code: 15151

MSI (s) (B4!8C) [16:45:40:458]: Product: Microsoft SQL Server 2005 -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. Refer to the server error logs and Setup logs for detailed error information.

Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. Refer to the server error logs and Setup logs for detailed error information.

I hope this helps!

Glenn

|||I have attempted to run SP1 (for SQL Express) 3 times; each time with the same error. Also, I initially installed SP1 for SQL Server 2005 with no problems.

Monday, March 19, 2012

Failed Install of SQL Server 2005 SP1 CTP

No comments:

Post a Comment

Extracting Sql

Blog Archive

About Me