RadGrid export on Azure 502 errors

[Quinn]

Hello,

We recently moved to Azure, and in our staging environments, we have had repeated 502 errors when attempting to export to excel from a radgrid.

Restarting the app allows export to be used again for some time. 

I've read some forums that seemed to have similar issues, but not exactly. Was wondering if there was a common fix for this issue that i missed somewhere.

 

Thanks for your help!

[Attila Antal]

Hi Quinn,

The error 502 could appear from different reasons, usually it's due to incorrect addresses or proxy limitations.

• HTTP Error 502 Bad gateway
• 502 Bad Gateway
• 502 HTTP Status Code

Nevertheless,  we would like to know whether this issue is caused by the grid or is related to the server's configuration.

Can you please share the Grid's declaration (markup) and all the code behind code that is related to it (including the exporting methods if not using the built-in one).

I look forward to hearing from you.

Kind regards,
Attila Antal
Progress Telerik

[Quinn]

Hey Attila,

Thanks for your quick response. I think I've run down the issue we were facing using an Azure trace tool. I found this error: Could not load file or assembly 'Telerik.Web.Spreadsheet, Version=2019.3.1023.40...'

I believe we had some recent dll updates that caused the issue. Still not sure why it was a sporadic issue we could fix with app restarts, but will test my fix soon and update if successful.

[Attila Antal]

Hi Quinn,

Based on your last reply, I suspect the exception was thrown due to incorrect assembly references.

For instance, the first part "Could not load file or assembly 'Telerik.Web.Spreadsheet, Version=2019.3.1023.40.." says that the assembly referenced cannot be accessed, or loaded as it is either missing or the application does not have permissions.

Then the second statement says "I believe we had some recent dll updates that caused the issue." which makes me believe that assemblies have been replaced with a different version, while the application is still holding a reference to the old ones, hence the error message from your first statement.

Please double-check and ensure that you have correct assemblies referenced in both the project and GAC of the server/computer machine. That should fix the problem.

I hope this will help resolve the issue.

Kind regards,
Attila Antal
Progress Telerik

[Quinn]

Your reply is what I assumed as well, but I'm still finding these issues at run time.

I have a bit of confusion with Telerik.Web.Spreadsheet. 

Here are the main issues I believe are connected to my problems.

Could not load file or assembly 'Telerik.Web.Spreadsheet, Version=2019.3.1023.40

Could not load file or assembly 'Telerik.Everlive.Sdk.Net35, Version=1.0.0.0

Could not load file or assembly 'AWSSDK.S3, Version=3.3.0.0

We are running .Net framework 4.6.2

 

I believe I have met the dependency requirements of each package, but I'm a bit confused by the documentation for Telerik.Web.Spreadsheet. I have confirmed there is no Telerik.Web.Spreadsheet.dll in my bin folder. I can't really understand if there should be this file, or if it's included in the packages and does not need an explicit dll?

 

Sorry if that is a bit confusing, and thanks again for your help!

[Attila Antal]

Hi Quinn,

Yes, most likely this would be the reason for the initial problem you have described. These problems, however, are related to Visual Studio Project/Environment configuration rather than to Telerik UI controls.

Here is a KB article addressing similar issue in Azure environment: Unable to Find Dependency (MICROSOFT.WINDOWSAZURE.STORAGE, TELERIK.EVERLIVE.SDK.NET35, AWSSDK.CORE, AWSSDK.S3) build warnings on Telerik.Web.UI.dll in Visual Studio

You can also check out the Installation Troubleshooting and General Troubleshooting pages where we listed the most common problems and tips to resolve them.

I hope this will help resolve the issue.

Kind regards,
Attila Antal
Progress Telerik