Post reply

Reporting Services 2008 - Web Service URL

  • February 15, 2011 at 4:30 am

    #388861

    Hello,

    We have a SharePoint site setup on a server with SQL 2008 and reporting services installed on the same box.

    I have run the configuration wizard, set the reporting database up as SharePoint integrated mode and configured the web service URL.

    When I access the URL http://<server>/ReportingWebService (as configured in the Web Service URL tab in configuration manager) I get the following error in my web browser:

    Reporting 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

    I have checked the reporting services application log and this is the error (section of the log file).

    library!ReportServer_0-2!1894!02/14/2011-21:11:26:: Call to GetItemTypeAction(/).

    library!ReportServer_0-2!1894!02/14/2011-21:11:26:: Call to ListParentsAction(/).

    library!ReportServer_0-2!1894!02/14/2011-21:11:26:: Call to ListChildrenAction(/, False).

    library!ReportServer_0-2!1894!02/14/2011-21:11:42:: 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 ---;

    Any idea which directory is missing/can't be found?

    Thanks in advance.

    Mason

  • February 16, 2011 at 3:01 am

    #1287504

    This article offers up a couple of things to try. Port conflicts and Alternate Access Mappings via SharePoint.

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/299d17b5-5aed-463e-bb34-f53c5f93f6a2

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply