[2024-04-10 12:35:23] local.ERROR: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Ambiguous column name 'lotacao_id'. (SQL: select distinct concat(cc.cod_ccusto, ' - ', cc.des_ccusto) as descricao_ccusto from tbl_lotacao_ccusto as lotcc join tbl_ccusto as cc on cc.id = lotcc.ccusto_id join tbl_orc_lotacao ol on ol.lotacao_id = lotcc.lotacao_id and ol.cc_custo_id = lotcc.ccusto_id where lotacao_id in (0) and (cc.dat_fim_valid < GETDATE()) AND ol.orcamento_id = 272 and ol.tipo_table = 'O' and ol.ativo = 1 ) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Ambiguous column name 'lotacao_id'. (SQL: select distinct concat(cc.cod_ccusto, ' - ', cc.des_ccusto) as descricao_ccusto from tbl_lotacao_ccusto as lotcc join tbl_ccusto as cc on cc.id = lotcc.ccusto_id join tbl_orc_lotacao ol on ol.lotacao_id = lotcc.lotacao_id and ol.cc_custo_id = lotcc.ccusto_id where lotacao_id in (0) and (cc.dat_fim_valid < GETDATE()) AND ol.orcamento_id = 272 and ol.tipo_table = 'O' and ol.ativo = 1 ) at C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:664, PDOException(code: 42000): SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Ambiguous column name 'lotacao_id'. at C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:330) [stacktrace] #0 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('\ \ s...', Array, Object(Closure)) #1 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(333): Illuminate\\Database\\Connection->run('\ \ s...', Array, Object(Closure)) #2 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\DatabaseManager.php(349): Illuminate\\Database\\Connection->select('\ \ s...') #3 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Facades\\Facade.php(239): Illuminate\\Database\\DatabaseManager->__call('select', Array) #4 C:\\xampp\\htdocs\ atureza51_atualizacao\\app\\Modules\\Natureza51\\Http\\Controllers\\OrcLotacaoController.php(534): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array) #5 [internal function]: App\\Modules\\Natureza51\\Http\\Controllers\\OrcLotacaoController->confereCentroCusto('272', 'O', NULL) #6 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): call_user_func_array(Array, Array) #7 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('confereCentroCu...', Array) #8 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Modules\\Natureza51\\Http\\Controllers\\OrcLotacaoController), 'confereCentroCu...') #9 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(176): Illuminate\\Routing\\Route->runController() #10 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(680): Illuminate\\Routing\\Route->run() #11 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #12 C:\\xampp\\htdocs\ atureza51_atualizacao\\app\\Core\\Http\\Middleware\\InstiMid.php(144): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #13 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(163): App\\Core\\Http\\Middleware\\InstiMid->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #14 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #15 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Middleware\\ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #19 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(56): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #22 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #23 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #24 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #25 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #28 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(682): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #29 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(657): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #30 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(623): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #31 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(612): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #32 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(176): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #33 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #34 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #35 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #36 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #37 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #38 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #41 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #44 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #47 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #49 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #50 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #51 C:\\xampp\\htdocs\ atureza51_atualizacao\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #52 C:\\xampp\\htdocs\ atureza51_atualizacao\\public\\index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #53 {main} "}