SSRS Service URL Error - Path not found
Hi, We have setup SQL reporting services (2008) on a server which is also running SharePoint. When I try to access the SQL Reporting Services URL which we setup in the Confirguration Manager we get this error shown below. There is no information in the system event logs and I can see any obvious path issues in the reporting services configuration file. What is the path that it's having problems with? Mason Report Services Error Report Server has encountered a SharePoint error. (rsSharePointError) Get Online Help The system cannot find the path specified. (Exception from HRESULT: 0x80070003) -------------------------------------------------------------------------------- SQL Server Reporting Services
February 14th, 2011 2:27am

On an additional note, the database is running in SharePoint integrated mode. The URL which i'm referring to is the Web Services URL. I have also tried running the url on a different port just in case it was conflicted and set it to http://<boxname>:8888/ReportingWebService. Mason
Free Windows Admin Tool Kit Click here and download it now
February 14th, 2011 2:29am

This is the error in SQL Reporting Services application log: Any ideas which directory it's complaining about? Mason library!ReportServer_0-6!22b4!02/15/2011-17:29:01:: Call to GetSystemPropertiesAction(). library!ReportServer_0-6!19bc!02/15/2011-17:29:13:: Call to GetSystemPropertiesAction(). library!ReportServer_0-6!19bc!02/15/2011-17:29:16:: Call to (). library!ReportServer_0-6!1db0!02/15/2011-17:32:16:: Call to GetItemTypeAction(/). library!ReportServer_0-6!1db0!02/15/2011-17:32:16:: Call to ListParentsAction(/). library!ReportServer_0-6!1db0!02/15/2011-17:32:16:: Call to ListChildrenAction(/, False). library!ReportServer_0-6!1db0!02/15/2011-17:32:57:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: , Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> System.IO.DirectoryNotFoundException: The system cannot find the path specified. (Exception from HRESULT: 0x80070003) at Microsoft.SharePoint.Library.SPRequestInternalClass.OpenWebInternal(String bstrUrl, Guid& pguidID, String& pbstrRequestAccessEmail, UInt32& pwebVersion, String& pbstrServerRelativeUrl, UInt32& pnLanguage, UInt32& pnLocale, String& pbstrDefaultTheme, String& pbstrDefaultThemeCSSUrl, String& pbstrAlternateCSSUrl, String& pbstrCustomizedCssFileList, String& pbstrCustomJSUrl, String& pbstrAlternateHeaderUrl, String& pbstrMasterUrl, String& pbstrCustomMasterUrl, String& pbstrSiteLogoUrl, String& pbstrSiteLogoDescription, Object& pvarUser, Boolean& pvarIsAuditor, Int32& plSiteFlags) at Microsoft.SharePoint.Library.SPRequest.OpenWebInternal(String bstrUrl, Guid& pguidID, String& pbstrRequestAccessEmail, UInt32& pwebVersion, String& pbstrServerRelativeUrl, UInt32& pnLanguage, UInt32& pnLocale, String& pbstrDefaultTheme, String& pbstrDefaultThemeCSSUrl, String& pbstrAlternateCSSUrl, String& pbstrCustomizedCssFileList, String& pbstrCustomJSUrl, String& pbstrAlternateHeaderUrl, String& pbstrMasterUrl, String& pbstrCustomMasterUrl, String& pbstrSiteLogoUrl, String& pbstrSiteLogoDescription, Object& pvarUser, Boolean& pvarIsAuditor, Int32& plSiteFlags) at Microsoft.SharePoint.SPWeb.InitWebPublic() at Microsoft.SharePoint.SPWeb.get_ID() at Microsoft.ReportingServices.SharePoint.Objects.RSSPImpWeb.get_ID() at Microsoft.ReportingServices.SharePoint.Utilities.CatalogItemUtilities.CreateCatalogItem(RSSPWeb web) 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 ---; webserver!ReportServer_0-6!1db0!02/15/2011-17:32:57:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> System.IO.DirectoryNotFoundException: The system cannot find the path specified. (Exception from HRESULT: 0x80070003)
February 15th, 2011 1:39am

Hi, Logon the SharePoint, go to Alternate Access Mappings page and check whether SharePoint was remapping the request away from http:\\<Boxname> to others url. If yes, remove them and try again. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
February 15th, 2011 7:15am

Hi, There were no re-mappings which could affect it. I have tried setting up reporting services under SQL server 2005, running it in SharePoint integrated mode tho when I load the Web Service URL I get a similar error tho a null reference exception. Are these errors relating to issues within SharePoint or do is it within reporting services? I found that under SQL server 2008 when I ran the database in native mode, the web service URL worked as it should tho when in integrated mode we get these sharepoint errors. From the post above, any ideas about what the missing path error is that it's having trouble with? Could it be a missing file/directory which needs to be set somewhere? Is it a URL issue? Thanks Mason w3wp!webserver!5!2/17/2011-21:24:15:: e ERROR: Reporting Services error 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.Server.SharePointDBInterface.internalFindObjectsNonRecursive(String wssUrl, CatalogItemList& children) at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.FindObjectsNonRecursive(String wssUrl, CatalogItemList& childList, Security secMgr, IPathTranslator pathTranslator, Boolean appendMyReports) --- End of inner exception stack trace --- at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.FindObjectsNonRecursive(String wssUrl, CatalogItemList& childList, Security secMgr, IPathTranslator pathTranslator, Boolean appendMyReports) at Microsoft.ReportingServices.Library.ListChildrenAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderFolder() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() w3wp!library!5!17/02/2011-21:27:56:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams w3wp!library!1!17/02/2011-21:37:56:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
February 17th, 2011 5:43am

Techstyler Did you get the resolution for the above issue. I am also facing the similar issue. Please let me know, if you have solved this. manjunath
Free Windows Admin Tool Kit Click here and download it now
June 25th, 2012 10:43pm

HI I get the same issue. You have solved this?
June 29th, 2012 3:58am

Hi, Did you manage to get a solution for this? I am stuck with the same issue. Regards, NaweedRegards, Naweed
Free Windows Admin Tool Kit Click here and download it now
November 7th, 2012 11:13am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics