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)
tocroi72Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

anipeddiCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft IIS Web Server

From novice to tech pro — start learning today.