F
Filament•2mo ago
Jr.Pikong

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.Pikong
Jr.Pikong•2mo ago
If I check in my S3 Bucket .csv file is created complete, but no .xlsx file
Jr.Pikong
Jr.Pikong•2mo ago
Total row : 434,460 ( row ) chunkSize : 2.000
No description
Want results from more Discord servers?
Add your server
More Posts
How to add morphToMany field value from the form ?I have a file submission feature and each submission have notes which is morphic and I have to add fresource in multiple panelsHi, I am trying to reuse same model resource in different panels and display a slight different arraStop job from executingHello, My errorlog keeps filling up with these errors: How can I stop them from being executed overproduct variants selectI need help with a product variant configuration form. The form enables users to define attributes aWhere is the error her?> Tables\Actions\Action::make('roles') > ->label(__('Import')) > Custom Validation Rule not showing failure message in File upload field.Hello all. I was trying to make a custom validation rule for a file upload field, but this was returKeyValue IssuesFilament\Forms\Components\KeyValue::Filament\Forms\Components\{closure}(): Argument #1 ($value) mustCustomize and export a JSON columnHow do you format the JSON values in the database within the exporter file. Im trying to make these