Export FIle Excel error create big file

Hi All I have proble with export data for large ( 400.000 ) row or more, and error in job :

  2024-05-22 11:59:37 Filament\Actions\Exports\Jobs\CreateXlsxFile ... RUNNING
  2024-05-22 12:00:37 Filament\Actions\Exports\Jobs\CreateXlsxFile ... 1m FAIL

  2024-05-22 11:59:37 Filament\Actions\Exports\Jobs\CreateXlsxFile ... RUNNING
  2024-05-22 12:00:37 Filament\Actions\Exports\Jobs\CreateXlsxFile ... 1m FAIL

I check resource ( RAM,CPU ) is OK and I don't have Log what the problem . and in table failed_jobs I get error :

Illuminate\Queue\TimeoutExceededException: Filament\Actions\Exports\Jobs\CreateXlsxFile has timed out. in /var/www/html/vendor/laravel/framework/src/Illuminate/Queue/TimeoutExceededException.php:15
Stack trace:
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(796): Illuminate\Queue\TimeoutExceededException::forJob()
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(217): Illuminate\Queue\Worker->timeoutExceededException()
#2 /var/www/html/vendor/openspout/openspout/src/Common/Helper/Escaper/XLSX.php(136): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#3 /var/www/html/vendor/openspout/openspout/src/Common/Helper/Escaper/XLSX.php(35): OpenSpout\Common\Helper\Escaper\XLSX->escapeControlCharacters()

Illuminate\Queue\TimeoutExceededException: Filament\Actions\Exports\Jobs\CreateXlsxFile has timed out. in /var/www/html/vendor/laravel/framework/src/Illuminate/Queue/TimeoutExceededException.php:15
Stack trace:
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(796): Illuminate\Queue\TimeoutExceededException::forJob()
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(217): Illuminate\Queue\Worker->timeoutExceededException()
#2 /var/www/html/vendor/openspout/openspout/src/Common/Helper/Escaper/XLSX.php(136): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#3 /var/www/html/vendor/openspout/openspout/src/Common/Helper/Escaper/XLSX.php(35): OpenSpout\Common\Helper\Escaper\XLSX->escapeControlCharacters()

any one have a idea ?

2 Replies

Jr.PikongOP•9mo ago

If I check in my S3 Bucket .csv file is created complete, but no .xlsx file

Jr.PikongOP•9mo ago

Total row : 434,460 ( row ) chunkSize : 2.000

Gaming

Programming

Export FIle Excel error create big file

Did you find this page helpful?