SCCM 2007 R2 - An error occurred on the server when processing the URL. Please contact the system administrator.


  • When trying to run report "Software 02D - Computers with a specific software product" the report fails and displays this message:

    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 version of SCCM is 2007 R2 running on Windows Server 2008 x64 and IIS 7.0. 

    Other reports run and display fine, both on the server and running the report from a remote workstation.  This is the first time I have encountered this issue.

    As the report fails I use SMS Trace to view the "smsreporting.log" file and the second to last line displays the following error:
    <SMSRecordset: SortRecordset Error> Number=9 Description=Subscript out of range Source=SMSComponent

    Thank you for the assistance.
    Saturday, January 30, 2010 7:34 PM


All replies

  • Hi,

    Try to uninstall and reinstall the SCCM Reporting Point role.

    If the problem still exist then change the value from 4MB to 11MB in the AspBufferingLimit in the IIS metabase (http://forums.iis.net/t/1152640.aspxwas) and try to execute your report again.

    For more information : http://social.technet.microsoft.com/Forums/en/configmgrgeneral/thread/2601fe0d-a0db-4842-94b5-2938f422eec3

    Bechir Gharbi. MCSA, MCSE Security & Messaging, MCITP Entr-Srv Administrator, MCT, MCTS ConfigMgr/OpsMgr/ISA Server.
    • Edited by Bechir Gharbi Saturday, January 30, 2010 9:02 PM more informations
    • Marked as answer by Simon Senger Monday, February 01, 2010 9:19 PM
    Saturday, January 30, 2010 8:46 PM
  • The Subscript out of range error can be caused if a report is run which returns more than 10,000 rows which is the default limitation of the number of rows which we can handle.

    Change the limitation is a good choice.
    Monday, February 01, 2010 7:42 AM
  • Changing the AspBufferingLimit value from 4MB to 11MB solved the problem. 

    Thank you very much.

    Monday, February 01, 2010 9:19 PM