[2023-01-18 10:08:15] local.ERROR: SQLSTATE[22018]: Invalid character value for cast specification: 301 [Microsoft][ODBC Visual FoxPro Driver]Operator/operand type mismatch. (SQLExecute[301] at ext\pdo_odbc\odbc_stmt.c:257) (SQL: SELECT c.fec_emisio as periodo, "OS" as tipo, a.nro_servic as documento, a.tipofami+"-"+a.grupo+"-"+a.subgrupo+"-"+a.sec_serv+" "+ALLTRIM(b.desc_serv)+" ("+b.unimed+")" + "| Cantidad: " + ALLTRIM(STR(a.can_ordena)) + " | Valor unitario: " + ALLTRIM(STR(a.pre_unitar)) as detalle, a.pre_tot as total, ALLTRIM(a.zona + "." + a.loca + "." + LEFT(a.codproy,2) + "." + RIGHT(a.codproy,2)) as codproy, a.cod_inv, left(alltrim(a.cta_con),9) as cta_con, a.detlin, c.nro_expe, a.estado as estado FROM logistica/data/sum40018 as a JOIN logistica/data/sum40003 as b ON a.tipofami=b.tipofami AND a.grupo=b.grupo AND a.subgrupo=b.subgrupo AND a.sec_serv=b.sec_serv JOIN logistica/data/sum40017 as c ON a.nro_servic=c.nro_servic WHERE left(a.periodo,4)=2023 ) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 22018): SQLSTATE[22018]: Invalid character value for cast specification: 301 [Microsoft][ODBC Visual FoxPro Driver]Operator/operand type mismatch. (SQLExecute[301] at ext\\pdo_odbc\\odbc_stmt.c:257) (SQL: SELECT c.fec_emisio as periodo, \"OS\" as tipo, a.nro_servic as documento, a.tipofami+\"-\"+a.grupo+\"-\"+a.subgrupo+\"-\"+a.sec_serv+\" \"+ALLTRIM(b.desc_serv)+\" (\"+b.unimed+\")\" + \"| Cantidad: \" + ALLTRIM(STR(a.can_ordena)) + \" | Valor unitario: \" + ALLTRIM(STR(a.pre_unitar)) as detalle, a.pre_tot as total, ALLTRIM(a.zona + \".\" + a.loca + \".\" + LEFT(a.codproy,2) + \".\" + RIGHT(a.codproy,2)) as codproy, a.cod_inv, left(alltrim(a.cta_con),9) as cta_con, a.detlin, c.nro_expe, a.estado as estado FROM logistica/data/sum40018 as a JOIN logistica/data/sum40003 as b ON a.tipofami=b.tipofami AND a.grupo=b.grupo AND a.subgrupo=b.subgrupo AND a.sec_serv=b.sec_serv JOIN logistica/data/sum40017 as c ON a.nro_servic=c.nro_servic WHERE left(a.periodo,4)=2023 ) at C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:712) [stacktrace] #0 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #1 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #2 C:\\laragon\\www\\utilitario\\app\\Http\\Controllers\\ActividadController.php(143): Illuminate\\Database\\Connection->select(Object(Illuminate\\Database\\Query\\Expression)) #3 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ActividadController->importar() #4 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('importar', Array) #5 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ActividadController), 'importar') #6 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #7 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #8 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #9 C:\\laragon\\www\\utilitario\\app\\Http\\Middleware\\CargarActividades.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #10 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CargarActividades->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #11 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #13 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #14 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #15 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #16 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Middleware\\ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #19 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #20 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure)) #21 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #22 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #23 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #24 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #28 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #29 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #30 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #31 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #32 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #33 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #34 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #35 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #36 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #37 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #38 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 C:\\laragon\\www\\utilitario\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(38): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\laragon\\www\\utilitario\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #49 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #50 C:\\laragon\\www\\utilitario\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #51 {main} [previous exception] [object] (PDOException(code: 22018): SQLSTATE[22018]: Invalid character value for cast specification: 301 [Microsoft][ODBC Visual FoxPro Driver]Operator/operand type mismatch. (SQLExecute[301] at ext\\pdo_odbc\\odbc_stmt.c:257) at C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:373) [stacktrace] #0 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(373): PDOStatement->execute() #1 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}(Object(Illuminate\\Database\\Query\\Expression), Array) #2 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #3 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #4 C:\\laragon\\www\\utilitario\\app\\Http\\Controllers\\ActividadController.php(143): Illuminate\\Database\\Connection->select(Object(Illuminate\\Database\\Query\\Expression)) #5 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ActividadController->importar() #6 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('importar', Array) #7 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ActividadController), 'importar') #8 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #9 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #10 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #11 C:\\laragon\\www\\utilitario\\app\\Http\\Middleware\\CargarActividades.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CargarActividades->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #13 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #14 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #15 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #16 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #19 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Middleware\\ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #20 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #21 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #22 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure)) #23 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #24 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #28 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #29 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #30 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #31 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #32 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #33 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #34 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #35 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #36 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #37 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #38 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #39 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #40 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\laragon\\www\\utilitario\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(38): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\laragon\\www\\utilitario\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #49 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #50 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #51 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #52 C:\\laragon\\www\\utilitario\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #53 {main} "} [2023-01-18 11:36:49] local.ERROR: SQLSTATE[S1000]: <>: 832 [Microsoft][ODBC Visual FoxPro Driver]TIPO_IN is not unique and must be qualified. (SQLExecute[832] at ext\pdo_odbc\odbc_stmt.c:257) (SQL: SELECT a.codigo, alltrim(programa.codigo) + " - " + alltrim(programa.descrip) as concatenado_programa, a.cod_pre, a.cod_pre + " " + actividad.descrip as concatenado_actividad, a.cod_ccp1 as cuenta_contable, ALLTRIM(a.cod_ccp1) + " " + ALLTRIM(a.descrip) as concatenado_cuenta_contable, a.pia, 0 as pim, a.pro_ene, a.pro_feb, a.pro_mar, a.pro_abr, a.pro_may, a.pro_jun, a.pro_jul, a.pro_ago, a.pro_set, a.pro_oct, a.pro_nov, a.pro_dic, pro_tot, a.uti_ene, a.uti_feb, a.uti_mar, a.uti_abr, a.uti_may, a.uti_jun, a.uti_jul, a.uti_ago, a.uti_set, a.uti_oct, a.uti_nov, a.uti_dic, a.uti_ene + a.uti_feb + a.uti_mar + a.uti_abr + a.uti_may + a.uti_jun + a.uti_jul + a.uti_ago + a.uti_set + a.uti_oct + a.uti_nov + a.uti_dic as uti_tot, a.cer_ene, a.cer_feb, a.cer_mar, a.cer_abr, a.cer_may, a.cer_jun, a.cer_jul, a.cer_ago, a.cer_set, a.cer_oct, a.cer_nov, a.cer_dic, a.cer_ene + a.cer_feb + a.cer_mar + a.cer_abr + a.cer_may + a.cer_jun + a.cer_jul + a.cer_ago + a.cer_set + a.cer_oct + a.cer_nov + a.cer_dic as cer_tot, a.clasificador as nivel_6, nivel1.cod1 as nivel_5, nivel2.cod1 as nivel_4, nivel3.cod1 as nivel_3, nivel4.cod1 as nivel_2, a.clasificador + " " + nivel1.descrip as concatenado_nivel_6, nivel1.cod1 + " " + nivel2.deseg as concatenado_nivel_5, nivel2.cod1 + " " + nivel3.nomesp as concatenado_nivel_4, nivel3.cod1 + " " + nivel4.desapl as concatenado_nivel_3, nivel4.cod1 + " " + nivel5.desgg as concatenado_nivel_2, actividad.cod_cla + " " + MEF.DEN_CLA AS MEF FROM planif/data/tab_recu as a LEFT JOIN planif/data/tab_acti as actividad ON a.cod_pre=actividad.llave AND actividad.origen="O" LEFT JOIN planif/data/tab_prog as programa ON actividad.cod_pro=programa.codigo AND programa.origen="O" left join planif/data/tab_cla as nivel1 on nivel1.codigo=a.clasificador and NIVEL1.origen="O" left join planif/data/tab_egam as nivel2 on nivel1.cod1=nivel2.codeg and NIVEL2.origen="O" left join planif/data/tab_esp2 as nivel3 on nivel2.cod1=nivel3.codesp and NIVEL3.origen="O" left join planif/data/tab_mapm as nivel4 on nivel3.cod1=nivel4.codapl and NIVEL4.origen="O" left join planif/data/tab_gggm as nivel5 on nivel4.cod1=nivel5.codgg and NIVEL5.origen="O" LEFT JOIN planif/data/TAB_CLAMEF AS MEF ON MEF.COD_CLA=ACTIVIDAD.COD_CLA WHERE a.origen="O" and tipo_in="E" ) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: S1000): SQLSTATE[S1000]: <>: 832 [Microsoft][ODBC Visual FoxPro Driver]TIPO_IN is not unique and must be qualified. (SQLExecute[832] at ext\\pdo_odbc\\odbc_stmt.c:257) (SQL: SELECT a.codigo, alltrim(programa.codigo) + \" - \" + alltrim(programa.descrip) as concatenado_programa, a.cod_pre, a.cod_pre + \" \" + actividad.descrip as concatenado_actividad, a.cod_ccp1 as cuenta_contable, ALLTRIM(a.cod_ccp1) + \" \" + ALLTRIM(a.descrip) as concatenado_cuenta_contable, a.pia, 0 as pim, a.pro_ene, a.pro_feb, a.pro_mar, a.pro_abr, a.pro_may, a.pro_jun, a.pro_jul, a.pro_ago, a.pro_set, a.pro_oct, a.pro_nov, a.pro_dic, pro_tot, a.uti_ene, a.uti_feb, a.uti_mar, a.uti_abr, a.uti_may, a.uti_jun, a.uti_jul, a.uti_ago, a.uti_set, a.uti_oct, a.uti_nov, a.uti_dic, a.uti_ene + a.uti_feb + a.uti_mar + a.uti_abr + a.uti_may + a.uti_jun + a.uti_jul + a.uti_ago + a.uti_set + a.uti_oct + a.uti_nov + a.uti_dic as uti_tot, a.cer_ene, a.cer_feb, a.cer_mar, a.cer_abr, a.cer_may, a.cer_jun, a.cer_jul, a.cer_ago, a.cer_set, a.cer_oct, a.cer_nov, a.cer_dic, a.cer_ene + a.cer_feb + a.cer_mar + a.cer_abr + a.cer_may + a.cer_jun + a.cer_jul + a.cer_ago + a.cer_set + a.cer_oct + a.cer_nov + a.cer_dic as cer_tot, a.clasificador as nivel_6, nivel1.cod1 as nivel_5, nivel2.cod1 as nivel_4, nivel3.cod1 as nivel_3, nivel4.cod1 as nivel_2, a.clasificador + \" \" + nivel1.descrip as concatenado_nivel_6, nivel1.cod1 + \" \" + nivel2.deseg as concatenado_nivel_5, nivel2.cod1 + \" \" + nivel3.nomesp as concatenado_nivel_4, nivel3.cod1 + \" \" + nivel4.desapl as concatenado_nivel_3, nivel4.cod1 + \" \" + nivel5.desgg as concatenado_nivel_2, actividad.cod_cla + \" \" + MEF.DEN_CLA AS MEF FROM planif/data/tab_recu as a LEFT JOIN planif/data/tab_acti as actividad ON a.cod_pre=actividad.llave AND actividad.origen=\"O\" LEFT JOIN planif/data/tab_prog as programa ON actividad.cod_pro=programa.codigo AND programa.origen=\"O\" left join planif/data/tab_cla as nivel1 on nivel1.codigo=a.clasificador and NIVEL1.origen=\"O\" left join planif/data/tab_egam as nivel2 on nivel1.cod1=nivel2.codeg and NIVEL2.origen=\"O\" left join planif/data/tab_esp2 as nivel3 on nivel2.cod1=nivel3.codesp and NIVEL3.origen=\"O\" left join planif/data/tab_mapm as nivel4 on nivel3.cod1=nivel4.codapl and NIVEL4.origen=\"O\" left join planif/data/tab_gggm as nivel5 on nivel4.cod1=nivel5.codgg and NIVEL5.origen=\"O\" LEFT JOIN planif/data/TAB_CLAMEF AS MEF ON MEF.COD_CLA=ACTIVIDAD.COD_CLA WHERE a.origen=\"O\" and tipo_in=\"E\" ) at C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:712) [stacktrace] #0 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #1 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #2 C:\\laragon\\www\\utilitario\\app\\Exports\\ActividadExport.php(58): Illuminate\\Database\\Connection->select(Object(Illuminate\\Database\\Query\\Expression)) #3 C:\\laragon\\www\\utilitario\\vendor\\maatwebsite\\excel\\src\\Sheet.php(476): App\\Exports\\ActividadExport->collection() #4 C:\\laragon\\www\\utilitario\\vendor\\maatwebsite\\excel\\src\\Sheet.php(219): Maatwebsite\\Excel\\Sheet->fromCollection(Object(App\\Exports\\ActividadExport)) #5 C:\\laragon\\www\\utilitario\\vendor\\maatwebsite\\excel\\src\\Writer.php(71): Maatwebsite\\Excel\\Sheet->export(Object(App\\Exports\\ActividadExport)) #6 C:\\laragon\\www\\utilitario\\vendor\\maatwebsite\\excel\\src\\Excel.php(195): Maatwebsite\\Excel\\Writer->export(Object(App\\Exports\\ActividadExport), 'Xlsx') #7 C:\\laragon\\www\\utilitario\\vendor\\maatwebsite\\excel\\src\\Excel.php(84): Maatwebsite\\Excel\\Excel->export(Object(App\\Exports\\ActividadExport), 'avance_gasto.xl...', 'Xlsx') #8 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Facades\\Facade.php(261): Maatwebsite\\Excel\\Excel->download(Object(App\\Exports\\ActividadExport), 'avance_gasto.xl...') #9 C:\\laragon\\www\\utilitario\\app\\Http\\Controllers\\ReporteController.php(18): Illuminate\\Support\\Facades\\Facade::__callStatic('download', Array) #10 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ReporteController->verActividades() #11 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('verActividades', Array) #12 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ReporteController), 'verActividades') #13 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #14 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #15 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 C:\\laragon\\www\\utilitario\\app\\Http\\Middleware\\Presupuesto.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #17 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Presupuesto->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #18 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #19 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #22 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #23 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #24 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Middleware\\ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure)) #28 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #29 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #31 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #32 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #33 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #34 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #35 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #36 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #37 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #38 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #39 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #40 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #41 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #46 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #47 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #49 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #50 C:\\laragon\\www\\utilitario\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(38): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #51 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #52 C:\\laragon\\www\\utilitario\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #53 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #54 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #55 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #56 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #57 C:\\laragon\\www\\utilitario\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #58 {main} [previous exception] [object] (PDOException(code: S1000): SQLSTATE[S1000]: <>: 832 [Microsoft][ODBC Visual FoxPro Driver]TIPO_IN is not unique and must be qualified. (SQLExecute[832] at ext\\pdo_odbc\\odbc_stmt.c:257) at C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:373) [stacktrace] #0 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(373): PDOStatement->execute() #1 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}(Object(Illuminate\\Database\\Query\\Expression), Array) #2 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #3 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #4 C:\\laragon\\www\\utilitario\\app\\Exports\\ActividadExport.php(58): Illuminate\\Database\\Connection->select(Object(Illuminate\\Database\\Query\\Expression)) #5 C:\\laragon\\www\\utilitario\\vendor\\maatwebsite\\excel\\src\\Sheet.php(476): App\\Exports\\ActividadExport->collection() #6 C:\\laragon\\www\\utilitario\\vendor\\maatwebsite\\excel\\src\\Sheet.php(219): Maatwebsite\\Excel\\Sheet->fromCollection(Object(App\\Exports\\ActividadExport)) #7 C:\\laragon\\www\\utilitario\\vendor\\maatwebsite\\excel\\src\\Writer.php(71): Maatwebsite\\Excel\\Sheet->export(Object(App\\Exports\\ActividadExport)) #8 C:\\laragon\\www\\utilitario\\vendor\\maatwebsite\\excel\\src\\Excel.php(195): Maatwebsite\\Excel\\Writer->export(Object(App\\Exports\\ActividadExport), 'Xlsx') #9 C:\\laragon\\www\\utilitario\\vendor\\maatwebsite\\excel\\src\\Excel.php(84): Maatwebsite\\Excel\\Excel->export(Object(App\\Exports\\ActividadExport), 'avance_gasto.xl...', 'Xlsx') #10 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Facades\\Facade.php(261): Maatwebsite\\Excel\\Excel->download(Object(App\\Exports\\ActividadExport), 'avance_gasto.xl...') #11 C:\\laragon\\www\\utilitario\\app\\Http\\Controllers\\ReporteController.php(18): Illuminate\\Support\\Facades\\Facade::__callStatic('download', Array) #12 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ReporteController->verActividades() #13 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('verActividades', Array) #14 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ReporteController), 'verActividades') #15 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #16 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #17 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #18 C:\\laragon\\www\\utilitario\\app\\Http\\Middleware\\Presupuesto.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #19 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Presupuesto->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #22 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #23 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #24 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Middleware\\ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #28 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #29 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure)) #30 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #31 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #32 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #33 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #34 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #35 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #36 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #37 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #38 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #39 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #40 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #41 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #42 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #44 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #49 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #50 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #51 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #52 C:\\laragon\\www\\utilitario\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(38): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #53 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #54 C:\\laragon\\www\\utilitario\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #55 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #56 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #57 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #58 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #59 C:\\laragon\\www\\utilitario\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #60 {main} "} [2023-01-18 12:36:59] local.ERROR: SQLSTATE[22018]: Invalid character value for cast specification: 301 [Microsoft][ODBC Visual FoxPro Driver]Operator/operand type mismatch. (SQLExecute[301] at ext\pdo_odbc\odbc_stmt.c:257) (SQL: SELECT c.fec_emisio as periodo, "OS" as tipo, a.nro_servic as documento, a.tipofami+"-"+a.grupo+"-"+a.subgrupo+"-"+a.sec_serv+" "+ALLTRIM(b.desc_serv)+" ("+b.unimed+")" + "| Cantidad: " + ALLTRIM(STR(a.can_ordena)) + " | Valor unitario: " + ALLTRIM(STR(a.pre_unitar)) as detalle, a.pre_tot as total, ALLTRIM(a.zona + "." + a.loca + "." + LEFT(a.codproy,2) + "." + RIGHT(a.codproy,2)) as codproy, a.cod_inv, left(alltrim(a.cta_con),9) as cta_con, a.detlin, c.nro_expe, a.estado as estado FROM logistica/data/sum40018 as a JOIN logistica/data/sum40003 as b ON a.tipofami=b.tipofami AND a.grupo=b.grupo AND a.subgrupo=b.subgrupo AND a.sec_serv=b.sec_serv JOIN logistica/data/sum40017 as c ON a.nro_servic=c.nro_servic WHERE left(a.periodo,4)=2023 ) {"userId":2,"exception":"[object] (Illuminate\\Database\\QueryException(code: 22018): SQLSTATE[22018]: Invalid character value for cast specification: 301 [Microsoft][ODBC Visual FoxPro Driver]Operator/operand type mismatch. (SQLExecute[301] at ext\\pdo_odbc\\odbc_stmt.c:257) (SQL: SELECT c.fec_emisio as periodo, \"OS\" as tipo, a.nro_servic as documento, a.tipofami+\"-\"+a.grupo+\"-\"+a.subgrupo+\"-\"+a.sec_serv+\" \"+ALLTRIM(b.desc_serv)+\" (\"+b.unimed+\")\" + \"| Cantidad: \" + ALLTRIM(STR(a.can_ordena)) + \" | Valor unitario: \" + ALLTRIM(STR(a.pre_unitar)) as detalle, a.pre_tot as total, ALLTRIM(a.zona + \".\" + a.loca + \".\" + LEFT(a.codproy,2) + \".\" + RIGHT(a.codproy,2)) as codproy, a.cod_inv, left(alltrim(a.cta_con),9) as cta_con, a.detlin, c.nro_expe, a.estado as estado FROM logistica/data/sum40018 as a JOIN logistica/data/sum40003 as b ON a.tipofami=b.tipofami AND a.grupo=b.grupo AND a.subgrupo=b.subgrupo AND a.sec_serv=b.sec_serv JOIN logistica/data/sum40017 as c ON a.nro_servic=c.nro_servic WHERE left(a.periodo,4)=2023 ) at C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:712) [stacktrace] #0 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #1 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #2 C:\\laragon\\www\\utilitario\\app\\Http\\Controllers\\ActividadController.php(143): Illuminate\\Database\\Connection->select(Object(Illuminate\\Database\\Query\\Expression)) #3 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ActividadController->importar() #4 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('importar', Array) #5 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ActividadController), 'importar') #6 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #7 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #8 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #9 C:\\laragon\\www\\utilitario\\app\\Http\\Middleware\\CargarActividades.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #10 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CargarActividades->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #11 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #13 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #14 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #15 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #16 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Middleware\\ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #19 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #20 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure)) #21 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #22 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #23 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #24 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #28 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #29 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #30 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #31 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #32 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #33 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #34 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #35 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #36 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #37 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #38 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 C:\\laragon\\www\\utilitario\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(38): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\laragon\\www\\utilitario\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #49 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #50 C:\\laragon\\www\\utilitario\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #51 {main} [previous exception] [object] (PDOException(code: 22018): SQLSTATE[22018]: Invalid character value for cast specification: 301 [Microsoft][ODBC Visual FoxPro Driver]Operator/operand type mismatch. (SQLExecute[301] at ext\\pdo_odbc\\odbc_stmt.c:257) at C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:373) [stacktrace] #0 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(373): PDOStatement->execute() #1 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}(Object(Illuminate\\Database\\Query\\Expression), Array) #2 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #3 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #4 C:\\laragon\\www\\utilitario\\app\\Http\\Controllers\\ActividadController.php(143): Illuminate\\Database\\Connection->select(Object(Illuminate\\Database\\Query\\Expression)) #5 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ActividadController->importar() #6 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('importar', Array) #7 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ActividadController), 'importar') #8 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #9 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #10 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #11 C:\\laragon\\www\\utilitario\\app\\Http\\Middleware\\CargarActividades.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CargarActividades->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #13 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #14 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #15 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #16 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #19 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Middleware\\ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #20 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #21 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #22 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure)) #23 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #24 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #28 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #29 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #30 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #31 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #32 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #33 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #34 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #35 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #36 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #37 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #38 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #39 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #40 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\laragon\\www\\utilitario\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(38): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\laragon\\www\\utilitario\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #49 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #50 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #51 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #52 C:\\laragon\\www\\utilitario\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #53 {main} "} [2023-01-18 13:22:37] local.ERROR: SQLSTATE[22018]: Invalid character value for cast specification: 301 [Microsoft][ODBC Visual FoxPro Driver]Operator/operand type mismatch. (SQLExecute[301] at ext\pdo_odbc\odbc_stmt.c:257) (SQL: SELECT c.fec_emisio as periodo, "OS" as tipo, a.nro_servic as documento, a.tipofami+"-"+a.grupo+"-"+a.subgrupo+"-"+a.sec_serv+" "+ALLTRIM(b.desc_serv)+" ("+b.unimed+")" + "| Cantidad: " + ALLTRIM(STR(a.can_ordena)) + " | Valor unitario: " + ALLTRIM(STR(a.pre_unitar)) as detalle, a.pre_tot as total, ALLTRIM(a.zona + "." + a.loca + "." + LEFT(a.codproy,2) + "." + RIGHT(a.codproy,2)) as codproy, a.cod_inv, left(alltrim(a.cta_con),9) as cta_con, a.detlin, c.nro_expe, a.estado as estado FROM logistica/data/sum40018 as a JOIN logistica/data/sum40003 as b ON a.tipofami=b.tipofami AND a.grupo=b.grupo AND a.subgrupo=b.subgrupo AND a.sec_serv=b.sec_serv JOIN logistica/data/sum40017 as c ON a.nro_servic=c.nro_servic WHERE left(a.periodo,4)=2023 ) {"userId":2,"exception":"[object] (Illuminate\\Database\\QueryException(code: 22018): SQLSTATE[22018]: Invalid character value for cast specification: 301 [Microsoft][ODBC Visual FoxPro Driver]Operator/operand type mismatch. (SQLExecute[301] at ext\\pdo_odbc\\odbc_stmt.c:257) (SQL: SELECT c.fec_emisio as periodo, \"OS\" as tipo, a.nro_servic as documento, a.tipofami+\"-\"+a.grupo+\"-\"+a.subgrupo+\"-\"+a.sec_serv+\" \"+ALLTRIM(b.desc_serv)+\" (\"+b.unimed+\")\" + \"| Cantidad: \" + ALLTRIM(STR(a.can_ordena)) + \" | Valor unitario: \" + ALLTRIM(STR(a.pre_unitar)) as detalle, a.pre_tot as total, ALLTRIM(a.zona + \".\" + a.loca + \".\" + LEFT(a.codproy,2) + \".\" + RIGHT(a.codproy,2)) as codproy, a.cod_inv, left(alltrim(a.cta_con),9) as cta_con, a.detlin, c.nro_expe, a.estado as estado FROM logistica/data/sum40018 as a JOIN logistica/data/sum40003 as b ON a.tipofami=b.tipofami AND a.grupo=b.grupo AND a.subgrupo=b.subgrupo AND a.sec_serv=b.sec_serv JOIN logistica/data/sum40017 as c ON a.nro_servic=c.nro_servic WHERE left(a.periodo,4)=2023 ) at C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:712) [stacktrace] #0 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #1 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #2 C:\\laragon\\www\\utilitario\\app\\Http\\Controllers\\ActividadController.php(143): Illuminate\\Database\\Connection->select(Object(Illuminate\\Database\\Query\\Expression)) #3 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ActividadController->importar() #4 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('importar', Array) #5 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ActividadController), 'importar') #6 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #7 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #8 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #9 C:\\laragon\\www\\utilitario\\app\\Http\\Middleware\\CargarActividades.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #10 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CargarActividades->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #11 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #13 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #14 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #15 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #16 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Middleware\\ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #19 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #20 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure)) #21 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #22 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #23 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #24 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #28 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #29 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #30 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #31 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #32 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #33 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #34 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #35 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #36 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #37 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #38 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 C:\\laragon\\www\\utilitario\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(38): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\laragon\\www\\utilitario\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #49 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #50 C:\\laragon\\www\\utilitario\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #51 {main} [previous exception] [object] (PDOException(code: 22018): SQLSTATE[22018]: Invalid character value for cast specification: 301 [Microsoft][ODBC Visual FoxPro Driver]Operator/operand type mismatch. (SQLExecute[301] at ext\\pdo_odbc\\odbc_stmt.c:257) at C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:373) [stacktrace] #0 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(373): PDOStatement->execute() #1 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}(Object(Illuminate\\Database\\Query\\Expression), Array) #2 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #3 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure)) #4 C:\\laragon\\www\\utilitario\\app\\Http\\Controllers\\ActividadController.php(143): Illuminate\\Database\\Connection->select(Object(Illuminate\\Database\\Query\\Expression)) #5 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\ActividadController->importar() #6 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('importar', Array) #7 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\ActividadController), 'importar') #8 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #9 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #10 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #11 C:\\laragon\\www\\utilitario\\app\\Http\\Middleware\\CargarActividades.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CargarActividades->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #13 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #14 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #15 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #16 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #19 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Middleware\\ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #20 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #21 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #22 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure)) #23 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #24 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #28 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #29 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #30 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #31 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #32 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #33 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #34 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #35 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #36 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #37 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #38 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #39 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #40 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 C:\\laragon\\www\\utilitario\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(38): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 C:\\laragon\\www\\utilitario\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #49 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #50 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #51 C:\\laragon\\www\\utilitario\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #52 C:\\laragon\\www\\utilitario\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #53 {main} "}