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.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Compiler Error

Author  Topic 

scottd
Starting Member

11 Posts

Posted - 2007-09-13 : 10:33:14
Hi everyone,

The Reporting Services demons are after me again!
I'm trying to run a report in MRS that I've created and get the following when I debug or try to run the report:

Error 1 [rsUnexpectedCompilerError] An unexpected error occurred while compiling expressions. Native compiler return value: ‘[BC42206] Maximum number of warnings has been exceeded.’

I checked the "warnings" tab, and there are none doesn't it figure?

Any ideas would be welcome.

Needing a beer already,

>scott

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-13 : 10:49:12
Are you using latest service pack?
quote:
Visual Basic Reference: Error Messages
Maximum number of warnings has been exceeded
The maximum number of compilation warnings is 100. The compiler imposes this limit to reduce the size of error and warning reports.
By default, this message is a warning. For more information on hiding warnings or treating warnings as errors, see Configuring Warnings in Visual Basic.
Error ID: BC42206
To correct this error
• Review the other warnings generated by this compilation and resolve as many as possible. If the source code contains more than 100 warnings, you might see more warnings in the next compilation.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-13 : 10:51:24
Try to see if this helps
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=366207



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

scottd
Starting Member

11 Posts

Posted - 2007-09-13 : 10:55:23
SP 2 and some hotfixes from MS
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-13 : 11:01:51
Which function gives the error during compiling?





E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

scottd
Starting Member

11 Posts

Posted - 2007-09-13 : 11:07:15
Peso,

Thanks for responding, I think the problem lies in the code. There are over 3 thousand lines there ..pass the booze!

>scott
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-13 : 11:10:22
Tried F5 or F8 yet?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -