[2024-09-17 19:37:06] production.ERROR: No application encryption key has been specified. {"exception":"[object] (Illuminate\\Encryption\\MissingAppKeyException(code: 0): No application encryption key has been specified. at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php:79) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Support/helpers.php(306): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(81): tap() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(60): Illuminate\\Encryption\\EncryptionServiceProvider->key() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(32): Illuminate\\Encryption\\EncryptionServiceProvider->parseKey() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(885): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(770): Illuminate\\Container\\Container->build() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(933): Illuminate\\Container\\Container->resolve() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(706): Illuminate\\Foundation\\Application->resolve() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(918): Illuminate\\Container\\Container->make() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(1043): Illuminate\\Foundation\\Application->make() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(959): Illuminate\\Container\\Container->resolveClass() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(920): Illuminate\\Container\\Container->resolveDependencies() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(770): Illuminate\\Container\\Container->build() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(933): Illuminate\\Container\\Container->resolve() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(706): Illuminate\\Foundation\\Application->resolve() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(918): Illuminate\\Container\\Container->make() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(169): Illuminate\\Foundation\\Application->make() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/Cors.php(28): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Cors->handle() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #44 {main} "} [2024-09-17 19:37:06] production.ERROR: No application encryption key has been specified. {"exception":"[object] (Illuminate\\Encryption\\MissingAppKeyException(code: 0): No application encryption key has been specified. at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php:79) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Support/helpers.php(306): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(81): tap() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(60): Illuminate\\Encryption\\EncryptionServiceProvider->key() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(32): Illuminate\\Encryption\\EncryptionServiceProvider->parseKey() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(885): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(770): Illuminate\\Container\\Container->build() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(933): Illuminate\\Container\\Container->resolve() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(706): Illuminate\\Foundation\\Application->resolve() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(918): Illuminate\\Container\\Container->make() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(1043): Illuminate\\Foundation\\Application->make() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(959): Illuminate\\Container\\Container->resolveClass() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(920): Illuminate\\Container\\Container->resolveDependencies() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(770): Illuminate\\Container\\Container->build() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(933): Illuminate\\Container\\Container->resolve() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(706): Illuminate\\Foundation\\Application->resolve() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(918): Illuminate\\Container\\Container->make() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(249): Illuminate\\Foundation\\Application->make() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(213): Illuminate\\Foundation\\Http\\Kernel->terminateMiddleware() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->terminate() #19 {main} "} [2024-09-22 12:40:38] local.ERROR: SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: insert into [cobranza_mercado] ([fecha], [item], [idsocio], [idcredito], [montocredito], [fecharegistro], [idusuarioregistro], [origenaplic], [idoficinaregistro], [esliquidado], [eseliminado], [ipregistro], [recibo]) values (2024-09-22 12:40:38, 4, 4, 0100104-24, 100.00, 2024-09-22 12:40:38, 1, 1, 1, 0, 0, 38.187.11.45, 1)) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: insert into [cobranza_mercado] ([fecha], [item], [idsocio], [idcredito], [montocredito], [fecharegistro], [idusuarioregistro], [origenaplic], [idoficinaregistro], [esliquidado], [eseliminado], [ipregistro], [recibo]) values (2024-09-22 12:40:38, 4, 4, 0100104-24, 100.00, 2024-09-22 12:40:38, 1, 1, 1, 0, 0, 38.187.11.45, 1)) at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(579): Illuminate\\Database\\Connection->run() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(531): Illuminate\\Database\\Connection->statement() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/SqlServerProcessor.php(24): Illuminate\\Database\\Connection->insert() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3341): Illuminate\\Database\\Query\\Processors\\SqlServerProcessor->processInsertGetId() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1904): Illuminate\\Database\\Query\\Builder->insertGetId() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1335): Illuminate\\Database\\Eloquent\\Builder->__call() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1300): Illuminate\\Database\\Eloquent\\Model->insertAndSetId() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1139): Illuminate\\Database\\Eloquent\\Model->performInsert() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(151): Illuminate\\Database\\Eloquent\\Model->save() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(30): App\\Http\\Controllers\\Api\\V1\\App\\AppController->App\\Http\\Controllers\\Api\\V1\\App\\{closure}() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/SqlServerConnection.php(30): Illuminate\\Database\\Connection->transaction() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(469): Illuminate\\Database\\SqlServerConnection->transaction() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(353): Illuminate\\Database\\DatabaseManager->__call() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(179): Illuminate\\Support\\Facades\\Facade::__callStatic() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->registerCobranza() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #48 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #49 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #50 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #51 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #52 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #53 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #54 {main} [previous exception] [object] (PDOException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:578) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(578): PDOStatement->execute() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(786): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(579): Illuminate\\Database\\Connection->run() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(531): Illuminate\\Database\\Connection->statement() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/SqlServerProcessor.php(24): Illuminate\\Database\\Connection->insert() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3341): Illuminate\\Database\\Query\\Processors\\SqlServerProcessor->processInsertGetId() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1904): Illuminate\\Database\\Query\\Builder->insertGetId() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1335): Illuminate\\Database\\Eloquent\\Builder->__call() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1300): Illuminate\\Database\\Eloquent\\Model->insertAndSetId() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1139): Illuminate\\Database\\Eloquent\\Model->performInsert() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(151): Illuminate\\Database\\Eloquent\\Model->save() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(30): App\\Http\\Controllers\\Api\\V1\\App\\AppController->App\\Http\\Controllers\\Api\\V1\\App\\{closure}() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/SqlServerConnection.php(30): Illuminate\\Database\\Connection->transaction() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(469): Illuminate\\Database\\SqlServerConnection->transaction() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(353): Illuminate\\Database\\DatabaseManager->__call() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(179): Illuminate\\Support\\Facades\\Facade::__callStatic() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->registerCobranza() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #48 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #49 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #50 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #51 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #52 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #53 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #54 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #55 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #56 {main} "} [2024-09-22 21:23:51] local.ERROR: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cuando se especifica SELECT DISTINCT, los elementos de ORDER BY deben aparecer en la lista de selección. (Connection: sqlsrv, SQL: select distinct top 50 [recibo], [idsocio] from [cobranza_mercado] where [cobranza_mercado].[idusuarioregistro] = 1 and [cobranza_mercado].[eseliminado] = 0 order by [cobranza_mercado].[fecha] desc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cuando se especifica SELECT DISTINCT, los elementos de ORDER BY deben aparecer en la lista de selección. (Connection: sqlsrv, SQL: select distinct top 50 [recibo], [idsocio] from [cobranza_mercado] where [cobranza_mercado].[idusuarioregistro] = 1 and [cobranza_mercado].[eseliminado] = 0 order by [cobranza_mercado].[fecha] desc) at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2719): Illuminate\\Database\\Connection->select() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2707): Illuminate\\Database\\Query\\Builder->runSelect() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3248): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2708): Illuminate\\Database\\Query\\Builder->onceWithColumns() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(717): Illuminate\\Database\\Query\\Builder->get() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(701): Illuminate\\Database\\Eloquent\\Builder->getModels() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(211): Illuminate\\Database\\Eloquent\\Builder->get() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->history() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #48 {main} [previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cuando se especifica SELECT DISTINCT, los elementos de ORDER BY deben aparecer en la lista de selección. at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:419) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(419): PDOStatement->execute() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(786): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2719): Illuminate\\Database\\Connection->select() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2707): Illuminate\\Database\\Query\\Builder->runSelect() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3248): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2708): Illuminate\\Database\\Query\\Builder->onceWithColumns() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(717): Illuminate\\Database\\Query\\Builder->get() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(701): Illuminate\\Database\\Eloquent\\Builder->getModels() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(211): Illuminate\\Database\\Eloquent\\Builder->get() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->history() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #48 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #49 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #50 {main} "} [2024-09-22 21:53:46] local.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]El nombre de columna 'nom' no es válido. (Connection: sqlsrv, SQL: select [cobranza_mercado].*, [credito].[moneda] as [moneda], [socio].[nom] as [nom_socio], [socio].[ap] as [ap_socio], [socio].[am] as [am_socio], [usuario].[nom] as [nom_usuario], [usuario].[ap] as [ap_usuario], [usuario].[am] as [am_usuario] from [cobranza_mercado] left join [credito] on [credito].[idcredito] = [cobranza_mercado].[idcredito] left join [socio] on [socio].[idsocio] = [cobranza_mercado].[idsocio] left join [usuario] on [usuario].[id_usuario] = [cobranza_mercado].[idusuarioregistro] where [cobranza_mercado].[recibo] = 2 and [cobranza_mercado].[idsocio] = 4 and [cobranza_mercado].[eseliminado] = 0 order by [cobranza_mercado].[item] desc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]El nombre de columna 'nom' no es válido. (Connection: sqlsrv, SQL: select [cobranza_mercado].*, [credito].[moneda] as [moneda], [socio].[nom] as [nom_socio], [socio].[ap] as [ap_socio], [socio].[am] as [am_socio], [usuario].[nom] as [nom_usuario], [usuario].[ap] as [ap_usuario], [usuario].[am] as [am_usuario] from [cobranza_mercado] left join [credito] on [credito].[idcredito] = [cobranza_mercado].[idcredito] left join [socio] on [socio].[idsocio] = [cobranza_mercado].[idsocio] left join [usuario] on [usuario].[id_usuario] = [cobranza_mercado].[idusuarioregistro] where [cobranza_mercado].[recibo] = 2 and [cobranza_mercado].[idsocio] = 4 and [cobranza_mercado].[eseliminado] = 0 order by [cobranza_mercado].[item] desc) at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2719): Illuminate\\Database\\Connection->select() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2707): Illuminate\\Database\\Query\\Builder->runSelect() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3248): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2708): Illuminate\\Database\\Query\\Builder->onceWithColumns() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(717): Illuminate\\Database\\Query\\Builder->get() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(701): Illuminate\\Database\\Eloquent\\Builder->getModels() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(309): Illuminate\\Database\\Eloquent\\Builder->get() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->searchCobranza() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #48 {main} [previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]El nombre de columna 'nom' no es válido. at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:419) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(419): PDOStatement->execute() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(786): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2719): Illuminate\\Database\\Connection->select() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2707): Illuminate\\Database\\Query\\Builder->runSelect() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3248): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2708): Illuminate\\Database\\Query\\Builder->onceWithColumns() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(717): Illuminate\\Database\\Query\\Builder->get() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(701): Illuminate\\Database\\Eloquent\\Builder->getModels() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(309): Illuminate\\Database\\Eloquent\\Builder->get() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->searchCobranza() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #48 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #49 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #50 {main} "} [2024-09-23 19:52:10] local.ERROR: SQLSTATE[42S02]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]El nombre de objeto 'usuarios' no es válido. (Connection: sqlsrv, SQL: select count(*) as aggregate from [usuarios] where [id_usuario] = 329) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]El nombre de objeto 'usuarios' no es válido. (Connection: sqlsrv, SQL: select count(*) as aggregate from [usuarios] where [id_usuario] = 329) at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2719): Illuminate\\Database\\Connection->select() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2707): Illuminate\\Database\\Query\\Builder->runSelect() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3248): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2708): Illuminate\\Database\\Query\\Builder->onceWithColumns() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3175): Illuminate\\Database\\Query\\Builder->get() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3103): Illuminate\\Database\\Query\\Builder->aggregate() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Validation/DatabasePresenceVerifier.php(54): Illuminate\\Database\\Query\\Builder->count() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Validation/Concerns/ValidatesAttributes.php(880): Illuminate\\Validation\\DatabasePresenceVerifier->getCount() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Validation/Concerns/ValidatesAttributes.php(852): Illuminate\\Validation\\Validator->getExistCount() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(616): Illuminate\\Validation\\Validator->validateExists() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(422): Illuminate\\Validation\\Validator->validateAttribute() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(453): Illuminate\\Validation\\Validator->passes() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(360): Illuminate\\Validation\\Validator->fails() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #48 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #49 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #50 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #51 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #52 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #53 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #54 {main} [previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]El nombre de objeto 'usuarios' no es válido. at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:419) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(419): PDOStatement->execute() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(786): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2719): Illuminate\\Database\\Connection->select() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2707): Illuminate\\Database\\Query\\Builder->runSelect() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3248): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2708): Illuminate\\Database\\Query\\Builder->onceWithColumns() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3175): Illuminate\\Database\\Query\\Builder->get() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3103): Illuminate\\Database\\Query\\Builder->aggregate() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Validation/DatabasePresenceVerifier.php(54): Illuminate\\Database\\Query\\Builder->count() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Validation/Concerns/ValidatesAttributes.php(880): Illuminate\\Validation\\DatabasePresenceVerifier->getCount() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Validation/Concerns/ValidatesAttributes.php(852): Illuminate\\Validation\\Validator->getExistCount() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(616): Illuminate\\Validation\\Validator->validateExists() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(422): Illuminate\\Validation\\Validator->validateAttribute() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(453): Illuminate\\Validation\\Validator->passes() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(360): Illuminate\\Validation\\Validator->fails() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #48 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #49 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #50 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #51 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #52 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #53 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #54 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #55 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #56 {main} "} [2024-09-23 19:57:41] local.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]El nombre de columna 'id' no es válido. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 329, [fechamodifica] = 23/09/2024 19:57:41, [eseliminado] = 1, [ipmodifica] = 38.187.11.45 where [id] is null) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]El nombre de columna 'id' no es válido. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 329, [fechamodifica] = 23/09/2024 19:57:41, [eseliminado] = 1, [ipmodifica] = 38.187.11.45 where [id] is null) at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(385): Illuminate\\Database\\Eloquent\\Model->save() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #47 {main} [previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]El nombre de columna 'id' no es válido. at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:603) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(603): PDOStatement->execute() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(786): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(385): Illuminate\\Database\\Eloquent\\Model->save() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #48 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #49 {main} "} [2024-09-23 20:08:11] local.ERROR: SQLSTATE[42S22]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]El nombre de columna 'id' no es válido. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:08:11, [eseliminado] = 1, [ipmodifica] = 38.187.11.45 where [id] is null) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]El nombre de columna 'id' no es válido. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:08:11, [eseliminado] = 1, [ipmodifica] = 38.187.11.45 where [id] is null) at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(393): Illuminate\\Database\\Eloquent\\Model->save() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #47 {main} [previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]El nombre de columna 'id' no es válido. at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:603) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(603): PDOStatement->execute() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(786): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(393): Illuminate\\Database\\Eloquent\\Model->save() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #48 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #49 {main} "} [2024-09-23 20:14:17] local.ERROR: SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:14:17, [eseliminado] = 1, [ipmodifica] = 38.187.11.45) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:14:17, [eseliminado] = 1, [ipmodifica] = 38.187.11.45) at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(393): Illuminate\\Database\\Eloquent\\Model->save() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #47 {main} [previous exception] [object] (PDOException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:603) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(603): PDOStatement->execute() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(786): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(393): Illuminate\\Database\\Eloquent\\Model->save() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #48 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #49 {main} "} [2024-09-23 20:15:59] local.ERROR: SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:15:59, [eseliminado] = 1, [ipmodifica] = 38.187.11.45) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:15:59, [eseliminado] = 1, [ipmodifica] = 38.187.11.45) at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(393): Illuminate\\Database\\Eloquent\\Model->save() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #47 {main} [previous exception] [object] (PDOException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:603) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(603): PDOStatement->execute() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(786): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(393): Illuminate\\Database\\Eloquent\\Model->save() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #48 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #49 {main} "} [2024-09-23 20:20:19] local.ERROR: SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:20:19, [eseliminado] = 1, [ipmodifica] = 38.187.11.45) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:20:19, [eseliminado] = 1, [ipmodifica] = 38.187.11.45) at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(398): Illuminate\\Database\\Eloquent\\Model->save() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #47 {main} [previous exception] [object] (PDOException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:603) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(603): PDOStatement->execute() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(786): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(398): Illuminate\\Database\\Eloquent\\Model->save() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #48 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #49 {main} "} [2024-09-23 20:23:36] local.ERROR: SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:23:36, [eseliminado] = 1, [ipmodifica] = 38.187.11.45) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:23:36, [eseliminado] = 1, [ipmodifica] = 38.187.11.45) at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(392): Illuminate\\Database\\Eloquent\\Model->save() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #47 {main} [previous exception] [object] (PDOException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:603) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(603): PDOStatement->execute() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(786): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(392): Illuminate\\Database\\Eloquent\\Model->save() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #48 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #49 {main} "} [2024-09-23 20:25:28] local.ERROR: SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:25:28, [eseliminado] = 1, [ipmodifica] = 38.187.11.45) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:25:28, [eseliminado] = 1, [ipmodifica] = 38.187.11.45) at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(393): Illuminate\\Database\\Eloquent\\Model->save() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #47 {main} [previous exception] [object] (PDOException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:603) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(603): PDOStatement->execute() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(786): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(393): Illuminate\\Database\\Eloquent\\Model->save() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #48 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #49 {main} "} [2024-09-23 20:28:08] local.ERROR: Class "App\Http\Controllers\Api\V1\App\Log" not found {"exception":"[object] (Error(code: 0): Class \"App\\Http\\Controllers\\Api\\V1\\App\\Log\" not found at /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php:376) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #39 {main} "} [2024-09-23 20:29:11] local.INFO: Valores para eliminar cobranza {"recibo":"5","idsocio":"4","fecha":"2024-09-23 00:00:06.000","idusuariomodifica":1,"ipmodifica":"38.187.11.45","fechamodifica":"2024-09-23 20:29:11"} [2024-09-23 20:29:11] local.INFO: Guardando cobranza {"cobranza_id":null,"fechamodifica":"2024-09-23 20:29:11"} [2024-09-23 20:29:11] local.ERROR: SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:29:11, [eseliminado] = 1, [ipmodifica] = 38.187.11.45) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:29:11, [eseliminado] = 1, [ipmodifica] = 38.187.11.45) at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(413): Illuminate\\Database\\Eloquent\\Model->save() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #47 {main} [previous exception] [object] (PDOException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:603) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(603): PDOStatement->execute() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(786): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1215): Illuminate\\Database\\Eloquent\\Builder->update() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1132): Illuminate\\Database\\Eloquent\\Model->performUpdate() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(413): Illuminate\\Database\\Eloquent\\Model->save() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #47 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #48 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #49 {main} "} [2024-09-23 20:34:10] local.ERROR: SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [eseliminado] = 1, [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:34:10, [ipmodifica] = 38.187.11.45 where [recibo] = 5 and [idsocio] = 4 and cast([fecha] as date) = 2024-09-23 00:00:06.000) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [eseliminado] = 1, [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:34:10, [ipmodifica] = 38.187.11.45 where [recibo] = 5 and [idsocio] = 4 and cast([fecha] as date) = 2024-09-23 00:00:06.000) at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(383): Illuminate\\Database\\Eloquent\\Builder->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #45 {main} [previous exception] [object] (PDOException(code: 22007): SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. at /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:603) [stacktrace] #0 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(603): PDOStatement->execute() #1 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(786): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(610): Illuminate\\Database\\Connection->run() #4 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(543): Illuminate\\Database\\Connection->affectingStatement() #5 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3376): Illuminate\\Database\\Connection->update() #6 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1021): Illuminate\\Database\\Query\\Builder->update() #7 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Controllers/Api/V1/App/AppController.php(383): Illuminate\\Database\\Eloquent\\Builder->update() #8 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\V1\\App\\AppController->deleteCobranza() #9 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #10 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch() #11 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #12 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #13 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #14 /var/www/html/api.cobranzas-inclusiva.siscperu.com/app/Http/Middleware/CoopMiddleware.php(32): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #15 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CoopMiddleware->handle() #16 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #17 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #18 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #19 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(102): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest() #20 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter() #21 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #22 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #23 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then() #24 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #25 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #26 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #27 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch() #28 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #29 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #30 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #31 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #32 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #34 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #35 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #36 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #37 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #39 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(62): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #41 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #43 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #44 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then() #45 /var/www/html/api.cobranzas-inclusiva.siscperu.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #46 /var/www/html/api.cobranzas-inclusiva.siscperu.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle() #47 {main} "} [2024-09-23 20:36:28] local.ERROR: Error al intentar eliminar la cobranza {"error":"SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [eseliminado] = 1, [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:36:28, [ipmodifica] = 38.187.11.45 where [recibo] = 5 and [idsocio] = 4 and cast([fecha] as date) = 2024-09-23 00:00:06.000)"} [2024-09-23 20:38:58] local.ERROR: Error al intentar eliminar la cobranza {"error":"SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [eseliminado] = 1, [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:38:58, [ipmodifica] = 38.187.11.45 where [recibo] = 5 and [idsocio] = 4 and cast([fecha] as date) = 2024-09-23 00:00:06)"} [2024-09-23 20:40:15] local.ERROR: Error al intentar eliminar la cobranza {"error":"SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [eseliminado] = 1, [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23 20:40:15, [ipmodifica] = 38.187.11.45 where [recibo] = 5 and [idsocio] = 4 and cast([fecha] as date) = 2024-09-23)"} [2024-09-23 20:40:56] local.ERROR: Error al intentar eliminar la cobranza {"error":"SQLSTATE[22007]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo. (Connection: sqlsrv, SQL: update [cobranza_mercado] set [eseliminado] = 1, [idusuariomodifica] = 1, [fechamodifica] = 2024-09-23, [ipmodifica] = 38.187.11.45 where [recibo] = 5 and [idsocio] = 4)"} [2024-09-23 20:42:12] local.INFO: Cobranza actualizada correctamente {"recibo":"5","idsocio":"4","fecha":"2024-09-23 00:00:06.000","filas_actualizadas":2} [2024-09-23 20:42:29] local.INFO: Cobranza actualizada correctamente {"recibo":"4","idsocio":"4","fecha":"2024-09-22 23:58:07.000","filas_actualizadas":3} [2024-09-23 20:42:31] local.INFO: Cobranza actualizada correctamente {"recibo":"1","idsocio":"4","fecha":"2024-09-22 12:51:34.000","filas_actualizadas":2} [2024-09-23 20:43:04] local.INFO: Cobranza actualizada correctamente {"recibo":"2","idsocio":"4","fecha":"2024-09-22 17:30:49.000","filas_actualizadas":2} [2024-09-23 20:53:13] local.INFO: Cobranza actualizada correctamente {"recibo":"1","idsocio":"329","fecha":"2024-09-22 13:16:04.000","filas_actualizadas":1} [2024-09-24 01:57:18] local.INFO: Cobranza actualizada correctamente {"recibo":"8","idsocio":"4","fecha":"2024-09-23 22:48:41.000","filas_actualizadas":1}