Monday, May 2, 2011

Errors in SSRS:

You can come across various errors like:
1. Error while saving to AOD. ( Report library not checked out to you)
2. Changes do not reflect after deployment. ( Clean solution and rebuild and save to AOD)
3. Field does not exist in the data set. ( Data set being referred by the design is old refresh it )
4. Table returned from the data set is invalid. ( Occurs when the table returned from the business logic is incorrect usually happens when Execute.staticclassmethod has been used in business logic)
5. Error while executing the data set. ( CLR data table is not proper)

Error message will start like this:
Deployment failed unexpectedly with the message:
( Error Details )

Error: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
Solution: Restart SQL Server Reporting Services and/or Report Server.

Error: System.Web.Services.Protocols.SoapException: The Hidden expression for the text box ‘textbox15’ has ascope parameter that is not valid for an aggregate function.  The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the
name of a data set.
Solution: locate the text box in whichever design it exists and fix the error. This errors occurs when you are missing the data set or its reference from you solution.

Error: System.Web.Services.Protocols.SoapException: An unexpected error occurred while compiling expressions. Native compiler return value: ‘[BC30137] Error saving temporary Win32 resource file 'C:\Users\axadmin\AppData\Local\Temp\vbcF484.tmp': The process cannot access the file because it is being used by another process. ’.
Solution: Restart SQL Server Reporting Services

No comments:

Post a Comment