none
"Illegal Characters In Path" error when deploying from SSDT to SharePoint 2013 RRS feed

  • Question

  • This is very frustrating since the error is useless. Why does it not tell me what the illegal characters are? Or show me what path it is trying to use? 

    I can deploy to a folder named ADT with reports with longer names than another folder named BHPSA that has shorter report names just fine. How do I debug this? Please help.

    I do not need instructions on how to set the report server paths. Because I use the same path for the one that is broke that I use for the one that works.

    I am poured over the ULS logs and I don't see that error. So it must be generated from VS before it even gets to SP. I have been running procmon and procexplorer and do not see anything. My latest step is to redirect the system variables to another locations. I hope after a reboot that by some miracle this project deploys. 

    My SharePoint version is 2013. SQL Server is 2012. The Target ServerVersion in the project says SQL Server 2008 or later.

    The only thing that looks different is the first line in my reports related to schemas

    This report fails
    <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

    This one deploys

    Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">

    What does this information message mean?

    Message 2 Could not find schema information for the element 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner:DataSourceID'. O:\SharePoint 2013 Report Library\ADT\ADTDashboard.rdl 8 8 ADT

    About Visual Studio

    Microsoft Visual Studio 2012 Shell (Integrated)
    Version 11.0.61030.0 Q11REL
    Microsoft .NET Framework
    Version 4.5.51650

    Installed Version: IDE Standard

    Microsoft Visual Studio Tools for Applications 2012   04932-004-0017006-02406
    Microsoft Visual Studio Tools for Applications 2012

    Team Explorer for Visual Studio 2012   04932-004-0017006-02406
    Microsoft Team Explorer for Visual Studio 2012

    Visual Basic 2012   04932-004-0017006-02406
    Microsoft Visual Basic 2012

    Visual C# 2012   04932-004-0017006-02406
    Microsoft Visual C# 2012

    DaxEditor   1.6.40304.1
    Information about my package

    PreEmptive Analytics Visualizer   1.0
    Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.

    SQL Server Analysis Services   
    Microsoft SQL Server Analysis Services Designer 
    Version 11.0.3402.0

    SQL Server Integration Services   
    Microsoft SQL Server Integration Services Designer
    Version 11.0.3402.0

    SQL Server Reporting Services   
    Microsoft SQL Server Reporting Services Designers 
    Version 11.0.3402.0

    Thank You


    Tuesday, February 17, 2015 1:40 PM

All replies

  • Hi,

    Your issue can be caused by the schem information is not correct.

    Did you report which failed to depoy to Sharepoint can preveiw successfully in designer?

    Please try to change the scheme of the failed rdl to be the same as the one which works fine:
    Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">

    I recommend you to redesigne the report which faild to deploy.

    Regards
    swallow

    Wednesday, February 18, 2015 2:59 PM
  • It works fine in the designer. What I am doing is migrating these reports to a new server. So I downloaded all the reports from the existing SharePoint folder, added them to a project, tested them with the new datasource and was going to redeploy them. 

    So you are saying I can remove the XML for 2010 and put the 2008 XML header in the file? 

    Wednesday, February 18, 2015 3:09 PM