Upgrading Sql server 2005 to sql server 2008R2

Category: sql server setup

Question

Krishna Gine on Mon, 03 Jun 2013 14:33:06


HI All,

I am running SQL server 2005 to 2008 r2 upgrade and encountered below issue.

Product: SQL Server 2008 R2 SP1 Common Files - Update 'Service Pack 1 for SQL Server Database Services 2008 Common Core (64-bit) (KB2528583)' could not be installed. Error code 1639

Steps i performed:

1) Stopped SAP instance

2)Stopped Database (Is it required to stop database to upgrade?)

3)execute setup.exe ->Installation->upgrade to 2008 r2

OS->Windows server 2008 enterprise x64 version

below are the logs of file sql_common_core_Cpu64_1.log

=== Verbose logging started: 6/3/2013  9:08:48  Build type: SHIP UNICODE 4.05.6002.00  Calling process: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x64\setup100.exe ===
MSI (c) (08:24) [09:08:48:287]: Resetting cached policy values
MSI (c) (08:24) [09:08:48:287]: Machine policy value 'Debug' is 0
MSI (c) (08:24) [09:08:48:287]: ******* RunEngine:
           ******* Product: C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\x64\setup\sql_common_core_msi\sql_common_core.msi
           ******* Action: 
           ******* CommandLine: **********
MSI (c) (08:24) [09:08:48:287]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (08:24) [09:08:48:287]: Grabbed execution mutex.
MSI (c) (08:24) [09:08:48:288]: Cloaking enabled.
MSI (c) (08:24) [09:08:48:288]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (08:24) [09:08:48:288]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (8C:BC) [09:08:48:292]: Running installation inside multi-package transaction C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\x64\setup\sql_common_core_msi\sql_common_core.msi
MSI (s) (8C:BC) [09:08:48:292]: Grabbed execution mutex.
MSI (s) (8C:D4) [09:08:48:296]: Resetting cached policy values
MSI (s) (8C:D4) [09:08:48:296]: Machine policy value 'Debug' is 0
MSI (s) (8C:D4) [09:08:48:296]: ******* RunEngine:
           ******* Product: C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\x64\setup\sql_common_core_msi\sql_common_core.msi
           ******* Action: 
           ******* CommandLine: **********
MSI (s) (8C:D4) [09:08:48:297]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (8C:D4) [09:08:48:304]: Note: 1: 1402 2: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer 3: 2 
MSI (s) (8C:D4) [09:08:48:305]: File will have security applied from OpCode.
MSI (s) (8C:D4) [09:08:48:311]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\x64\setup\sql_common_core_msi\sql_common_core.msi' against software restriction policy
MSI (s) (8C:D4) [09:08:48:311]: SOFTWARE RESTRICTION POLICY: C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\x64\setup\sql_common_core_msi\sql_common_core.msi has a digital signature
MSI (s) (8C:D4) [09:08:48:324]: SOFTWARE RESTRICTION POLICY: C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\x64\setup\sql_common_core_msi\sql_common_core.msi is permitted to run at the 'unrestricted' authorization level.
MSI (s) (8C:D4) [09:08:48:324]: End dialog not enabled
MSI (s) (8C:D4) [09:08:48:324]: Original package ==> C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\x64\setup\sql_common_core_msi\sql_common_core.msi
MSI (s) (8C:D4) [09:08:48:324]: Package we're running from ==> C:\Windows\Installer\10909420.msi
MSI (s) (8C:D4) [09:08:48:328]: APPCOMPAT: looking for appcompat database entry with ProductCode '{36F70DEE-1EBF-4707-AFA2-E035EEAEBAA1}'.
MSI (s) (8C:D4) [09:08:48:328]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (8C:D4) [09:08:48:330]: MSCOREE already loaded, using loaded copy
MSI (s) (8C:D4) [09:08:48:330]: Machine policy value 'TransformsSecure' is 1
MSI (s) (8C:D4) [09:08:48:376]: File will have security applied from OpCode.
MSI (s) (8C:D4) [09:08:48:491]: Original patch ==> C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\PCU\x64\setup\sql_common_core_msi\sql_common_core.msp
MSI (s) (8C:D4) [09:08:48:491]: Patch we're running from ==> C:\Windows\Installer\10909421.msp
MSI (s) (8C:D4) [09:08:48:491]: SOFTWARE RESTRICTION POLICY: Verifying patch --> 'C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\PCU\x64\setup\sql_common_core_msi\sql_common_core.msp' against software restriction policy
MSI (s) (8C:D4) [09:08:48:491]: SOFTWARE RESTRICTION POLICY: C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\PCU\x64\setup\sql_common_core_msi\sql_common_core.msp has a digital signature
MSI (s) (8C:D4) [09:08:48:576]: SOFTWARE RESTRICTION POLICY: C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\PCU\x64\setup\sql_common_core_msi\sql_common_core.msp is permitted to run at the 'unrestricted' authorization level.
MSI (s) (8C:D4) [09:08:48:576]: SequencePatches starts. Product code: {36F70DEE-1EBF-4707-AFA2-E035EEAEBAA1}, Product version: 10.50.1600.1, Upgrade code: {1717733A-3F14-4903-BCCB-1C45C27BD3AA}, Product language 1033
MSI (s) (8C:D4) [09:08:48:576]: PATCH SEQUENCER: verifying the applicability of minor upgrade patch C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\PCU\x64\setup\sql_common_core_msi\sql_common_core.msp against product code: {36F70DEE-1EBF-4707-AFA2-E035EEAEBAA1}, product version: 10.50.1600.1, product language 1033 and upgrade code: {1717733A-3F14-4903-BCCB-1C45C27BD3AA}
MSI (s) (8C:D4) [09:08:48:577]: Note: 1: 2262 2: _Tables 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:577]: Note: 1: 2262 2: _Columns 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:577]: PATCH SEQUENCER: minor upgrade patch C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\PCU\x64\setup\sql_common_core_msi\sql_common_core.msp is applicable.
MSI (s) (8C:D4) [09:08:48:577]: SequencePatches returns success.
MSI (s) (8C:D4) [09:08:48:577]: Final Patch Application Order:
MSI (s) (8C:D4) [09:08:48:577]: {69E478CF-E69D-4552-B838-6951BEB3054B} - C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\PCU\x64\setup\sql_common_core_msi\sql_common_core.msp
MSI (s) (8C:D4) [09:08:48:577]: Machine policy value 'DisablePatch' is 0
MSI (s) (8C:D4) [09:08:48:577]: Machine policy value 'AllowLockdownPatch' is 0
MSI (s) (8C:D4) [09:08:48:577]: Machine policy value 'DisableLUAPatching' is 0
MSI (s) (8C:D4) [09:08:48:578]: Machine policy value 'DisableFlyWeightPatching' is 0
MSI (s) (8C:D4) [09:08:48:578]: Looking for patch transform: Target01ToUpgrade01
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: _Tables 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: _Columns 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: _sqlAction 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: CustomAction 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: _sqlFeatureDependency 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: _Validation 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: Component 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: Feature 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: Binary 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: Registry 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: ActionText 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: AdminExecuteSequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: AdminUISequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: AppSearch 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: CompLocator 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: Directory 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: Control 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: Dialog 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: ControlCondition 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: ControlEvent 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: CreateFolder 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: DrLocator 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: Error 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: FeatureComponents 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:578]: Note: 1: 2262 2: InstallUISequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: ListBox 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: Media 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: MsiAssembly 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: MsiFileHash 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: RegLocator 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: Signature 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: TextStyle 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: UIText 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: _sqlAction 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: CustomAction 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: _sqlFeatureDependency 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: _Validation 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: Component 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: Feature 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: Binary 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: Registry 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: ActionText 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: AdminUISequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: AppSearch 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: CompLocator 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: Directory 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: Control 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: Dialog 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: ControlCondition 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: ControlEvent 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: CreateFolder 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: DrLocator 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: Error 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: FeatureComponents 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: InstallUISequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: ListBox 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: MsiAssembly 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: MsiAssemblyName 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: MsiFileHash 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: RegLocator 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: Signature 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: TextStyle 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: UIText 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: Upgrade 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: Patch 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: MsiPatchHeaders 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2205 2:  3: Patch 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2228 2:  3: Patch 4: CREATE TABLE `Patch` ( `File_` CHAR(72) NOT NULL, `Sequence` INTEGER NOT NULL, `PatchSize` LONG NOT NULL, `Attributes` INTEGER NOT NULL, `Header` OBJECT, `StreamRef_` CHAR(72)  PRIMARY KEY `File_`, `Sequence` ) 
MSI (s) (8C:D4) [09:08:48:579]: Note: 1: 2262 2: Patch 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:580]: Note: 1: 2205 2:  3: PatchPackage 
MSI (s) (8C:D4) [09:08:48:580]: TRANSFORM: 'PatchPackage' table is missing or empty.  No pre-transform fixup necessary.
MSI (s) (8C:D4) [09:08:48:580]: TRANSFORM: Applying regular transform to database.
MSI (s) (8C:D4) [09:08:48:580]: Note: 1: 2262 2: _Tables 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:580]: Note: 1: 2262 2: _Columns 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:580]: Note: 1: 2262 2: _sqlAction 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:580]: Note: 1: 2262 2: CustomAction 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:580]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: _sqlFeatureDependency 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: _Validation 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: Component 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: Feature 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: Binary 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: Registry 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: ActionText 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: AdminExecuteSequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: AdminUISequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: AppSearch 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: CompLocator 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: Directory 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: Control 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: Dialog 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: ControlCondition 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: ControlEvent 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: CreateFolder 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: DrLocator 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: Error 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: FeatureComponents 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: InstallUISequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: ListBox 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: Media 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: MsiAssembly 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: MsiFileHash 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: RegLocator 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: Signature 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: TextStyle 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: UIText 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: #_PatchCache 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: #_BaselineData 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: #_BaselineFile 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: #_BaselineCost 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: __MsiRegistryList 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: _MsiPatchAuthorTransformView 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: _MsiPatchPatchTransformView 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: Patch 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: __MsiPatchInstallFile 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2262 2: __MsiPatchInstallMsiAssemblyName 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:581]: Note: 1: 2205 2:  3: PatchPackage 
MSI (s) (8C:D4) [09:08:48:581]: TRANSFORM: The minimum 'Media.DiskId' value inserted by a patch transform is 100
MSI (s) (8C:D4) [09:08:48:581]: TRANSFORM: The maximum 'Media.DiskId' value inserted by a patch transform is 99
MSI (s) (8C:D4) [09:08:48:581]: TRANSFORM: The minimum 'File.Sequence' or 'Patch.Sequence' value inserted by a patch transform is 10000
MSI (s) (8C:D4) [09:08:48:581]: TRANSFORM: The maximum 'File.Sequence' or 'Patch.Sequence' value inserted by a patch transform is 9999.
MSI (s) (8C:D4) [09:08:48:581]: TRANSFORM: Applying special patch transform to database.
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: _sqlAction 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: CustomAction 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: _sqlFeatureDependency 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: _Validation 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: Component 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: Feature 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: Binary 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: Registry 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: ActionText 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: AdminUISequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: AppSearch 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: CompLocator 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: Directory 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: Control 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: Dialog 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: ControlCondition 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: ControlEvent 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: CreateFolder 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: DrLocator 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: Error 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: FeatureComponents 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: InstallUISequence 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: ListBox 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: MsiAssembly 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: MsiAssemblyName 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: MsiFileHash 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: RegLocator 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: Signature 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: TextStyle 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: UIText 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: Upgrade 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: #_PatchCache 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: #_BaselineData 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: #_BaselineFile 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: #_BaselineCost 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: __MsiRegistryList 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: _MsiPatchPatchTransformView 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: Patch 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: MsiPatchHeaders 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: __MsiPatchInstallFile 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: __MsiPatchInstallMsiAssemblyName 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Transforming table Media.

MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: Media 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Transforming table Media.

MSI (s) (8C:D4) [09:08:48:582]: Note: 1: 2262 2: PatchPackage 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:582]: Transforming table PatchPackage.

MSI (s) (8C:D4) [09:08:48:583]: Note: 1: 2262 2: PatchPackage 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:583]: Transforming table PatchPackage.

MSI (s) (8C:D4) [09:08:48:583]: TRANSFORM: Modifying 'File' and 'Patch' rows added by this patch transform to have appropriate 'Sequence' values.  Offsetting values by 8270
MSI (s) (8C:D4) [09:08:48:583]: TRANSFORM: Modifying 'PatchPackage' table row added by this patch transform to use 'Media_' value 100.
MSI (s) (8C:D4) [09:08:48:583]: TRANSFORM: Modifying 'Media' table row added by this patch transform to use 'DiskId' value 100 and 'Source' values MSPSRC69E478CFE69D4552B8386951BEB3054B.
MSI (s) (8C:D4) [09:08:48:585]: APPCOMPAT: looking for appcompat database entry with ProductCode '{36F70DEE-1EBF-4707-AFA2-E035EEAEBAA1}'.
MSI (s) (8C:D4) [09:08:48:586]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (8C:D4) [09:08:48:586]: Transforms are not secure.
MSI (s) (8C:D4) [09:08:48:587]: Transforming table Property.

MSI (s) (8C:D4) [09:08:48:587]: Transforming table Property.

MSI (s) (8C:D4) [09:08:48:587]: PROPERTY CHANGE: Adding MsiLogFileLocation property. Its value is 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130603_085621\sql_common_core_Cpu64_1.log'.
MSI (s) (8C:D4) [09:08:48:587]: Command Line: __msiInstallerEngine_SkuName= EXTERNALMSICONTROL=1 ADDLOCAL=Client_Components_CNS,CommonFiles,Connectivity_CNS VSINSTALLDIR=C:\Program Files (x86)\Microsoft Visual Studio 9.0 INSTALLSQLSHAREDDIR_32=C:\Program Files (x86)\Microsoft SQL Server\ INSTALLSQLSHAREDDIR_64=c:\Program Files\Microsoft SQL Server\ REBOOT=ReallySuppress MEDIAPACKAGEPATH=\x64\setup\sql_common_core_msi\ PATCH=C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\PCU\x64\setup\sql_common_core_msi\sql_common_core.msp 
MSI (s) (8C:D4) [09:08:48:587]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{AFBD8AF2-01AD-499D-962C-EC41CE73B57D}'.
MSI (s) (8C:D4) [09:08:48:587]: Product Code passed to Engine.Initialize:           ''
MSI (s) (8C:D4) [09:08:48:587]: Product Code from property table before transforms: '{36F70DEE-1EBF-4707-AFA2-E035EEAEBAA1}'
MSI (s) (8C:D4) [09:08:48:587]: Product Code from property table after transforms:  '{36F70DEE-1EBF-4707-AFA2-E035EEAEBAA1}'
MSI (s) (8C:D4) [09:08:48:587]: Product not registered: beginning first-time install
MSI (s) (8C:D4) [09:08:48:587]: Product {36F70DEE-1EBF-4707-AFA2-E035EEAEBAA1} is not managed.
MSI (s) (8C:D4) [09:08:48:587]: MSI_LUA: Credential prompt not required, user is an admin
MSI (s) (8C:D4) [09:08:48:587]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'.
MSI (s) (8C:D4) [09:08:48:587]: Entering CMsiConfigurationManager::SetLastUsedSource.
MSI (s) (8C:D4) [09:08:48:587]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (8C:D4) [09:08:48:587]: Adding new sources is allowed.
MSI (s) (8C:D4) [09:08:48:588]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'.
MSI (s) (8C:D4) [09:08:48:588]: Package name extracted from package path: 'sql_common_core.msi'
MSI (s) (8C:D4) [09:08:48:588]: Package to be registered: 'sql_common_core.msi'
MSI (s) (8C:D4) [09:08:48:589]: Note: 1: 2262 2: AdminProperties 3: -2147287038 
MSI (s) (8C:D4) [09:08:48:589]: Machine policy value 'DisableMsi' is 1
MSI (s) (8C:D4) [09:08:48:589]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (8C:D4) [09:08:48:589]: User policy value 'AlwaysInstallElevated' is 0
MSI (s) (8C:D4) [09:08:48:589]: Product installation will be elevated because user is admin and product is being installed per-machine.
MSI (s) (8C:D4) [09:08:48:589]: Running product '{36F70DEE-1EBF-4707-AFA2-E035EEAEBAA1}' with elevated privileges: Product is assigned.
MSI (s) (8C:D4) [09:08:48:589]: PROPERTY CHANGE: Adding EXTERNALMSICONTROL property. Its value is '1'.
MSI (s) (8C:D4) [09:08:48:589]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'Client_Components_CNS,CommonFiles,Connectivity_CNS'.
MSI (s) (8C:D4) [09:08:48:589]: PROPERTY CHANGE: Adding VSINSTALLDIR property. Its value is 'C:\Program Files (x86)\Microsoft Visual Studio 9.0'.
MSI (s) (8C:D4) [09:08:48:589]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR_32 property. Its value is 'C:\Program Files (x86)\Microsoft SQL Server\'.
MSI (s) (8C:D4) [09:08:48:589]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR_64 property. Its value is 'c:\Program Files\Microsoft SQL Server\'.
MSI (s) (8C:D4) [09:08:48:589]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'.
MSI (s) (8C:D4) [09:08:48:589]: PROPERTY CHANGE: Modifying MEDIAPACKAGEPATH property. Its current value is '\Setup\'. Its new value: '\x64\setup\sql_common_core_msi\'.
MSI (s) (8C:D4) [09:08:48:589]: PROPERTY CHANGE: Adding PATCH property. Its value is 'C:\SAP Downloads\51044827\x86-x64-IA64\EnterpriseEdition\PCU\x64\setup\sql_common_core_msi\sql_common_core.msp'.
MSI (s) (8C:D4) [09:08:48:589]: Product: SQL Server 2008 R2 SP1 Common Files - Update 'Service Pack 1 for SQL Server Database Services 2008 Common Core (64-bit) (KB2528583)' could not be installed. Error code 1639. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130603_085621\sql_common_core_Cpu64_1.log.

