locked
A MOF syntax error occurred - SQL Server ENT 2008 R2 on Windows Server 2008 R2 RRS feed

  • Question

  • Having trouble getting SQL Server 2008 R2 installed on a Windows Server 2008 R2. Getting an MOF syntax error at this point durring the installation "SqlEngineConfigAction_install_confignonrc_Cpu64". Below is the section of the Details.txt file that includes the error. Any help on this would be greatly appreciated.

     

    2010-07-28 10:51:35 Slp: Running: C:\Windows\system32\WBEM\mofcomp.exe "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\xesospkg.mof"
    2010-07-28 10:51:35 Slp: Microsoft (R) MOF Compiler Version 6.1.7600.16385
    2010-07-28 10:51:35 Slp: Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
    2010-07-28 10:51:35 Slp: Parsing MOF file: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\xesospkg.mof
    2010-07-28 10:51:35 Slp: MOF file has been successfully parsed
    2010-07-28 10:51:35 Slp: Storing data in the repository...
    2010-07-28 10:51:36 Slp: An error occurred while processing item 17 defined on lines 201 - 222 in file C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\xesospkg.mof:
    2010-07-28 10:51:36 Slp: Compiler returned error 0x800706beError Number: 0x800706be, Facility: Win32
    2010-07-28 10:51:36 Slp: Description: The remote procedure call failed.
    2010-07-28 10:51:36 Slp:
    2010-07-28 10:51:36 Slp: Sco: Compile operation for mof file C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\xesospkg.mof failed. Exit code 3
    2010-07-28 10:51:36 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigNonRC and scenario ConfigNonRC.
    2010-07-28 10:51:36 Slp: A MOF syntax error occurred.
    2010-07-28 10:51:36 Slp: The configuration failure category of current exception is ConfigurationFailure
    2010-07-28 10:51:36 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigNonRC and scenario ConfigNonRC.
    2010-07-28 10:51:36 Slp: Microsoft.SqlServer.Configuration.Sco.ScoException: A MOF syntax error occurred.
    2010-07-28 10:51:36 Slp:    at Microsoft.SqlServer.Configuration.Sco.WmiProvider.InstallMof()
    2010-07-28 10:51:36 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.XEventSetup.Install(String path)
    2010-07-28 10:51:36 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Install_ConfigNonRC_Prepare(EffectiveProperties properties)
    2010-07-28 10:51:36 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)
    2010-07-28 10:51:36 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
    2010-07-28 10:51:36 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
    2010-07-28 10:51:36 Slp: Exception: Microsoft.SqlServer.Configuration.Sco.ScoException.
    2010-07-28 10:51:36 Slp: Source: Microsoft.SqlServer.Configuration.Sco.
    2010-07-28 10:51:36 Slp: Message: A MOF syntax error occurred..
    2010-07-28 10:51:36 Slp: Watson Bucket 1
     Original Parameter Values

    2010-07-28 10:51:36 Slp: Parameter 0 : SQL Server 2008 R2@RTM@

    2010-07-28 10:51:36 Slp: Parameter 1 : Microsoft.SqlServer.Configuration.Sco.WmiProvider.InstallMof

    2010-07-28 10:51:36 Slp: Parameter 2 : Microsoft.SqlServer.Configuration.Sco.WmiProvider.InstallMof

    2010-07-28 10:51:36 Slp: Parameter 3 : Microsoft.SqlServer.Configuration.Sco.ScoException@1211@1

    2010-07-28 10:51:36 Slp: Parameter 4 : Microsoft.SqlServer.Configuration.Sco.ScoException@1211@1

    2010-07-28 10:51:36 Slp: Parameter 5 : SqlEngineConfigAction_install_confignonrc

    2010-07-28 10:51:36 Slp: Parameter 6 : INSTALL@CONFIGNONRC@SQL_ENGINE_CORE_INST

    2010-07-28 10:51:36 Slp:
     Final Parameter Values

    2010-07-28 10:51:36 Slp: Parameter 0 : SQL Server 2008 R2@RTM@

    2010-07-28 10:51:36 Slp: Parameter 1 : 0xA60E3551

    2010-07-28 10:51:36 Slp: Parameter 2 : 0xA60E3551

    2010-07-28 10:51:36 Slp: Parameter 3 : 0xD3BEBD98@1211@1

    2010-07-28 10:51:36 Slp: Parameter 4 : 0xD3BEBD98@1211@1

    2010-07-28 10:51:36 Slp: Parameter 5 : SqlEngineConfigAction_install_confignonrc

    2010-07-28 10:51:36 Slp: Parameter 6 : 0x50806C41

    2010-07-28 10:51:37 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100728_103610\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
    2010-07-28 10:51:37 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100728_103610\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2010-07-28 10:51:37 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100728_103610\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
    2010-07-28 10:51:37 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100728_103610\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
    2010-07-28 10:51:37 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100728_103610\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2010-07-28 10:51:37 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100728_103610\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_
    2010-07-28 10:51:40 Slp: A MOF syntax error occurred.
    2010-07-28 10:51:40 Slp: Watson bucket for exception based failure has been created
    2010-07-28 10:51:49 Slp: Error: Action "SqlEngineConfigAction_install_confignonrc_Cpu64" failed during execution.
    2010-07-28 10:51:49 Slp: Completed Action: SqlEngineConfigAction_install_confignonrc_Cpu64, returned False

    Wednesday, July 28, 2010 8:56 PM

