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 :
I check resource ( RAM,CPU ) is OK
and I don't have Log what the problem .
and in table failed_jobs I get error :
any one have a idea ?
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 FAILI 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 ?
