SCCM Reporting - HTTP 500 Internal Server Error

On one of our SCCM Primary server, we were unable to run large reports (neither from the SCCM console nor using from web-reports). After much analysis found that the issue was with the 'AspBufferingLimit' value on the Metabase.xml file which is located at “C:\Windows\system32\inetsrv”.

Steps to increase the AspBufferingLimit value in Metabase.xml file as follows:

SCCM Web-Report   -  HTTP 500 Internal Server Error

Open IIS - Right click on Computer Properties - Check the "Enable Direct Metabase Edit" box. This will allow you to edit the Metabase

IIS - Enable Direct Metabase Edit

Open "C:\Windows\system32\inetsrv" - select Metabase.xml - Rightclick and select Edit

Metabase.xml AspBufferingLimit

Update the 'AspBufferingLimit' entry value on Metabase.xml from 4194304 to 8000000 (or as per requirement) - Save and close the file

Updated AspBufferingLimit on Metabase.xml

UnCheck the "Enable Direct Metabase Edit" on IIS after saving Metabase.xml

Uncheck Direct Metabase Edit

 

Start - Run - Services.msc - Choose "IIS Admin Service" - Restart the service

Restart IIS Admin Service

Check running the SCCM console/web report and it should work fine. 

SCCM Report works fine now

Hope this helps.. Thanks!