Sunday, October 14, 2012

“Out Of Memory-GetRows” or SMS report is showing only 10,000 Rows,

Error massage when you try to run SMS/SCCM web Report
“Out Of Memory-GetRows” or SMS report is showing only 10,000 Rows,
No need to worry about this error, this error is known and this hits comes by default value which is
Configured in SMS Registry.
Resolution-1 Increase the row count of SMS Report from 10,000 to unlimited

Report Viewer in Configuration Manager 2007 limits the result set returned by a report query to 10,000 rows. The maximum number of rows that are returned when running a report query can be modified by creating a registry key and setting a value on site system computers that have the reporting point role

To change the number of rows returned by a report query
  1. Open the Registry Editor on the reporting point computer.
  2. Navigate to HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\Reporting.
  3. Create a DWORD value named Rowcount, and then set its value to the number of rows that you want returned in the report query. If you want to return all rows, set the value to 0xffffffff, which is the hexadecimal equivalent of –1.
The configured number of rows is returned by any report query that is run from this reporting point.

Note: If you have given the wrong value then SMS Report will show only 10,000 Rows,

Resolution-2 Out of Memory- GetRows error while accessing the SMS Report,

Then you have to check the AspBufferingLimit value which will you could find in C:\Windows\system32\inetsrv\MetaBase.xml  search the “AspBufferingLimit “ and you see the value is 4194304 which is about 4 MB,
Now you have to change the value from 4 MB to according your limit,

After that jus restart the SMS Reporting service and you can see your SMS Report is back on track,



No comments:

Post a Comment

PXE Issue after SCCM CB 1806 upgrade

Recently i had upgraded my SCCM environment 1806 and after upgrade suddenly all PXE servers stopped working. While initiating the PXE ...