Answers

  • We were not able to get it working until I reinstalled Windows Server 2008 R2. The one thing I did different was to not install the AV software, we are using McAfee. Without McAfee installed I was able to get SQL installed. I haven't had time to go back and verify that McAfee was the culprit but for right now I am installing SQL without McAfee and that works.

    • Proposed as answer by Tom Li - MSFT Saturday, September 11, 2010 3:41 AM
    • Marked as answer by LeftClick Tuesday, September 14, 2010 9:21 PM
    Friday, September 10, 2010 7:41 PM
  • Thanks for sharing that!

    The solution for us was that the installation source was corrupt in some way, delivered from SAP.

    So we downloaded it from MSDN and used our own license number and it all went trough.

    • Marked as answer by LeftClick Tuesday, September 14, 2010 9:21 PM
    Saturday, September 11, 2010 8:54 AM

All replies

  • Hello,

    It seems this issue is related to WMI.

    Verify WMI does not have inconsistencies. Use the winmgmt command with the  /salvagerepository switch.

    http://msdn.microsoft.com/en-us/library/aa394525(VS.85).aspx

    http://social.technet.microsoft.com/Forums/en-US/winservergen/thread/8ed26d46-9994-4052-a307-5b071805aea8

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, July 28, 2010 9:20 PM
  • Alberto,

    Thanks for the reply. Unfortunately I did try this already and confirmed with the /verifyrepository that the WMI repository is consistent.

    Any other thoughts?

     

    -Scott

    Thursday, July 29, 2010 12:40 AM
  • Has anyone else run into this problem? I'm on the phone with MSFT support right now and will post the findings.

    Thursday, July 29, 2010 6:17 PM
  • Three and a half hours on the phone with support but no resolution yet. This is being escalated and I'm waiting for a call back today or Monday.

    Friday, July 30, 2010 2:06 PM
  • Hi LeftClick,

     

    Have you solved this issue?

    If this issue still exists, for further investigation, could you please paste line 201 – 222 of file “C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\xesospkg.mof”?

    Monday, August 2, 2010 1:25 AM
  • Still unsolved, waiting to hear back from MSFT today. Below is line 201 - 222 of the xesospkg.mof file.

    Thanks for the reply,

    -Scott

     

     

    class scheduler_created: XeSosPkg_scheduler_created
    {
     [WmiDataId(1), Description("FragmentId"): Amended,read] uint32 FragmentId;
     [WmiDataId(2), Description("RemainingLength"): Amended,read] uint32 RemainingLength;
     [WmiDataId(3), Description("ActivityId"): Amended,ActivityID, read, Extension("Guid")] guid ActivityId;
     [WmiDataId(4), Description("SequenceNumber"): Amended,read] uint32 SequenceNumber;
     [WmiDataId(5), read] uint32 id;
     [WmiDataId(6), read] uint16 node_id;
     [WmiDataId(7), read,
        XEMapId(6),
        ValueMap {
         "0",
         "1" },
        Values {
         "FIBER",
         "THREAD" }
       ] uint32 worker_type;
     [WmiDataId(8), read] uint32 priority;
     [WmiDataId(9), read] uint64 affinity_mask;
     [WmiDataId(10), read] uint32 ideal_worker_limit;
     [WmiDataId(11), read] sint8  is_hidden;
    };

    Monday, August 2, 2010 1:52 PM
  • Hello LeftClick, haven't You received a solution to this yet? !!!

    We are having the same issue with a brand new install of Windows Server 2008 R2 + SQL 2008 (we tried Slip Streamed SP1) no success. :-(

    Wednesday, September 8, 2010 7:32 AM
  • We were not able to get it working until I reinstalled Windows Server 2008 R2. The one thing I did different was to not install the AV software, we are using McAfee. Without McAfee installed I was able to get SQL installed. I haven't had time to go back and verify that McAfee was the culprit but for right now I am installing SQL without McAfee and that works.

    • Proposed as answer by Tom Li - MSFT Saturday, September 11, 2010 3:41 AM
    • Marked as answer by LeftClick Tuesday, September 14, 2010 9:21 PM
    Friday, September 10, 2010 7:41 PM
  • Thanks for sharing that!

    The solution for us was that the installation source was corrupt in some way, delivered from SAP.

    So we downloaded it from MSDN and used our own license number and it all went trough.

    • Marked as answer by LeftClick Tuesday, September 14, 2010 9:21 PM
    Saturday, September 11, 2010 8:54 AM
  • I have  a MOF syntax error with SQL Express 2008 R2 10.50.1600.1 installing on a Windows XP machine. Is there a solution?
    Thursday, December 2, 2010 12:52 PM