Reporting Service 2005 to 2014 migration.

We are in the middle of migrating our SSRS 2005 server to SSRS 2014. So far all the reports are working except our barcode reports. When we try and upload the barcode reports we get the following message:

"The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: Deserialization failed: The element 'Style' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition' has invalid child element 'Border' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition'. List of possible elements expected: 'BorderColor, BorderStyle, BorderWidth, BackgroundColor, BackgroundGradientType, BackgroundGradientEndColor, BackgroundImage, FontStyle, FontFamily, FontSize, FontWeight, Format, TextDecoration, TextAlign, VerticalAlign, Color, PaddingLeft, PaddingRight, PaddingTop, PaddingBottom, LineHeight, Direction, WritingMode, Language, UnicodeBiDi, Calendar, NumeralLanguage, NumeralVariant' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition' as well as any element in namespace '##other'. Line 664, position 26. (rsInvalidReportDefinition)."

If I change

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

With

http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition

We get the following message:

"The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not formed or not valid based on Reporting Services schemas. Details: The report definition has an invalid target namespace " which cannot be upgraded. (rsInvalidReportDefinition)"

Here is an example of one of our report files: (too many characters to upload here so I've linked it to my DropBox) https://www.dropbox.com/s/z5eb9m9cpw6ivrj/Item%20Barcodes%20%28Subassembly%29%20-%20Neodynamic.rdl?dl=0

What needs to be changed for these reports to run on 2014?



  • Edited by Kelvin.uk Friday, February 06, 2015 9:10 AM
February 6th, 2015 12:02pm

Hi Kelvin.uk,

Based on my understanding, you are migrating the content of Report Server 2005 to Report Server 2014, but the barcode reports cant be uploaded to report server 2014 and error is thrown out.

In Reporting Services, upgrading a report definition in SQL Server Data Tools is the only way to upgrade the .rdl file. In your scenario, since you are migrating the reports to a new environment with a higher Reporting Services version installed, and some .NET components are referenced when creating the barcode reports, you should upgrade reports definition, then deploy them to report server.

Reference:
Upgrade Reports

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

Free Windows Admin Tool Kit Click here and download it now
February 9th, 2015 2:09am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics