Sql Reporting Services Add-In for Sharepoint produces runtime errors
The Error:
I receive the following error in the event log when attempting to perform any SRSS related activity (create data sources, reports, etc. within a Library)
Error: Failure in loading assembly: Microsoft.ReportingServices.SharePoint.UI.WebParts, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
~PuGsLY~- <System>
<Provider Name="Windows SharePoint Services 3" />
<EventID Qualifiers="0">6611</EventID>
<Level>2</Level>
<Task>1734</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2008-11-03T20:01:41.000Z" />
<EventRecordID>20035</EventRecordID>
<Channel>Application</Channel>
<Computer>sharepoint01.choicehomes.com</Computer>
<Security />
</System>
- <EventData>
<Data>Error: Failure in loading assembly: Microsoft.ReportingServices.SharePoint.UI.WebParts, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</Data>
</EventData>
</Event>
My Topology:
[Sharepoint / MOSS Server]
+ Windows Server 2008
+ WSS3.0 / Enterprise
+ SRSS Add-In
[Reporting Server]
+ Windows Server 2008
+ WSS 3.0
+ SRSS 2008
[SQL Server (content db's)]
+ Windows Server 2008
+ SQL Server 2008
Background:
1) I have gone round & round with credentials for Application Pools, Local Admins on all Servers, Services, etc. and reviewed the troubleshooting docs.
2) The Add-In installation FAILED so I was forced to do the files only installation and the run 'rsCustomAction /i
3) I was SUCCESSFULLY able to configure the Reporting Services Integration from Central Admin (Grant Database Access, Manage integration settings, Set server defaults)
4) The web part does exist and the Library configured for all REPORT type content contains the Add-In content types in the NEW drop-down.
My Questions:
1) What could be causing this problem?
2) Why is the version 9.0.242.0 placed in the web.config file after the SRSS 2008 Add-In installation??? Why would we want to load this version (assuming the correct version would be 10.x.x.x)- Edited byMike Walsh MVPMVP, ModeratorThursday, August 06, 2009 3:39 PMAbomination of a Title (far too long - there's no need to write the entire error message when it is this long) reduced considerably in size
All Replies
- Removing the "9.0.242.0 version" entry from <SafeControls> in the web.config file prevents this error from occuring and allowed me to create new Report type content (data sources, models,etc.) without errors in my document library.
(remove this entry from web.config of the site in question)
<SafeControl Assembly="Microsoft.ReportingServices.SharePoint.UI.WebParts, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" Namespace="Microsoft.ReportingServices.SharePoint.UI.WebParts" TypeName="*" Safe="True" />
~PuGsLY~- Proposed As Answer byDan English Thursday, August 06, 2009 3:18 PM
- Same issue and very interesting since only installing the SharePoint SSRS Integration for 2008. Had to remove the same entry to get rid of the error message being placed in the Application Event Log. I checked the GAC and the only version that was loaded was 10.0.0.0 which is what I would expect to find. Not sure why two entries are placed in the web.config for SafeControls, one for 10.0.0.0 and the other for 9.0.242.0. Seems like a minor glitch from something that was not removed when making the new SSRS Add-in version for 2008 integration.
_____________________________________________________
Please mark posts as answer or helpful when they are.- Edited byMike Walsh MVPMVP, ModeratorThursday, August 06, 2009 3:40 PMPlease use normal sigs
