none
Не отображает summary dashboard network RRS feed

  • Вопрос

  • Здравствуйте, стоит на сервере scom 2012 sp1 rollup1, база к нему лежит на другом сервере вместе с reporting service. Данные собираются, всё отображается, отчёты работают. Но при нажатии summary dashboard network появляется ошибка, при чем если смотреть по отдельности то все отображается, не работает только этот dashboard. Подскажите что это могло бы быть.

    Ошибка:

    Please provide the following information to the support engineer if you have to contact Microsoft Help and Support :

    Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderException: An error occurred executing the command: [Microsoft.EnterpriseManagement.Presentation.DataProviders.Library!NetworkDashboardProvider/GetCurrentTopNodesByPerformance] in provider: [Microsoft.EnterpriseManagement.Presentation.DataProviders.NetworkDashboardProvider, Microsoft.EnterpriseManagement.Presentation.DataProviders.Library, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]. : Unable to execute stored procedure needed for dashboard.  If you just installed Operations Manager Reporting Server, please wait a while and try again.  This can also occur if the Operations Manager Reporting Server SQL Server is not started or inaccessible. ---> Microsoft.EnterpriseManagement.Presentation.DataProviders.DataWarehouseException: Unable to execute stored procedure needed for dashboard.  If you just installed Operations Manager Reporting Server, please wait a while and try again.  This can also occur if the Operations Manager Reporting Server SQL Server is not started or inaccessible. ---> Microsoft.EnterpriseManagement.Common.UnknownDatabaseException: Could not find stored procedure 'SDK.Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByPerformance2'.
       at Microsoft.EnterpriseManagement.Common.Internal.ServiceProxy.HandleFault(String methodName, Message message)
       at Microsoft.EnterpriseManagement.Common.Internal.MonitoringDataWarehouseServiceProxy.GetDataWarehouseStoredProcedureResult(String SpName, StoredProcedureParameterCollection param, IEnumerable`1 columnFilter, Int32 timeout)
       at Microsoft.EnterpriseManagement.Warehouse.DataWarehouse.GetDataWarehouseData(String storedProcedureName, StoredProcedureParameterCollection param, IEnumerable`1 columnFilter, Int32 timeout)
       at Microsoft.EnterpriseManagement.Warehouse.DataWarehouse.GetDataWarehouseData(String storedProcedureName, StoredProcedureParameterCollection param)
       at Microsoft.EnterpriseManagement.Presentation.DataProviders.NetworkDashboardProvider.GetCurrentTopNodesByPerformance(DateTime startDateTime, IDataObject performanceCounterArray, Boolean sortAscending, Int32 numEntities)
       --- End of inner exception stack trace ---
       at Microsoft.EnterpriseManagement.Presentation.DataProviders.NetworkDashboardProvider.GetCurrentTopNodesByPerformance(DateTime startDateTime, IDataObject performanceCounterArray, Boolean sortAscending, Int32 numEntities)
       --- End of inner exception stack trace ---
       at Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderCommandMethod.Invoke(CoreDataGateway gateWay, DataCommand command)
       at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.ExecuteInternal[TResult](DataCommand command)
       at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.<ExecuteAsync>b__0[TResult](<>f__AnonymousType0`1 data)

    25 января 2013 г. 2:31

Ответы

  • Алерты и ошибки в логах с содержанием вида "Data Warehouse Database Component Deployment " или подобного есть?

    Сделайте резервную копию базы и выполните скрипт на DataWarehouse:

    IF NOT EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByPerformance2' AND UID = SCHEMA_ID('SDK'))
    BEGIN
        EXECUTE ('CREATE PROCEDURE SDK.Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByPerformance2 AS RETURN 1')
    END
    GO
    ALTER PROCEDURE [SDK].[Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByPerformance2]
        @ManagementGroup uniqueidentifier,
        @ClassXml nvarchar(max),
        @StartTime datetime,
        @EndTime datetime,
        @ObjectName nvarchar(256),
        @CounterName nvarchar(256),
        @InstanceName nvarchar(256) = '',
        @NumEntities int,
        @AggregationType int,
        @OrderBy int
    AS
    BEGIN
        SET NOCOUNT ON
        DECLARE
             @ErrorInd         bit
            ,@ErrorMessage     nvarchar(max)
            ,@ErrorNumber      int
            ,@ErrorSeverity    int
            ,@ErrorState       int
            ,@ErrorLine        int
            ,@ErrorProcedure   nvarchar(256)
            ,@ErrorMessageText nvarchar(max)
        SET @ErrorInd = 0
    /* ------------------------------ */
        BEGIN TRY
            DECLARE @ExecError int
            -- Create #ClassTable to contain the GUIDs for all of the class types that we care about
            CREATE TABLE #ClassTable(
                Id uniqueidentifier)
            -- Parse the ClassXml to get the GUIDs into the #ClassTable
            DECLARE @xmlhandle int
            EXEC @ExecError = sp_xml_preparedocument @xmlhandle OUTPUT, @ClassXml
            IF NOT @ExecError = 0
                RAISERROR(777971000, 16, 1
                    ,'ClassXml'
                    ,@ExecError)
            INSERT INTO #ClassTable (Id)
            SELECT ID
            FROM
                OPENXML(@xmlhandle, '/Classes/Class', 2)
            WITH
                (ID nvarchar(max))
            -- #ClassTable is now set up
            CREATE TABLE #ManagedEntityTable(
                ManagedEntityRowId int)
            INSERT INTO #ManagedEntityTable
            SELECT DISTINCT ME.ManagedEntityRowId FROM vManagedEntity AS ME
                INNER JOIN vManagedEntityType AS MET ON MET.ManagedEntityTypeRowId = ME.ManagedEntityTypeRowId
                INNER JOIN #ClassTable AS CT ON CT.Id = MET.ManagedEntityTypeGuid
                INNER JOIN vManagementGroup AS MG ON MG.ManagementGroupRowId = ME.ManagementGroupRowId
                INNER JOIN vManagedEntityManagementGroup AS MEMG ON MEMG.ManagedEntityRowId = ME.ManagedEntityRowId
            WHERE MG.ManagementGroupGuid = @ManagementGroup
                AND MEMG.ToDateTime IS null
            -- #ManagedEntityTable is now set up
            CREATE TABLE #TopNTable (
                EntityGuid uniqueidentifier,
                DisplayName nvarchar(max),
                EntityRowId int,
                SampleValue float)
            DECLARE
                 @SqlStatement nvarchar(max)
                ,@SelectStatement nvarchar(max)
                ,@WhereStatement nvarchar(max)
                ,@TimeStatement nvarchar(max)
                ,@OrderByStatement nvarchar(max)
                ,@ViewName nvarchar(max)
                ,@ColumnName nvarchar(max)
            IF @AggregationType = 0
            BEGIN
                SET @ViewName = 'Perf.vPerfRaw'
                SET @ColumnName = 'vPerf.SampleValue'
                SET @TimeStatement = '
                    AND vPerf.DateTime >= @StartTime
                    AND vPerf.DateTime <= @EndTime
                    '
            END
            ELSE IF @AggregationType = 20
            BEGIN
                SET @ViewName = 'Perf.vPerfHourly'
                SET @ColumnName = 'vPerf.AverageValue'
                SET @TimeStatement = '
                    AND (vPerf.DateTime >= DATEADD(hh, DATEPART(hh, @StartTime), convert(varchar(8), @StartTime, 112)))
                    AND (vPerf.DateTime < DATEADD(hh, DATEPART(hh, @EndTime), convert(varchar(8), @EndTime, 112)))
                    '
            END
            ELSE IF @AggregationType = 30
            BEGIN
                SET @ViewName = 'Perf.vPerfDaily'
                SET @ColumnName = 'vPerf.AverageValue'
                SET @TimeStatement = '
                    AND (vPerf.DateTime >= DATEADD(hh, DATEPART(hh, @StartTime), convert(varchar(8), @StartTime, 112)))
                    AND (vPerf.DateTime < DATEADD(hh, DATEPART(hh, @EndTime), convert(varchar(8), @EndTime, 112)))
                    '
            END
            ELSE
            BEGIN
                RAISERROR (777971002, 16, 1
                    ,0
                    ,0
                    ,0
                    ,N'SDK.GetTopEntitiesByPerformance'
                    ,0
                    ,N'Invalid AggregationType - only 0, 20, and 30 are supported'
                )
            END
            IF @InstanceName = '' OR @InstanceName IS NULL
                SET @WhereStatement = '
                    WHERE PRule.ObjectName = @ObjectName
                        AND PRule.CounterName = @CounterName
                    '
            ELSE
                SET @WhereStatement = '
                    WHERE PRule.ObjectName = @ObjectName
                        AND PRule.CounterName = @CounterName
                        AND PRI.InstanceName = @InstanceName
                    '
            IF @OrderBy = 0
                SET @OrderByStatement = ' ORDER BY AVERAGE ASC '
            ELSE
                SET @OrderByStatement = ' ORDER BY AVERAGE DESC '
            SET @SqlStatement = '
                INSERT INTO #TopNTable (EntityRowId, SampleValue)
                SELECT TOP (@NumEntities) MET.ManagedEntityRowId, AVG(' + @ColumnName + ') AS Average
                FROM ' + @ViewName + ' AS vPerf
                    INNER JOIN vPerformanceRuleInstance AS PRI ON PRI.PerformanceRuleInstanceRowId = vPerf.PerformanceRuleInstanceRowId
                    INNER JOIN vPerformanceRule AS PRule ON PRule.RuleRowId = PRI.RuleRowId
                    INNER JOIN #ManagedEntityTable AS MET ON MET.ManagedEntityRowId = vPerf.ManagedEntityRowId
                ' + @WhereStatement + @TimeStatement + '
                GROUP BY MET.ManagedEntityRowId ' +
                @OrderByStatement
            EXEC sp_executesql @SqlStatement,
                @params = N'
                    @StartTime datetime,
                    @EndTime datetime,
                    @ObjectName nvarchar(256),
                    @CounterName nvarchar(256),
                    @InstanceName nvarchar(256),
                    @NumEntities int,
                    @ColumnName nvarchar(max)',
                @StartTime = @StartTime,
                @EndTime = @EndTime,
                @ObjectName = @ObjectName,
                @CounterName = @CounterName,
                @InstanceName = @InstanceName,
                @NumEntities = @NumEntities,
                @ColumnName = @ColumnName
            DECLARE
                @RowId int
            SET @RowId = 0
            WHILE EXISTS(SELECT * FROM #TopNTable as TNT where TNT.EntityRowId > @RowId)
            BEGIN
                SELECT TOP 1 @RowId = TNT.EntityRowId
                FROM #TopNTable as TNT
                WHERE TNT.EntityRowId > @RowId
                ORDER BY TNT.EntityRowId ASC
                UPDATE #TopNTable SET 
                    DisplayName = ME.DisplayName
                    ,EntityGuid = ME.ManagedEntityGuid
                FROM vManagedEntity as ME
                    INNER JOIN #TopNTable as TNT on TNT.EntityRowId = ME.ManagedEntityRowId
                WHERE ME.ManagedEntityRowId = @RowId
            END
            IF (@OrderBy = 0)
                SELECT TNT.EntityGuid as Id, TNT.DisplayName, TNT.SampleValue FROM #TopNTable AS TNT
                ORDER BY SampleValue ASC
            ELSE
                SELECT TNT.EntityGuid as Id, TNT.DisplayName, TNT.SampleValue FROM #TopNTable AS TNT
                ORDER BY SampleValue DESC
        END TRY
        BEGIN CATCH
            IF (@@TRANCOUNT > 0)
                ROLLBACK TRAN
            SELECT
                 @ErrorNumber = ERROR_NUMBER()
                ,@ErrorSeverity = ERROR_SEVERITY()
                ,@ErrorState = ERROR_STATE()
                ,@ErrorLine = ERROR_LINE()
                ,@ErrorProcedure = ISNULL(ERROR_PROCEDURE(), '-')
                ,@ErrorMessageText = ERROR_MESSAGE()
            SET @ErrorInd = 1
        END CATCH
        -- report error if any
        IF (@ErrorInd = 1)
        BEGIN
            DECLARE @AdjustedErrorSeverity int
            SET @AdjustedErrorSeverity = CASE
                                             WHEN @ErrorSeverity > 18 THEN 18
                                             ELSE @ErrorSeverity
                                         END
            RAISERROR (777971002, @AdjustedErrorSeverity, 1
                ,@ErrorNumber
                ,@ErrorSeverity
                ,@ErrorState
                ,@ErrorProcedure
                ,@ErrorLine
                ,@ErrorMessageText
            )
        END
    END
    GO
    GRANT EXECUTE ON [SDK].[Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByPerformance2] TO OpsMgrReader
    GO


    http://OpsMgr.ru/

    29 января 2013 г. 4:48
    Отвечающий
  • Вы можете распаковать Microsoft.SystemCenter.Visualization.Library.mpb и взять скрипты для создания процедур оттуда. Скрипты для распаковки можно найти в поисковиках. Но вообще я бы завел кейс в поддержке, потому что отсутствие процедур в массовом порядке это нехорошая ситуация и вам лучше выяснить корневую причину этого.

    http://OpsMgr.ru/

    5 февраля 2013 г. 5:08
    Отвечающий

Все ответы

  • Could not find stored procedure 'SDK.Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByPerformance2'.

    Ищите эту процедуру в DataWarehouse и смотрите права.


    http://OpsMgr.ru/

    25 января 2013 г. 4:52
    Отвечающий
  • Я смотрю эта проблема стала появляться в интернете всё чаще и чаще.

    Vladimir Zelenov | http://systemcenter4all.wordpress.com

    25 января 2013 г. 6:29
    Отвечающий
  • Такой процедуры не нашел, но есть в базе OperationsManagerDW очень похожая 'SDK.Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByPerformance'. Всё тоже самое только без "2" на конце. Такое чувство что она взялась там случайно :) Но откуда она взялась  и как её убрать?


    28 января 2013 г. 1:29
  • Microsoft.SystemCenter.Visualization.Library какой версии импортирован?


    http://OpsMgr.ru/

    28 января 2013 г. 7:37
    Отвечающий
  • 7.0.9538.0
    28 января 2013 г. 22:21
  • Алерты и ошибки в логах с содержанием вида "Data Warehouse Database Component Deployment " или подобного есть?

    Сделайте резервную копию базы и выполните скрипт на DataWarehouse:

    IF NOT EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByPerformance2' AND UID = SCHEMA_ID('SDK'))
    BEGIN
        EXECUTE ('CREATE PROCEDURE SDK.Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByPerformance2 AS RETURN 1')
    END
    GO
    ALTER PROCEDURE [SDK].[Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByPerformance2]
        @ManagementGroup uniqueidentifier,
        @ClassXml nvarchar(max),
        @StartTime datetime,
        @EndTime datetime,
        @ObjectName nvarchar(256),
        @CounterName nvarchar(256),
        @InstanceName nvarchar(256) = '',
        @NumEntities int,
        @AggregationType int,
        @OrderBy int
    AS
    BEGIN
        SET NOCOUNT ON
        DECLARE
             @ErrorInd         bit
            ,@ErrorMessage     nvarchar(max)
            ,@ErrorNumber      int
            ,@ErrorSeverity    int
            ,@ErrorState       int
            ,@ErrorLine        int
            ,@ErrorProcedure   nvarchar(256)
            ,@ErrorMessageText nvarchar(max)
        SET @ErrorInd = 0
    /* ------------------------------ */
        BEGIN TRY
            DECLARE @ExecError int
            -- Create #ClassTable to contain the GUIDs for all of the class types that we care about
            CREATE TABLE #ClassTable(
                Id uniqueidentifier)
            -- Parse the ClassXml to get the GUIDs into the #ClassTable
            DECLARE @xmlhandle int
            EXEC @ExecError = sp_xml_preparedocument @xmlhandle OUTPUT, @ClassXml
            IF NOT @ExecError = 0
                RAISERROR(777971000, 16, 1
                    ,'ClassXml'
                    ,@ExecError)
            INSERT INTO #ClassTable (Id)
            SELECT ID
            FROM
                OPENXML(@xmlhandle, '/Classes/Class', 2)
            WITH
                (ID nvarchar(max))
            -- #ClassTable is now set up
            CREATE TABLE #ManagedEntityTable(
                ManagedEntityRowId int)
            INSERT INTO #ManagedEntityTable
            SELECT DISTINCT ME.ManagedEntityRowId FROM vManagedEntity AS ME
                INNER JOIN vManagedEntityType AS MET ON MET.ManagedEntityTypeRowId = ME.ManagedEntityTypeRowId
                INNER JOIN #ClassTable AS CT ON CT.Id = MET.ManagedEntityTypeGuid
                INNER JOIN vManagementGroup AS MG ON MG.ManagementGroupRowId = ME.ManagementGroupRowId
                INNER JOIN vManagedEntityManagementGroup AS MEMG ON MEMG.ManagedEntityRowId = ME.ManagedEntityRowId
            WHERE MG.ManagementGroupGuid = @ManagementGroup
                AND MEMG.ToDateTime IS null
            -- #ManagedEntityTable is now set up
            CREATE TABLE #TopNTable (
                EntityGuid uniqueidentifier,
                DisplayName nvarchar(max),
                EntityRowId int,
                SampleValue float)
            DECLARE
                 @SqlStatement nvarchar(max)
                ,@SelectStatement nvarchar(max)
                ,@WhereStatement nvarchar(max)
                ,@TimeStatement nvarchar(max)
                ,@OrderByStatement nvarchar(max)
                ,@ViewName nvarchar(max)
                ,@ColumnName nvarchar(max)
            IF @AggregationType = 0
            BEGIN
                SET @ViewName = 'Perf.vPerfRaw'
                SET @ColumnName = 'vPerf.SampleValue'
                SET @TimeStatement = '
                    AND vPerf.DateTime >= @StartTime
                    AND vPerf.DateTime <= @EndTime
                    '
            END
            ELSE IF @AggregationType = 20
            BEGIN
                SET @ViewName = 'Perf.vPerfHourly'
                SET @ColumnName = 'vPerf.AverageValue'
                SET @TimeStatement = '
                    AND (vPerf.DateTime >= DATEADD(hh, DATEPART(hh, @StartTime), convert(varchar(8), @StartTime, 112)))
                    AND (vPerf.DateTime < DATEADD(hh, DATEPART(hh, @EndTime), convert(varchar(8), @EndTime, 112)))
                    '
            END
            ELSE IF @AggregationType = 30
            BEGIN
                SET @ViewName = 'Perf.vPerfDaily'
                SET @ColumnName = 'vPerf.AverageValue'
                SET @TimeStatement = '
                    AND (vPerf.DateTime >= DATEADD(hh, DATEPART(hh, @StartTime), convert(varchar(8), @StartTime, 112)))
                    AND (vPerf.DateTime < DATEADD(hh, DATEPART(hh, @EndTime), convert(varchar(8), @EndTime, 112)))
                    '
            END
            ELSE
            BEGIN
                RAISERROR (777971002, 16, 1
                    ,0
                    ,0
                    ,0
                    ,N'SDK.GetTopEntitiesByPerformance'
                    ,0
                    ,N'Invalid AggregationType - only 0, 20, and 30 are supported'
                )
            END
            IF @InstanceName = '' OR @InstanceName IS NULL
                SET @WhereStatement = '
                    WHERE PRule.ObjectName = @ObjectName
                        AND PRule.CounterName = @CounterName
                    '
            ELSE
                SET @WhereStatement = '
                    WHERE PRule.ObjectName = @ObjectName
                        AND PRule.CounterName = @CounterName
                        AND PRI.InstanceName = @InstanceName
                    '
            IF @OrderBy = 0
                SET @OrderByStatement = ' ORDER BY AVERAGE ASC '
            ELSE
                SET @OrderByStatement = ' ORDER BY AVERAGE DESC '
            SET @SqlStatement = '
                INSERT INTO #TopNTable (EntityRowId, SampleValue)
                SELECT TOP (@NumEntities) MET.ManagedEntityRowId, AVG(' + @ColumnName + ') AS Average
                FROM ' + @ViewName + ' AS vPerf
                    INNER JOIN vPerformanceRuleInstance AS PRI ON PRI.PerformanceRuleInstanceRowId = vPerf.PerformanceRuleInstanceRowId
                    INNER JOIN vPerformanceRule AS PRule ON PRule.RuleRowId = PRI.RuleRowId
                    INNER JOIN #ManagedEntityTable AS MET ON MET.ManagedEntityRowId = vPerf.ManagedEntityRowId
                ' + @WhereStatement + @TimeStatement + '
                GROUP BY MET.ManagedEntityRowId ' +
                @OrderByStatement
            EXEC sp_executesql @SqlStatement,
                @params = N'
                    @StartTime datetime,
                    @EndTime datetime,
                    @ObjectName nvarchar(256),
                    @CounterName nvarchar(256),
                    @InstanceName nvarchar(256),
                    @NumEntities int,
                    @ColumnName nvarchar(max)',
                @StartTime = @StartTime,
                @EndTime = @EndTime,
                @ObjectName = @ObjectName,
                @CounterName = @CounterName,
                @InstanceName = @InstanceName,
                @NumEntities = @NumEntities,
                @ColumnName = @ColumnName
            DECLARE
                @RowId int
            SET @RowId = 0
            WHILE EXISTS(SELECT * FROM #TopNTable as TNT where TNT.EntityRowId > @RowId)
            BEGIN
                SELECT TOP 1 @RowId = TNT.EntityRowId
                FROM #TopNTable as TNT
                WHERE TNT.EntityRowId > @RowId
                ORDER BY TNT.EntityRowId ASC
                UPDATE #TopNTable SET 
                    DisplayName = ME.DisplayName
                    ,EntityGuid = ME.ManagedEntityGuid
                FROM vManagedEntity as ME
                    INNER JOIN #TopNTable as TNT on TNT.EntityRowId = ME.ManagedEntityRowId
                WHERE ME.ManagedEntityRowId = @RowId
            END
            IF (@OrderBy = 0)
                SELECT TNT.EntityGuid as Id, TNT.DisplayName, TNT.SampleValue FROM #TopNTable AS TNT
                ORDER BY SampleValue ASC
            ELSE
                SELECT TNT.EntityGuid as Id, TNT.DisplayName, TNT.SampleValue FROM #TopNTable AS TNT
                ORDER BY SampleValue DESC
        END TRY
        BEGIN CATCH
            IF (@@TRANCOUNT > 0)
                ROLLBACK TRAN
            SELECT
                 @ErrorNumber = ERROR_NUMBER()
                ,@ErrorSeverity = ERROR_SEVERITY()
                ,@ErrorState = ERROR_STATE()
                ,@ErrorLine = ERROR_LINE()
                ,@ErrorProcedure = ISNULL(ERROR_PROCEDURE(), '-')
                ,@ErrorMessageText = ERROR_MESSAGE()
            SET @ErrorInd = 1
        END CATCH
        -- report error if any
        IF (@ErrorInd = 1)
        BEGIN
            DECLARE @AdjustedErrorSeverity int
            SET @AdjustedErrorSeverity = CASE
                                             WHEN @ErrorSeverity > 18 THEN 18
                                             ELSE @ErrorSeverity
                                         END
            RAISERROR (777971002, @AdjustedErrorSeverity, 1
                ,@ErrorNumber
                ,@ErrorSeverity
                ,@ErrorState
                ,@ErrorProcedure
                ,@ErrorLine
                ,@ErrorMessageText
            )
        END
    END
    GO
    GRANT EXECUTE ON [SDK].[Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByPerformance2] TO OpsMgrReader
    GO


    http://OpsMgr.ru/

    29 января 2013 г. 4:48
    Отвечающий
  • Ошибок не пишет, спасибо большое, заработало. А можно ещё такое же наполнение для процедур: SDK.Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByHostedEntityPerformance2

    SDK.Microsoft_SystemCenter_Visualization_Library_GetTopInterfacesByPerformance2

    SDK.Microsoft_SystemCenter_Visualization_Library_GetTopNodesByAlerts2

    SDK.Microsoft_SystemCenter_Visualization_Library_GetTopEntitiesByAlerts2

    чтобы оставшиеся dashboard's заработали в summary network :)

    4 февраля 2013 г. 23:54
  • Вы можете распаковать Microsoft.SystemCenter.Visualization.Library.mpb и взять скрипты для создания процедур оттуда. Скрипты для распаковки можно найти в поисковиках. Но вообще я бы завел кейс в поддержке, потому что отсутствие процедур в массовом порядке это нехорошая ситуация и вам лучше выяснить корневую причину этого.

    http://OpsMgr.ru/

    5 февраля 2013 г. 5:08
    Отвечающий
  • Спасибо, причина скорее всего в том что я переносил базы на другой сервер(по причине, что для sp1 нужна более новая версия sql сервер) и при обновлении до sp1 скорее всего какая-то бага произошла и новые процедуры не прописались в новую базу. Но не факт конечно, что я прав.

    5 февраля 2013 г. 22:34
  • Всё процедуры нашел, кроме

    SDK.Microsoft_SystemCenter_Visualization_Library_GetTopInterfacesByPerformance2

    5 февраля 2013 г. 23:21