Home > SCCM > SCCM Reports against a large collection

SCCM Reports against a large collection

Couple of days ago one of my customers asked me to help him with a report problem. the report return an error when he targets the report against a collection with high numbers of computers. when he ran the report against a small collection everything is fine.

“An error occurred on the server when processing the URL.  Please contact the system administrator.
If you are the system administrator please click here to find out more about this error.”

The first thing i suggested was to change the row limit in SCCM report.

http://technet.microsoft.com/en-us/library/bb680885.aspx

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.

Navigate to HKEY_LOCAL_MACHINESoftwareMicrosoftSMSReporting and 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.

But it seems it wasn’t just that, the reporting point (windows Server 2008) need some adjusting in the IIS role.

  1. How to Configure Connection and Command Timeout Settings.
  2. How to Configure the ASP Script Timeout Setting.
  3. and finally we needed to set the ASPBufferingLimit.
  4. In IIS 6.0, settings are set to aggressive and secure defaults to minimize attacks due to time-outs and limits that were previously too generous. IIS enforces the following time-outs at the connection level: Limits on Response Buffering: The default value for the ASPBufferingLimit metabase property is 4 MB. If ASP scripts buffer more than this, they error-out. There was no limit to buffering prior to IIS 6.0.
    we changed the ASPBufferingLimit to 50Mb.

Advertisements
Categories: SCCM Tags: ,
  1. Neil
    10/12/2010 at 1:11 PM

    Hey have you ever had it when you set the rowcount abover 32750 it just reverts back to 10k lines? We arent getting ASP time out errors but i cant go past that magic number

    Thanks

    • 11/12/2010 at 7:51 PM

      Hi Neil,

      Did you try to set the Rowcount value to 0xffffffff, which is the hexadecimal equivalent of –1. that way you shuold get all rows data, take in mind that it could significantly increase the workload on your site server database.
      i found that the max value for rowcount is 32767 (decimal).

      Kobi

  2. Neil
    12/12/2010 at 10:34 AM

    Hi Kobi
    Yeah I have tried the -1 and it that still gives me 10k lines bit perplexed.
    Mind you I am thinking a 1.6 Million row report mightbe a bit unmanagable.
    Thanks

    Neil

  3. 29/05/2012 at 5:32 PM

    This just helped me out big-time – thanks for sharing.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: