Wednesday, March 21, 2012

Recovering a file

Hi,

I am working on SQL Server Business Intelligence Development Studio - 2005. While working on the same, the studio got closed automatically and I was not able to save my existing file.

When I try to open the last saved file, it is thowing the following error:

Deserialization failed: The element 'QueryParameter' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition' has incomplete content. List of possible elements expected: 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Value ##other:*'. Line 277, position 12.

EDIT CODE

Now I am not able to open the file. Please let me know how can I recover the lost file.

Regards
Syed

The QueryParameter nodes exist for each dataset you have in your report, and determine what parameters from the UI are used in each of those datasets. What you can do is just open your report in an XML editor, find the QueryParameter node at or around line 277, and either manually fix it up (give it a name, and empty value and ensure it has a closing tag), or just delete the whole node. Make sure you keep the rdl extension on the file when you save it, that should fix your problem.

No comments:

Post a Comment