Reporting Scenarios – More Samples(Updated Attachment)

Reporting Scenarios – More Samples(Updated Attachment)

  • Comments 8
  • Likes

Updated attachment to fix deployment for Forecast MP.

 This posting is provided "AS IS" with no warranties, and confers no rights. Use of included utilities are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm.

Daniel Savage

Attachment: MMSSAmples2.zip
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
  • Hi Daniel,

    I had Layne's problem as well and it was not corrected after importing this new version. I then deleted the MP and get a different type of error that repeats every 10 minutes. No change after importing just the new MP posted.

    It's a sandbox environment, but sure would like to get it cleaned up.  Thanks--

    Failed to deploy Data Warehouse component. The operation will be retried.

    Exception 'DeploymentException': Failed to perform Data Warehouse component deployment operation: Uninstall; Component: Script, Id: '8a477b44-6d7b-fef5-beff-b328e34b7400', Management Pack Version-dependent Id: '14b16a47-bd22-45c7-803a-90536af568b1'; Target: Database, Server name: 'Server01', Database name: 'OperationsManagerDW'. Batch ordinal: 0; Exception: Cannot drop the procedure 'sp_opsmgrforecast', because it does not exist or you do not have permission.

    One or more workflows were affected by this.  

    Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Component

    Instance name: Server.domain.com

    Instance ID: {31BF520C-5735-43FF-9AEF-5B8885F51A40}

    Management group: Development

  • Hi Daniel,

    I'm getting the below event details after I imported the Forecast MP, maybe this info can help.

    Failed to deploy Data Warehouse component. The operation will be retried.

    Exception 'DeploymentException': Failed to perform Data Warehouse component deployment operation: Install; Component: Script, Id: '8a477b44-6d7b-fef5-beff-b328e34b7400', Management Pack Version-dependent Id: 'a322b261-1a61-4d94-8acc-114bd8f51dff'; Target: Database, Server name: 'myserver', Database name: 'OperationsManagerDW'. Batch ordinal: 1; Exception: Cannot assign a default value to a local variable.

    Must declare the scalar variable "@loop".

    Must declare the scalar variable "@loop".

    Incorrect syntax near the keyword 'from'.

    Must declare the scalar variable "@loop".

    One or more workflows were affected by this.  

    Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Component

    Instance name: myserver

    Instance ID: {7AB8D40F-3888-9309-5930-CFCA5681130C}

    Management group: mymanagementgroup

    Best regards,

    Mario

  • Morning Daniel,

    Just a FYI to you and other folks who may see the same DW events every 10 minutes; the issue cleared itself up, just took about 6 hours after removing the new MP.

  • yep im the getting the same error as Mario with the updated ForecastReport.xml

  • Open the ForecastReport.xml file in Notepad, do a search for "declare @loop". Replace both instancs of "declare @loop as int = 0" with:

    "

    declare @loop as int

    set @loop = 0

    "

    I ran the SQL manually and extracted the RDL but changing the XML would be easier.

  • I tried what CSummers said, but I get the same error as those above still.

    The report would have been very, very useful.

    Any help appreciated Daniel.....Thx again,

    John Bradshaw

  • I tried what CSummers said, but I get the same error as those above still.

    The report would have been very, very useful.

    Any help appreciated Daniel.....Thx again,

    John Bradshaw

  • Is there a way to have these reports work in SSRS 2005?