locked
sccm report takes forever to load RRS feed

  • Question

  • anyone encounter when retrieving report, it takes forever to load and doesn't load?

    tried to restart the ReportingServicesService.exe services but still the same. I have to restart the server. however after a day or so, the issue will comes back and report doesn't load.

    any help is appreciated . thanks.

    Event code: 3005 
    Event message: An unhandled exception has occurred. 
    Event time: 4/21/2016 8:20:48 AM 
    Event time (UTC): 4/21/2016 12:20:48 AM 
    Event ID: da7f25acc2ea4eed8244915af77826e8 
    Event sequence: 119 
    Event occurrence: 2 
    Event detail code: 0 
     
    Application information: 
        Application domain: ReportManager_MSSQLSERVER_0-6-131056687099069618 
        Trust level: RosettaMgr 
        Application Virtual Path: /Reports 
        Application Path: C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\ 
        Machine name: myprisiteservername
     
    Process information: 
        Process ID: 13292 
        Process name: ReportingServicesService.exe 
        Account name: myaccount
     
    Exception information: 
        Exception type: HttpHandlerInputException 
        Exception message: Missing URL parameter: IterationId 
     
    Request information: 
        Request URL: http://myprisiteservername/Reports/Reserved.ReportViewerWebControl.axd?ReportSession=pwipmm45i22gtjeeg15sbvvf&Culture=1033&CultureOverrides=False&UICulture=9&UICultureOverrides=False&ReportStack=1&ControlID=f6308ce496454f38abb02da317b71190&OpType=ReportImage&ResourceStreamID=Blank.gif 
        Request path: /Reports/Reserved.ReportViewerWebControl.axd 
        User host address: my ip address
        User: myaccount
        Is authenticated: True 
        Authentication Type: NTLM 
        Thread account name: myaccount
     
    Thread information: 
        Thread ID: 40 
        Thread account name: myaccount 
        Is impersonating: True 
        Stack trace:    at Microsoft.Reporting.WebForms.HandlerOperation.GetAndEnsureParam(NameValueCollection urlQuery, String paramName)
       at Microsoft.Reporting.WebForms.ReportImageOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
       at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
     
     
    Custom event details: 
    
    
    
    
    
    

    Thursday, April 21, 2016 12:31 AM

Answers

All replies