Reporting Scenarios – More Samples(Updated Attachment)

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?