rsSharePointError generic error: "Object reference not set to an instance of an object." help
Hello, it looks like I am going down the road that many others have related to the generic error "Object reference not set to an instance of an object." with SSRS and SharePoint. I currently have SharePoint 2007 and SQL Server 2008 R2 with SSRS configured with the SharePoint Add-in, all x64. In the Reporting Services Configuration Manager I do not see any errors or warnings noted. However, this error just surfaced trying to view reports that we have created. In the Reporting Services logs I have observed the following stacktrace. --- End of inner exception stack trace ---; library!ReportServer_0-4!9c4!03/01/2011-10:22:12:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: , Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.SharePoint.Objects.RSSPImpUser.get_LoginName() at Microsoft.ReportingServices.SharePoint.Utilities.CatalogItemUtilities.GetListItemUserLoginName(RSSPListItem item, String fieldName) at Microsoft.ReportingServices.SharePoint.Utilities.CatalogItemUtilities.CreateCatalogItem(RSSPFile file) at Microsoft.ReportingServices.SharePoint.Server.Utility.GetSPFileProperties(RSSPFile file) at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.GetSPItemProperty(ExternalItemPath wssPath, CatalogItemDescriptor& itemDesc, String& customizedPropertyXml) at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.GetAllProperties(ExternalItemPath objectName, ItemProperties& properties, Guid& id, Guid& linkID, ItemType& type, Byte& secDesc, Int32& executionOptions, Int32& snapshotLimit, String& subType) --- End of inner exception stack trace ---; from other postings I have validated that the Author property is properly set for the root site collection (author redux post) as what it should be. Any feed back on this issue would be greatly appreciated, thank you. mark Mark A. Eckert SharePoint Consultant Pharmica Consulting, Inc.
March 1st, 2011 1:19pm
For any of those trying to resolve this error, I found the root cause. This error was masked by another error related to a user account. Essentially the original account that was used to create the *.rdl files and the data connection library was removed from SharePoint. I stumbled upon this by querying my UserInfo table to find the tp_Deleted property of the account not set to 0. After seeing this, I simply added the account in question back to the Members group. This seems to be a really poor flaw in that you will be required to keep the user account of the person who creates SSRS reports in SharePoint even if they have left the company or do no longer require SharePoint access.Mark A. Eckert SharePoint Consultant Pharmica Consulting, Inc.
March 2nd, 2011 3:52pm
Hi Mark, That was some nice work. Hope we can get an answer from Microsoft as to why we are getting that error as i expect the account that deployed the reports not to be associated to the reporting services reports and objects in the sharepoint site. Thanks GS
March 30th, 2011 5:39pm