[2022-08-24 05:20:07] local.INFO: Kode Scan Sah : $2y$10$VpQoP3IaToHK109tOPlEyOhZKC36CAglIG5XB59B/CCSNFNWM3Ucm [2022-08-24 05:32:48] local.INFO: 110521001 -> Kode Scan Sah : $2y$10$QFnYPVLSOfHrkcwuCnNyBObLpj3cuRuLLEIXrGTk5Grrfr2NSejhq [2022-08-24 05:32:48] local.ERROR: PDOException: SQLSTATE[22001]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]String or binary data would be truncated. in D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\database\Connection.php:463 Stack trace: #0 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\database\Connection.php(463): PDOStatement->execute() #1 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\database\Connection.php(662): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\database\Connection.php(629): Illuminate\Database\Connection->runQueryCallback() #3 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\database\Connection.php(464): Illuminate\Database\Connection->run() #4 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\database\Connection.php(416): Illuminate\Database\Connection->statement() #5 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\database\Query\Processors\SqlServerProcessor.php(24): Illuminate\Database\Connection->insert() #6 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\database\Query\Builder.php(2695): Illuminate\Database\Query\Processors\SqlServerProcessor->processInsertGetId() #7 D:\xampp\htdocs\masterweb_android_api\app\Http\Controllers\PgwController.php(224): Illuminate\Database\Query\Builder->insertGetId() #8 [internal function]: App\Http\Controllers\PgwController->inputAbsenPgw() #9 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\container\BoundMethod.php(32): call_user_func_array() #10 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\container\Util.php(36): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #11 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\container\BoundMethod.php(90): Illuminate\Container\Util::unwrapIfClosure() #12 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\container\BoundMethod.php(34): Illuminate\Container\BoundMethod::callBoundMethod() #13 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\container\Container.php(590): Illuminate\Container\BoundMethod::call() #14 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(376): Illuminate\Container\Container->call() #15 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(342): Laravel\Lumen\Application->callControllerCallable() #16 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(316): Laravel\Lumen\Application->callLumenController() #17 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(278): Laravel\Lumen\Application->callControllerAction() #18 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(263): Laravel\Lumen\Application->callActionOnArrayBasedRoute() #19 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(165): Laravel\Lumen\Application->handleFoundRoute() #20 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(416): Laravel\Lumen\Application->Laravel\Lumen\Concerns\{closure}() #21 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(171): Laravel\Lumen\Application->sendThroughPipeline() #22 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(108): Laravel\Lumen\Application->dispatch() #23 D:\xampp\htdocs\masterweb_android_api\public\index.php(28): Laravel\Lumen\Application->run() #24 {main} Next Illuminate\Database\QueryException: SQLSTATE[22001]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]String or binary data would be truncated. (SQL: insert into [pgw_presensi_utama] ([fk_pgw_master], [kd_sekolah], [jam_datang], [tanggal_absen], [lat], [long], [updated_time], [lokasi_datang]) values (110521001, $2y$10$QFnYPVLSOfHrkcwuCnNyBObLpj3cuRuLLEIXrGTk5Grrfr2NSejhq, 12:32, 2022-08-24, -8.0493684, 112.6328942, 2022-08-24 05:32:48, -8.0493684, 112.6328942)) in D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\database\Connection.php:669 Stack trace: #0 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\database\Connection.php(629): Illuminate\Database\Connection->runQueryCallback() #1 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\database\Connection.php(464): Illuminate\Database\Connection->run() #2 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\database\Connection.php(416): Illuminate\Database\Connection->statement() #3 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\database\Query\Processors\SqlServerProcessor.php(24): Illuminate\Database\Connection->insert() #4 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\database\Query\Builder.php(2695): Illuminate\Database\Query\Processors\SqlServerProcessor->processInsertGetId() #5 D:\xampp\htdocs\masterweb_android_api\app\Http\Controllers\PgwController.php(224): Illuminate\Database\Query\Builder->insertGetId() #6 [internal function]: App\Http\Controllers\PgwController->inputAbsenPgw() #7 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\container\BoundMethod.php(32): call_user_func_array() #8 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\container\Util.php(36): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #9 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\container\BoundMethod.php(90): Illuminate\Container\Util::unwrapIfClosure() #10 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\container\BoundMethod.php(34): Illuminate\Container\BoundMethod::callBoundMethod() #11 D:\xampp\htdocs\masterweb_android_api\vendor\illuminate\container\Container.php(590): Illuminate\Container\BoundMethod::call() #12 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(376): Illuminate\Container\Container->call() #13 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(342): Laravel\Lumen\Application->callControllerCallable() #14 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(316): Laravel\Lumen\Application->callLumenController() #15 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(278): Laravel\Lumen\Application->callControllerAction() #16 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(263): Laravel\Lumen\Application->callActionOnArrayBasedRoute() #17 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(165): Laravel\Lumen\Application->handleFoundRoute() #18 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(416): Laravel\Lumen\Application->Laravel\Lumen\Concerns\{closure}() #19 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(171): Laravel\Lumen\Application->sendThroughPipeline() #20 D:\xampp\htdocs\masterweb_android_api\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(108): Laravel\Lumen\Application->dispatch() #21 D:\xampp\htdocs\masterweb_android_api\public\index.php(28): Laravel\Lumen\Application->run() #22 {main} {"exception":"[object] (Illuminate\\Database\\QueryException(code: 22001): SQLSTATE[22001]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]String or binary data would be truncated. (SQL: insert into [pgw_presensi_utama] ([fk_pgw_master], [kd_sekolah], [jam_datang], [tanggal_absen], [lat], [long], [updated_time], [lokasi_datang]) values (110521001, $2y$10$QFnYPVLSOfHrkcwuCnNyBObLpj3cuRuLLEIXrGTk5Grrfr2NSejhq, 12:32, 2022-08-24, -8.0493684, 112.6328942, 2022-08-24 05:32:48, -8.0493684, 112.6328942)) at D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\database\\Connection.php:669) [stacktrace] #0 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\database\\Connection.php(629): Illuminate\\Database\\Connection->runQueryCallback() #1 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\database\\Connection.php(464): Illuminate\\Database\\Connection->run() #2 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\database\\Connection.php(416): Illuminate\\Database\\Connection->statement() #3 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\database\\Query\\Processors\\SqlServerProcessor.php(24): Illuminate\\Database\\Connection->insert() #4 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\database\\Query\\Builder.php(2695): Illuminate\\Database\\Query\\Processors\\SqlServerProcessor->processInsertGetId() #5 D:\\xampp\\htdocs\\masterweb_android_api\\app\\Http\\Controllers\\PgwController.php(224): Illuminate\\Database\\Query\\Builder->insertGetId() #6 [internal function]: App\\Http\\Controllers\\PgwController->inputAbsenPgw() #7 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\container\\BoundMethod.php(32): call_user_func_array() #8 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #9 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure() #10 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod() #11 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\container\\Container.php(590): Illuminate\\Container\\BoundMethod::call() #12 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(376): Illuminate\\Container\\Container->call() #13 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(342): Laravel\\Lumen\\Application->callControllerCallable() #14 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(316): Laravel\\Lumen\\Application->callLumenController() #15 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(278): Laravel\\Lumen\\Application->callControllerAction() #16 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(263): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute() #17 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->handleFoundRoute() #18 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(416): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}() #19 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(171): Laravel\\Lumen\\Application->sendThroughPipeline() #20 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(108): Laravel\\Lumen\\Application->dispatch() #21 D:\\xampp\\htdocs\\masterweb_android_api\\public\\index.php(28): Laravel\\Lumen\\Application->run() #22 {main} [previous exception] [object] (PDOException(code: 22001): SQLSTATE[22001]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]String or binary data would be truncated. at D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\database\\Connection.php:463) [stacktrace] #0 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\database\\Connection.php(463): PDOStatement->execute() #1 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\database\\Connection.php(662): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\database\\Connection.php(629): Illuminate\\Database\\Connection->runQueryCallback() #3 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\database\\Connection.php(464): Illuminate\\Database\\Connection->run() #4 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\database\\Connection.php(416): Illuminate\\Database\\Connection->statement() #5 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\database\\Query\\Processors\\SqlServerProcessor.php(24): Illuminate\\Database\\Connection->insert() #6 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\database\\Query\\Builder.php(2695): Illuminate\\Database\\Query\\Processors\\SqlServerProcessor->processInsertGetId() #7 D:\\xampp\\htdocs\\masterweb_android_api\\app\\Http\\Controllers\\PgwController.php(224): Illuminate\\Database\\Query\\Builder->insertGetId() #8 [internal function]: App\\Http\\Controllers\\PgwController->inputAbsenPgw() #9 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\container\\BoundMethod.php(32): call_user_func_array() #10 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\container\\Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #11 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\container\\BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure() #12 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod() #13 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\illuminate\\container\\Container.php(590): Illuminate\\Container\\BoundMethod::call() #14 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(376): Illuminate\\Container\\Container->call() #15 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(342): Laravel\\Lumen\\Application->callControllerCallable() #16 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(316): Laravel\\Lumen\\Application->callLumenController() #17 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(278): Laravel\\Lumen\\Application->callControllerAction() #18 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(263): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute() #19 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->handleFoundRoute() #20 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(416): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}() #21 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(171): Laravel\\Lumen\\Application->sendThroughPipeline() #22 D:\\xampp\\htdocs\\masterweb_android_api\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(108): Laravel\\Lumen\\Application->dispatch() #23 D:\\xampp\\htdocs\\masterweb_android_api\\public\\index.php(28): Laravel\\Lumen\\Application->run() #24 {main} "} [2022-08-24 05:34:33] local.INFO: 110521001 -> Kode Scan Sah : $2y$10$QFnYPVLSOfHrkcwuCnNyBObLpj3cuRuLLEIXrGTk5Grrfr2NSejhq [2022-08-24 05:36:32] local.INFO: 110521001 -> Kode Scan Sah : $2y$10$QFnYPVLSOfHrkcwuCnNyBObLpj3cuRuLLEIXrGTk5Grrfr2NSejhq [2022-08-24 05:37:26] local.INFO: 110521001 -> Kode Scan Sah : $2y$10$6flg1PjlVv8d/2jDjYAwG.ytLC8nN2rJWoEyEz1ny2bqjLaGYFlle [2022-08-24 05:38:17] local.INFO: 110521001 -> Kode Scan Tidak Sah : 20533640 [2022-08-24 05:43:16] local.INFO: 110521001 -> Kode Scan Tidak Sah : 20533640 [2022-08-24 06:17:42] local.INFO: 110521001 -> Kode Scan Sah : $2y$10$5ju0iLKJ.xGdw3n9FKpkc.7XR7qxfUBt.JLSkSaaUmiLdPSRCA9F2 [2022-08-24 06:18:18] local.INFO: 110521001 -> Kode Scan Tidak Sah : 20533640 [2022-08-24 06:18:25] local.INFO: 110521001 -> Kode Scan Tidak Sah : 20533640 [2022-08-24 06:18:38] local.INFO: 110521001 -> Kode Scan Tidak Sah : 20533640 [2022-08-24 06:47:18] local.INFO: 110521001 -> Kode Scan Tidak Sah : 20533640 [2022-08-24 06:47:34] local.INFO: 110521001 -> Kode Scan Sah : $2y$10$jrgPByPn2EmgyscCX.twie7pEPQLvMb8Qth3PbNeIqgJUJdlUovsK [2022-08-24 11:14:39] local.INFO: 110521001 -> Kode Scan Sah : $2y$10$TRf8l64jcq7KPHyHxqNlw.moWoBTGpPpPHeBqvbvBzRAivCz8wf6i [2022-08-24 11:15:11] local.INFO: 110521001 -> Kode Scan Tidak Sah : 20533640 [2022-08-24 11:15:16] local.INFO: 110521001 -> Kode Scan Tidak Sah : 20533640