Errors using the uninstall tool - 'vs_uninst_betas'

Hi Folks

getting the following error message when using the tool and can get past it. i can email the error dialog to you if required, i just cant post it.

the setup has encountered an unexpected error in data store. The action is RestoreSetupParams. The error is: Failed to read property installl ds

What are you trying to uninstall?

This tool was written by VS, it might be valueable to post this question into one of the VS forums.

Mike

|||

Hi Mike,

i am trying to install SQL server express edition 2005 however i am being told that there are incompatable components from beta versions of visual studio, .net framework or sql 2005. I have removed all of these and rebooted and run the tool however it makes no difference.

Previously both the express edition and the full edition of sql2005 have been on this computer at seperate times, however both have been removed. I have tried to install the full version however the same error occurs.

I have removed everything remotely connected with sql 2005, .net and visual studio and the problem remains.

I can email you screen shots of all error messages if required

thanks for the help

Nick

|||

Hi Nick,

The setup log should list the specific components that are causing the problem on your computer. If you can not find those components listed in Add/Remove Programs, you can remove them manually using the following in the Run dialog:

msiexec /x <product id>

Product ID will be a long number listed in the setup log for each of the offending product. Run this for each of the products listed in the log.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||

Hi Mike,

again thanks for replying to me!

Unfortunately your reply was of limited help. I am not sure what/where the setup log is that you refer to. When the original error messages appear after running the tool, there are no product id’s and no indication of what they are.

if you let me know where to get the setup log i will run

msiexec /x <product id>

for the offending products

thanks in advance

nick

|||

Hi Nick,

You can find the setup logs at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG. The summary.txt has general information, will usually tell you which specific component of SQL failed to install and point you to a more detailed log in the Files folder. The detailed log should contain the product IDs.

Mike

|||

hi,

the information stored in the summary.txt is as follows -

Microsoft SQL Server 2005 Setup beginning at Mon Jul 17 12:27:30 2006
Process ID : 1268
c:\b4bd99cb30de03073795be5c67\setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2006/6/17 12:27:30
Complete: LoadResourcesAction at: 2006/6/17 12:27:30, returned true
Running: ParseBootstrapOptionsAction at: 2006/6/17 12:27:30
Loaded DLL:c:\b4bd99cb30de03073795be5c67\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2006/6/17 12:27:30, returned true
Running: ValidateWinNTAction at: 2006/6/17 12:27:30
Complete: ValidateWinNTAction at: 2006/6/17 12:27:30, returned true
Running: ValidateMinOSAction at: 2006/6/17 12:27:30
Complete: ValidateMinOSAction at: 2006/6/17 12:27:30, returned true
Running: PerformSCCAction at: 2006/6/17 12:27:30
Complete: PerformSCCAction at: 2006/6/17 12:27:30, returned true
Running: ActivateLoggingAction at: 2006/6/17 12:27:30
Complete: ActivateLoggingAction at: 2006/6/17 12:27:30, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__1268" returned false.
Running: PerformSCCAction2 at: 2006/6/17 12:27:30
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Product "{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}" versioned 9.00.1187.07 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Express Edition CTP"
Product "{2750B389-A2D2-4953-99CA-27C1F2A8E6FD}" versioned 9.00.1187.07 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Tools Express Edition CTP"
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

Class not registered.

i am unable to manually delete the last two using the run command that you supplied as it says the installation package could not be opened when i place the product id in the run command. is it possible to manually remove these last two items in some other way?

as always mike - thanks for your help

nick

|||

sorry for the delay Nick, this one fell off the radar.

If the manual uninstall trick doesn't work, it could be that the product is actually already uninstalled and only the Add/Remove Programs entry still exists, which is messing things up. As a last resort, you can try the Windows Installer Cleanup Utility, which removes entries from the ARP list. If that doesn't resolve the issue, I'm not sure what is wrong with your computer. You may need to phone into support to get more directed help.

Mike

|||

Hi Mike

I think a reformat may be in order! Thanks for all the help.

By the way, would you know of a good article/thread on how to preform sql 2005 express back ups by any chance?

thanks again for all the help

nick

|||

just what i needed.. great application

many thanks

:)

|||

I don't think the definitive article exists on backup for Express, we pretty much default to "just use Windows Task Scheduler" like that really helps. That said, I've found a few interesting bits to suffice untill I finally write the definitive article.

One of our MVPs wrote a couple articles, a SProc and a tool that helps with maintenance of your database. Check it out at http://www.sqldbatips.com/showarticle.asp?ID=27.sql

Errors using the uninstall tool - 'vs_uninst_betas'

Hi Folks

getting the following error message when using the tool and can get past it. i can email the error dialog to you if required, i just cant post it.

the setup has encountered an unexpected error in data store. The action is RestoreSetupParams. The error is: Failed to read property installl ds

What are you trying to uninstall?

This tool was written by VS, it might be valueable to post this question into one of the VS forums.

Mike

|||

Hi Mike,

i am trying to install SQL server express edition 2005 however i am being told that there are incompatable components from beta versions of visual studio, .net framework or sql 2005. I have removed all of these and rebooted and run the tool however it makes no difference.

Previously both the express edition and the full edition of sql2005 have been on this computer at seperate times, however both have been removed. I have tried to install the full version however the same error occurs.

I have removed everything remotely connected with sql 2005, .net and visual studio and the problem remains.

I can email you screen shots of all error messages if required

thanks for the help

Nick

|||

Hi Nick,

The setup log should list the specific components that are causing the problem on your computer. If you can not find those components listed in Add/Remove Programs, you can remove them manually using the following in the Run dialog:

msiexec /x <product id>

Product ID will be a long number listed in the setup log for each of the offending product. Run this for each of the products listed in the log.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||

Hi Mike,

again thanks for replying to me!

Unfortunately your reply was of limited help. I am not sure what/where the setup log is that you refer to. When the original error messages appear after running the tool, there are no product id’s and no indication of what they are.

if you let me know where to get the setup log i will run

msiexec /x <product id>

for the offending products

thanks in advance

nick

|||

Hi Nick,

You can find the setup logs at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG. The summary.txt has general information, will usually tell you which specific component of SQL failed to install and point you to a more detailed log in the Files folder. The detailed log should contain the product IDs.

Mike

|||

hi,

the information stored in the summary.txt is as follows -

Microsoft SQL Server 2005 Setup beginning at Mon Jul 17 12:27:30 2006
Process ID : 1268
c:\b4bd99cb30de03073795be5c67\setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2006/6/17 12:27:30
Complete: LoadResourcesAction at: 2006/6/17 12:27:30, returned true
Running: ParseBootstrapOptionsAction at: 2006/6/17 12:27:30
Loaded DLL:c:\b4bd99cb30de03073795be5c67\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2006/6/17 12:27:30, returned true
Running: ValidateWinNTAction at: 2006/6/17 12:27:30
Complete: ValidateWinNTAction at: 2006/6/17 12:27:30, returned true
Running: ValidateMinOSAction at: 2006/6/17 12:27:30
Complete: ValidateMinOSAction at: 2006/6/17 12:27:30, returned true
Running: PerformSCCAction at: 2006/6/17 12:27:30
Complete: PerformSCCAction at: 2006/6/17 12:27:30, returned true
Running: ActivateLoggingAction at: 2006/6/17 12:27:30
Complete: ActivateLoggingAction at: 2006/6/17 12:27:30, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__1268" returned false.
Running: PerformSCCAction2 at: 2006/6/17 12:27:30
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Product "{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}" versioned 9.00.1187.07 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Express Edition CTP"
Product "{2750B389-A2D2-4953-99CA-27C1F2A8E6FD}" versioned 9.00.1187.07 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Tools Express Edition CTP"
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

Class not registered.

i am unable to manually delete the last two using the run command that you supplied as it says the installation package could not be opened when i place the product id in the run command. is it possible to manually remove these last two items in some other way?

as always mike - thanks for your help

nick

|||

sorry for the delay Nick, this one fell off the radar.

If the manual uninstall trick doesn't work, it could be that the product is actually already uninstalled and only the Add/Remove Programs entry still exists, which is messing things up. As a last resort, you can try the Windows Installer Cleanup Utility, which removes entries from the ARP list. If that doesn't resolve the issue, I'm not sure what is wrong with your computer. You may need to phone into support to get more directed help.

Mike

|||

Hi Mike

I think a reformat may be in order! Thanks for all the help.

By the way, would you know of a good article/thread on how to preform sql 2005 express back ups by any chance?

thanks again for all the help

nick

|||

just what i needed.. great application

many thanks

:)

|||

I don't think the definitive article exists on backup for Express, we pretty much default to "just use Windows Task Scheduler" like that really helps. That said, I've found a few interesting bits to suffice untill I finally write the definitive article.

One of our MVPs wrote a couple articles, a SProc and a tool that helps with maintenance of your database. Check it out at http://www.sqldbatips.com/showarticle.asp?ID=27.

errorlog monitoring & job outputs

Considering email is setup, how would you send emails by scanning errorlog for any issues. Also, how to send program outputs using email.
Thanks...nobody has this kind of setup?|||Which mail, setup how?

-PatP|||email setup to send emails from SQL Server.|||Need more info from ya, Mkalsi...you can use xp_sendmail to do it...I have things setup to do what I THINK you are trying to do...

Although, this is probably more convoluted than you need...I wanted to try to make my messages a little more readable than just inserting the error message row columns from the EventLog table...

Anyway...check out the sendmail code near the bottom...that's the gist of what you'll need.

Keep in mind though, that there's a whole 'nother arm-wrestling match about permissions and user id stuff that must be in place to send mail from SQL Server 2000 through outlook - it was a tad more complex than just point-n-shoot.

*================================================= ====================================
| Name: Send_EventLog_Mail_By_Level
| Description: Performs a select against the EventLog table based on input parameters for target date and
| target error level and inserts the selected rows into an email which is then sent to a static
| mail address list. No email is sent if selection results in no rows selected for that date/error level.
|
| Created: 04/29/2004 by Yo_Mama
| Modified: 09/20/2004 by Yo_Mama - Added Server Name to message subject/message body.
| Inputs: TDate (smalldatetime) - The date for which any errors are to be selected/reported via email.
| TLevel (int) - The relative error level for which rows are to be selected/reported via email.
|================================================= =====================================*/
CREATE PROCEDURE [dbo].[Send_EventLog_Mail_By_Level]
@.TDate smalldatetime = NULL,
@.TLevel int = 0
AS

DECLARE @.SQLCmd varchar(256)
DECLARE @.Message varchar(256)
DECLARE @.Subject varchar(128)
DECLARE @.TargetDate smalldatetime
DECLARE @.LargestEventSize int
DECLARE @.SvrName varchar(30)

/*-- Capture Server Name and build string to use in WaitForFile request */
SET @.SvrName = CONVERT(varchar, SERVERPROPERTY ('ServerName'))

IF (@.TDate IS NULL)
SET @.TargetDate = CONVERT(varchar(10), GETDATE(), 101)
ELSE
SET @.TargetDate = CONVERT(varchar(10), @.TDate, 101)

/*-- Drop the temporary table and recreate it */
IF EXISTS (SELECT *
FROM dbo.sysobjects
WHERE ID = OBJECT_ID(N'[dbo].[EventLogTbl]')
AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[EventLogTbl]

CREATE TABLE [dbo].[EventLogTbl] (EvtID int, EventDesc varchar(1200))

/*-- Build rows in the temporary table by selecting the date and message level desired and formatting row */
INSERT INTO EventLogTbl
SELECT [ID] as EvtID, ('---> ID=' + LTRIM(CONVERT(varchar(10), [ID])) +
', Date=' + CONVERT(varchar(20), [Date]) + ', Level=' +
LTRIM(CONVERT(varchar(2), MsgLevel)) + ', APP=' + RTRIM(App) +
', Function=' + RTRIM([Function]) + ', Message=' + RTRIM(Message) +
', Rows=' + LTRIM(CONVERT(varchar(5), [Rows])) + ', Host=' +
RTRIM(Host)) AS EventDesc
FROM EventLog
WHERE (CONVERT(varchar(10), [Date], 101) = CONVERT(varchar(10), @.TargetDate, 101)) AND
MsgLevel = @.TLevel

/*-- If our dragnet caught anything, then format subject line, message intro, and detail the message rows */
IF (@.@.ROWCOUNT > 0)
BEGIN
SET @.Subject = @.SvrName + '.IBDIndex - Level ' +
CONVERT(varchar(3), @.TLevel) + ' Processing Events were found for ' +
CONVERT(varchar(10), @.TargetDate,101)

SET @.Message = 'The following events (Message Level ' + CONVERT(varchar(3), @.TLevel) +
') occurred in ' + @.SvrName + '.IBDIndex processing on ' +
CONVERT(varchar(12), @.TargetDate,101) + CHAR(13) + CHAR(10) +
CHAR(9) + '- Check EventLog table for details and context' +
CHAR(13) + CHAR(10)

/*-- Capture the longest message in the temp table...need it to cast varchar below */
SELECT @.LargestEventSize = Max(Len(EventDesc))
FROM EventLogTbl

/*-- Set the SQL command for xp_sendmail - need to recast varchar to avoid trailing blanks */
SET @.SqlCmd = 'SELECT Cast(EventDesc AS varchar(' +
CONVERT(varchar(5), @.LargestEventSize) +
')) FROM EventLogTbl ORDER BY EvtID'

/*-- Send of the email!!! */
EXECUTE Master.dbo.xp_sendmail
'Yo_Mama@.AngieDaddyToo.com',
@.query = @.SQLCmd,
@.no_header= 'TRUE',
@.dbuse = 'MyDatabase',
@.subject=@.Subject,
@.message=@.message
END

DROP TABLE EventLogTbl

RETURN

GO