[2025-05-14 11:23:09] production.ALERT: Import update  
[2025-05-14 11:23:09] 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 (cd92884e-3665-4306-89b2-ed3d221fcbba, mysql, edi_sunriteblinds, {"uuid":"cd92884e-3665-4306-89b2-ed3d221fcbba","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_51_9_11_13_08.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"51\";s:6:\"DBname\";s:13:\"SUNRITEBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiXC85OCtvRWRpeHErSWxvcUJRTTA0YlkwOTFXTk9KRitFN3RtYjFXTDhrRGc9IiwiaXYiOiI4YWU0YzA4Y2M2NTkwYTc5NTc0N2UwYTQyYWU1ZmU1ZiIsInNhbHQiOiI2YTBmMGUwZTZlOTc3OTI2MDM5MTAxMjNkMTQ2OWEzMmU0ZDBhMjQwNzYzOWM1NDQwY2NhMWI2MGY5YzEwMjdjZGY1YTNjMzFjM2MxOWQ0YjZiOTJhOTI2ZTc2ODk4OGFmYWU1Y2ZkMDAyNjcwODY1ODM3MjUyMWMxODUyYTRlMjJhMmQwYTg2MGVmNjJkNWEwYzU1NTk0OGVjNTE2ZWVhZmNiMzVmODA1ZmEwMzZhODcwNTc4MTExZDE0YmI2ZTQzMjc4OGM2ZDVlMWI2NWUzNDMzNTU3MWRiODg1OTk0MjQxYzExYWQyNTYxZTdjZWVmZmQ4OGYyMjZhM2QxZDIzZTEwNGNmYzlhNjFiZmZlMTQ0MzI3NTg1Y2JjMjYyM2NhYzRjMTM5ZTI2N2FkZTE2NmU0YWVjYzkxOTg0YWI1MWViZTI0ZWExM2I3NTFjNWNjMDEwZTFkN2MzNTJkNGI4ZGNhNGY3MTA0ZjNjMThjYzdhYzQxZmRlN2E3OGZlMGVmOGFjMjViNTVhZDljY2VjOTRlOWNkMmYwZDQ3MDNhNTc2NWQ1OTA5YWE1MTUyYjQzZjk5MTY1NzY2MjcxYTQ0ZDlkMDQ4M2I4YWM1N2RhYWI3OTViZmJjZTRhNjc2OTZhOGYxZjcyODNiYmQxMWZjNmQ2ZTg3OTFkMzA0MjM0OSIsIml0ZXJhdGlvbnMiOjl9\";s:6:\"edi_id\";i:1;}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-14 11:23:09)) 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 (cd92884e-3665-4306-89b2-ed3d221fcbba, mysql, edi_sunriteblinds, {"uuid":"cd92884e-3665-4306-89b2-ed3d221fcbba","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_51_9_11_13_08.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"51\";s:6:\"DBname\";s:13:\"SUNRITEBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiXC85OCtvRWRpeHErSWxvcUJRTTA0YlkwOTFXTk9KRitFN3RtYjFXTDhrRGc9IiwiaXYiOiI4YWU0YzA4Y2M2NTkwYTc5NTc0N2UwYTQyYWU1ZmU1ZiIsInNhbHQiOiI2YTBmMGUwZTZlOTc3OTI2MDM5MTAxMjNkMTQ2OWEzMmU0ZDBhMjQwNzYzOWM1NDQwY2NhMWI2MGY5YzEwMjdjZGY1YTNjMzFjM2MxOWQ0YjZiOTJhOTI2ZTc2ODk4OGFmYWU1Y2ZkMDAyNjcwODY1ODM3MjUyMWMxODUyYTRlMjJhMmQwYTg2MGVmNjJkNWEwYzU1NTk0OGVjNTE2ZWVhZmNiMzVmODA1ZmEwMzZhODcwNTc4MTExZDE0YmI2ZTQzMjc4OGM2ZDVlMWI2NWUzNDMzNTU3MWRiODg1OTk0MjQxYzExYWQyNTYxZTdjZWVmZmQ4OGYyMjZhM2QxZDIzZTEwNGNmYzlhNjFiZmZlMTQ0MzI3NTg1Y2JjMjYyM2NhYzRjMTM5ZTI2N2FkZTE2NmU0YWVjYzkxOTg0YWI1MWViZTI0ZWExM2I3NTFjNWNjMDEwZTFkN2MzNTJkNGI4ZGNhNGY3MTA0ZjNjMThjYzdhYzQxZmRlN2E3OGZlMGVmOGFjMjViNTVhZDljY2VjOTRlOWNkMmYwZDQ3MDNhNTc2NWQ1OTA5YWE1MTUyYjQzZjk5MTY1NzY2MjcxYTQ0ZDlkMDQ4M2I4YWM1N2RhYWI3OTViZmJjZTRhNjc2OTZhOGYxZjcyODNiYmQxMWZjNmQ2ZTg3OTFkMzA0MjM0OSIsIml0ZXJhdGlvbnMiOjl9\";s:6:\"edi_id\";i:1;}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-14 11:23:09)) (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') = Dark Silver and JSON_VALUE(cd_custmzdcolrdetails, '$.134') = 400751 and JSON_VALUE(pfm_jsondata, '$.128') = Patina and JSON_VALUE(pfm_jsondata, '$.129') = 101036 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-14 11:33:13] production.ALERT: Import update  
[2025-05-14 11:33:13] 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 (e2a8af4f-584f-4ac7-a0a8-1306eb79b77f, mysql, edi_sunriteblinds, {"uuid":"e2a8af4f-584f-4ac7-a0a8-1306eb79b77f","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_51_9_11_20_10.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"51\";s:6:\"DBname\";s:13:\"SUNRITEBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiXC85OCtvRWRpeHErSWxvcUJRTTA0YlkwOTFXTk9KRitFN3RtYjFXTDhrRGc9IiwiaXYiOiI4YWU0YzA4Y2M2NTkwYTc5NTc0N2UwYTQyYWU1ZmU1ZiIsInNhbHQiOiI2YTBmMGUwZTZlOTc3OTI2MDM5MTAxMjNkMTQ2OWEzMmU0ZDBhMjQwNzYzOWM1NDQwY2NhMWI2MGY5YzEwMjdjZGY1YTNjMzFjM2MxOWQ0YjZiOTJhOTI2ZTc2ODk4OGFmYWU1Y2ZkMDAyNjcwODY1ODM3MjUyMWMxODUyYTRlMjJhMmQwYTg2MGVmNjJkNWEwYzU1NTk0OGVjNTE2ZWVhZmNiMzVmODA1ZmEwMzZhODcwNTc4MTExZDE0YmI2ZTQzMjc4OGM2ZDVlMWI2NWUzNDMzNTU3MWRiODg1OTk0MjQxYzExYWQyNTYxZTdjZWVmZmQ4OGYyMjZhM2QxZDIzZTEwNGNmYzlhNjFiZmZlMTQ0MzI3NTg1Y2JjMjYyM2NhYzRjMTM5ZTI2N2FkZTE2NmU0YWVjYzkxOTg0YWI1MWViZTI0ZWExM2I3NTFjNWNjMDEwZTFkN2MzNTJkNGI4ZGNhNGY3MTA0ZjNjMThjYzdhYzQxZmRlN2E3OGZlMGVmOGFjMjViNTVhZDljY2VjOTRlOWNkMmYwZDQ3MDNhNTc2NWQ1OTA5YWE1MTUyYjQzZjk5MTY1NzY2MjcxYTQ0ZDlkMDQ4M2I4YWM1N2RhYWI3OTViZmJjZTRhNjc2OTZhOGYxZjcyODNiYmQxMWZjNmQ2ZTg3OTFkMzA0MjM0OSIsIml0ZXJhdGlvbnMiOjl9\";s:6:\"edi_id\";i:2;}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-14 11:33:13)) 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 (e2a8af4f-584f-4ac7-a0a8-1306eb79b77f, mysql, edi_sunriteblinds, {"uuid":"e2a8af4f-584f-4ac7-a0a8-1306eb79b77f","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_51_9_11_20_10.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"51\";s:6:\"DBname\";s:13:\"SUNRITEBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0IjoiXC85OCtvRWRpeHErSWxvcUJRTTA0YlkwOTFXTk9KRitFN3RtYjFXTDhrRGc9IiwiaXYiOiI4YWU0YzA4Y2M2NTkwYTc5NTc0N2UwYTQyYWU1ZmU1ZiIsInNhbHQiOiI2YTBmMGUwZTZlOTc3OTI2MDM5MTAxMjNkMTQ2OWEzMmU0ZDBhMjQwNzYzOWM1NDQwY2NhMWI2MGY5YzEwMjdjZGY1YTNjMzFjM2MxOWQ0YjZiOTJhOTI2ZTc2ODk4OGFmYWU1Y2ZkMDAyNjcwODY1ODM3MjUyMWMxODUyYTRlMjJhMmQwYTg2MGVmNjJkNWEwYzU1NTk0OGVjNTE2ZWVhZmNiMzVmODA1ZmEwMzZhODcwNTc4MTExZDE0YmI2ZTQzMjc4OGM2ZDVlMWI2NWUzNDMzNTU3MWRiODg1OTk0MjQxYzExYWQyNTYxZTdjZWVmZmQ4OGYyMjZhM2QxZDIzZTEwNGNmYzlhNjFiZmZlMTQ0MzI3NTg1Y2JjMjYyM2NhYzRjMTM5ZTI2N2FkZTE2NmU0YWVjYzkxOTg0YWI1MWViZTI0ZWExM2I3NTFjNWNjMDEwZTFkN2MzNTJkNGI4ZGNhNGY3MTA0ZjNjMThjYzdhYzQxZmRlN2E3OGZlMGVmOGFjMjViNTVhZDljY2VjOTRlOWNkMmYwZDQ3MDNhNTc2NWQ1OTA5YWE1MTUyYjQzZjk5MTY1NzY2MjcxYTQ0ZDlkMDQ4M2I4YWM1N2RhYWI3OTViZmJjZTRhNjc2OTZhOGYxZjcyODNiYmQxMWZjNmQ2ZTg3OTFkMzA0MjM0OSIsIml0ZXJhdGlvbnMiOjl9\";s:6:\"edi_id\";i:2;}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-14 11:33:13)) (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') = Dark Silver and JSON_VALUE(cd_custmzdcolrdetails, '$.134') = 400751 and JSON_VALUE(pfm_jsondata, '$.128') = Patina and JSON_VALUE(pfm_jsondata, '$.129') = 101036 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-14 13:12:50] production.ALERT: Import update  
[2025-05-14 13:12:50] 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 (0fc919d1-c308-4a45-83fc-f11c84cf2c60, mysql, edi_sunriteblinds, {"uuid":"0fc919d1-c308-4a45-83fc-f11c84cf2c60","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_50_9_01_02_47.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"50\";s:6:\"DBname\";s:13:\"SUNRITEBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0Ijoia2xuZEI2cmtpZHdpa0sxM0lnVEJWT3pXdUgyYUU4djFJQlNqc1hxZ0c4cz0iLCJpdiI6IjU2NzlmMzcwYjc0NzljZDE5ODc0OGFhYmJlZTIxNWZhIiwic2FsdCI6IjdlMTg1MzI2MmU5ZmU2NDliMzVlNDViYTI3YzIwMDgwZGM5NDMyZDU3ZTA4NzM1YjhjMjMxYzI3YmU3OTUyODBkYWZkZDQ3MTIyYjY0ZGE2ODcwNDZjOWRlMjY0OGJkM2E5OWIxMzkxZjhlY2YyOWI0NmU2MWM5MWJjYzkyMTNlODAzOWI2YTE4MzI2M2E3Y2NkODczNWM4ZjU5ODBmOGFiMmUwMThmOGUzNmU5NjQyNTk3ZmM4MWEzNWUxNjcwZThkNmZlNmZiNTYyM2RiYmQwYWExMGNhOGUzNmM2YWZkYjE0NDMxN2U1ZDg0ZDAyYjdlM2MwZTIxMGY5ZmRjY2U1NDU4OGYxODFkM2I1ZjI3MWE5YWMzNGVmMGRjOWU3OTYyZjliYTY4OTYzZDJiODI1MzY1YTg0YjA5NTBkMDJkNjIzODE5YmIwZWM2OTI3M2I2ZjRlZGQyYmQ1MDZhODJhYWJjOWM5YWJjOGUyOTc5MzM0ZDdjZjY4NThkOWJlOWJkNDU5NGIwYWM4MzNhMzg1MTQzZmZmN2YwMDNiZjhmM2ExM2I1NmQ1ZGIzNGQwNDAwZTJmMjdjODM1Yzk2M2VmMTUwYzIwNWM2YTI1YTAzNTA4NTY0ZDg0ODVkZTA4ODg3MmFmZTdlYzhmMDllMWJkNDA0MjQ5ZTYzMDlmNTY0IiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:3;}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-14 13:12:50)) 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 (0fc919d1-c308-4a45-83fc-f11c84cf2c60, mysql, edi_sunriteblinds, {"uuid":"0fc919d1-c308-4a45-83fc-f11c84cf2c60","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_50_9_01_02_47.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"50\";s:6:\"DBname\";s:13:\"SUNRITEBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0Ijoia2xuZEI2cmtpZHdpa0sxM0lnVEJWT3pXdUgyYUU4djFJQlNqc1hxZ0c4cz0iLCJpdiI6IjU2NzlmMzcwYjc0NzljZDE5ODc0OGFhYmJlZTIxNWZhIiwic2FsdCI6IjdlMTg1MzI2MmU5ZmU2NDliMzVlNDViYTI3YzIwMDgwZGM5NDMyZDU3ZTA4NzM1YjhjMjMxYzI3YmU3OTUyODBkYWZkZDQ3MTIyYjY0ZGE2ODcwNDZjOWRlMjY0OGJkM2E5OWIxMzkxZjhlY2YyOWI0NmU2MWM5MWJjYzkyMTNlODAzOWI2YTE4MzI2M2E3Y2NkODczNWM4ZjU5ODBmOGFiMmUwMThmOGUzNmU5NjQyNTk3ZmM4MWEzNWUxNjcwZThkNmZlNmZiNTYyM2RiYmQwYWExMGNhOGUzNmM2YWZkYjE0NDMxN2U1ZDg0ZDAyYjdlM2MwZTIxMGY5ZmRjY2U1NDU4OGYxODFkM2I1ZjI3MWE5YWMzNGVmMGRjOWU3OTYyZjliYTY4OTYzZDJiODI1MzY1YTg0YjA5NTBkMDJkNjIzODE5YmIwZWM2OTI3M2I2ZjRlZGQyYmQ1MDZhODJhYWJjOWM5YWJjOGUyOTc5MzM0ZDdjZjY4NThkOWJlOWJkNDU5NGIwYWM4MzNhMzg1MTQzZmZmN2YwMDNiZjhmM2ExM2I1NmQ1ZGIzNGQwNDAwZTJmMjdjODM1Yzk2M2VmMTUwYzIwNWM2YTI1YTAzNTA4NTY0ZDg0ODVkZTA4ODg3MmFmZTdlYzhmMDllMWJkNDA0MjQ5ZTYzMDlmNTY0IiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:3;}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-14 13:12:50)) (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') = Nero and JSON_VALUE(cd_custmzdcolrdetails, '$.134') = 354677 and JSON_VALUE(pfm_jsondata, '$.128') = Dewdrop (220) and JSON_VALUE(pfm_jsondata, '$.129') = 91856 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}