Export to Excel fails on Web Farm #9757

5 Answer(s)

• 

  0

  ismcagdas created 4 years ago

  Support Team

  Hi @ashvinu

  Do you use Redis ? If not, you should switch to Redis, see https://aspnetboilerplate.com/Pages/Documents/Caching#redis-cache-integration. Default memory cache will cause problems in such an environment.

  Save Cancel
• 

  0

  ashvinu created 4 years ago

  Hello, no we are not using Redis.

  I have tried using IDistributedCache.

  I haved added the following in the Startup.cs

     services.AddDistributedSqlServerCache(options =>
              {
                  options.ConnectionString = _appConfiguration["ConnectionStrings:Default"];
                  options.SchemaName = "dbo";
                  options.TableName = "CacheForTokens";
              });
  

  and have modified the TempFileCacheManager.cs as follows:

       public class TempFileCacheManager : ITempFileCacheManager
      {
          private readonly IDistributedCache _cacheManager;
  
          public TempFileCacheManager(IDistributedCache cacheManager)
          {
              _cacheManager = cacheManager;
          }
  
  
          public void SetFile(string token, byte[] content)
          {
              _cacheManager.Set(token, content);
  
          }
  
          public byte[] GetFile(string token)
          {
              return _cacheManager.Get(token) as byte[];
          }
      }
  

  I see that the token and value is saved successfully in the table when I try to export to Excel,

  but I am still getting the file not found error

  Do you have any idea about what is missing to get this working?

  Thanks and Regards

  Save Cancel
• 

  0

  ashvinu created 4 years ago

  Hello,

  we figured out that the problem is actually with the direction server on the production environment.

  The redirection is not able to read after the "?" in the url, for example: https://website/File/DownloadTempFile?fileType=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet&fileToken=dd24ea6494374d4a8d5565e605eea86c&fileName=AuditLogs.xlsx

  We are trying to look for a solution, but just in case you have any idea, please let us know.

  Thanks and Regards

  Save Cancel
• 

  0

  ismcagdas created 4 years ago

  Support Team

  Hi @ashvinu

  I'm not sure but maybe / charecter here application/vnd.openxmlformats-officedocument.spreadsheetml.sheet causes the problem. Could you encode query string values and try in that way ?

  Save Cancel
• 

  0

  ashvinu created 4 years ago

  Hello,

  the infrastructure guy on our side managed to solve the problem with the redirection server and we are now able to download Excel using the IDistributedCache.

  Thanks and Regards Kirtee

  Save Cancel