Post reply

Target Data Source Folder Error when Deploying to Sharepoint

  • July 12, 2012 at 2:33 pm

    #259460

    I have an SSRS 2008 R2 report on one server where I am trying to deploy to a SharePoint site on another server. Here is some information about the Sharepoint site:

    url of the homepage: http://server1/Home%20Health%20Reports/Forms/current.aspx

    Under 'Libraries', I have a link to the SSRS Reports repository named 'SSRS Reports'. The url is http://server1/Home%20Health%20Reports/Forms/current.aspx

    Also under 'Libraries', I have a link to where the Data Sources should go, and it is named 'Data Conn Library'. The url is http://server1/Data%20Conn%20Library/Forms/AllItems.aspx

    In my SSRS solution, here is what I have configured for deployment:

    TargetDatasetFolder: http://server1/Data Conn Library

    TargetDataSourceFolder: http://server1/Data Conn Library

    TargetReportFolder: http://server1/SSRS Reports (also http://server1/Home Health Reports)

    TargetServerURL: http://server1/

    TargetServerVersion: SQL Server 2008 R2 (I'm checking into this)

    The following is the message that comes back upon attempting deployment:

    "Error 1 The specified folder is not valid. Specify a value for the TargetReportItemFolder property in the deployment settings. If you are deploying to a SharePoint site, the location must be a fully-qualified URL to the target library or folder."

    What are this issues with my deployment configuration?

    Thank you for your help.

    CSDunn

  • July 13, 2012 at 4:06 am

    #1512434

    Hi,

    In your SSRS Deployment, try below url,

    TagetDataSetFolder : http://server1/Data%20Conn%20Library

    TagetDataSourceFolder : http://server1/Data%20Conn%20Library

    🙂

  • July 13, 2012 at 7:54 am

    #1512548

    Thanks for the feeback. I suspected that having spaces in the folder names was an issue. However, I changed those destination folder names not to have spaces, and I still encountered the problem.

    Checking on this today, suddenly, the deployment works like I expected it to work yesterday! Magic!

    Here is what I suspect: SSRS caches deployment settings. When I had the deployment set up to deploy to directores that contained spaces, I had the obvious error. If SSRS was caching my deployment settings, then my deployment reconfiguration to folders with no spaces in the folder names wasn't 'registering'.

    Does SSRS cache deployment settings in a like manner to the way it caches datasets?

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

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