[Transparência] Erro ao filtrar por Órgão
Origem
Chamado 7904999
Passos para reproduzir o problema
Transparência v1 > Consulta > Instrumento de Cobrança > Filtrar por Órgão
Qual o resultado obtido
Log dia 17/06 Às 00h45:
[2024-06-17 00:45:59] SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "orgaos" SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "orgaos"
LINE 1: ...."situacao" = $1 and "unidades"."sigilo" = $2 and "orgaos"."...
^ (SQL: select count(*) as aggregate from "contratofaturas" left join "contratos" on "contratos"."id" = "contratofaturas"."contrato_id" left join "fornecedores" on "fornecedores"."id" = "contratos"."fornecedor_id" left join "unidades" on "unidades"."id" = "contratos"."unidade_id" left join "tipolistafatura" on "tipolistafatura"."id" = "contratofaturas"."tipolistafatura_id" left join "justificativafatura" on "justificativafatura"."id" = "contratofaturas"."justificativafatura_id" left join "apropriacoes_faturas_contratofaturas" on "apropriacoes_faturas_contratofaturas"."contratofaturas_id" = "contratofaturas"."id" where "contratos"."situacao" = 1 and "unidades"."sigilo" = 0 and "orgaos"."codigo" in (20114) and "contratofaturas"."situacao" in (PEN, PGS, PGP, ANA, PPG, APR, CAN, ERR, ENV, AND, PROC) and "contratofaturas"."deleted_at" is null) {"userId":6025,"email":"isadora-d.oliveira@economia.gov.br","exception":"[object] (Illuminate\\Database\\QueryException(code: 42P01): SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table \"orgaos\"
LINE 1: ...."situacao" = $1 and "unidades"."sigilo" = $2 and "orgaos"."... ^ (SQL: select count() as aggregate from "contratofaturas" left join "contratos" on "contratos"."id" = "contratofaturas"."contrato_id" left join "fornecedores" on "fornecedores"."id" = "contratos"."fornecedor_id" left join "unidades" on "unidades"."id" = "contratos"."unidade_id" left join "tipolistafatura" on "tipolistafatura"."id" = "contratofaturas"."tipolistafatura_id" left join "justificativafatura" on "justificativafatura"."id" = "contratofaturas"."justificativafatura_id" left join "apropriacoes_faturas_contratofaturas" on "apropriacoes_faturas_contratofaturas"."contratofaturas_id" = "contratofaturas"."id" where "contratos"."situacao" = 1 and "unidades"."sigilo" = 0 and "orgaos"."codigo" in (20114) and "contratofaturas"."situacao" in (PEN, PGS, PGP, ANA, PPG, APR, CAN, ERR, ENV, AND, PROC) and "contratofaturas"."deleted_at" is null) at /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Doctrine\DBAL\Driver\PDO\Exception(code: 42P01): SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "orgaos" LINE 1: ...."situacao" = $1 and "unidades"."sigilo" = $2 and "orgaos"."... ^ at /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42P01): SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "orgaos" LINE 1: ...."situacao" = $1 and "unidades"."sigilo" = $2 and "orgaos"."... ^ at /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117) [stacktrace] #0 /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select count()...', Array, Object(Closure)) #1 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Database/Connection.php(333): Illuminate\Database\Connection->run('select count()...', Array, Object(Closure)) #2 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2095): Illuminate\Database\Connection->select('select count()...', Array, true) #3 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2083): Illuminate\Database\Query\Builder->runSelect() #4 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2569): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2084): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #6 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2496): Illuminate\Database\Query\Builder->get(Array) #7 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2424): Illuminate\Database\Query\Builder->aggregate('count', Array) #8 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1338): Illuminate\Database\Query\Builder->count() #9 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/backpack/crud/src/PanelTraits/Query.php(140): Illuminate\Database\Eloquent\Builder->__call('count', Array) #10 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/backpack/crud/src/app/Http/Controllers/Operations/ListOperation.php(35): Backpack\CRUD\CrudPanel->count() #11 (closed) [internal function]: Backpack\CRUD\app\Http\Controllers\CrudController->search() #12 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #13 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('search', Array) #14 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\Transparencia\ConsultaFaturasCrudController), 'search') #15 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\Routing\Route->runController() #16 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\Routing\Route->run() #17 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #18 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/backpack/crud/src/app/Http/Controllers/CrudController.php(45): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #19 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(145): Backpack\CRUD\app\Http\Controllers\CrudController->Backpack\CRUD\app\Http\Controllers\{closure}(Object(Illuminate\Http\Request), Object(Closure)) #20 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #21 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #22 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #23 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #24 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #25 /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #26 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #27 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #28 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #29 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #30 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #31 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #32 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #33 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #34 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #35 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #36 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #37 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #38 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #39 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #40 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Router.php(684): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #41 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Router.php(659): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #42 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route)) #43 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Router.php(614): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #44 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #45 /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #46 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/app/Http/Middleware/Cors.php(18): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #47 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\Http\Middleware\Cors->handle(Object(Illuminate\Http\Request), Object(Closure)) #48 /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #49 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #50 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure)) #51 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #52 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #53 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #54 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #55 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #56 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #57 /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #58 /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #59 /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #60 /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #61 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #62 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #63 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #64 /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #65 /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #66 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #67 (closed) /opt/websites/apache/2.4/hom_11977_comprasctr_app/contratos/public/index.php(55): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #68 {main} "}
e
[2024-06-17 00:45:59] Nó: DFCDSRVV7944 ; Código: 20240617004559795893 SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "orgaos" Nó: DFCDSRVV7944 ; Código: 20240617004559795893 SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "orgaos"
LINE 1: ...."situacao" = $1 and "unidades"."sigilo" = $2 and "orgaos"."...
^ (SQL: select count(*) as aggregate from "contratofaturas" left join "contratos" on "contratos"."id" = "contratofaturas"."contrato_id" left join "fornecedores" on "fornecedores"."id" = "contratos"."fornecedor_id" left join "unidades" on "unidades"."id" = "contratos"."unidade_id" left join "tipolistafatura" on "tipolistafatura"."id" = "contratofaturas"."tipolistafatura_id" left join "justificativafatura" on "justificativafatura"."id" = "contratofaturas"."justificativafatura_id" left join "apropriacoes_faturas_contratofaturas" on "apropriacoes_faturas_contratofaturas"."contratofaturas_id" = "contratofaturas"."id" where "contratos"."situacao" = 1 and "unidades"."sigilo" = 0 and "orgaos"."codigo" in (20114) and "contratofaturas"."situacao" in (PEN, PGS, PGP, ANA, PPG, APR, CAN, ERR, ENV, AND, PROC) and "contratofaturas"."deleted_at" is null)
Qual o resultado esperado
Que o usuário consiga filtrar as informações disponíveis no Transparência > Instrumento de Cobrança por Órgão
Contexto
Produção e homologação.
Solução alternativa
Não há.
Solução sugerida
Não há.