data source already exits

  • Hi

    I am new to ssrs

    when deploying project I get following error

    Error rsItemAlreadyExists : The item '/Data Sources' already exists.

    I have set properties to OverwriteDataSources to True

    as suggested in another post and I am running bids as administrator

    any ideas please

    thank you

    Tina

  • Is the deploy actually failing, or is it completing and giving you the error? I have the OverwriteDataSources set to False by default. Whenever I deploy a report, I get the following warning:

    Warning : Cannot deploy data source Bookscape Test to the server because it already exists and OverwriteDataSources is not specified.

    However, the deploy itself ultimately succeeds:

    Deploy complete -- 0 errors, 3 warnings

    ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

    ========== Deploy: 1 succeeded, 0 failed, 0 skipped ==========

    If the deploy is failing, what happens if you change the Overwrite setting to False?

    Doug

  • Hi

    It fails with same message whether set to true or false

    below is message received

    ------ Build started: Project: Report Project1, Configuration: Debug ------

    Build complete -- 0 errors, 0 warnings

    ------ Deploy started: Project: Report Project1, Configuration: Debug ------

    Deploying to http://sql-srv/ReportServer

    Error rsItemAlreadyExists : The item '/Data Sources' already exists.

    Deploy complete -- 1 errors, 0 warnings

    ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

    ========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

    Thanks

    Tina

  • It seems the deployment wants to create the folder "Data Sources", but it fails since it already exists.

    How did you configure the property for the folder?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Hi

    Sorry I am not sure what you are asking

    which folder?

    Thanks

    Tina

  • tkenney 85817 (1/24/2014)


    Hi

    Sorry I am not sure what you are asking

    which folder?

    Thanks

    Tina

    The folder called "Data Sources". It's what is default specified for the TargetDataSourceFolder property.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Hi

    Deployment

    Overwritedatasources True

    TargetDataSource Data Sources

    TargetReportFolder DDD_Reporting/Fleet

    TargetServerURl http://sql-srv/ReportServer

    Thanks

    Tina

Viewing 7 posts - 1 through 6 (of 6 total)

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