Click here to Skip to main content
14,427,540 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hi,

In my web application, there is one page which is used for reporting purpose.
Based on selected parameters it fetches the summary data and binds to Gridview.
There is another separate button on which detail excel report should generate.
Problem is this functionality properly works in development environment. Excel report gets generate in development environment.

But in UAT sometime it excel gets generate sometime it doesn't. when it doesn't work it shows following message

This page isn’t working

mindworks.ultimatix.net is currently unable to handle this request.
HTTP ERROR 502

Requesting to give hint about the cause of the issue.

What I have tried:

Tried tracing the issue by logging the steps but it shows all the code is getting executed. But still excel report in not getting generate.

1) Using sql connection to fetch data.
2) Using openxml to generate excel file.
Posted
Comments
Richard Deeming 8-May-17 13:01pm
   
If you're using Office Interop, then don't. It's not supported in ASP.NET applications.

If you're using OpenXML, then you're going to need to debug your code and check the server's event logs to find out what the real problem is. "Error 502" simply tells us that something went wrong on the server. We have no way to tell you what went wrong, or how to fix it.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100