Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««89101112

Report Server Diagnostic Reports Expand / Collapse
Author
Message
Posted Friday, June 7, 2013 10:00 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, November 7, 2014 9:05 AM
Points: 54, Visits: 310
I noticed today that some data sources where being missed using the schemas listed in the data sources.
If you are using Sharepoint 2010 with SSRS then you will want to update the queries that contain:

http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition or
http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition

http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition

The new schema worked on both 2008 and 2012 reports. I am not sure if this is a Sharepoint Issue, but if you are seeing missing connections, then you will want to update the query accordingly.

These reports will NOT reflect Sharepoint Permissions, and those are not stored in the ReportServer.
Post #1461255
Posted Saturday, May 17, 2014 9:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 12:13 PM
Points: 399, Visits: 821
We migrated to fresh hardware and fresh Reporting Services databases for SQL Server 2012. When I copied the Reporting Services reports to the new SQL Server 2012 instance, I noticed that we are periodically missing data on the ReportStatistics page. For example, the following summaries on the page are missing data:

- Online Usage - Last 180 Days
- Online Number of Users - Last 180 Days
- Top 10 Online Users -Last 180 Days

Has anyone else noticed missing data with SQL Server 2012? Just thought I would check before I go through the code. Up until this point, the pages worked great.

Thanks,

J.



Post #1572006
Posted Saturday, May 17, 2014 11:52 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, November 7, 2014 9:05 AM
Points: 54, Visits: 310
Did you check the schema references in the report, so that it points to http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition

In the ExecutionLogview3, does it indicate that you are using more than one server (scale out)?
Post #1572023
Posted Saturday, May 17, 2014 1:11 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:31 AM
Points: 4,472, Visits: 6,402
Please start a new thread instead of posting to one that is a year old.

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1572028
« Prev Topic | Next Topic »

Add to briefcase «««89101112

Permissions Expand / Collapse