ImportAction job is failing but there is no error message
I have simple table with dozens of fields. Nothing special. I want to import records with Filament ImportAction.
I am able to select file, then I get to choose to map CSV fields with database fields. After I click import, the job is dispatched, but the problem is that job is never completed.
I see in my terminal window where I am running php artisan queue:work that ImportCsv job is failing:
2024-03-13 19:36:32 Filament\Actions\Imports\Jobs\ImportCsv .............................................................................. RUNNING
2024-03-13 19:36:32 Filament\Actions\Imports\Jobs\ImportCsv ......................................................................... 56.26ms FAIL
And the job is running and failing, running and failing over and over again.
But the job is never added to fail_jobs table. I get import error for every row in the CSV file and my
failed_import_rows
table is filled with thousand of records but for each row validation_error field is set to NULL.
My CSV file is not big it has 65 rows, so that should be 65 records but the job is stuced in a loop. I need to stop laravel queue worker and delete the job from the jobs
table.
This is how I run my queue worker
5 Replies
Did you check your laravel.log?
This is my error log from laravel.log file
It says exactly where the error is. Did you read it?
you mean this file:
/var/www/html/vendor/filament/actions/src/Imports/Jobs/ImportCsv.php:160
In that file line 160 filament is throwing an exception saying too many exceptions.
This is my failed_import_rows table
Maybe look in your import action. There seems to be a mistake in the query
As you get a QueryException