When running what ends up as being a very large report or data set using SMS 2003 Reporting, it may seem as if there are limitations as to the amount of rows or data being returned. This is often described as there being only a partial set of data returned, and has to do with some default IIS limits. Fortunately, these limits can be changed.
To get a better idea if whether you are running up against some default configurations of SMS and IIS limiting report returns to about 10,000 rows of data, or possibly 4mb of information, you can disable friendly HTTP messages in the Internet Options on the client accessing the Web Report.
To disable friendly messages :
Response object error 'ASP 0251 : 80004005'
Response Buffer Limit Exceeded
/smsreporting_mat/Report.asp, line 0
Execution of the ASP page caused the Response Buffer to exceed its configured limit.
Should you see this error what is likely happening is that the amount of data being returned exceeds the current IIS configuration which defaults to 10,000 rows. Fortunately this can be remedied.
The solutions to this problem can be found on the SMS 2003 FAQ at this location:
What is not always clear from the FAQ or overlooked is that there are multiple steps which are all often needed to get a complete solution. I have provided a quick and dirty hit list here to get you on your feet should you run into this limit:
Before beginning I’d like to state that the following steps are not intended to be an exhaustive resource on making modifications to your SMS registry or IIS Metabase entries. In fact, before you begin I recommend reviewing the FAQ and its referenced documents to ensure you are comfortable with the changes you are about to make. Back up the IIS metabase and the appropriate registry keys before making any of these changes. Mucking about in the Metabase and Registry with a vague idea as to results of actions taken, or where inattention to details occur could render your Site, Component Server, or IIS installation worse off than having SMS Reports failing to return all of the data you expect. Sufficient warning? I hope so.
Following these steps should allow you to increase your Reporting Servers ability to serve up those extra large data sets for reports which have previously been problematic.
One thing to keep in mind is that defaults are set for a reason. Any time values are adjusted from those defaults you’ll need to monitor your systems and actions for performance. When in doubt, back it up before you act and keep a log of the changes you make.
Brent G. Dunsire
Supportability Program Manager
Systems Management Server and SCRM