[2025-05-16 11:39:14] production.ALERT: Import update  
[2025-05-16 11:39:14] production.ALERT: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SUNRITEBLINDS.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 'SUNRITEBLINDS.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (d44972d8-b73a-42b3-b69b-ef8800fd3303, mysql, edi_sunriteblinds, {"uuid":"d44972d8-b73a-42b3-b69b-ef8800fd3303","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:84:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/SUNRITEBLINDS\/EDI_File_81_9_11_29_14.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"81\";s:6:\"DBname\";s:13:\"SUNRITEBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:856:\"eyJjaXBoZXJ0ZXh0IjoiczdpUXhsXC9EUWVsWmlOaGhhMmZKVUhuUysxOTRBWjJ3N3dQS0JFXC80TlNjPSIsIml2IjoiYmIxZTAzYzNjNmQ1NGNhYmM4NjQ4YmEzMDEzNTBiNjMiLCJzYWx0IjoiNTQ0YTdlN2ZlOGY4OTdmZTk5YTEzNDJjZjc2N2M0NTc3MTc1NjQ1ODEyOTYwNjc1MDMyMzhkOWM3ZDI5OGE3Nzg5MTU4OWRiZjI5ZTZmODM4NWVkYmIxOTU3OWNhN2ZiM2UyNDg1Y2E5ZTZjNWUyZDg4OWVhYjMyMTAxNDExNDE3MjJjNDE0Y2ZmMjE2ZjhmNzM2NGRlNzE2MjY1ZDQzNGI4N2E2ODFkMWQ3ZjMyZTkwMGIyZWQyNDFjZDA4YjkzMGU1NTcxNTdiZmRkMTk2NzFkMTllYzhmNzFjY2FlMzViZGM5MGU4YmRiMGJkNjhhZTM3ODk4ZjQyMGE3NWU4MTgwMWZmMjFmOWM3NmNhZmUxNGNmZmQ1M2Q4ZmJlYTY2MmRlMTQ5NmU2ODBlNGM2MmUzNTgwNzBmM2FhNTc5NWRhN2Y4ZWIxMGE1ZjQ1NjAyMTFlNTBhZDU2NzEyNmQ0MGI1MjU2MTQxMTBjZDI5MzdlNzE5NDYzZTA3NzcwMzBhNWE0NzRhMTNhMTI3OTU1Mjg1OTkwOTg1ODIwYTkxNzU2MDA5MzU2Njg0NjBiZTFlYjNiZjcyYWQ5YjA2YjY5ZWI2ZTg2MDU0NDY4ZGYwYzE0NjM1OTA0YjdiYzNlNjM5MzJhZWI2M2Q5NzYyYTE0YWU1YmNiN2ZkMjMzMTZiZWYiLCJpdGVyYXRpb25zIjo5fQ==\";s:6:\"edi_id\";i:9;}s:5:\"queue\";s:17:\"edi_sunriteblinds\";}"}}, 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-05-16 11:39:14)) 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 'SUNRITEBLINDS.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (d44972d8-b73a-42b3-b69b-ef8800fd3303, mysql, edi_sunriteblinds, {"uuid":"d44972d8-b73a-42b3-b69b-ef8800fd3303","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:84:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/SUNRITEBLINDS\/EDI_File_81_9_11_29_14.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"81\";s:6:\"DBname\";s:13:\"SUNRITEBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:856:\"eyJjaXBoZXJ0ZXh0IjoiczdpUXhsXC9EUWVsWmlOaGhhMmZKVUhuUysxOTRBWjJ3N3dQS0JFXC80TlNjPSIsIml2IjoiYmIxZTAzYzNjNmQ1NGNhYmM4NjQ4YmEzMDEzNTBiNjMiLCJzYWx0IjoiNTQ0YTdlN2ZlOGY4OTdmZTk5YTEzNDJjZjc2N2M0NTc3MTc1NjQ1ODEyOTYwNjc1MDMyMzhkOWM3ZDI5OGE3Nzg5MTU4OWRiZjI5ZTZmODM4NWVkYmIxOTU3OWNhN2ZiM2UyNDg1Y2E5ZTZjNWUyZDg4OWVhYjMyMTAxNDExNDE3MjJjNDE0Y2ZmMjE2ZjhmNzM2NGRlNzE2MjY1ZDQzNGI4N2E2ODFkMWQ3ZjMyZTkwMGIyZWQyNDFjZDA4YjkzMGU1NTcxNTdiZmRkMTk2NzFkMTllYzhmNzFjY2FlMzViZGM5MGU4YmRiMGJkNjhhZTM3ODk4ZjQyMGE3NWU4MTgwMWZmMjFmOWM3NmNhZmUxNGNmZmQ1M2Q4ZmJlYTY2MmRlMTQ5NmU2ODBlNGM2MmUzNTgwNzBmM2FhNTc5NWRhN2Y4ZWIxMGE1ZjQ1NjAyMTFlNTBhZDU2NzEyNmQ0MGI1MjU2MTQxMTBjZDI5MzdlNzE5NDYzZTA3NzcwMzBhNWE0NzRhMTNhMTI3OTU1Mjg1OTkwOTg1ODIwYTkxNzU2MDA5MzU2Njg0NjBiZTFlYjNiZjcyYWQ5YjA2YjY5ZWI2ZTg2MDU0NDY4ZGYwYzE0NjM1OTA0YjdiYzNlNjM5MzJhZWI2M2Q5NzYyYTE0YWU1YmNiN2ZkMjMzMTZiZWYiLCJpdGVyYXRpb25zIjo5fQ==\";s:6:\"edi_id\";i:9;}s:5:\"queue\";s:17:\"edi_sunriteblinds\";}"}}, 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-05-16 11:39:14)) (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') = Grey and JSON_VALUE(cd_custmzdcolrdetails, '$.134') = 391958 and JSON_VALUE(pfm_jsondata, '$.128') = Caspian FR and JSON_VALUE(pfm_jsondata, '$.129') = 99112 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-05-16 11:49:15] production.ALERT: Import update  
[2025-05-16 11:49:15] production.ALERT: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'RAINBOW.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 'RAINBOW.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (4696fdd5-8a8f-4837-bc3a-5af3aaa5d3f2, mysql, edi_rainbow, {"uuid":"4696fdd5-8a8f-4837-bc3a-5af3aaa5d3f2","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:78:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/RAINBOW\/EDI_File_57_9_11_29_27.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"57\";s:6:\"DBname\";s:7:\"RAINBOW\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0Ijoib0tZaW5lNFhvSW1wb1BFSnJoNEF4dDBVUFE2QnFwMGFYK1BxWHZkS2xsYz0iLCJpdiI6Ijg1MDVmN2Y3ZTk2ZjY0OGVjODczNTBiZGM2YjU0M2QxIiwic2FsdCI6IjJlMjdmMjczNzBmYmE0Njg5MmMyYzRiNDc4ZjI3NDliOThmMDI2MmY5OTY2NDkwMTM2MGJhN2E4NzZmYjM0MGQ4MmU1MDkwYWNlOWM2ZjQ0OWYzYjc2MTNmMzZjNTUwOTc0NmNiZTMzNzk3MTIzZWJlMTBjMmMyNzZiMjA0ZjFiNTliNzZiOTcyOWJiNGY2Y2RhMWIzMmIyMzNiZWM1ODE5M2M3OGU3OWNhOWZmMzQxNTA5ZGVkOTVjNjRjOTVhZjYyN2M5NjdkOWMyYTRjZDlhOGFmZDM5MmYxMzU4ZmQzNDFkYzM2MmFiOGI2MDIyYmRmNmVhMDdmZWNjMjIzYzE5YmI5Y2I3YzRlMWE1ZDg0MzU0MTc2ZjJlMTllYzEzOWVjY2NiNDA2NWE4NmU4MGZmYTE3ZGY1YjU1Y2NiYjNkMjUzNWIwN2ViYTg4NTc4ODdkMzkwMDdhMmFiZTg2NWQ3ZmYxMDNkY2M5ODAzZmY2ZTg5YTE3MzE4ZjIwMDZlMDMxOGM2Y2ExZmIzNzZlZDY4MjI0YjAxZTJiOWRkN2EwZDBlNTA2YTNmNTBiYTM0YjgwMWI1ZGU2Y2UyOTE4NDM5NmEzNzNjZjNmYjZjYmVlMDIyN2MxNWQ0M2I0MDQ2MDNkYzQwMjUzYTc0ZDAxMDgxMTM2ODE1MGE0NzhhMzMwIiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:67;}s:5:\"queue\";s:11:\"edi_rainbow\";}"}}, 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-05-16 11:49:15)) 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 'RAINBOW.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (4696fdd5-8a8f-4837-bc3a-5af3aaa5d3f2, mysql, edi_rainbow, {"uuid":"4696fdd5-8a8f-4837-bc3a-5af3aaa5d3f2","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:78:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/RAINBOW\/EDI_File_57_9_11_29_27.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"57\";s:6:\"DBname\";s:7:\"RAINBOW\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0Ijoib0tZaW5lNFhvSW1wb1BFSnJoNEF4dDBVUFE2QnFwMGFYK1BxWHZkS2xsYz0iLCJpdiI6Ijg1MDVmN2Y3ZTk2ZjY0OGVjODczNTBiZGM2YjU0M2QxIiwic2FsdCI6IjJlMjdmMjczNzBmYmE0Njg5MmMyYzRiNDc4ZjI3NDliOThmMDI2MmY5OTY2NDkwMTM2MGJhN2E4NzZmYjM0MGQ4MmU1MDkwYWNlOWM2ZjQ0OWYzYjc2MTNmMzZjNTUwOTc0NmNiZTMzNzk3MTIzZWJlMTBjMmMyNzZiMjA0ZjFiNTliNzZiOTcyOWJiNGY2Y2RhMWIzMmIyMzNiZWM1ODE5M2M3OGU3OWNhOWZmMzQxNTA5ZGVkOTVjNjRjOTVhZjYyN2M5NjdkOWMyYTRjZDlhOGFmZDM5MmYxMzU4ZmQzNDFkYzM2MmFiOGI2MDIyYmRmNmVhMDdmZWNjMjIzYzE5YmI5Y2I3YzRlMWE1ZDg0MzU0MTc2ZjJlMTllYzEzOWVjY2NiNDA2NWE4NmU4MGZmYTE3ZGY1YjU1Y2NiYjNkMjUzNWIwN2ViYTg4NTc4ODdkMzkwMDdhMmFiZTg2NWQ3ZmYxMDNkY2M5ODAzZmY2ZTg5YTE3MzE4ZjIwMDZlMDMxOGM2Y2ExZmIzNzZlZDY4MjI0YjAxZTJiOWRkN2EwZDBlNTA2YTNmNTBiYTM0YjgwMWI1ZGU2Y2UyOTE4NDM5NmEzNzNjZjNmYjZjYmVlMDIyN2MxNWQ0M2I0MDQ2MDNkYzQwMjUzYTc0ZDAxMDgxMTM2ODE1MGE0NzhhMzMwIiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:67;}s:5:\"queue\";s:11:\"edi_rainbow\";}"}}, 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-05-16 11:49:15)) (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') = Redcurrant and JSON_VALUE(cd_custmzdcolrdetails, '$.134') = 548540 and JSON_VALUE(pfm_jsondata, '$.128') = Banlight Duo FR B/O (0009) and JSON_VALUE(pfm_jsondata, '$.129') = 134706 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-05-16 12:52:57] production.ALERT: Import update  
[2025-05-16 12:52:57] production.ALERT: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SUNRITEBLINDS.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 'SUNRITEBLINDS.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (29ed31e3-ba1f-47e8-aa74-a1d7b36b9b76, mysql, edi_sunriteblinds, {"uuid":"29ed31e3-ba1f-47e8-aa74-a1d7b36b9b76","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:84:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/SUNRITEBLINDS\/EDI_File_91_9_12_42_53.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"91\";s:6:\"DBname\";s:13:\"SUNRITEBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:856:\"eyJjaXBoZXJ0ZXh0IjoiczdpUXhsXC9EUWVsWmlOaGhhMmZKVUhuUysxOTRBWjJ3N3dQS0JFXC80TlNjPSIsIml2IjoiYmIxZTAzYzNjNmQ1NGNhYmM4NjQ4YmEzMDEzNTBiNjMiLCJzYWx0IjoiNTQ0YTdlN2ZlOGY4OTdmZTk5YTEzNDJjZjc2N2M0NTc3MTc1NjQ1ODEyOTYwNjc1MDMyMzhkOWM3ZDI5OGE3Nzg5MTU4OWRiZjI5ZTZmODM4NWVkYmIxOTU3OWNhN2ZiM2UyNDg1Y2E5ZTZjNWUyZDg4OWVhYjMyMTAxNDExNDE3MjJjNDE0Y2ZmMjE2ZjhmNzM2NGRlNzE2MjY1ZDQzNGI4N2E2ODFkMWQ3ZjMyZTkwMGIyZWQyNDFjZDA4YjkzMGU1NTcxNTdiZmRkMTk2NzFkMTllYzhmNzFjY2FlMzViZGM5MGU4YmRiMGJkNjhhZTM3ODk4ZjQyMGE3NWU4MTgwMWZmMjFmOWM3NmNhZmUxNGNmZmQ1M2Q4ZmJlYTY2MmRlMTQ5NmU2ODBlNGM2MmUzNTgwNzBmM2FhNTc5NWRhN2Y4ZWIxMGE1ZjQ1NjAyMTFlNTBhZDU2NzEyNmQ0MGI1MjU2MTQxMTBjZDI5MzdlNzE5NDYzZTA3NzcwMzBhNWE0NzRhMTNhMTI3OTU1Mjg1OTkwOTg1ODIwYTkxNzU2MDA5MzU2Njg0NjBiZTFlYjNiZjcyYWQ5YjA2YjY5ZWI2ZTg2MDU0NDY4ZGYwYzE0NjM1OTA0YjdiYzNlNjM5MzJhZWI2M2Q5NzYyYTE0YWU1YmNiN2ZkMjMzMTZiZWYiLCJpdGVyYXRpb25zIjo5fQ==\";s:6:\"edi_id\";i:11;}s:5:\"queue\";s:17:\"edi_sunriteblinds\";}"}}, 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-05-16 12:52:57)) 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 'SUNRITEBLINDS.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (29ed31e3-ba1f-47e8-aa74-a1d7b36b9b76, mysql, edi_sunriteblinds, {"uuid":"29ed31e3-ba1f-47e8-aa74-a1d7b36b9b76","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:84:\"\/var\/www\/html\/api\/public\/storage\/EDI_Files\/SUNRITEBLINDS\/EDI_File_91_9_12_42_53.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"91\";s:6:\"DBname\";s:13:\"SUNRITEBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:856:\"eyJjaXBoZXJ0ZXh0IjoiczdpUXhsXC9EUWVsWmlOaGhhMmZKVUhuUysxOTRBWjJ3N3dQS0JFXC80TlNjPSIsIml2IjoiYmIxZTAzYzNjNmQ1NGNhYmM4NjQ4YmEzMDEzNTBiNjMiLCJzYWx0IjoiNTQ0YTdlN2ZlOGY4OTdmZTk5YTEzNDJjZjc2N2M0NTc3MTc1NjQ1ODEyOTYwNjc1MDMyMzhkOWM3ZDI5OGE3Nzg5MTU4OWRiZjI5ZTZmODM4NWVkYmIxOTU3OWNhN2ZiM2UyNDg1Y2E5ZTZjNWUyZDg4OWVhYjMyMTAxNDExNDE3MjJjNDE0Y2ZmMjE2ZjhmNzM2NGRlNzE2MjY1ZDQzNGI4N2E2ODFkMWQ3ZjMyZTkwMGIyZWQyNDFjZDA4YjkzMGU1NTcxNTdiZmRkMTk2NzFkMTllYzhmNzFjY2FlMzViZGM5MGU4YmRiMGJkNjhhZTM3ODk4ZjQyMGE3NWU4MTgwMWZmMjFmOWM3NmNhZmUxNGNmZmQ1M2Q4ZmJlYTY2MmRlMTQ5NmU2ODBlNGM2MmUzNTgwNzBmM2FhNTc5NWRhN2Y4ZWIxMGE1ZjQ1NjAyMTFlNTBhZDU2NzEyNmQ0MGI1MjU2MTQxMTBjZDI5MzdlNzE5NDYzZTA3NzcwMzBhNWE0NzRhMTNhMTI3OTU1Mjg1OTkwOTg1ODIwYTkxNzU2MDA5MzU2Njg0NjBiZTFlYjNiZjcyYWQ5YjA2YjY5ZWI2ZTg2MDU0NDY4ZGYwYzE0NjM1OTA0YjdiYzNlNjM5MzJhZWI2M2Q5NzYyYTE0YWU1YmNiN2ZkMjMzMTZiZWYiLCJpdGVyYXRpb25zIjo5fQ==\";s:6:\"edi_id\";i:11;}s:5:\"queue\";s:17:\"edi_sunriteblinds\";}"}}, 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-05-16 12:52:57)) (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') = Shell Gold and JSON_VALUE(cd_custmzdcolrdetails, '$.134') = 400915 and JSON_VALUE(pfm_jsondata, '$.128') = Patina and JSON_VALUE(pfm_jsondata, '$.129') = 101058 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}