none
rsSharePointError generic error: "Object reference not set to an instance of an object." help

    Question

  • 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.
    Tuesday, March 01, 2011 4:01 PM

Answers

  • 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.
    • Marked as answer by Mark A. Eckert Wednesday, March 02, 2011 2:46 PM
    Wednesday, March 02, 2011 2:46 PM

All replies

  • 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.
    • Marked as answer by Mark A. Eckert Wednesday, March 02, 2011 2:46 PM
    Wednesday, March 02, 2011 2:46 PM
  • 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


    Wednesday, March 30, 2011 9:36 PM
  • Hey,

    I have also same issue. My environment is WSS 3.0 with SP2 and SQL server 2008 R2. I can open the Report Builder 3.0 but cannot save the report whereas if any existing report is opened, it saves properly.

    Here is the error that i receive when i click the Save icon on Report Builder 3.0;

    Also, see the below error from report server log;

    library!ReportServer_0-16!ec8!12/05/2011-01:33:34:: 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.SharePointDBInterface.InternalFindObjects(ExternalItemPath wssUrl, CatalogItemList& children)
    at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.FindObjectsNonRecursive(ExternalItemPath wssUrl, CatalogItemList& childList, Security secMgr, IPathTranslator pathTranslator, Boolean appendMyReports)
    --- End of inner exception stack trace ---;

    Nothing is logged in Applicaion Event log as well as SharePoint log.

    Please let us know if there is any resolution for same.

     

    Thanks

    Mahesh Dhinge


    Thanks Mahesh Dhinge
    Monday, December 05, 2011 6:38 AM