SSRS Gotcha! BC 42206 Maximum number of warnings has been exceeded

Recently, another colleague came to me again with an issue where BIDs would not open a report in design mode.  Instead, the following block of text greeted the developer:

<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:\Users\DarthVader\AppData\Local\Temp\tmpE34F.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 31012, 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>

When I loaded the same report, I was greeted with a slightly more friendly version of the above.

Deserialization failed: The 'DataType' attribute is not declared. Line 31012, position 20.

The solution is to do a search and replace for the words DataType = “Integer” and replace it with blank text.

Anecdotal evidence suggests that this happens when a report is downloaded from the server to get the latest version or boolean parameters are used (switch to integers.)

More Info:

http://connect.microsoft.com/VisualStudio/feedback/details/405739/vs-2008-rs-2008-error-deserialization-failed-the-datatype-attribute-is-not-declared      

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s