Monday, August 31, 2009

The report definition has an invalid target namespace 'http://schema.microsoft.com/sqlserver/reporting/2009/01/reportdefinition' which cannot be upgraded.

This week I installed the CTP version of SQL Server 2008 R2 as a seperate instance on my laptop to test. This laptop is also used to build and deploy reports to SQL 2008 reporting servers. The installation can be done without any problem, however the tools can't be installed seperate. The SQL 2008 R2 tools make use of the same components as the tools of SQL Server 2008. After having installed these SQL 2008 R2 tools you are able to open, modify and save your SQL 2008 reports. However after saving these reports you can't deploy them anymore to a SQL 2008 reporting server. If you try to do this you will get next error:

 The report definition has an invalid target namespace 'http://schema.microsoft.com/sqlserver/reporting/2009/01/reportdefinition' which cannot be upgraded.

To be able to deploy reports to SQL 2008 on my laptop, I have unstalled the tools of SQL 2008 R2 and reinstalled the SQL 2008 tools. After that I restored a backup of my SQL 2008 reports.

Microsoft it would be nice if these tools do not have shared components with previous releases. This will make testing of these products much easier.  Now I need to install a seperate machine to test the CTP version of SQL 2008 R2. Or does anybody have another solution for this?

6 comments:

Swetha said...

I tried to do the same and i was not successful. I still get the same error.
SQL Server 2008 R2 CTP is not uninstalling fully either. I am stuck.
Can you tell me how to properly uninstall SQL Server 2008 R2 CTP.
Thanks!

André van de Graaf said...

Swetha,

During the installation of SQL 2008 R2 my Visual Studio version was upgraded. Have you uninstalled Visual Studio and reinstalled it with the version which is shipped with SQL 2008
I hope this will work.
Do not forget to restore you SQL 2008 reports.
Gr. André

Swetha said...

Thanks Andre,
I will try uninstalling VS 2008 now. When you meant restore reports, did you mean making a backup copy of reportserver database? I have a copy of the BIDS SSRS projects with me. Will that suffice? Just wanted to make sure before i went ahead with the uninstall.

André van de Graaf said...

Swetha,

You need to have a copy of your Visual Studio project files before the upgrade to SQL 2008 R2.
After saving a report in SQL 2008 R2 the RDL file of your report is changes with reference to SQL 2008 R2 schemas. So you need to have the RDL files of SQL 2008 reports.

With uninstalling and reinstalled Visual Studio 2008 you avoid tha tother RDL are changing there reference to SQL 2008 R2 schemas.


Gr. André

Swetha said...

Hmm...Uninstalled VS2008 and reinstalled it still the same error. Weird thing is that even though the uninstall of Sql Server 2008 R2 CTP shows success message, it does not remove it from Add/remove programs.
I see the AS,RS, SQL in C:\Program Files\Microsoft SQL Server folder.
Can you tell me the steps you took to uninstall SQL R2 CTP completely from your system?
Thanks.
Can you email me at swetha.sankaran@gmail.com

justsamson.com said...

I upgraded from SQL 2008 to 2008 R2 and I ran into a smiliar problem. I was able to work around this by:

1) removing the report from the project

2) Then from file menu I opened the report (RDL) and it displayed the contents of the report as XML markup.

3) I then did a Save As and save the report to the project directory.

4) Then I closed that window and added the report to the project.

5) I double clicked the report to open it to design view then I updated the data source and then ran it.

It worked like a champ. Hopefully this works for someone else.