Archive

Posts Tagged ‘schedule’

Operations Manager 2007 R2 reports problem

19/08/2010 Leave a comment

Yesterday i bumped into 2 problems in Operations manager reports. the reporting services and SQL were on the same machine , Win2008R2 with SQL 2008 SP1.

The first problem was inability to drilldown a report from a client console, the report graph is shown correctly but when we want to drilldown the report it ended with the following error:

image

there was a similar problem with OpsMgr RTM and Microsoft fixed it with SP1, so what is going on here? 
OK, lets try to run the report from server side…..and…..everything works just fine.
Lately, every problems with SRS and SQL came from regional settings configurations (SCOM & SCCM) ,as we can see the error is about a type mismatch ‘The value provided for the report parameter ‘StartDate_BaseValue’ is not valid for its type. (rsReportParameterTypeMisMatch)’ . To verify this I opened the report server web site from server and client side, and here are the results:

Server side browser is the left image with the correct settings (MM/DD/YYYY)
image image
the server was set to English (United States) and the client to non-English format.

OK, now after we have a working reporting environment I needed to publish some of the reports using the schedule feature of SRS.
and a second problem appears. I can see a proper report when I ran the report manually, but when I schedule it and chose any format I ended with a blank graph.
image
this is a known bug in SQL 2008 reporting and Microsoft released a fix to this problem, after applying the fix the report rendered successfully.

image 

1. I recommend you to save a copy of the file before any changes are made!!!

2. Do not forget to restart the SSRS service after saving the file.

Advertisements
Categories: OpsMgr Tags: , , ,