locked
SCOM Reporting "Could not find stored procedure 'sdk.GetServiceLevelInformationData'." RRS feed

  • Question

  • I tried adding the management pack "Microsoft System Center 2012 R2 Management Pack for Virtual Machine Manger Host and Virtual Machine Dashboards"

    But we are getting the following errors:

    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.ServiceLevel.DataProviders!ServiceLevelAgreementProvider/GetServiceLevels] in provider: [Microsoft.EnterpriseManagement.ServiceLevel.DataProviders.ServiceLevelAgreementProvider, Microsoft.EnterpriseManagement.ServiceLevel.DataProviders, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35].Could not find stored procedure 'sdk.GetServiceLevelInformationData'. ---> Microsoft.EnterpriseManagement.Common.UnknownDatabaseException: Could not find stored procedure 'sdk.GetServiceLevelInformationData'.
       at Microsoft.EnterpriseManagement.Monitoring.DataProviders.RetryCommandExecutionStrategy.Invoke(IDataProviderCommandMethodInvoker invoker)
       at Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderCommandMethod.Invoke(CoreDataGateway gateWay, DataCommand command)
       --- 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)

    Tuesday, October 6, 2015 6:28 PM

Answers

  • Hi Kanjas,

    "Microsoft.EnterpriseManagement.Common.UnknownDatabaseException: Could not find stored procedure 'sdk.GetServiceLevelInformationData'."

    SDK.GetServiceLevelInformationData is a stored procedure under OM DB "DataWarehouse" .

    This issue implies that is related to SQL DB , you should be able to find it in SQL server management studio :

    If the stored procedure exists , I'm afaid that you need to open a case with Microsoft :

    https://support.microsoft.com/en-us/gp/support-options-for-business?wa=wsignin1.0

    PAUL

    • Proposed as answer by Elton_Ji Tuesday, October 20, 2015 3:19 AM
    • Marked as answer by Elton_Ji Wednesday, October 21, 2015 6:06 AM
    Monday, October 19, 2015 9:39 AM