none
Path not valid error when deploying a report or Datasource to Sharepoint 2010

    Question

  • I am getting the "Path not valid" error when trying to deploy a report or datasource to Sharepoint 2010, from BIDS.  The Project Properties paths are set correctly (http://servername/folername).  The error message (and the entry in the log file) show an additional '/' prepended to the URL, obviously incorrect for Integrated mode (though I understand it is required to deploy directly to the Report Server).

    Any ideas, or has anyone had the same issue?

    Thanks in advance.

    Wednesday, December 29, 2010 5:37 PM

Answers

  • While you are deploying Report to SharePoint we don't specify the ReportServer URL for the TargetServerURL. You need to specify the SharePoint top-leve site or the subsite.

    Check this:

    To publish a report to a SharePoint site

    1.       In Business Intelligence Development Studio, open an existing or new Report Server project.

    2.       From the Project menu, click Properties. The <project> Property Pages dialog box opens.

    3.       In the Configuration list, select the name of a solution build configuration to use to build and publish your report. The current configuration is listed as Active(<configuration>).

    4.       If you want to publish the shared data sources in your project and overwrite previously published shared data sources, set OverwriteDataSources to True.

    5.       (Optional) For TargetDataSourceFolder, type a URL to a SharePoint library or library folder (for example, http://TestServer/TestSite/Documents/DataSources).

    If you do not specify a value, the TargetReportFolder value is used.

    6.       For TargetReportFolder, type a URL to a library or library folder (for example, http://TestServer/TestSite/Documents/Reports).

    7.       For TargetServerURL, type a URL to a SharePoint top-level site or subsite. If you do not specify a site, the default top-level site is used (for example, http://servername, http://servername/site, or http://servername/site/subsite).

    8.       Click OK. 

    9.       In Solution Explorer, right-click the report you want to publish, and click Deploy. The report is published to the location specified in TargetReportFolder. Deployment errors appear in the Output window.

     

    For further details refer:

    http://msdn.microsoft.com/en-us/library/ms155802.aspx [How to: Set Deployment Properties (Reporting Services)]

    Rest of the things look fine for me..

    Thanks!!


    Chaitanya
    • Marked as answer by GW_Hinkel Thursday, December 30, 2010 3:42 PM
    Thursday, December 30, 2010 3:00 AM

All replies

  • For deploying the reports from BIDS to SharePoint, can you please provide all the options you had set for the properties? Also, please give the complete error message with details.

    Thanks

     


    Chaitanya
    Wednesday, December 29, 2010 5:45 PM
  • Here are the Deployment Properties:

    TargetServerURL: http://ServerName/ReportServer_SQL2K8R2

    TargetDataSourceFolder: http://ServerName/sites/BI Portal/Shared Documents

    TargetReportFolder: http://ServerName/sites/BI Portal/Shared Documents

    Deploying the datasource or Report, I get the error: Error 1 The path of the item '/http://ServerName/sites/BI Portal/Shared Documents' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash.  0 0 

    From the logfile, the error is:

    library!ReportServer_0-4!1684!12/29/2010-11:27:17:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-4!1684!12/29/2010-11:27:18:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: , Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: The path of the item '/http://ServerName/sites/BI Portal/Shared Documents' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. ---> System.UriFormatException: Invalid URI: The format of the URI could not be determined.
       at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind)
       at Microsoft.SharePoint.SPSite..ctor(String requestUrl)
       at Microsoft.ReportingServices.SharePoint.Objects.RSSPImpSite..ctor(String requestUrl)
       at Microsoft.ReportingServices.SharePoint.Objects.RSSharePointClassFactory.CreateSPSite(String requestUrl)
       at Microsoft.ReportingServices.SharePoint.ObjectModel.RSSharePointClassFactory.CreateSPSite(String requestUrl)
       at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper.GetSiteFromExternalPath(String path, Boolean noThrow)
       --- End of inner exception stack trace ---;

    Let me know if there is any other information you require Chaitanya.

     

    Wednesday, December 29, 2010 6:31 PM
  • While you are deploying Report to SharePoint we don't specify the ReportServer URL for the TargetServerURL. You need to specify the SharePoint top-leve site or the subsite.

    Check this:

    To publish a report to a SharePoint site

    1.       In Business Intelligence Development Studio, open an existing or new Report Server project.

    2.       From the Project menu, click Properties. The <project> Property Pages dialog box opens.

    3.       In the Configuration list, select the name of a solution build configuration to use to build and publish your report. The current configuration is listed as Active(<configuration>).

    4.       If you want to publish the shared data sources in your project and overwrite previously published shared data sources, set OverwriteDataSources to True.

    5.       (Optional) For TargetDataSourceFolder, type a URL to a SharePoint library or library folder (for example, http://TestServer/TestSite/Documents/DataSources).

    If you do not specify a value, the TargetReportFolder value is used.

    6.       For TargetReportFolder, type a URL to a library or library folder (for example, http://TestServer/TestSite/Documents/Reports).

    7.       For TargetServerURL, type a URL to a SharePoint top-level site or subsite. If you do not specify a site, the default top-level site is used (for example, http://servername, http://servername/site, or http://servername/site/subsite).

    8.       Click OK. 

    9.       In Solution Explorer, right-click the report you want to publish, and click Deploy. The report is published to the location specified in TargetReportFolder. Deployment errors appear in the Output window.

     

    For further details refer:

    http://msdn.microsoft.com/en-us/library/ms155802.aspx [How to: Set Deployment Properties (Reporting Services)]

    Rest of the things look fine for me..

    Thanks!!


    Chaitanya
    • Marked as answer by GW_Hinkel Thursday, December 30, 2010 3:42 PM
    Thursday, December 30, 2010 3:00 AM
  • That was it. Thanks so much for your help Chaitanya.

    Gary.

    Thursday, December 30, 2010 3:42 PM