Discussion:
Cannot install SP3 for SQL Express for BCM
(too old to reply)
Mike P
2009-03-01 06:47:00 UTC
Permalink
I installed BCM 2007 and it setup SQL Express.

Windows update now wants to update it to SP3, but fails every time with an
error message
Product: Microsoft SQL Server 2005 Express Edition -- Error 2259. The
installer has encountered an unexpected error. The error code is 2259.
Database: Table(s) Update failed

Any suggestions please.

Mike
========================================
SQLSetup0006_RECEPTION_Core(Local).log
Microsoft SQL Server 2005 Setup beginning at Sat Feb 28 21:30:30 2009
Process ID : 456
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe Version:
2005.90.3042.0
Running: LoadResourcesAction at: 2009/1/28 21:30:30
Complete: LoadResourcesAction at: 2009/1/28 21:30:30, returned true
Running: ParseBootstrapOptionsAction at: 2009/1/28 21:30:30
Loaded DLL:c:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2009/1/28 21:30:30, returned true
Running: ValidateWinNTAction at: 2009/1/28 21:30:30
Complete: ValidateWinNTAction at: 2009/1/28 21:30:30, returned true
Running: ValidateMinOSAction at: 2009/1/28 21:30:30
Complete: ValidateMinOSAction at: 2009/1/28 21:30:30, returned true
Running: PerformSCCAction at: 2009/1/28 21:30:30
Complete: PerformSCCAction at: 2009/1/28 21:30:30, returned true
Running: ActivateLoggingAction at: 2009/1/28 21:30:30
Complete: ActivateLoggingAction at: 2009/1/28 21:30:30, returned true
Running: DetectPatchedBootstrapAction at: 2009/1/28 21:30:30
Complete: DetectPatchedBootstrapAction at: 2009/1/28 21:30:30, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following
restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__456" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following
restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2009/1/28 21:30:30
Complete: PerformDotNetCheck2 at: 2009/1/28 21:30:30, returned true
Running: InvokeSqlSetupDllAction at: 2009/1/28 21:30:30
Loaded DLL:c:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\sqlspars.dll Version:2005.90.3042.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [RECEPTION]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find install through Product Code
Product Code = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
Install Id = MSSMLBIZ SQL 9.0 SQL Server Standalone Product MSSQL.1
Install Type = 3
Install SKU = -1592396055
Instance Name = MSSMLBIZ
Language Id = 1033
Trying to find Instance Name from command line.
No Instance Name provided on the command line
If possible, determine action
Machine = RECEPTION, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = RECEPTION, Article = WMIServiceWin32CompSystemWorking, Result = 0
(0x0)
Machine = RECEPTION, Article = WMIServiceWin32ProcessorWorking, Result = 0
(0x0)
Machine = RECEPTION, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = RECEPTION, Article = WMIServiceWin32DirectoryWorking, Result = 0
(0x0)
Machine = RECEPTION, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = RECEPTION, Article = XMLDomDocument, Result = 0 (0x0)
Machine = RECEPTION, Article = Processor, Result = 0 (0x0)
Machine = RECEPTION, Article = PhysicalMemory, Result = 0 (0x0)
Machine = RECEPTION, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = RECEPTION, Article = OSVersion, Result = 0 (0x0)
Machine = RECEPTION, Article = OSServicePack, Result = 0 (0x0)
Machine = RECEPTION, Article = OSType, Result = 0 (0x0)
Machine = RECEPTION, Article = AdminShare, Result = 0 (0x0)
Machine = RECEPTION, Article = PendingReboot, Result = 70011 (0x1117b)
Machine = RECEPTION, Article = IEVersion, Result = 0 (0x0)
Machine = RECEPTION, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = RECEPTION, Article = COMPlus, Result = 0 (0x0)
Machine = RECEPTION, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = RECEPTION, Article = MDAC25Version, Result = 0 (0x0)
Machine = RECEPTION, Article = SKUUpgrade, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: RECEPTION
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: Error
Description: Setup has detected a pending reboot on the machine. Action:
Reboot the machine before continuing the setup.
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
Article: Edition Upgrade Check, Result: CheckPassed
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Func Name='DisplaySCCWizard'>
CSetupBootstrapWizard returned 2
Bootstrap wizard returned a user exit condition
<EndFunc Name='DisplaySCCWizard' Return='1602' GetLastError='183'>
<EndFunc Name='DwLaunchMsiExec' Return='70011' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2009/1/28 21:31:25, returned false
Error: Action "InvokeSqlSetupDllAction" failed during execution.
Action "AnalyzeInstallStage" will be skipped due to the following
restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed."
returned false.
Action "PrepareForChainingStage" will be skipped due to the following
restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed."
returned false.
Action "SequenceChainingActionsStage" will be skipped due to the following
restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed."
returned false.
Action "InstallChainedPackagesStage" will be skipped due to the following
restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed."
returned false.
Error: Action "ExposeVistaClusteredResources" failed during execution.
Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the
following condition:
Condition "The Clustered SQL Server instance that hosts is installed."
returned false.
Running: ReportChainingResults at: 2009/1/28 21:31:25
Error: Action "ReportChainingResults" threw an exception during execution.
DwLaunchMsiExec() returned : 70011
Error Code: 70011
Windows Error Text: Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3416

Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "watsonFailedActionErrorCode" {"SetupStateScope",
"", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.watsonFailedActionErrorCode
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "watsonFailedActionErrorCode" {"SetupStateScope",
"", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.watsonFailedActionErrorCode
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
Message pump returning: 70011


================================================
Luther Blissett
2009-03-02 19:00:46 UTC
Permalink
Post by Mike P
I installed BCM 2007 and it setup SQL Express.
Windows update now wants to update it to SP3, but fails every time with an
error message
Product: Microsoft SQL Server 2005 Express Edition -- Error 2259. The
installer has encountered an unexpected error. The error code is 2259.
Database:  Table(s) Update failed
Any suggestions please.
Mike
========================================
SQLSetup0006_RECEPTION_Core(Local).log
Microsoft SQL Server 2005 Setup beginning at Sat Feb 28 21:30:30 2009
Process ID      : 456
2005.90.3042.0
Running: LoadResourcesAction at: 2009/1/28 21:30:30
Complete: LoadResourcesAction at: 2009/1/28 21:30:30, returned true
Running: ParseBootstrapOptionsAction at: 2009/1/28 21:30:30
Loaded DLL:c:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2009/1/28 21:30:30, returned true
Running: ValidateWinNTAction at: 2009/1/28 21:30:30
Complete: ValidateWinNTAction at: 2009/1/28 21:30:30, returned true
Running: ValidateMinOSAction at: 2009/1/28 21:30:30
Complete: ValidateMinOSAction at: 2009/1/28 21:30:30, returned true
Running: PerformSCCAction at: 2009/1/28 21:30:30
Complete: PerformSCCAction at: 2009/1/28 21:30:30, returned true
Running: ActivateLoggingAction at: 2009/1/28 21:30:30
Complete: ActivateLoggingAction at: 2009/1/28 21:30:30, returned true
Running: DetectPatchedBootstrapAction at: 2009/1/28 21:30:30
Complete: DetectPatchedBootstrapAction at: 2009/1/28 21:30:30, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following
Condition "EventCondition: __STP_LaunchPatchedBootstrap__456" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2009/1/28 21:30:30
Complete: PerformDotNetCheck2 at: 2009/1/28 21:30:30, returned true
Running: InvokeSqlSetupDllAction at: 2009/1/28 21:30:30
Loaded DLL:c:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\sqlspars.dll Version:2005.90.3042.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [RECEPTION]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find install through Product Code
Product Code = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
Install Id = MSSMLBIZ SQL 9.0 SQL Server Standalone Product MSSQL.1
Install Type = 3
Install SKU = -1592396055
Instance Name = MSSMLBIZ
Language Id = 1033
Trying to find Instance Name from command line.
No Instance Name provided on the command line
If possible, determine action
Machine = RECEPTION, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = RECEPTION, Article = WMIServiceWin32CompSystemWorking, Result = 0
(0x0)
Machine = RECEPTION, Article = WMIServiceWin32ProcessorWorking, Result = 0
(0x0)
Machine = RECEPTION, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = RECEPTION, Article = WMIServiceWin32DirectoryWorking, Result = 0
(0x0)
Machine = RECEPTION, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = RECEPTION, Article = XMLDomDocument, Result = 0 (0x0)
Machine = RECEPTION, Article = Processor, Result = 0 (0x0)
Machine = RECEPTION, Article = PhysicalMemory, Result = 0 (0x0)
Machine = RECEPTION, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = RECEPTION, Article = OSVersion, Result = 0 (0x0)
Machine = RECEPTION, Article = OSServicePack, Result = 0 (0x0)
Machine = RECEPTION, Article = OSType, Result = 0 (0x0)
Machine = RECEPTION, Article = AdminShare, Result = 0 (0x0)
Machine = RECEPTION, Article = PendingReboot, Result = 70011 (0x1117b)
Machine = RECEPTION, Article = IEVersion, Result = 0 (0x0)
Machine = RECEPTION, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = RECEPTION, Article = COMPlus, Result = 0 (0x0)
Machine = RECEPTION, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = RECEPTION, Article = MDAC25Version, Result = 0 (0x0)
Machine = RECEPTION, Article = SKUUpgrade, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: RECEPTION
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: Error
Reboot the machine before continuing the setup.
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
Article: Edition Upgrade Check, Result: CheckPassed
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Func Name='DisplaySCCWizard'>
CSetupBootstrapWizard returned 2
Bootstrap wizard returned a user exit condition
<EndFunc Name='DisplaySCCWizard' Return='1602' GetLastError='183'>
<EndFunc Name='DwLaunchMsiExec' Return='70011' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2009/1/28 21:31:25, returned false
Error: Action "InvokeSqlSetupDllAction" failed during execution.
Action "AnalyzeInstallStage" will be skipped due to the following
Condition "Action: InvokeSqlSetupDllAction has finished and passed."
returned false.
Action "PrepareForChainingStage" will be skipped due to the following
Condition "Action: InvokeSqlSetupDllAction has finished and passed."
returned false.
Action "SequenceChainingActionsStage" will be skipped due to the following
Condition "Action: InvokeSqlSetupDllAction has finished and passed."
returned false.
Action "InstallChainedPackagesStage" will be skipped due to the following
Condition "Action: InvokeSqlSetupDllAction has finished and passed."
returned false.
Error: Action "ExposeVistaClusteredResources" failed during execution.  
Action: "ExposeVistaClusteredResources" will be marked as failed due to the
Condition "The Clustered SQL Server instance that hosts  is installed."
returned false.
Running: ReportChainingResults at: 2009/1/28 21:31:25
Error: Action "ReportChainingResults" threw an exception during execution.
DwLaunchMsiExec() returned : 70011
        Error Code: 70011
Windows Error Text:   Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
     Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3416
  Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "watsonFailedActionErrorCode" {"SetupStateScope",
"", ""} in cache
          Source File Name: datastore\propertycollection.cpp
        Compiler Timestamp: Wed Jun 14 16:28:01 2006
             Function Name: SetupStateScope.watsonFailedActionErrorCode
        Source Line Number: 44
        ----------------------------------------------------------
        No collector registered for scope: "SetupStateScope"
Failed to create CAB file due to datastore exception
  Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "watsonFailedActionErrorCode" {"SetupStateScope",
"", ""} in cache
          Source File Name: datastore\propertycollection.cpp
        Compiler Timestamp: Wed Jun 14 16:28:01 2006
             Function Name: SetupStateScope.watsonFailedActionErrorCode
        Source Line Number: 44
        ----------------------------------------------------------
        No collector registered for scope: "SetupStateScope"
Message pump returning: 70011
================================================
Try running the issue by a Sql Server newsgroup.

Loading...