Excel Export Requested file does not exist! #9489

7 Answer(s)

• 

  0

  ismcagdas created 4 years ago

  Support Team

  Hi @zyrel.sermon

  Sorry for our late reply.

  1. Do you use Redis or any other cache prodider or do you use memory cache ?
  2. Does your app have more than one instance running on production ?

  Save Cancel
• 

  0

  zyrel.sermon created 4 years ago

  Hi

  Do you use Redis or any other cache prodider or do you use memory cache ? ** we use memory cache Does your app have more than one instance running on production ? ** yes our app is running in multiple instance

  Save Cancel
• 

  0

  maliming created 4 years ago

  Support Team

  yes our app is running in multiple instance

  hi, You should use the redis in the situation

  Save Cancel
• 

  0

  zyrel.sermon created 4 years ago

  Hi is there any sample code snippet or docs on how we can implement redis cache in exporting file? Thanks

  Save Cancel
• 

  0

  maliming created 4 years ago

  Support Team

  hi @zyrel.sermon

  https://aspnetboilerplate.com/Pages/Documents/Caching#redis-cache-integration

  Save Cancel
• 

  0

  zyrel.sermon created 4 years ago

  Hi

  We're using the IDistributedCache to set and get data cache from redis and we're able to see logs set/get from redis, there are times that the exporting is successful and there are times that the "Requested file does not exist!" occurs is it possible that the keys we're getting are already expired?

  here's a sample code

  protected FileDto CreateExcelPackage(string fileName, Action<ExcelPackage> creator)
          {
              var file = new FileDto(fileName, MimeTypeNames.ApplicationVndOpenxmlformatsOfficedocumentSpreadsheetmlSheet);
              string cacheString;
              var cacheToken = _distributedCache.Get(fileName);
              if (cacheToken != null)
              {
                  cacheString = Encoding.UTF8.GetString(cacheToken);
                  file = JsonConvert.DeserializeObject<FileDto>(cacheString);
              }
              else
              {
                  using (var excelPackage = new ExcelPackage())
                  {
                      creator(excelPackage);
                      Save(excelPackage, file);
                  }
                  cacheString = JsonConvert.SerializeObject(file);
                  cacheToken = Encoding.UTF8.GetBytes(cacheString);
                  var options = new DistributedCacheEntryOptions()
                      .SetSlidingExpiration(TimeSpan.FromMinutes(1))
                      .SetAbsoluteExpiration(DateTime.Now.AddMinutes(30));
                  _distributedCache.Set(fileName, cacheToken, options);
                  file = this.CreateExcelPackage(fileName, creator);
              }
              return file;
          }
  

  are we doing it wrong? please advise thanks

  Save Cancel
• 

  0

  maliming created 4 years ago

  Support Team

  hi @zyrel.sermon

  Why are you using IDistributedCache instead of abp cache?

  Save Cancel