MSI (s) (8C:D4) [09:08:48:590]: Windows Installer installed an update. Product Name: SQL Server 2008 R2 SP1 Common Files. Product Version: 10.51.2500.0. Product Language: 1033. Update Name: Service Pack 1 for SQL Server Database Services 2008 Common Core (64-bit) (KB2528583). Installation success or error status: 1639.

MSI (s) (8C:D4) [09:08:48:591]: Note: 1: 1708 
MSI (s) (8C:D4) [09:08:48:591]: Product: SQL Server 2008 R2 SP1 Common Files -- Installation failed.

MSI (s) (8C:D4) [09:08:48:592]: Windows Installer installed the product. Product Name: SQL Server 2008 R2 SP1 Common Files. Product Version: 10.51.2500.0. Product Language: 1033. Installation success or error status: 1639.

MSI (s) (8C:D4) [09:08:48:593]: Attempting to delete file C:\Windows\Installer\10909421.msp
MSI (s) (8C:D4) [09:08:48:594]: MainEngineThread is returning 1639
Info 1639. Invalid command line argument. Consult the Windows Installer SDK for detailed command line help.
;"C:\SAP
MSI (s) (8C:BC) [09:08:48:595]: User policy value 'DisableRollback' is 0
MSI (s) (8C:BC) [09:08:48:595]: Machine policy value 'DisableRollback' is 0
MSI (s) (8C:BC) [09:08:48:595]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (8C:BC) [09:08:48:595]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 
MSI (s) (8C:BC) [09:08:48:597]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 
MSI (s) (8C:BC) [09:08:48:597]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2 
MSI (s) (8C:BC) [09:08:48:598]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2 
MSI (s) (8C:BC) [09:08:48:598]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (s) (8C:BC) [09:08:48:598]: Restoring environment variables
MSI (c) (08:24) [09:08:48:600]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (08:24) [09:08:48:601]: MainEngineThread is returning 1639
=== Verbose logging stopped: 6/3/2013  9:08:48 ===

Please review the log and let me know the solution.

Thanks,

Krishna

Replies

Alberto Morillo on Mon, 03 Jun 2013 15:43:47


Hello,

Could you try to rename the directory “SAP Downloads” as “SAP” only, and try to run SQL Server setup again.

There is no need to stop any SQL Server service.

Have you seen this article about upgrading a SAP instance?

http://blogs.msdn.com/b/saponsqlserver/archive/2009/11/29/upgrade-to-sql-server-2008-or-sql-server-2008-r2-with-minimal-downtime.aspx   

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Krishna Gine on Tue, 04 Jun 2013 11:29:43


Hi Akberto,

Thanks for the reply. it worked after changing folder name with no space in it.

Regards,

Krishna

Alberto Morillo on Tue, 04 Jun 2013 11:36:39


Hello,

Thank you for letting me know. I am glad it worked.

Thank you for visiting MSDN forums!

Regards,

Alberto Morillo
SQLCoffee.com