Last month one of our stake holder facing problem while running SCCM report . He was facing error 500 in internet explorer. when checked the IIS logs find below error is appearing
![clip_image001[5]](http://microsoftteched.com/wp-content/uploads/2010/01/clip_image0015.png?w=300)
After searching on the web, found SMS 2003 Faq’s http://technet.microsoft.com/en-us/library/cc875797.aspx . However, our servers are installed with SCCM 2007 and IE7. After going through the SMS 2003 FAQ and http://learn.iis.net/page.aspx/373/editing-configuration-files/ we were able to solve the problem. Below are the steps.
Resolution Steps:
1) Open the latest IIS log file using SMS trace utility and filter it by “buffer” (filter by “contains”). You will see error logs as below. You can find the report ID number.
2) Run the report in Internet Explorer and observe whether same error entry is appearing in the IIS logs or not.
![clip_image001[5]](http://microsoftteched.com/wp-content/uploads/2010/01/clip_image0015.png)
3) If yes, go to that report in SMS console, and take the SQL query for that report. Then run the query on the SMS database and check for how many rows it returned?
4) You need to adjust a registry value on the SMS Reporting Point to allow the return of a larger row set. To do that, go to HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\Reporting Add a DWORD value Rowcount and assign it a value for the desired maximum limit, the maximum row count is 32767 (decimal) But if you need to return more, then set it to 0xffffffff (Hex). This will return all rows but will significantly increase the workload on your site server database. It is not recommend doing this until it is critical to do these settings.
5) Open console of IIS manager 7.0
6) Select server Name.
7) On the right pane, right click on ASP and click on Open feature
![image[8]](http://microsoftteched.com/wp-content/uploads/2010/01/image8.png)
8 ) Change the value of “response buffering time-out”. To decide upon “response buffering time-out “ please check how many maximum rows we expect from the report and based on that do math 1 MB per 1000 records. However, it’s ideal. After changing the value if error is still appearing in IIS logs. Please calculate the “response buffering time-out” value by doing math of 2MB per 500 Records.
9) Change “Script Timeout” value to 180 sec. The default is 90.
![clip_image003[4]](http://microsoftteched.com/wp-content/uploads/2010/01/clip_image0034.png)
10 ) Run the report
Thank and Regards |Abhishek Joshi| www.AbhishekJoshi.com
Incoming search terms: