When I try to run any report by one of our previous SharePoint admins, I'm getting error.
Report Server has encountered a SharePoint error. (rsSharePointError) Object reference not set to an instance of an object. For more information about this error navigate to the report server on the local server machine, or enable remote errors
The log file doesn't give much more:
library!ReportServer_0-7!d84!04/18/2016-16:24:45:: 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 ---;
This seems to have something to do with the user being previously in our system, them removed and re-added, but I can't see how to resolve these errors. If I upload a new version of the SSRS report (thus becoming the last modifier), then it runs, but there are many of them, and this seems like a bad solution.
I've been doing some research here, here, and here, but I can't figure out how to resolve.
What else can I do or check?
EDIT: SSRS SQL Server 2008 R2, Sharepoint 2010.