Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbradish
Starting Member
24 Posts |
 Posted - 2009-10-05 : 16:21:23
|
| Hello,I keep receiving the following line of code when I open a report in MVS 2008 (9.0.30729.1 SP). All of my reports are upgraded from 2005, including our "template" report which any new report springs from.My question is, where did my report go? Unless this is something I worked on "yesterday" I'm SOL with no backup. I'm going to try and get the report code from the deployed report on the server, but what's up??This is happening frequently in multiple projects on reports pulling from a variety of OLTP databases and tables.MSVS desgin message follows.Your feedback would be appreciated.~ Delora<html><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8"><title></title><style>.ErrorStyle { font-family: tahoma; font-size: 11 pt; text-align: left}.DetailsStyle { font-family: tahoma; font-size: 10pt; text-align: left;text-indent: 0; word-spacing: 0; line-height: 100%; float: left; margin-top: 0; margin-bottom: 0}.StackStyle { font-family: tahoma; font-size: 10pt; text-align: left; margin-left: 20; text-indent: 0}</style></head><body><DIV class="DetailsStyle" width="100%"><table border="0" width="100%" id="table1" height="100%" cellspacing="0" cellpadding="0"><tr><td height="40" bgcolor="#FF9999" width="8%" style="letter-spacing: 0" align="center"><img border="0" src="C:\Documents and Settings\delora\Local Settings\Temp\tmp2847.tmp" width="35" height="35"></td><td height="40" bgcolor="#FF9999" width="91%" style="vertical-align: top; letter-spacing: 0" align="left"><b><font size="2" face="Arial" fontsize="70%">One or more errors encountered while loading the designer. The errors are listed below.</font><font size="2" face="Arial"></font></b></td></tr><tr><td colspan="2" align="left" valign="top"><DIV id="div1" class="ErrorStyle" width="100%"><span style="font-weight: 600"><br>Deserialization failed: The 'DataType' attribute is not declared. Line 1304, position 20. </span><span style="font-weight: 400"><p></p><div a href="" id="task0" style="cursor: hand; text-decoration:underline; color=#0000FF">Edit code</a><p></p></div></span></DIV></td></tr></table></div></body></html> |
|
|
dbradish
Starting Member
24 Posts |
Posted - 2009-10-05 : 16:56:03
|
| p.s.The deployed report runs fine on the report server. At time of last MSVS <Save>, the design view was fine.I can view the RDL code in MSVS.When I try and open the (integrated SharePoint) report on the report server using RptBld2.0, I get the following:The 'DataType' attribute is not declared.----------------------------Deserialization failed: The 'DataType' attribute is not declared. Line 1304, position 20.So, I am now headed to line 1304 to see what's up. I am QUITE CERTAIN that no data structures have changed in the warehouse.Side Note: I have had frequent problems with upgraded reports losing their DataSource that is fixed with a copy/paste from another report that hasn't lost its way. I'm wondering if my data type has joined my DataSources in infinity. (Buzz Lightyear, are you out there?)Anyone else having this problem? |
 |
|
|
dbradish
Starting Member
24 Posts |
Posted - 2009-10-05 : 17:26:16
|
For everyone's amazement or amusement, I'll keep replying to my own topic.  Maybe someone can find some help in it.I'm not an XML genius so I had to copy/paste the XML text into SSBIDS to find line 1304. And now I must give a positive thumbs up to IntelliSense: it also flagged the incorrect lines with nice squigglies.RDL ERROR (in red): <ParameterValues> <ParameterValue> <Value DataType="Integer">-1</Value> <Label> All Orders</Label> </ParameterValue> <ParameterValue> <Value DataType="Integer">0</Value> <Label>Non-Winners Only</Label> </ParameterValue> <ParameterValue> <Value DataType="Integer">1</Value> <Label>Winners Only</Label> </ParameterValue> </ParameterValues>I have no idea what caused the values to be okay one moment and be error-prone the next, but the correction is as follows:RDL FIX (in red): <ParameterValues> <ParameterValue> <Value>-1</Value> <Label> All Orders</Label> </ParameterValue> <ParameterValue> <Value>0</Value> <Label>Non-Winners Only</Label> </ParameterValue> <ParameterValue> <Value>1</Value> <Label>Winners Only</Label> </ParameterValue> </ParameterValues>Signing off. Best of luck to all you SSRS developers. Do not be afraid to be great!~ Delora |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Corrupt (?) RDL files in MVS 2008 Design View
Thanks for the follow-up!Tara Kizer