Event Code 3005 -  ASP.NET 2.0.50727.0      Warning      Web Event       1309

Posted on 2008-11-12
Last Modified: 2012-05-05
I am experiencing a strange issue in SQL reporting. My report has been working well when I export the report to either excel or csv file. However, i am not sure what happen recently but every time i run the report now, the report show the data but if i click on Export in the SQL report, there're a pop up window asking for user name and password which it didn't happen before. And when i  enter in my window log in and password , the exporting is not working  still, and i got the new IE page "You are not authorized to view this page" ...... This only happenned recently. If i stop the SQL reporting service & IIS and start both of them again, the issue dissappear.  

Below is the Event Code when that happened

11/11/2008      4:56:51 PM      ASP.NET 2.0.50727.0      Warning      Web Event       1309      N/A      
"Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 11/11/2008 4:56:51 PM
Event time (UTC): 11/12/2008 12:56:51 AM
Event ID: b25f16f0678a4a9498a84729e4d79057
Event sequence: 590
Event occurrence: 1
Event detail code: 0
Application information:
    Application domain: /test/test/1/Root/ReportServer-2-128709115494500000
    Trust level: RosettaSrv
    Application Virtual Path: /ReportServer
    Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\
    Machine name: TEST
Process information:
    Process ID: 2208
    Process name: w3wp.exe
Exception information:
    Exception type: HttpException
    Exception message: The remote host closed the connection. The error code is 0x80072746.
Request information:
    Request URL: http://test/ReportServer/Reserved.ReportViewerWebControl.axd?ExecutionID=j31wzy2m10xp0zytihjy5w55&ControlID=2ad5a0656d2241dd850cee7fbd6124b7&Culture=1033&UICulture=9&ReportStack=1&OpType=Export&FileName=PCPRosterExcel&ContentDisposition=OnlyHtmlInline&Format=EXCEL
Request path: /ReportServer/Reserved.ReportViewerWebControl.axd
    User host address:     User: TEST    
Is authenticated: True
    Authentication Type: Negotiate
Thread information:
    Thread ID: 7
Is impersonating: True
    Stack trace:    at System.Web.Hosting.ISAPIWorkerRequestInProcForIIS6.FlushCore(Byte[] status, Byte[] header, Int32 keepConnected, Int32 totalBodySize, Int32 numBodyFragments, IntPtr[] bodyFragments, Int32[] bodyFragmentLengths, Int32 doneWithSession, Int32 finalStatus, Boolean& async)
   at System.Web.Hosting.ISAPIWorkerRequest.FlushCachedResponse(Boolean isFinal)
   at System.Web.Hosting.ISAPIWorkerRequest.FlushResponse(Boolean finalFlush)
   at System.Web.HttpResponse.Flush(Boolean finalFlush)
   at System.Web.HttpResponse.Flush()
   at Microsoft.Reporting.WebForms.ReportDataOperation.StreamToRepsonse(Stream data, String mimeType, HttpResponse response)
   at Microsoft.Reporting.WebForms.ExportOperation.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)
Question by:tocroi72
    LVL 4

    Accepted Solution


    Author Comment

    I don't think the issue is with Crytal reports -  We have an intranet website and we just post the link to SQL reports from there. The user login is probably not the problem because i run the reports , the data was showing, only when i click export to excel or CSV , i got the error. And this only happen occationally, and issue will dissappear right after i restart the SQL reporting service & IIS. Thanks.
    LVL 31

    Assisted Solution

    by:James Murrell
    this could be the reason:

    An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine

    check permissions. run reconfigurator on server in order to check plesk permissions;

    To enable the details of this specific error message to be viewable on remote machines, please create a  tag within a "web.config" configuration file located in the root directory of the current web application. This  tag should then have its "mode" attribute set to "Off".


    The system TEMP and TMP variables point to a folder that does not exist. The compiler generates temporary files in the folder where the TEMP and the TMP variables point to before the files are copied to the Temporary ASP.NET Files folder. However, the folder where the system variables point to is deleted when you restart the computer. Therefore, the compiler cannot generate the temporary files.

    1. Create a temporary folder under %Systemroot%, and then name it Temp.
    2. Grant full permissions on the Temp folder to the aspnet user account in .NET Framework 1.0 or to the NETWORK SERVICE user account in .NET Framework 1.1.
    3. Right-click My Computer, and then click Properties.
    4. On the Advanced tab, click Environment Variables.
    5. Select the TEMP variable under System variables, and then click Edit.
    6. Type %SystemRoot%\TEMP in the Variable Value box, and then click OK.
    7. Repeat steps 5 and 6 to edit the TMP variable. Click OK two times.
    8. Click Start, and then click Run.
    9. To reset Internet Information Services (IIS), type iisreset on the command prompt.

    Note If the error message that is mentioned in the "Symptoms" section of this article persists, restart the computer.

    all taken from

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now