[2025-04-23 07:33:24] production.ALERT: Import update  
[2025-04-23 07:33:24] production.ALERT: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'GOLDCREST.bm_automationfailedqueue' doesn't exist in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:539
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(539): PDO->prepare()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3274): Illuminate\Database\Connection->insert()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Failed/DatabaseUuidFailedJobProvider.php(64): Illuminate\Database\Query\Builder->insert()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(275): Illuminate\Queue\Failed\DatabaseUuidFailedJobProvider->log()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(196): Illuminate\Queue\Console\WorkCommand->logFailedJob()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(421): Illuminate\Queue\Console\WorkCommand->Illuminate\Queue\Console\{closure}()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(249): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(195): Illuminate\Events\Dispatcher->dispatch()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(582): Illuminate\Queue\Jobs\Job->fail()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(528): Illuminate\Queue\Worker->failJob()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->markJobAsFailedIfWillExceedMaxAttempts()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#26 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#27 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#28 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#49 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#52 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#53 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#54 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#55 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#56 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#57 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#58 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#59 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#60 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#61 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#62 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#63 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'GOLDCREST.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (d8b97025-1a50-4e73-8217-407532fb3e6e, mysql, edi_goldcrest, {"uuid":"d8b97025-1a50-4e73-8217-407532fb3e6e","displayName":"App\\Jobs\\EdiExcelJob","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":600,"retryUntil":null,"data":{"commandName":"App\\Jobs\\EdiExcelJob","command":"O:20:\"App\\Jobs\\EdiExcelJob\":2:{s:7:\"\u0000*\u0000data\";a:7:{s:8:\"FilePath\";s:80:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/GOLDCREST\/EDI_File_79_9_07_23_22.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"79\";s:6:\"DBname\";s:9:\"GOLDCREST\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiWmdzU2h2aElDaW1mVHRzQXo2THRvMFNOZkRIXC9VRGwzYnlHTXF4UWY5ZVE9IiwiaXYiOiI4NTQyMTJkMzQ0NmEzOGYzZTE1MjczZTVhZTI3NmQ3ZSIsInNhbHQiOiI0NDJmMDg1ODE3Y2MxYjFlOWVmZGE3YmU5OGM0NDU4MzE5Mjg1ZTkwNzQwNTEwN2IwZDBmN2YxMzgyYzM1ODdmMWRhYWExY2JhYmE1YzljMTRjNTEwZjc4MTg1N2UzZTRlYjdmNGY4MjFiMGRmZTdkZDc2Mzg5MzI3ZjhlMTMxZDFhOTVmYjVkMDNjNTU1MDFlMTkzNjIyZTQyN2I2MDUyM2JiN2NkZTBlMGNlOTU3ZjYxYTRjY2MxYjZlZmMzMDAyZTE0ZDkxMzgyODgwMWFhMzk0NjMwN2NkYWUxZmI4ZWIzODNkNDY3NjUyYzJhZWY1NmZhYTYxOGFlODMwZTUxNjNiMzU0ZWRiZjY5YmQxNGJmOGQzMWE3ZjA1MzY1MWQyYWYzN2ZhMmI1N2NkMDU5ZTA1OGRlYTczNmI5YzhmMDc2Njk5ZDU0YWI3Y2FjNTBhNWE5MzAyZGFhYjY4OGZkYTRmOGIzMjBiNWRhODViY2QzZmQwYTBjNjg2OTI0NzhjNTI5MDMzZDdhNDNiNjE1NzBiODBiNzBjNGViYWQzNTViN2NkYmQyZjM5NGI2MTFhOWI1OGY5YWY5YmVjZGQ5OThjZjA5NmRmZjhkYTc0Zjc1ZTc1OTAwZDNhMDA3Yzk0MjUzYmE1NmU5MjliNDdlNTA0N2M1MDA3NTRhZDFmNSIsIml0ZXJhdGlvbnMiOjl9\";s:6:\"edi_id\";i:6;}s:5:\"queue\";s:13:\"edi_goldcrest\";}"}}, Illuminate\Queue\MaxAttemptsExceededException: App\Jobs\EdiExcelJob has been attempted too many times or run too long. The job may have previously timed out. in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php:746
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#12 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#13 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#14 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#41 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#43 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#44 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#45 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#48 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#49 {main}, 2025-04-23 07:33:24)) in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3274): Illuminate\Database\Connection->insert()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Failed/DatabaseUuidFailedJobProvider.php(64): Illuminate\Database\Query\Builder->insert()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(275): Illuminate\Queue\Failed\DatabaseUuidFailedJobProvider->log()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(196): Illuminate\Queue\Console\WorkCommand->logFailedJob()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(421): Illuminate\Queue\Console\WorkCommand->Illuminate\Queue\Console\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(249): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(195): Illuminate\Events\Dispatcher->dispatch()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(582): Illuminate\Queue\Jobs\Job->fail()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(528): Illuminate\Queue\Worker->failJob()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->markJobAsFailedIfWillExceedMaxAttempts()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#24 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#25 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#26 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#49 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#52 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#53 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#54 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#55 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#56 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#57 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#58 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#59 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#60 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#61 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'GOLDCREST.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (d8b97025-1a50-4e73-8217-407532fb3e6e, mysql, edi_goldcrest, {"uuid":"d8b97025-1a50-4e73-8217-407532fb3e6e","displayName":"App\\Jobs\\EdiExcelJob","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":600,"retryUntil":null,"data":{"commandName":"App\\Jobs\\EdiExcelJob","command":"O:20:\"App\\Jobs\\EdiExcelJob\":2:{s:7:\"\u0000*\u0000data\";a:7:{s:8:\"FilePath\";s:80:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/GOLDCREST\/EDI_File_79_9_07_23_22.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"79\";s:6:\"DBname\";s:9:\"GOLDCREST\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiWmdzU2h2aElDaW1mVHRzQXo2THRvMFNOZkRIXC9VRGwzYnlHTXF4UWY5ZVE9IiwiaXYiOiI4NTQyMTJkMzQ0NmEzOGYzZTE1MjczZTVhZTI3NmQ3ZSIsInNhbHQiOiI0NDJmMDg1ODE3Y2MxYjFlOWVmZGE3YmU5OGM0NDU4MzE5Mjg1ZTkwNzQwNTEwN2IwZDBmN2YxMzgyYzM1ODdmMWRhYWExY2JhYmE1YzljMTRjNTEwZjc4MTg1N2UzZTRlYjdmNGY4MjFiMGRmZTdkZDc2Mzg5MzI3ZjhlMTMxZDFhOTVmYjVkMDNjNTU1MDFlMTkzNjIyZTQyN2I2MDUyM2JiN2NkZTBlMGNlOTU3ZjYxYTRjY2MxYjZlZmMzMDAyZTE0ZDkxMzgyODgwMWFhMzk0NjMwN2NkYWUxZmI4ZWIzODNkNDY3NjUyYzJhZWY1NmZhYTYxOGFlODMwZTUxNjNiMzU0ZWRiZjY5YmQxNGJmOGQzMWE3ZjA1MzY1MWQyYWYzN2ZhMmI1N2NkMDU5ZTA1OGRlYTczNmI5YzhmMDc2Njk5ZDU0YWI3Y2FjNTBhNWE5MzAyZGFhYjY4OGZkYTRmOGIzMjBiNWRhODViY2QzZmQwYTBjNjg2OTI0NzhjNTI5MDMzZDdhNDNiNjE1NzBiODBiNzBjNGViYWQzNTViN2NkYmQyZjM5NGI2MTFhOWI1OGY5YWY5YmVjZGQ5OThjZjA5NmRmZjhkYTc0Zjc1ZTc1OTAwZDNhMDA3Yzk0MjUzYmE1NmU5MjliNDdlNTA0N2M1MDA3NTRhZDFmNSIsIml0ZXJhdGlvbnMiOjl9\";s:6:\"edi_id\";i:6;}s:5:\"queue\";s:13:\"edi_goldcrest\";}"}}, Illuminate\Queue\MaxAttemptsExceededException: App\Jobs\EdiExcelJob has been attempted too many times or run too long. The job may have previously timed out. in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php:746
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#12 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#13 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#14 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#41 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#43 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#44 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#45 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#48 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#49 {main}, 2025-04-23 07:33:24)) (SQL: select `cd_id` as `colormapid`, `cd_fabricmapid` as `fabricmapid` from `bm_colordetails` inner join `bm_fabriccolourmap` on `pfm_colourmapid` = `cd_id` and `pfm_status` = 0 inner join `bm_productgroupmaterialmap` on `pgmm_fabriccolormapid` = `pfm_id` and `pgmm_status` = 0 where `cd_mtrlcategid` = 5 and `cd_status` = 0 and JSON_VALUE(cd_custmzdcolrdetails, '$.133') = Oyster and JSON_VALUE(cd_custmzdcolrdetails, '$.134') = 508589 and JSON_VALUE(pfm_jsondata, '$.128') = Soho and JSON_VALUE(pfm_jsondata, '$.129') = 124667 limit 1) in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#9 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#10 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#11 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#38 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#40 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#41 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#42 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#45 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#46 {main}  
[2025-04-23 08:19:33] production.ALERT: Import update  
[2025-04-23 08:19:33] production.ALERT: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SCOTBLINDS.bm_automationfailedqueue' doesn't exist in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:539
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(539): PDO->prepare()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3274): Illuminate\Database\Connection->insert()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Failed/DatabaseUuidFailedJobProvider.php(64): Illuminate\Database\Query\Builder->insert()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(275): Illuminate\Queue\Failed\DatabaseUuidFailedJobProvider->log()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(196): Illuminate\Queue\Console\WorkCommand->logFailedJob()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(421): Illuminate\Queue\Console\WorkCommand->Illuminate\Queue\Console\{closure}()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(249): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(195): Illuminate\Events\Dispatcher->dispatch()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(582): Illuminate\Queue\Jobs\Job->fail()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(528): Illuminate\Queue\Worker->failJob()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->markJobAsFailedIfWillExceedMaxAttempts()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#26 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#27 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#28 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#49 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#52 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#53 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#54 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#55 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#56 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#57 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#58 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#59 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#60 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#61 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#62 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#63 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SCOTBLINDS.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (971d388e-6e7c-450f-ad39-131bf22a425b, mysql, edi_scotblinds, {"uuid":"971d388e-6e7c-450f-ad39-131bf22a425b","displayName":"App\\Jobs\\EdiExcelJob","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":600,"retryUntil":null,"data":{"commandName":"App\\Jobs\\EdiExcelJob","command":"O:20:\"App\\Jobs\\EdiExcelJob\":2:{s:7:\"\u0000*\u0000data\";a:7:{s:8:\"FilePath\";s:81:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/SCOTBLINDS\/EDI_File_96_9_08_09_32.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"96\";s:6:\"DBname\";s:10:\"SCOTBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiZTJoUUdYOUd1N1V0NDFyTTFhd3lMNTQ5NDR0VkJyazkzRlNrUzRrUGRoST0iLCJpdiI6IjU0OTM4OTIwMmQ3ODQ4NjZhMGI2OWUzNTI0MjhmOTQyIiwic2FsdCI6IjgxNmE5MDNmNWRkYzZmN2IzY2YzMGYxMjI3OGQ3YmI4ZDY5OWM4Y2YzNjMyYzlhMTc0YTBkYTMxYWMxNmFjMWFlZDQ1ODVhZTUzZjg0MjU0N2JlMmU0ZTMyMzYwNDAwNzFjMTZkNjg0ODk3ZjNmYmUxNDc4NDUxYzQ3YmExNTUxOGQ5M2RlYmRlZjFlNTI5ZDBiMTUzMTNlMjdlZDMzOGQ2Mjc1YmFkZTNjYTc2MDM3NTcyN2I1MmI1NWIyNjkwYjUwZmM3NzMzMDYzMzBiYjljZjQ0NmE4YWUyMjRjOTc2NThiNjlhZjNiNTJiZDY5MzlhZjYwYmFhYmY1YzY3YWQyNTcyOGNkZGZiZGU2YjIzZTQwMjVjYTFmNDkzMmI1YTg2OWYwZTFkZTk0ZjM3MWQzZWY0YzcwYjY1ZTQ2MTJmZjAzNTNiZDIxZTZkZWNiNDgxYWVkNTU0MTEyMDEyYmU5NDgzNDQ4MjhlM2I2MTg1MmYxOGM3MGFmMzAwODQ3NDg2ZjBlMWI1Mjg5ZWNiY2Q5ODk4MjNjODAyMmMxYzdjMzgxNTk4M2VlMzRmMGZhNTJiNjc3YjlkYjlhNWZlYjY4NjAyYmNmNzE0OTJlODljY2M3ODI5MGQzMTg1NjkxNTRhNmYwZjg1YTNlNWM5M2RkNWM2YzBkMjYzODZmOTJlIiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:32;}s:5:\"queue\";s:14:\"edi_scotblinds\";}"}}, Illuminate\Queue\MaxAttemptsExceededException: App\Jobs\EdiExcelJob has been attempted too many times or run too long. The job may have previously timed out. in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php:746
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#12 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#13 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#14 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#41 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#43 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#44 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#45 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#48 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#49 {main}, 2025-04-23 08:19:33)) in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3274): Illuminate\Database\Connection->insert()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Failed/DatabaseUuidFailedJobProvider.php(64): Illuminate\Database\Query\Builder->insert()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(275): Illuminate\Queue\Failed\DatabaseUuidFailedJobProvider->log()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(196): Illuminate\Queue\Console\WorkCommand->logFailedJob()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(421): Illuminate\Queue\Console\WorkCommand->Illuminate\Queue\Console\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(249): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(195): Illuminate\Events\Dispatcher->dispatch()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(582): Illuminate\Queue\Jobs\Job->fail()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(528): Illuminate\Queue\Worker->failJob()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->markJobAsFailedIfWillExceedMaxAttempts()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#24 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#25 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#26 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#49 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#52 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#53 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#54 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#55 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#56 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#57 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#58 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#59 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#60 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#61 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SCOTBLINDS.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (971d388e-6e7c-450f-ad39-131bf22a425b, mysql, edi_scotblinds, {"uuid":"971d388e-6e7c-450f-ad39-131bf22a425b","displayName":"App\\Jobs\\EdiExcelJob","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":600,"retryUntil":null,"data":{"commandName":"App\\Jobs\\EdiExcelJob","command":"O:20:\"App\\Jobs\\EdiExcelJob\":2:{s:7:\"\u0000*\u0000data\";a:7:{s:8:\"FilePath\";s:81:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/SCOTBLINDS\/EDI_File_96_9_08_09_32.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"96\";s:6:\"DBname\";s:10:\"SCOTBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiZTJoUUdYOUd1N1V0NDFyTTFhd3lMNTQ5NDR0VkJyazkzRlNrUzRrUGRoST0iLCJpdiI6IjU0OTM4OTIwMmQ3ODQ4NjZhMGI2OWUzNTI0MjhmOTQyIiwic2FsdCI6IjgxNmE5MDNmNWRkYzZmN2IzY2YzMGYxMjI3OGQ3YmI4ZDY5OWM4Y2YzNjMyYzlhMTc0YTBkYTMxYWMxNmFjMWFlZDQ1ODVhZTUzZjg0MjU0N2JlMmU0ZTMyMzYwNDAwNzFjMTZkNjg0ODk3ZjNmYmUxNDc4NDUxYzQ3YmExNTUxOGQ5M2RlYmRlZjFlNTI5ZDBiMTUzMTNlMjdlZDMzOGQ2Mjc1YmFkZTNjYTc2MDM3NTcyN2I1MmI1NWIyNjkwYjUwZmM3NzMzMDYzMzBiYjljZjQ0NmE4YWUyMjRjOTc2NThiNjlhZjNiNTJiZDY5MzlhZjYwYmFhYmY1YzY3YWQyNTcyOGNkZGZiZGU2YjIzZTQwMjVjYTFmNDkzMmI1YTg2OWYwZTFkZTk0ZjM3MWQzZWY0YzcwYjY1ZTQ2MTJmZjAzNTNiZDIxZTZkZWNiNDgxYWVkNTU0MTEyMDEyYmU5NDgzNDQ4MjhlM2I2MTg1MmYxOGM3MGFmMzAwODQ3NDg2ZjBlMWI1Mjg5ZWNiY2Q5ODk4MjNjODAyMmMxYzdjMzgxNTk4M2VlMzRmMGZhNTJiNjc3YjlkYjlhNWZlYjY4NjAyYmNmNzE0OTJlODljY2M3ODI5MGQzMTg1NjkxNTRhNmYwZjg1YTNlNWM5M2RkNWM2YzBkMjYzODZmOTJlIiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:32;}s:5:\"queue\";s:14:\"edi_scotblinds\";}"}}, Illuminate\Queue\MaxAttemptsExceededException: App\Jobs\EdiExcelJob has been attempted too many times or run too long. The job may have previously timed out. in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php:746
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#12 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#13 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#14 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#41 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#43 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#44 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#45 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#48 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#49 {main}, 2025-04-23 08:19:33)) (SQL: select `cd_id` as `colormapid`, `cd_fabricmapid` as `fabricmapid` from `bm_colordetails` inner join `bm_fabriccolourmap` on `pfm_colourmapid` = `cd_id` and `pfm_status` = 0 inner join `bm_productgroupmaterialmap` on `pgmm_fabriccolormapid` = `pfm_id` and `pgmm_status` = 0 where `cd_mtrlcategid` = 5 and `cd_status` = 0 and JSON_VALUE(cd_custmzdcolrdetails, '$.133') = White and JSON_VALUE(cd_custmzdcolrdetails, '$.134') = 519262 and JSON_VALUE(pfm_jsondata, '$.128') = Sunfilter 5% (250) and JSON_VALUE(pfm_jsondata, '$.129') = 126942 limit 1) in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#9 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#10 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#11 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#38 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#40 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#41 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#42 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#45 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#46 {main}  
[2025-04-23 08:29:36] production.ALERT: Import update  
[2025-04-23 08:29:36] production.ALERT: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SCOTBLINDS.bm_automationfailedqueue' doesn't exist in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:539
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(539): PDO->prepare()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3274): Illuminate\Database\Connection->insert()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Failed/DatabaseUuidFailedJobProvider.php(64): Illuminate\Database\Query\Builder->insert()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(275): Illuminate\Queue\Failed\DatabaseUuidFailedJobProvider->log()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(196): Illuminate\Queue\Console\WorkCommand->logFailedJob()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(421): Illuminate\Queue\Console\WorkCommand->Illuminate\Queue\Console\{closure}()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(249): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(195): Illuminate\Events\Dispatcher->dispatch()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(582): Illuminate\Queue\Jobs\Job->fail()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(528): Illuminate\Queue\Worker->failJob()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->markJobAsFailedIfWillExceedMaxAttempts()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#26 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#27 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#28 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#49 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#52 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#53 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#54 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#55 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#56 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#57 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#58 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#59 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#60 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#61 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#62 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#63 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SCOTBLINDS.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (43510f2e-4a2e-4e4e-9a60-7c3b0c2549eb, mysql, edi_scotblinds, {"uuid":"43510f2e-4a2e-4e4e-9a60-7c3b0c2549eb","displayName":"App\\Jobs\\EdiExcelJob","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":600,"retryUntil":null,"data":{"commandName":"App\\Jobs\\EdiExcelJob","command":"O:20:\"App\\Jobs\\EdiExcelJob\":2:{s:7:\"\u0000*\u0000data\";a:7:{s:8:\"FilePath\";s:81:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/SCOTBLINDS\/EDI_File_81_9_08_16_37.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"81\";s:6:\"DBname\";s:10:\"SCOTBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiTjZqeVJjZkcreW4yZWZGdUo4VlZVZzdTdjdJUE45dUtiSTdvWWFxTVFrMD0iLCJpdiI6IjU4OTJjNzcxZWI1Zjk4OWVjYjgxYzhkODU2OGNiZTcxIiwic2FsdCI6ImM3NDdkZWIwMjlmZDRiZDM4Y2E1NWI1ZTZiOTIzMzFjOTcyYzhjZGI3NmFkMGI5ZmE5ZmJlNGY2NTlkNjllM2U3NGM4ZWRmMjI3YTliMGY2ZjUyMjYzZTA5MGU4NWY2MGNlODMwZjAzNmIxZGVhZjUwODUxOTEzMWQ5MDA3NTg5ZjVjY2UyZmM4NDczMDc1MjdjMjg4MzUxMDE2NDY5OTg0MmRlZjk1MDMzOWQ3Y2Y5NjlhY2Y1OTcyNGY5ZTFlYzA5YWE1NDU0ZmYyMGYwNTc2ODhhZGJlNDRhNDk5YTM1OTlkMGZlODQwYThkZTI4NDkzOGVjYjA1OWY5YTc2ZThlYmFlYmMyNGJkYzIwNTIyYTMyMmMwMWYyYWQzYzE0OTJkMGZiZmMxYTM2Zjc0NzliZWFjMDQ1YWE1ZWM4ZTQzMDkxNGM0M2MyZWNjNjAwZDMxNTU4M2U4OGVlNzNkYzUzZjYwZWY1MGZkOGQ0ZmNkOTRhOTM0MGM5MTNhMDViZjhlZWY5MWU1YThlY2Q1YWE4MWE4NzdjNTVjYzBiNjA0YzcxYzNlOTE5OTE1YTkyNGQwODhmYjQzODE0M2I4NTQ5ZDdmMDg3YzRmZTU0NWNkZmNjZDJiMjkwMGZiNjZjY2NkMDM1MTIzMjJhZGNkYTU1OGMzMjE3NWVjZGVhZGFmIiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:33;}s:5:\"queue\";s:14:\"edi_scotblinds\";}"}}, Illuminate\Queue\MaxAttemptsExceededException: App\Jobs\EdiExcelJob has been attempted too many times or run too long. The job may have previously timed out. in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php:746
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#12 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#13 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#14 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#41 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#43 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#44 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#45 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#48 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#49 {main}, 2025-04-23 08:29:36)) in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3274): Illuminate\Database\Connection->insert()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Failed/DatabaseUuidFailedJobProvider.php(64): Illuminate\Database\Query\Builder->insert()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(275): Illuminate\Queue\Failed\DatabaseUuidFailedJobProvider->log()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(196): Illuminate\Queue\Console\WorkCommand->logFailedJob()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(421): Illuminate\Queue\Console\WorkCommand->Illuminate\Queue\Console\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(249): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(195): Illuminate\Events\Dispatcher->dispatch()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(582): Illuminate\Queue\Jobs\Job->fail()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(528): Illuminate\Queue\Worker->failJob()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->markJobAsFailedIfWillExceedMaxAttempts()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#24 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#25 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#26 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#49 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#52 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#53 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#54 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#55 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#56 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#57 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#58 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#59 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#60 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#61 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SCOTBLINDS.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (43510f2e-4a2e-4e4e-9a60-7c3b0c2549eb, mysql, edi_scotblinds, {"uuid":"43510f2e-4a2e-4e4e-9a60-7c3b0c2549eb","displayName":"App\\Jobs\\EdiExcelJob","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":600,"retryUntil":null,"data":{"commandName":"App\\Jobs\\EdiExcelJob","command":"O:20:\"App\\Jobs\\EdiExcelJob\":2:{s:7:\"\u0000*\u0000data\";a:7:{s:8:\"FilePath\";s:81:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/SCOTBLINDS\/EDI_File_81_9_08_16_37.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"81\";s:6:\"DBname\";s:10:\"SCOTBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiTjZqeVJjZkcreW4yZWZGdUo4VlZVZzdTdjdJUE45dUtiSTdvWWFxTVFrMD0iLCJpdiI6IjU4OTJjNzcxZWI1Zjk4OWVjYjgxYzhkODU2OGNiZTcxIiwic2FsdCI6ImM3NDdkZWIwMjlmZDRiZDM4Y2E1NWI1ZTZiOTIzMzFjOTcyYzhjZGI3NmFkMGI5ZmE5ZmJlNGY2NTlkNjllM2U3NGM4ZWRmMjI3YTliMGY2ZjUyMjYzZTA5MGU4NWY2MGNlODMwZjAzNmIxZGVhZjUwODUxOTEzMWQ5MDA3NTg5ZjVjY2UyZmM4NDczMDc1MjdjMjg4MzUxMDE2NDY5OTg0MmRlZjk1MDMzOWQ3Y2Y5NjlhY2Y1OTcyNGY5ZTFlYzA5YWE1NDU0ZmYyMGYwNTc2ODhhZGJlNDRhNDk5YTM1OTlkMGZlODQwYThkZTI4NDkzOGVjYjA1OWY5YTc2ZThlYmFlYmMyNGJkYzIwNTIyYTMyMmMwMWYyYWQzYzE0OTJkMGZiZmMxYTM2Zjc0NzliZWFjMDQ1YWE1ZWM4ZTQzMDkxNGM0M2MyZWNjNjAwZDMxNTU4M2U4OGVlNzNkYzUzZjYwZWY1MGZkOGQ0ZmNkOTRhOTM0MGM5MTNhMDViZjhlZWY5MWU1YThlY2Q1YWE4MWE4NzdjNTVjYzBiNjA0YzcxYzNlOTE5OTE1YTkyNGQwODhmYjQzODE0M2I4NTQ5ZDdmMDg3YzRmZTU0NWNkZmNjZDJiMjkwMGZiNjZjY2NkMDM1MTIzMjJhZGNkYTU1OGMzMjE3NWVjZGVhZGFmIiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:33;}s:5:\"queue\";s:14:\"edi_scotblinds\";}"}}, Illuminate\Queue\MaxAttemptsExceededException: App\Jobs\EdiExcelJob has been attempted too many times or run too long. The job may have previously timed out. in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php:746
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#12 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#13 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#14 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#41 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#43 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#44 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#45 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#48 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#49 {main}, 2025-04-23 08:29:36)) (SQL: select `cd_id` as `colormapid`, `cd_fabricmapid` as `fabricmapid` from `bm_colordetails` inner join `bm_fabriccolourmap` on `pfm_colourmapid` = `cd_id` and `pfm_status` = 0 inner join `bm_productgroupmaterialmap` on `pgmm_fabriccolormapid` = `pfm_id` and `pgmm_status` = 0 where `cd_mtrlcategid` = 5 and `cd_status` = 0 and JSON_VALUE(cd_custmzdcolrdetails, '$.133') = Ocean and JSON_VALUE(cd_custmzdcolrdetails, '$.134') = 447309 and JSON_VALUE(pfm_jsondata, '$.128') = Dapple Spc+ (L) and JSON_VALUE(pfm_jsondata, '$.129') = 112248 limit 1) in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#9 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#10 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#11 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#38 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#40 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#41 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#42 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#45 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#46 {main}  
[2025-04-23 09:14:30] production.ALERT: Import update  
[2025-04-23 09:14:30] production.ALERT: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SCOTBLINDS.bm_automationfailedqueue' doesn't exist in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:539
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(539): PDO->prepare()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3274): Illuminate\Database\Connection->insert()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Failed/DatabaseUuidFailedJobProvider.php(64): Illuminate\Database\Query\Builder->insert()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(275): Illuminate\Queue\Failed\DatabaseUuidFailedJobProvider->log()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(196): Illuminate\Queue\Console\WorkCommand->logFailedJob()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(421): Illuminate\Queue\Console\WorkCommand->Illuminate\Queue\Console\{closure}()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(249): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(195): Illuminate\Events\Dispatcher->dispatch()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(582): Illuminate\Queue\Jobs\Job->fail()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(528): Illuminate\Queue\Worker->failJob()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->markJobAsFailedIfWillExceedMaxAttempts()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#26 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#27 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#28 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#49 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#52 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#53 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#54 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#55 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#56 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#57 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#58 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#59 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#60 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#61 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#62 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#63 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SCOTBLINDS.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (38f00e38-20b8-4f9c-bf9d-546a248de045, mysql, edi_scotblinds, {"uuid":"38f00e38-20b8-4f9c-bf9d-546a248de045","displayName":"App\\Jobs\\EdiExcelJob","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":600,"retryUntil":null,"data":{"commandName":"App\\Jobs\\EdiExcelJob","command":"O:20:\"App\\Jobs\\EdiExcelJob\":2:{s:7:\"\u0000*\u0000data\";a:7:{s:8:\"FilePath\";s:81:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/SCOTBLINDS\/EDI_File_59_9_09_04_29.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"59\";s:6:\"DBname\";s:10:\"SCOTBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiaDVwK1ZVYVZpaElVbVFmSHhKZm1lRWh5UStYOEVQRUxiZlNRaU9RTDA0TT0iLCJpdiI6ImFiNTk2ODdjMTYwMTgzOGRkODM5ZjUzN2VmODI1ODRiIiwic2FsdCI6ImQyZjFlMDgyOTc5OWQ4ZmY2MjBhODU4Y2IxNDEzMDU1MzJmZmE5MjY4MmUzYTIzNDkwYjQ0ZDhlOWIyMjliODE0YjAzZGQ1MmFlMmU2OGVmMDJiYjY5ZDA4MTg4OTFhODFjMzczMzMyNmE5Y2NlNTZhMGUxNDEyYWRjOTM5N2U5NDllOWJjOGFmZDhmYThlYzA5OTQ1MGRjYzY4MTE4ZmIzMGM4OWQzMDY1NzJhYTEzOTQ4MGUyODJiNTQ5Mzk3NjlmMTAzMzYyNDE0Mjc0ODUyMjlhOGQyNTI4ZTVjZWVjYmVlMTJhYzY4ZGM0NWY2YTA3NDk2YzNjYjE3MGZmODg3ZTE5OTY2MmIyMThjYmRhYzE2MjgzZDM4MDQwZGQ5NjM4NzQ3Y2FhYTE2ZTI4Mjg3MDhmZDUzNzZhZWY5ZGJkZWIyMDFhZGVlMzRjOTYwZDBjMDIwODJlZDNiZTc0ZWJiMmYyNjE0NWQ2YTUxODAyYWYyMmEwZjVmYmU5ZWFhMmU5ZTNkOTFkNjdhZmMzZTRlZDhhOWU0NmE5MzJiZDYxY2ExMTVjM2ZjMWM3YmQxZDY3ZGJkZDMwMjEwNGNjOTYxOTM3YWZkOWYyMjkxN2UzY2RiZTNmZTg1ZTFjODRiNTI3ZDlmNWE5YWEwYjZiZGU0NDY5MmYwZmQxMTg2NWM4IiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:34;}s:5:\"queue\";s:14:\"edi_scotblinds\";}"}}, Illuminate\Queue\MaxAttemptsExceededException: App\Jobs\EdiExcelJob has been attempted too many times or run too long. The job may have previously timed out. in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php:746
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#12 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#13 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#14 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#41 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#43 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#44 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#45 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#48 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#49 {main}, 2025-04-23 09:14:30)) in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3274): Illuminate\Database\Connection->insert()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Failed/DatabaseUuidFailedJobProvider.php(64): Illuminate\Database\Query\Builder->insert()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(275): Illuminate\Queue\Failed\DatabaseUuidFailedJobProvider->log()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(196): Illuminate\Queue\Console\WorkCommand->logFailedJob()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(421): Illuminate\Queue\Console\WorkCommand->Illuminate\Queue\Console\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(249): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(195): Illuminate\Events\Dispatcher->dispatch()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(582): Illuminate\Queue\Jobs\Job->fail()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(528): Illuminate\Queue\Worker->failJob()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->markJobAsFailedIfWillExceedMaxAttempts()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#24 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#25 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#26 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#49 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#52 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#53 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#54 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#55 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#56 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#57 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#58 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#59 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#60 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#61 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SCOTBLINDS.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (38f00e38-20b8-4f9c-bf9d-546a248de045, mysql, edi_scotblinds, {"uuid":"38f00e38-20b8-4f9c-bf9d-546a248de045","displayName":"App\\Jobs\\EdiExcelJob","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":600,"retryUntil":null,"data":{"commandName":"App\\Jobs\\EdiExcelJob","command":"O:20:\"App\\Jobs\\EdiExcelJob\":2:{s:7:\"\u0000*\u0000data\";a:7:{s:8:\"FilePath\";s:81:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/SCOTBLINDS\/EDI_File_59_9_09_04_29.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"59\";s:6:\"DBname\";s:10:\"SCOTBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiaDVwK1ZVYVZpaElVbVFmSHhKZm1lRWh5UStYOEVQRUxiZlNRaU9RTDA0TT0iLCJpdiI6ImFiNTk2ODdjMTYwMTgzOGRkODM5ZjUzN2VmODI1ODRiIiwic2FsdCI6ImQyZjFlMDgyOTc5OWQ4ZmY2MjBhODU4Y2IxNDEzMDU1MzJmZmE5MjY4MmUzYTIzNDkwYjQ0ZDhlOWIyMjliODE0YjAzZGQ1MmFlMmU2OGVmMDJiYjY5ZDA4MTg4OTFhODFjMzczMzMyNmE5Y2NlNTZhMGUxNDEyYWRjOTM5N2U5NDllOWJjOGFmZDhmYThlYzA5OTQ1MGRjYzY4MTE4ZmIzMGM4OWQzMDY1NzJhYTEzOTQ4MGUyODJiNTQ5Mzk3NjlmMTAzMzYyNDE0Mjc0ODUyMjlhOGQyNTI4ZTVjZWVjYmVlMTJhYzY4ZGM0NWY2YTA3NDk2YzNjYjE3MGZmODg3ZTE5OTY2MmIyMThjYmRhYzE2MjgzZDM4MDQwZGQ5NjM4NzQ3Y2FhYTE2ZTI4Mjg3MDhmZDUzNzZhZWY5ZGJkZWIyMDFhZGVlMzRjOTYwZDBjMDIwODJlZDNiZTc0ZWJiMmYyNjE0NWQ2YTUxODAyYWYyMmEwZjVmYmU5ZWFhMmU5ZTNkOTFkNjdhZmMzZTRlZDhhOWU0NmE5MzJiZDYxY2ExMTVjM2ZjMWM3YmQxZDY3ZGJkZDMwMjEwNGNjOTYxOTM3YWZkOWYyMjkxN2UzY2RiZTNmZTg1ZTFjODRiNTI3ZDlmNWE5YWEwYjZiZGU0NDY5MmYwZmQxMTg2NWM4IiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:34;}s:5:\"queue\";s:14:\"edi_scotblinds\";}"}}, Illuminate\Queue\MaxAttemptsExceededException: App\Jobs\EdiExcelJob has been attempted too many times or run too long. The job may have previously timed out. in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php:746
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#12 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#13 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#14 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#41 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#43 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#44 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#45 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#48 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#49 {main}, 2025-04-23 09:14:30)) (SQL: select `cd_id` as `colormapid`, `cd_fabricmapid` as `fabricmapid` from `bm_colordetails` inner join `bm_fabriccolourmap` on `pfm_colourmapid` = `cd_id` and `pfm_status` = 0 inner join `bm_productgroupmaterialmap` on `pgmm_fabriccolormapid` = `pfm_id` and `pgmm_status` = 0 where `cd_mtrlcategid` = 5 and `cd_status` = 0 and JSON_VALUE(cd_custmzdcolrdetails, '$.133') = Slate and JSON_VALUE(cd_custmzdcolrdetails, '$.134') = 451516 and JSON_VALUE(pfm_jsondata, '$.128') = Ex-Lite B/O (183) (L) and JSON_VALUE(pfm_jsondata, '$.129') = 112956 limit 1) in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#9 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#10 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#11 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#38 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#40 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#41 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#42 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#45 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#46 {main}  
[2025-04-23 10:35:02] production.ALERT: Import update  
[2025-04-23 10:35:02] production.ALERT: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SCOTBLINDS.bm_automationfailedqueue' doesn't exist in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:539
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(539): PDO->prepare()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3274): Illuminate\Database\Connection->insert()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Failed/DatabaseUuidFailedJobProvider.php(64): Illuminate\Database\Query\Builder->insert()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(275): Illuminate\Queue\Failed\DatabaseUuidFailedJobProvider->log()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(196): Illuminate\Queue\Console\WorkCommand->logFailedJob()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(421): Illuminate\Queue\Console\WorkCommand->Illuminate\Queue\Console\{closure}()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(249): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(195): Illuminate\Events\Dispatcher->dispatch()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(582): Illuminate\Queue\Jobs\Job->fail()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(528): Illuminate\Queue\Worker->failJob()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->markJobAsFailedIfWillExceedMaxAttempts()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#26 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#27 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#28 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#49 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#52 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#53 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#54 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#55 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#56 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#57 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#58 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#59 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#60 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#61 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#62 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#63 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SCOTBLINDS.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (043cde62-781b-4a27-a10d-94ad191906f0, mysql, edi_scotblinds, {"uuid":"043cde62-781b-4a27-a10d-94ad191906f0","displayName":"App\\Jobs\\EdiExcelJob","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":600,"retryUntil":null,"data":{"commandName":"App\\Jobs\\EdiExcelJob","command":"O:20:\"App\\Jobs\\EdiExcelJob\":2:{s:7:\"\u0000*\u0000data\";a:7:{s:8:\"FilePath\";s:81:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/SCOTBLINDS\/EDI_File_56_9_10_24_59.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"56\";s:6:\"DBname\";s:10:\"SCOTBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiaDVwK1ZVYVZpaElVbVFmSHhKZm1lRWh5UStYOEVQRUxiZlNRaU9RTDA0TT0iLCJpdiI6ImFiNTk2ODdjMTYwMTgzOGRkODM5ZjUzN2VmODI1ODRiIiwic2FsdCI6ImQyZjFlMDgyOTc5OWQ4ZmY2MjBhODU4Y2IxNDEzMDU1MzJmZmE5MjY4MmUzYTIzNDkwYjQ0ZDhlOWIyMjliODE0YjAzZGQ1MmFlMmU2OGVmMDJiYjY5ZDA4MTg4OTFhODFjMzczMzMyNmE5Y2NlNTZhMGUxNDEyYWRjOTM5N2U5NDllOWJjOGFmZDhmYThlYzA5OTQ1MGRjYzY4MTE4ZmIzMGM4OWQzMDY1NzJhYTEzOTQ4MGUyODJiNTQ5Mzk3NjlmMTAzMzYyNDE0Mjc0ODUyMjlhOGQyNTI4ZTVjZWVjYmVlMTJhYzY4ZGM0NWY2YTA3NDk2YzNjYjE3MGZmODg3ZTE5OTY2MmIyMThjYmRhYzE2MjgzZDM4MDQwZGQ5NjM4NzQ3Y2FhYTE2ZTI4Mjg3MDhmZDUzNzZhZWY5ZGJkZWIyMDFhZGVlMzRjOTYwZDBjMDIwODJlZDNiZTc0ZWJiMmYyNjE0NWQ2YTUxODAyYWYyMmEwZjVmYmU5ZWFhMmU5ZTNkOTFkNjdhZmMzZTRlZDhhOWU0NmE5MzJiZDYxY2ExMTVjM2ZjMWM3YmQxZDY3ZGJkZDMwMjEwNGNjOTYxOTM3YWZkOWYyMjkxN2UzY2RiZTNmZTg1ZTFjODRiNTI3ZDlmNWE5YWEwYjZiZGU0NDY5MmYwZmQxMTg2NWM4IiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:35;}s:5:\"queue\";s:14:\"edi_scotblinds\";}"}}, Illuminate\Queue\MaxAttemptsExceededException: App\Jobs\EdiExcelJob has been attempted too many times or run too long. The job may have previously timed out. in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php:746
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#12 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#13 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#14 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#41 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#43 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#44 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#45 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#48 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#49 {main}, 2025-04-23 10:35:02)) in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3274): Illuminate\Database\Connection->insert()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Failed/DatabaseUuidFailedJobProvider.php(64): Illuminate\Database\Query\Builder->insert()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(275): Illuminate\Queue\Failed\DatabaseUuidFailedJobProvider->log()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(196): Illuminate\Queue\Console\WorkCommand->logFailedJob()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(421): Illuminate\Queue\Console\WorkCommand->Illuminate\Queue\Console\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(249): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(195): Illuminate\Events\Dispatcher->dispatch()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(582): Illuminate\Queue\Jobs\Job->fail()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(528): Illuminate\Queue\Worker->failJob()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->markJobAsFailedIfWillExceedMaxAttempts()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#24 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#25 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#26 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#49 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#52 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#53 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#54 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#55 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#56 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#57 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#58 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#59 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#60 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#61 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SCOTBLINDS.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (043cde62-781b-4a27-a10d-94ad191906f0, mysql, edi_scotblinds, {"uuid":"043cde62-781b-4a27-a10d-94ad191906f0","displayName":"App\\Jobs\\EdiExcelJob","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":600,"retryUntil":null,"data":{"commandName":"App\\Jobs\\EdiExcelJob","command":"O:20:\"App\\Jobs\\EdiExcelJob\":2:{s:7:\"\u0000*\u0000data\";a:7:{s:8:\"FilePath\";s:81:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/SCOTBLINDS\/EDI_File_56_9_10_24_59.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"56\";s:6:\"DBname\";s:10:\"SCOTBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiaDVwK1ZVYVZpaElVbVFmSHhKZm1lRWh5UStYOEVQRUxiZlNRaU9RTDA0TT0iLCJpdiI6ImFiNTk2ODdjMTYwMTgzOGRkODM5ZjUzN2VmODI1ODRiIiwic2FsdCI6ImQyZjFlMDgyOTc5OWQ4ZmY2MjBhODU4Y2IxNDEzMDU1MzJmZmE5MjY4MmUzYTIzNDkwYjQ0ZDhlOWIyMjliODE0YjAzZGQ1MmFlMmU2OGVmMDJiYjY5ZDA4MTg4OTFhODFjMzczMzMyNmE5Y2NlNTZhMGUxNDEyYWRjOTM5N2U5NDllOWJjOGFmZDhmYThlYzA5OTQ1MGRjYzY4MTE4ZmIzMGM4OWQzMDY1NzJhYTEzOTQ4MGUyODJiNTQ5Mzk3NjlmMTAzMzYyNDE0Mjc0ODUyMjlhOGQyNTI4ZTVjZWVjYmVlMTJhYzY4ZGM0NWY2YTA3NDk2YzNjYjE3MGZmODg3ZTE5OTY2MmIyMThjYmRhYzE2MjgzZDM4MDQwZGQ5NjM4NzQ3Y2FhYTE2ZTI4Mjg3MDhmZDUzNzZhZWY5ZGJkZWIyMDFhZGVlMzRjOTYwZDBjMDIwODJlZDNiZTc0ZWJiMmYyNjE0NWQ2YTUxODAyYWYyMmEwZjVmYmU5ZWFhMmU5ZTNkOTFkNjdhZmMzZTRlZDhhOWU0NmE5MzJiZDYxY2ExMTVjM2ZjMWM3YmQxZDY3ZGJkZDMwMjEwNGNjOTYxOTM3YWZkOWYyMjkxN2UzY2RiZTNmZTg1ZTFjODRiNTI3ZDlmNWE5YWEwYjZiZGU0NDY5MmYwZmQxMTg2NWM4IiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:35;}s:5:\"queue\";s:14:\"edi_scotblinds\";}"}}, Illuminate\Queue\MaxAttemptsExceededException: App\Jobs\EdiExcelJob has been attempted too many times or run too long. The job may have previously timed out. in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php:746
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#12 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#13 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#14 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#41 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#43 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#44 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#45 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#48 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#49 {main}, 2025-04-23 10:35:02)) (SQL: select `cd_id` as `colormapid`, `cd_fabricmapid` as `fabricmapid` from `bm_colordetails` inner join `bm_fabriccolourmap` on `pfm_colourmapid` = `cd_id` and `pfm_status` = 0 inner join `bm_productgroupmaterialmap` on `pgmm_fabriccolormapid` = `pfm_id` and `pgmm_status` = 0 where `cd_mtrlcategid` = 5 and `cd_status` = 0 and JSON_VALUE(cd_custmzdcolrdetails, '$.133') = Linen and JSON_VALUE(cd_custmzdcolrdetails, '$.134') = 539153 and JSON_VALUE(pfm_jsondata, '$.128') = Evita (200) and JSON_VALUE(pfm_jsondata, '$.129') = 132610 limit 1) in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#9 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first()
#10 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString()
#11 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#38 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#40 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#41 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#42 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#45 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#46 {main}  
[2025-04-23 11:41:03] production.ALERT: Import update  
[2025-04-23 11:41:03] production.ALERT: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SCOTBLINDS.bm_automationfailedqueue' doesn't exist in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:539
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(539): PDO->prepare()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3274): Illuminate\Database\Connection->insert()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Failed/DatabaseUuidFailedJobProvider.php(64): Illuminate\Database\Query\Builder->insert()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(275): Illuminate\Queue\Failed\DatabaseUuidFailedJobProvider->log()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(196): Illuminate\Queue\Console\WorkCommand->logFailedJob()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(421): Illuminate\Queue\Console\WorkCommand->Illuminate\Queue\Console\{closure}()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(249): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(195): Illuminate\Events\Dispatcher->dispatch()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(582): Illuminate\Queue\Jobs\Job->fail()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(528): Illuminate\Queue\Worker->failJob()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->markJobAsFailedIfWillExceedMaxAttempts()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#26 /var/www/html/api/app/Repositories/EDI_datas.php(464): Illuminate\Database\Eloquent\Builder->first()
#27 /var/www/html/api/app/Repositories/EDI_datas.php(422): App\Repositories\EDI_datas->GetFabricByString()
#28 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(213): App\Repositories\EDI_datas->GetFabricFieldDataByString()
#29 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#49 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#52 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#53 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#54 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#55 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#56 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#57 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#58 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#59 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#60 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#61 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#62 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#63 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#64 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SCOTBLINDS.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (333c3ce3-f6fc-4283-9e7b-8a86cebc9397, mysql, edi_scotblinds, {"uuid":"333c3ce3-f6fc-4283-9e7b-8a86cebc9397","displayName":"App\\Jobs\\EdiExcelJob","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":600,"retryUntil":null,"data":{"commandName":"App\\Jobs\\EdiExcelJob","command":"O:20:\"App\\Jobs\\EdiExcelJob\":2:{s:7:\"\u0000*\u0000data\";a:7:{s:8:\"FilePath\";s:82:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/SCOTBLINDS\/EDI_File_57_16_11_31_00.xlsx\";s:10:\"supplierid\";s:2:\"16\";s:9:\"productId\";s:2:\"57\";s:6:\"DBname\";s:10:\"SCOTBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiTjZqeVJjZkcreW4yZWZGdUo4VlZVZzdTdjdJUE45dUtiSTdvWWFxTVFrMD0iLCJpdiI6IjU4OTJjNzcxZWI1Zjk4OWVjYjgxYzhkODU2OGNiZTcxIiwic2FsdCI6ImM3NDdkZWIwMjlmZDRiZDM4Y2E1NWI1ZTZiOTIzMzFjOTcyYzhjZGI3NmFkMGI5ZmE5ZmJlNGY2NTlkNjllM2U3NGM4ZWRmMjI3YTliMGY2ZjUyMjYzZTA5MGU4NWY2MGNlODMwZjAzNmIxZGVhZjUwODUxOTEzMWQ5MDA3NTg5ZjVjY2UyZmM4NDczMDc1MjdjMjg4MzUxMDE2NDY5OTg0MmRlZjk1MDMzOWQ3Y2Y5NjlhY2Y1OTcyNGY5ZTFlYzA5YWE1NDU0ZmYyMGYwNTc2ODhhZGJlNDRhNDk5YTM1OTlkMGZlODQwYThkZTI4NDkzOGVjYjA1OWY5YTc2ZThlYmFlYmMyNGJkYzIwNTIyYTMyMmMwMWYyYWQzYzE0OTJkMGZiZmMxYTM2Zjc0NzliZWFjMDQ1YWE1ZWM4ZTQzMDkxNGM0M2MyZWNjNjAwZDMxNTU4M2U4OGVlNzNkYzUzZjYwZWY1MGZkOGQ0ZmNkOTRhOTM0MGM5MTNhMDViZjhlZWY5MWU1YThlY2Q1YWE4MWE4NzdjNTVjYzBiNjA0YzcxYzNlOTE5OTE1YTkyNGQwODhmYjQzODE0M2I4NTQ5ZDdmMDg3YzRmZTU0NWNkZmNjZDJiMjkwMGZiNjZjY2NkMDM1MTIzMjJhZGNkYTU1OGMzMjE3NWVjZGVhZGFmIiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:36;}s:5:\"queue\";s:14:\"edi_scotblinds\";}"}}, Illuminate\Queue\MaxAttemptsExceededException: App\Jobs\EdiExcelJob has been attempted too many times or run too long. The job may have previously timed out. in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php:746
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#12 /var/www/html/api/app/Repositories/EDI_datas.php(464): Illuminate\Database\Eloquent\Builder->first()
#13 /var/www/html/api/app/Repositories/EDI_datas.php(422): App\Repositories\EDI_datas->GetFabricByString()
#14 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(213): App\Repositories\EDI_datas->GetFabricFieldDataByString()
#15 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#42 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#44 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#45 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#46 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#49 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#50 {main}, 2025-04-23 11:41:03)) in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3274): Illuminate\Database\Connection->insert()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Failed/DatabaseUuidFailedJobProvider.php(64): Illuminate\Database\Query\Builder->insert()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(275): Illuminate\Queue\Failed\DatabaseUuidFailedJobProvider->log()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(196): Illuminate\Queue\Console\WorkCommand->logFailedJob()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(421): Illuminate\Queue\Console\WorkCommand->Illuminate\Queue\Console\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(249): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(195): Illuminate\Events\Dispatcher->dispatch()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(582): Illuminate\Queue\Jobs\Job->fail()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(528): Illuminate\Queue\Worker->failJob()
#12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->markJobAsFailedIfWillExceedMaxAttempts()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#24 /var/www/html/api/app/Repositories/EDI_datas.php(464): Illuminate\Database\Eloquent\Builder->first()
#25 /var/www/html/api/app/Repositories/EDI_datas.php(422): App\Repositories\EDI_datas->GetFabricByString()
#26 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(213): App\Repositories\EDI_datas->GetFabricFieldDataByString()
#27 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#49 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#52 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#53 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#54 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#55 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#56 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#57 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#58 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#59 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#60 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#61 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#62 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SCOTBLINDS.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (333c3ce3-f6fc-4283-9e7b-8a86cebc9397, mysql, edi_scotblinds, {"uuid":"333c3ce3-f6fc-4283-9e7b-8a86cebc9397","displayName":"App\\Jobs\\EdiExcelJob","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":600,"retryUntil":null,"data":{"commandName":"App\\Jobs\\EdiExcelJob","command":"O:20:\"App\\Jobs\\EdiExcelJob\":2:{s:7:\"\u0000*\u0000data\";a:7:{s:8:\"FilePath\";s:82:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/SCOTBLINDS\/EDI_File_57_16_11_31_00.xlsx\";s:10:\"supplierid\";s:2:\"16\";s:9:\"productId\";s:2:\"57\";s:6:\"DBname\";s:10:\"SCOTBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiTjZqeVJjZkcreW4yZWZGdUo4VlZVZzdTdjdJUE45dUtiSTdvWWFxTVFrMD0iLCJpdiI6IjU4OTJjNzcxZWI1Zjk4OWVjYjgxYzhkODU2OGNiZTcxIiwic2FsdCI6ImM3NDdkZWIwMjlmZDRiZDM4Y2E1NWI1ZTZiOTIzMzFjOTcyYzhjZGI3NmFkMGI5ZmE5ZmJlNGY2NTlkNjllM2U3NGM4ZWRmMjI3YTliMGY2ZjUyMjYzZTA5MGU4NWY2MGNlODMwZjAzNmIxZGVhZjUwODUxOTEzMWQ5MDA3NTg5ZjVjY2UyZmM4NDczMDc1MjdjMjg4MzUxMDE2NDY5OTg0MmRlZjk1MDMzOWQ3Y2Y5NjlhY2Y1OTcyNGY5ZTFlYzA5YWE1NDU0ZmYyMGYwNTc2ODhhZGJlNDRhNDk5YTM1OTlkMGZlODQwYThkZTI4NDkzOGVjYjA1OWY5YTc2ZThlYmFlYmMyNGJkYzIwNTIyYTMyMmMwMWYyYWQzYzE0OTJkMGZiZmMxYTM2Zjc0NzliZWFjMDQ1YWE1ZWM4ZTQzMDkxNGM0M2MyZWNjNjAwZDMxNTU4M2U4OGVlNzNkYzUzZjYwZWY1MGZkOGQ0ZmNkOTRhOTM0MGM5MTNhMDViZjhlZWY5MWU1YThlY2Q1YWE4MWE4NzdjNTVjYzBiNjA0YzcxYzNlOTE5OTE1YTkyNGQwODhmYjQzODE0M2I4NTQ5ZDdmMDg3YzRmZTU0NWNkZmNjZDJiMjkwMGZiNjZjY2NkMDM1MTIzMjJhZGNkYTU1OGMzMjE3NWVjZGVhZGFmIiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:36;}s:5:\"queue\";s:14:\"edi_scotblinds\";}"}}, Illuminate\Queue\MaxAttemptsExceededException: App\Jobs\EdiExcelJob has been attempted too many times or run too long. The job may have previously timed out. in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php:746
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#12 /var/www/html/api/app/Repositories/EDI_datas.php(464): Illuminate\Database\Eloquent\Builder->first()
#13 /var/www/html/api/app/Repositories/EDI_datas.php(422): App\Repositories\EDI_datas->GetFabricByString()
#14 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(213): App\Repositories\EDI_datas->GetFabricFieldDataByString()
#15 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#42 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#44 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#45 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#46 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#49 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#50 {main}, 2025-04-23 11:41:03)) (SQL: select `fd_id` as `FabRColorId` from `bm_fabricdetails` where `fd_mtrlcategid` = 5 and `fd_status` = 0 and JSON_VALUE(fd_custmzdfabdetails, '$.128') = Corsica (0031) and JSON_VALUE(fd_custmzdfabdetails, '$.129') = 134424 limit 1) in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run()
#2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get()
#9 /var/www/html/api/app/Repositories/EDI_datas.php(464): Illuminate\Database\Eloquent\Builder->first()
#10 /var/www/html/api/app/Repositories/EDI_datas.php(422): App\Repositories\EDI_datas->GetFabricByString()
#11 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(213): App\Repositories\EDI_datas->GetFabricFieldDataByString()
#12 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel()
#13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle()
#14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call()
#19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow()
#23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}()
#24 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#25 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then()
#26 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware()
#27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call()
#28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire()
#29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob()
#31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
#32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
#33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
#34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call()
#38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#39 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute()
#40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run()
#41 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run()
#42 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#43 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run()
#45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run()
#46 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
#47 {main}