[2025-05-22 07:51:37] production.ALERT: Import update [2025-05-22 07:51:37] 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 (d5ef9cdf-ef45-4ba3-8397-260945a060dc, mysql, edi_sunriteblinds, {"uuid":"d5ef9cdf-ef45-4ba3-8397-260945a060dc","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_56_9_07_41_33.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"56\";s:6:\"DBname\";s:13:\"SUNRITEBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0Ijoia1IwVUpXcEZIbzN1SFZjUkVEdmVjWmtTdTVLUkVkQjdma1FmOXFmZG5ZWT0iLCJpdiI6IjNkNThmM2E5M2M4ZDhmNTMzMmJmODVhNDAxZWMwMGJhIiwic2FsdCI6ImMyMTM1MTZjOTBhYjYxZDRlMjNjMzg4NDhhYjc4OGUwYjQ1MmE3M2Y5YjNhMDEzYjgyMTJmZWQwZjE0ZjY4NGVjZjZlMzkyNjU2MmY2ZjRkYzJiYWY2NjBlYzhkMDAzN2NjOTk5N2Q2YTYyOTYzNzI2YzhmYWE2ODEwOGZjNzYzZDUzYTAzMWQyMmIxMjVjYzA2NjI2MWIzOTkyNDFkOWIxNTMxNjRjZWFkMWExMTAyMTgwN2U4ZWQ5NjcxYTIwMjI2NTg4YmRmMjNkN2NhOWVmOTlmZjhlNzMxOTcxYTZiMDZmZGFjZWJmOTcxM2Y2MzU3MzVjZTc1MTNjOTZhNDVlMmVhODlmNDA1N2JjMzcxZDkzY2VlZDBmYTZkMDkyODFjYTE5ZTQ5NWNhMWM2MWViNGJkY2ZlYjk3N2U4ZmNlNzEwZDUyYTc1NDU5OWY3M2U4MWRmZmZlZGNhNmM3YzI3MTg3M2ZhMjJlNWJmMTViNmEyNGE2OTlmZWU3NGUwNmMzNjlhYzk0Njg1NTAwMWNjYmVhNGI3YmZlNjViNDhhNzY2YTNjMzBhZjhjYWRmMDIxNWM3MzM2MDg5MmMxMjUwNjRhMzIwMTA4ODRkOGQ1YzhmYmQxNzc4Nzk1MmRjNDk0NTdlYmRkNTE0YTk2MDVhMWI5YWI5ODIyODI2NDEzIiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:21;}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-22 07:51:36)) in /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760 Stack trace: #0 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run() #2 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement() #3 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3274): Illuminate\Database\Connection->insert() #4 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Failed/DatabaseUuidFailedJobProvider.php(64): Illuminate\Database\Query\Builder->insert() #5 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(275): Illuminate\Queue\Failed\DatabaseUuidFailedJobProvider->log() #6 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(196): Illuminate\Queue\Console\WorkCommand->logFailedJob() #7 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(421): Illuminate\Queue\Console\WorkCommand->Illuminate\Queue\Console\{closure}() #8 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(249): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}() #9 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(195): Illuminate\Events\Dispatcher->dispatch() #10 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(582): Illuminate\Queue\Jobs\Job->fail() #11 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(528): Illuminate\Queue\Worker->failJob() #12 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(214): Illuminate\Queue\Worker->markJobAsFailedIfWillExceedMaxAttempts() #13 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421): Illuminate\Queue\Worker->Illuminate\Queue\{closure}() #14 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}() #15 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #16 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run() #17 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select() #18 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect() #19 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #20 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns() #21 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get() #22 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels() #23 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get() #24 /var/www/html/api/app/Repositories/EDI_datas.php(523): Illuminate\Database\Eloquent\Builder->first() #25 /var/www/html/api/app/Http/Controllers/EdiExcelController.php(217): App\Repositories\EDI_datas->GetColorByString() #26 /var/www/html/api/app/Jobs/EdiExcelJob.php(114): App\Http\Controllers\EdiExcelController->ImportExcel() #27 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Jobs\EdiExcelJob->handle() #28 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #29 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #30 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #31 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call() #32 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\Container\Container->call() #33 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}() #34 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #35 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then() #36 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\Bus\Dispatcher->dispatchNow() #37 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Queue\CallQueuedHandler->Illuminate\Queue\{closure}() #38 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #39 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\Pipeline\Pipeline->then() #40 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\Queue\CallQueuedHandler->dispatchThroughMiddleware() #41 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\Queue\CallQueuedHandler->call() #42 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\Queue\Jobs\Job->fire() #43 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process() #44 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\Queue\Worker->runJob() #45 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon() #46 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker() #47 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle() #48 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #49 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #50 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #51 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\Container\BoundMethod::call() #52 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call() #53 /var/www/html/api/vendor/symfony/console/Command/Command.php(291): Illuminate\Console\Command->execute() #54 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\Component\Console\Command\Command->run() #55 /var/www/html/api/vendor/symfony/console/Application.php(1014): Illuminate\Console\Command->run() #56 /var/www/html/api/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand() #57 /var/www/html/api/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun() #58 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run() #59 /var/www/html/api/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\Console\Application->run() #60 /var/www/html/api/artisan(37): Illuminate\Foundation\Console\Kernel->handle() #61 {main} Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'SUNRITEBLINDS.bm_automationfailedqueue' doesn't exist (SQL: insert into `bm_automationfailedqueue` (`uuid`, `connection`, `queue`, `payload`, `exception`, `failed_at`) values (d5ef9cdf-ef45-4ba3-8397-260945a060dc, mysql, edi_sunriteblinds, {"uuid":"d5ef9cdf-ef45-4ba3-8397-260945a060dc","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_56_9_07_41_33.xlsx\";s:10:\"supplierid\";s:1:\"9\";s:9:\"productId\";s:2:\"56\";s:6:\"DBname\";s:13:\"SUNRITEBLINDS\";s:6:\"UserId\";s:1:\"1\";s:7:\"session\";s:852:\"eyJjaXBoZXJ0ZXh0Ijoia1IwVUpXcEZIbzN1SFZjUkVEdmVjWmtTdTVLUkVkQjdma1FmOXFmZG5ZWT0iLCJpdiI6IjNkNThmM2E5M2M4ZDhmNTMzMmJmODVhNDAxZWMwMGJhIiwic2FsdCI6ImMyMTM1MTZjOTBhYjYxZDRlMjNjMzg4NDhhYjc4OGUwYjQ1MmE3M2Y5YjNhMDEzYjgyMTJmZWQwZjE0ZjY4NGVjZjZlMzkyNjU2MmY2ZjRkYzJiYWY2NjBlYzhkMDAzN2NjOTk5N2Q2YTYyOTYzNzI2YzhmYWE2ODEwOGZjNzYzZDUzYTAzMWQyMmIxMjVjYzA2NjI2MWIzOTkyNDFkOWIxNTMxNjRjZWFkMWExMTAyMTgwN2U4ZWQ5NjcxYTIwMjI2NTg4YmRmMjNkN2NhOWVmOTlmZjhlNzMxOTcxYTZiMDZmZGFjZWJmOTcxM2Y2MzU3MzVjZTc1MTNjOTZhNDVlMmVhODlmNDA1N2JjMzcxZDkzY2VlZDBmYTZkMDkyODFjYTE5ZTQ5NWNhMWM2MWViNGJkY2ZlYjk3N2U4ZmNlNzEwZDUyYTc1NDU5OWY3M2U4MWRmZmZlZGNhNmM3YzI3MTg3M2ZhMjJlNWJmMTViNmEyNGE2OTlmZWU3NGUwNmMzNjlhYzk0Njg1NTAwMWNjYmVhNGI3YmZlNjViNDhhNzY2YTNjMzBhZjhjYWRmMDIxNWM3MzM2MDg5MmMxMjUwNjRhMzIwMTA4ODRkOGQ1YzhmYmQxNzc4Nzk1MmRjNDk0NTdlYmRkNTE0YTk2MDVhMWI5YWI5ODIyODI2NDEzIiwiaXRlcmF0aW9ucyI6OX0=\";s:6:\"edi_id\";i:21;}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-22 07:51:36)) (SQL: select `cd_id` as `colormapid`, `cd_fabricmapid` as `fabricmapid` from `bm_colordetails` inner join `bm_fabriccolourmap` on `pfm_colourmapid` = `cd_id` and `pfm_status` = 0 inner join `bm_productgroupmaterialmap` on `pgmm_fabriccolormapid` = `pfm_id` and `pgmm_status` = 0 where `cd_mtrlcategid` = 5 and `cd_status` = 0 and JSON_VALUE(cd_custmzdcolrdetails, '$.133') = Blush and JSON_VALUE(cd_custmzdcolrdetails, '$.134') = 539190 and JSON_VALUE(pfm_jsondata, '$.128') = Foss (200) and JSON_VALUE(pfm_jsondata, '$.129') = 132623 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-22 08:01:42] production.ALERT: Import update [2025-05-22 08:01:42] 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 (03df9fa9-d29e-48a9-9c1a-650090146377, mysql, edi_sunriteblinds, {"uuid":"03df9fa9-d29e-48a9-9c1a-650090146377","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_07_47_52.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:856:\"eyJjaXBoZXJ0ZXh0IjoibEpmY1IyclwvWTE3SGZuVWVsWWdBT1wvV1BaVktUWEp6b3JzTXBpQkNkYnBnPSIsIml2IjoiNTU1MzFhMmM1MzM4MTJmYzRhYzYwYzJjYzdiMDRmNDIiLCJzYWx0IjoiYTYwYjRkODE0ZjYxMmIxZDdkNTY2N2VmNjRiZWQ4MDNmMmM2OWRmYjFmYTI1YjFjZjA3ZTYyYWNmYmM5YjUzOGUxZDQwZDJhZWNhMzAzMjY5ZDM4Y2Q1YzE4OWIwNDY5MDU5NDcwNWZjN2I4MTllNzdiMTYwZjI3MTc3ZjFlMGQ3MzFiMmVhZjM4NzFiNmM2ZmFmMDE0ZDhhZjhiMGZjMjI2MmVlYjNjOTQwNmVjYzE1YmY3OWQxNmFjOTNjMTM0OWU3M2E5ZjM4NzdjYzczY2UzZmNlN2YxZmY3NzgxZGJlYjJhODM2M2ViODMwMWE5ZjI4NjUxNzA1NTA5YTVjNmEwYTAyODdjNzZjNDdiOWIwMzA2YWMyY2E2ZDc3NjYzNjliOGIzN2U0MDIxNWFhZjNlOTUyMTBmNGRiYTk1NTQzYWI1OTU5ZDhiZTk1MDBmMGNjOGUwYWQ4ZjJkOWJiNTE3MjY4YTg2YWZiNDJhZDRlNWUzNzE1YmM5NTg1NjgxYzkxMzc3ZWE2YTk5MjIwNWIyZWZmNmQyNjdmMzQ3NWExY2MxZWMzOGQzNjMwZDZkYTE4MTkxOWY3ZTliNWUwZjBkYTMyMDllZjAxZTNiNzUyYTYzYTk2NzM5NzMwNzZmYTkxN2U0N2NkMTJjNDllZmIyYjliOGMwMDYwNTNkNGUiLCJpdGVyYXRpb25zIjo5fQ==\";s:6:\"edi_id\";i:22;}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-22 08:01:42)) 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 (03df9fa9-d29e-48a9-9c1a-650090146377, mysql, edi_sunriteblinds, {"uuid":"03df9fa9-d29e-48a9-9c1a-650090146377","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_07_47_52.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:856:\"eyJjaXBoZXJ0ZXh0IjoibEpmY1IyclwvWTE3SGZuVWVsWWdBT1wvV1BaVktUWEp6b3JzTXBpQkNkYnBnPSIsIml2IjoiNTU1MzFhMmM1MzM4MTJmYzRhYzYwYzJjYzdiMDRmNDIiLCJzYWx0IjoiYTYwYjRkODE0ZjYxMmIxZDdkNTY2N2VmNjRiZWQ4MDNmMmM2OWRmYjFmYTI1YjFjZjA3ZTYyYWNmYmM5YjUzOGUxZDQwZDJhZWNhMzAzMjY5ZDM4Y2Q1YzE4OWIwNDY5MDU5NDcwNWZjN2I4MTllNzdiMTYwZjI3MTc3ZjFlMGQ3MzFiMmVhZjM4NzFiNmM2ZmFmMDE0ZDhhZjhiMGZjMjI2MmVlYjNjOTQwNmVjYzE1YmY3OWQxNmFjOTNjMTM0OWU3M2E5ZjM4NzdjYzczY2UzZmNlN2YxZmY3NzgxZGJlYjJhODM2M2ViODMwMWE5ZjI4NjUxNzA1NTA5YTVjNmEwYTAyODdjNzZjNDdiOWIwMzA2YWMyY2E2ZDc3NjYzNjliOGIzN2U0MDIxNWFhZjNlOTUyMTBmNGRiYTk1NTQzYWI1OTU5ZDhiZTk1MDBmMGNjOGUwYWQ4ZjJkOWJiNTE3MjY4YTg2YWZiNDJhZDRlNWUzNzE1YmM5NTg1NjgxYzkxMzc3ZWE2YTk5MjIwNWIyZWZmNmQyNjdmMzQ3NWExY2MxZWMzOGQzNjMwZDZkYTE4MTkxOWY3ZTliNWUwZjBkYTMyMDllZjAxZTNiNzUyYTYzYTk2NzM5NzMwNzZmYTkxN2U0N2NkMTJjNDllZmIyYjliOGMwMDYwNTNkNGUiLCJpdGVyYXRpb25zIjo5fQ==\";s:6:\"edi_id\";i:22;}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-22 08:01:42)) (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') = Coffee Bean and JSON_VALUE(cd_custmzdcolrdetails, '$.134') = 354364 and JSON_VALUE(pfm_jsondata, '$.128') = Gemini (200) and JSON_VALUE(pfm_jsondata, '$.129') = 91780 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-22 08:11:43] production.ALERT: Import update [2025-05-22 08:11:43] 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 (25b2e7ed-0671-45d3-86ab-49e632c72540, mysql, edi_sunriteblinds, {"uuid":"25b2e7ed-0671-45d3-86ab-49e632c72540","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_07_51_59.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:856:\"eyJjaXBoZXJ0ZXh0IjoibEpmY1IyclwvWTE3SGZuVWVsWWdBT1wvV1BaVktUWEp6b3JzTXBpQkNkYnBnPSIsIml2IjoiNTU1MzFhMmM1MzM4MTJmYzRhYzYwYzJjYzdiMDRmNDIiLCJzYWx0IjoiYTYwYjRkODE0ZjYxMmIxZDdkNTY2N2VmNjRiZWQ4MDNmMmM2OWRmYjFmYTI1YjFjZjA3ZTYyYWNmYmM5YjUzOGUxZDQwZDJhZWNhMzAzMjY5ZDM4Y2Q1YzE4OWIwNDY5MDU5NDcwNWZjN2I4MTllNzdiMTYwZjI3MTc3ZjFlMGQ3MzFiMmVhZjM4NzFiNmM2ZmFmMDE0ZDhhZjhiMGZjMjI2MmVlYjNjOTQwNmVjYzE1YmY3OWQxNmFjOTNjMTM0OWU3M2E5ZjM4NzdjYzczY2UzZmNlN2YxZmY3NzgxZGJlYjJhODM2M2ViODMwMWE5ZjI4NjUxNzA1NTA5YTVjNmEwYTAyODdjNzZjNDdiOWIwMzA2YWMyY2E2ZDc3NjYzNjliOGIzN2U0MDIxNWFhZjNlOTUyMTBmNGRiYTk1NTQzYWI1OTU5ZDhiZTk1MDBmMGNjOGUwYWQ4ZjJkOWJiNTE3MjY4YTg2YWZiNDJhZDRlNWUzNzE1YmM5NTg1NjgxYzkxMzc3ZWE2YTk5MjIwNWIyZWZmNmQyNjdmMzQ3NWExY2MxZWMzOGQzNjMwZDZkYTE4MTkxOWY3ZTliNWUwZjBkYTMyMDllZjAxZTNiNzUyYTYzYTk2NzM5NzMwNzZmYTkxN2U0N2NkMTJjNDllZmIyYjliOGMwMDYwNTNkNGUiLCJpdGVyYXRpb25zIjo5fQ==\";s:6:\"edi_id\";i:23;}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-22 08:11:43)) 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 (25b2e7ed-0671-45d3-86ab-49e632c72540, mysql, edi_sunriteblinds, {"uuid":"25b2e7ed-0671-45d3-86ab-49e632c72540","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_07_51_59.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:856:\"eyJjaXBoZXJ0ZXh0IjoibEpmY1IyclwvWTE3SGZuVWVsWWdBT1wvV1BaVktUWEp6b3JzTXBpQkNkYnBnPSIsIml2IjoiNTU1MzFhMmM1MzM4MTJmYzRhYzYwYzJjYzdiMDRmNDIiLCJzYWx0IjoiYTYwYjRkODE0ZjYxMmIxZDdkNTY2N2VmNjRiZWQ4MDNmMmM2OWRmYjFmYTI1YjFjZjA3ZTYyYWNmYmM5YjUzOGUxZDQwZDJhZWNhMzAzMjY5ZDM4Y2Q1YzE4OWIwNDY5MDU5NDcwNWZjN2I4MTllNzdiMTYwZjI3MTc3ZjFlMGQ3MzFiMmVhZjM4NzFiNmM2ZmFmMDE0ZDhhZjhiMGZjMjI2MmVlYjNjOTQwNmVjYzE1YmY3OWQxNmFjOTNjMTM0OWU3M2E5ZjM4NzdjYzczY2UzZmNlN2YxZmY3NzgxZGJlYjJhODM2M2ViODMwMWE5ZjI4NjUxNzA1NTA5YTVjNmEwYTAyODdjNzZjNDdiOWIwMzA2YWMyY2E2ZDc3NjYzNjliOGIzN2U0MDIxNWFhZjNlOTUyMTBmNGRiYTk1NTQzYWI1OTU5ZDhiZTk1MDBmMGNjOGUwYWQ4ZjJkOWJiNTE3MjY4YTg2YWZiNDJhZDRlNWUzNzE1YmM5NTg1NjgxYzkxMzc3ZWE2YTk5MjIwNWIyZWZmNmQyNjdmMzQ3NWExY2MxZWMzOGQzNjMwZDZkYTE4MTkxOWY3ZTliNWUwZjBkYTMyMDllZjAxZTNiNzUyYTYzYTk2NzM5NzMwNzZmYTkxN2U0N2NkMTJjNDllZmIyYjliOGMwMDYwNTNkNGUiLCJpdGVyYXRpb25zIjo5fQ==\";s:6:\"edi_id\";i:23;}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-22 08:11:43)) (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') = Nevole and JSON_VALUE(cd_custmzdcolrdetails, '$.134') = 550660 and JSON_VALUE(pfm_jsondata, '$.128') = Focal B/O (300) and JSON_VALUE(pfm_jsondata, '$.129') = 135089 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}