• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 8874
  • Last Modified:

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

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      
TEST      
"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
    Account name: NT AUTHORITY\NETWORK SERVICE
 
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: 192.168.134.10     User: TEST    
Is authenticated: True
    Authentication Type: Negotiate
   
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
    Thread ID: 7
   
Thread account name: NT AUTHORITY\NETWORK SERVICE
   
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)
0
tocroi72
Asked:
tocroi72
2 Solutions
 
anipeddiCommented:
0
 
tocroi72Author Commented:
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.
0
 
James MurrellProduct SpecialistCommented:
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".

or

CAUSE
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.

RESOLUTION
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 http://forum.swsoft.com/showthread.php?t=48310
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now