none
SCOM / OPSMGR execution of CLR code

    Question

  • Does SCOM 2007 enable CLR on the SQL Server or is it a task that must be performed. As i now get errors when doing tasks

    Date: 30/06/2009 12:38:09 p.m.
    Application: System Center Operations Manager 2007
    Application Version: 6.0.6278.0
    Severity: Error
    Message:
     
    Microsoft.EnterpriseManagement.Common.UnknownServiceException: The service threw an unknown exception. See inner exception for details. ---> System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]: Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option. (Fault Detail is equal to An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
    System.Data.SqlClient.SqlException: Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at Sys...).
       --- End of inner exception stack trace ---
       at Microsoft.EnterpriseManagement.DataAbstractionLayer.SdkDataAbstractionLayer.HandleIndigoExceptions(Exception ex)
       at Microsoft.EnterpriseManagement.DataAbstractionLayer.TypeSpaceOperations.PerformGroupMembershipDiscoverySnapshot(String managementPackXml)
       at Microsoft.EnterpriseManagement.ManagementGroup.RefreshMonitoringGroupMembers(ManagementPack managementPack)
       at Microsoft.EnterpriseManagement.Internal.UI.Authoring.Extensibility.MomTemplatePagesManager.PopulateNewGenericGroupMembers(Object sender, ConsoleJobEventArgs e)
       at Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ConsoleJobExceptionHandler.ExecuteJob(IComponent component, EventHandler`1 job, Object sender, ConsoleJobEventArgs args)
    System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]: Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option. (Fault Detail is equal to An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
    System.Data.SqlClient.SqlException: Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at Sys...).
    Tuesday, June 30, 2009 7:51 PM

Answers

  • Setup configurs SQL to allow execution of CLR code. You can do it manually.
    Run this on the OperationsManager database

    sp_configure @configname=clr_enabled, @configvalue=1
    GO
    RECONFIGURE
    GO

    http://OpsMgr.ru/
    Wednesday, July 1, 2009 2:36 AM
    Moderator

All replies

  • Setup configurs SQL to allow execution of CLR code. You can do it manually.
    Run this on the OperationsManager database

    sp_configure @configname=clr_enabled, @configvalue=1
    GO
    RECONFIGURE
    GO

    http://OpsMgr.ru/
    Wednesday, July 1, 2009 2:36 AM
    Moderator
  • Hi There, Thank you for the answer but i need to know if it should be turned on or is this the result of poor Management Packs. I never got these errors till i installed DFS and DHCP MP's.

    Cheers
    Wednesday, July 1, 2009 8:49 PM
  • Hi

    sp_Configure @Configname=clr_enabled,@configvalue=1

    GO

    RECONFIGURE

    GO

    it's worked for me..

    Friday, July 6, 2012 9:32 AM