Post reply

has anyone come up with a solution, cannot deploy report after upgrading to sql 08 and vs08

  • January 18, 2011 at 9:30 am

    #233057

    I just upgraded from sql 05 to sql 08 + Vs 08

    my target report folder has always been LTC Audit Report/Consumer Complaints Reports

    and my target server url is http://myservername/ReportServer. but i am getting below error whenever I tried to deploy my report.

    Error 8 The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded.

    C:\Documents\Visual Studio 2008\Projects\Consumer Complaints Reports\Consumer Complaints Reports\Regulatory Entry Report.rdl 0 0

  • January 19, 2011 at 6:41 pm

    #1275635

    In either the project properties or the report properties (sorry -- not in front of the work PC so I can't check which), there's a property that says what version of SQL server you want to deploy to. If you're trying to send a 2008 R2 definition to 2008 or 2008 to 2005, it'll give you that namespace error. Make sure you're setting it to the version that exists on the host report server.

  • January 20, 2011 at 11:06 am

    #1276129

    Can you please be more specific, do you mean Solution "Appeal report" Property Pages

    under configuration property. I can't find where you make that choice.

    the only namespace I know is when you open the code in xml

    this is what I have now xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition"

    i change it to

    xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"

    I get error

    Deserialization failed: The element 'ReportItems' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition' has invalid child element 'Tablix' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition'.

    In 2005 what is called? instead of tablix.

    thanks

  • January 20, 2011 at 11:21 am

    #1276146

    My guess is you won't be able to run that report or any others with 2008/2008 R2 components on them. RS 2005 has the table and matrix objects, and while the matrix is similar to the tablix, it's not the same and probably incompatible with 2005. Reports with those objects will have to be hosted on a 2008 RS box.

  • January 20, 2011 at 11:26 am

    #1276150

    Thanks doug, that is what microsoft connect guys also told me. Unfortunately I can't convince this people here to upgrade their server to 08.

Viewing 5 posts - 1 through 4 (of 4 total)

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