[2025-03-06 00:14:29] production.INFO: "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'subscriptionID' cannot be null (SQL: insert into `poslaju_order_trackings` (`twsID`, `connoteNo`, `subscriptionID`, `otherInfo`, `eventCode`, `reasonCode`, `officeCode`, `dateTime`, `status`, `remark`, `response`, `updated_at`, `created_at`) values (?, ERD147281125MY, ?, ?, EM009, , 4029, 2025-03-06 00:06:43, ?, , {\"connoteNo\":\"ERD147281125MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM009\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-06 00:06:43\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-06 00:14:29, 2025-03-06 00:14:29))" [2025-03-06 00:20:15] production.INFO: "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'subscriptionID' cannot be null (SQL: insert into `poslaju_order_trackings` (`twsID`, `connoteNo`, `subscriptionID`, `otherInfo`, `eventCode`, `reasonCode`, `officeCode`, `dateTime`, `status`, `remark`, `response`, `updated_at`, `created_at`) values (?, ERD147192221MY, ?, ?, EM009, , 4029, 2025-03-06 00:06:43, ?, , {\"connoteNo\":\"ERD147192221MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM009\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-06 00:06:43\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-06 00:20:15, 2025-03-06 00:20:15))" [2025-03-06 00:32:53] production.INFO: "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'subscriptionID' cannot be null (SQL: insert into `poslaju_order_trackings` (`twsID`, `connoteNo`, `subscriptionID`, `otherInfo`, `eventCode`, `reasonCode`, `officeCode`, `dateTime`, `status`, `remark`, `response`, `updated_at`, `created_at`) values (?, ERD147498095MY, ?, ?, EM009, , 4029, 2025-03-06 00:06:44, ?, , {\"connoteNo\":\"ERD147498095MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM009\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-06 00:06:44\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-06 00:32:53, 2025-03-06 00:32:53))" [2025-03-06 03:13:04] production.INFO: "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'subscriptionID' cannot be null (SQL: insert into `poslaju_order_trackings` (`twsID`, `connoteNo`, `subscriptionID`, `otherInfo`, `eventCode`, `reasonCode`, `officeCode`, `dateTime`, `status`, `remark`, `response`, `updated_at`, `created_at`) values (?, ERD147281125MY, ?, ?, EM009, , 4029, 2025-03-06 03:12:12, ?, , {\"connoteNo\":\"ERD147281125MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM009\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-06 03:12:12\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-06 03:13:04, 2025-03-06 03:13:04))" [2025-03-06 03:13:14] production.INFO: "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'subscriptionID' cannot be null (SQL: insert into `poslaju_order_trackings` (`twsID`, `connoteNo`, `subscriptionID`, `otherInfo`, `eventCode`, `reasonCode`, `officeCode`, `dateTime`, `status`, `remark`, `response`, `updated_at`, `created_at`) values (?, ERD147498095MY, ?, ?, EM009, , 4029, 2025-03-06 03:12:10, ?, , {\"connoteNo\":\"ERD147498095MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM009\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-06 03:12:10\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-06 03:13:14, 2025-03-06 03:13:14))" [2025-03-06 04:07:07] production.INFO: "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'subscriptionID' cannot be null (SQL: insert into `poslaju_order_trackings` (`twsID`, `connoteNo`, `subscriptionID`, `otherInfo`, `eventCode`, `reasonCode`, `officeCode`, `dateTime`, `status`, `remark`, `response`, `updated_at`, `created_at`) values (?, ERD147498095MY, ?, ?, EM005, , 4029, 2025-03-06 04:05:07, ?, , {\"connoteNo\":\"ERD147498095MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-06 04:05:07\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-06 04:07:07, 2025-03-06 04:07:07))" [2025-03-06 04:30:45] production.INFO: "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'subscriptionID' cannot be null (SQL: insert into `poslaju_order_trackings` (`twsID`, `connoteNo`, `subscriptionID`, `otherInfo`, `eventCode`, `reasonCode`, `officeCode`, `dateTime`, `status`, `remark`, `response`, `updated_at`, `created_at`) values (?, ERD147281125MY, ?, ?, EM005, , 4029, 2025-03-06 04:30:08, ?, , {\"connoteNo\":\"ERD147281125MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-06 04:30:08\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-06 04:30:45, 2025-03-06 04:30:45))" [2025-03-06 08:53:50] production.INFO: "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'subscriptionID' cannot be null (SQL: insert into `poslaju_order_trackings` (`twsID`, `connoteNo`, `subscriptionID`, `otherInfo`, `eventCode`, `reasonCode`, `officeCode`, `dateTime`, `status`, `remark`, `response`, `updated_at`, `created_at`) values (?, ERD146933505MY, ?, ?, EM013, , 9870, 2025-03-06 08:53:39, ?, , {\"connoteNo\":\"ERD146933505MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM013\",\"reasonCode\":\"\",\"officeCode\":\"9870\",\"dateTime\":\"2025-03-06 08:53:39\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-06 08:53:50, 2025-03-06 08:53:50))" [2025-03-06 08:58:31] production.INFO: "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'subscriptionID' cannot be null (SQL: insert into `poslaju_order_trackings` (`twsID`, `connoteNo`, `subscriptionID`, `otherInfo`, `eventCode`, `reasonCode`, `officeCode`, `dateTime`, `status`, `remark`, `response`, `updated_at`, `created_at`) values (?, ERD146933505MY, ?, ?, EM053, , 9870, 2025-03-06 08:57:41, ?, , {\"connoteNo\":\"ERD146933505MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM053\",\"reasonCode\":\"\",\"officeCode\":\"9870\",\"dateTime\":\"2025-03-06 08:57:41\",\"remark\":\"\",\"receiverName\":\"RAHMAN OMAR RUNNER BRUNEI\",\"receiverId\":\"700809135127\",\"receiverSignature\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/sog?connoteNo=ERD146933505MY\",\"epod\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/epod?id=cf32fb370fc62cb36be2c0b55bf1992374e1a7512df19884ca805d8f7943e73928bd21ed59c384cb32e8f468e39ee30fbfc04db87d77d12a458462869e5b2b0a5841854f338a9672e80d235df5895e98\"}, 2025-03-06 08:58:31, 2025-03-06 08:58:31))" [2025-03-06 09:21:13] production.INFO: Failed to create batch GDEX consignment due to wrong shipping address. order id 27117.The specified CGI application encountered an error and the server terminated the process. [2025-03-06 09:26:29] production.INFO: Failed to create batch GDEX consignment due to wrong shipping address. order id 27117.The specified CGI application encountered an error and the server terminated the process. [2025-03-06 14:01:40] production.INFO: "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'subscriptionID' cannot be null (SQL: insert into `poslaju_order_trackings` (`twsID`, `connoteNo`, `subscriptionID`, `otherInfo`, `eventCode`, `reasonCode`, `officeCode`, `dateTime`, `status`, `remark`, `response`, `updated_at`, `created_at`) values (?, ERD146930075MY, ?, ?, EM004, , 2804, 2025-03-06 14:01:39, ?, , {\"connoteNo\":\"ERD146930075MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM004\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-06 14:01:39\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-06 14:01:40, 2025-03-06 14:01:40))" [2025-03-06 14:16:17] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '27117' for key 'order_id' (SQL: insert into `consignments` (`order_id`, `warehouse_id`, `bill_code`, `shipping_type`, `shipped_out`, `created_at`, `updated_at`, `response`) values (27117, 5, MY37249108760, GDEX, 0, 2025-03-06 14:16:17, 2025-03-06 14:16:17, {"s":"success","r":["MY37249108760"],"e":""})) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '27117' for key 'order_id' (SQL: insert into `consignments` (`order_id`, `warehouse_id`, `bill_code`, `shipping_type`, `shipped_out`, `created_at`, `updated_at`, `response`) values (27117, 5, MY37249108760, GDEX, 0, 2025-03-06 14:16:17, 2025-03-06 14:16:17, {\"s\":\"success\",\"r\":[\"MY37249108760\"],\"e\":\"\"})) at /home/obsessco/public_html/order2/vendor/illuminate/database/Connection.php:671) [stacktrace] #0 /home/obsessco/public_html/order2/vendor/illuminate/database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('insert into `co...', Array, Object(Closure)) #1 /home/obsessco/public_html/order2/vendor/illuminate/database/Connection.php(465): Illuminate\\Database\\Connection->run('insert into `co...', Array, Object(Closure)) #2 /home/obsessco/public_html/order2/vendor/illuminate/database/Connection.php(417): Illuminate\\Database\\Connection->statement('insert into `co...', Array) #3 /home/obsessco/public_html/order2/vendor/illuminate/database/Query/Processors/Processor.php(32): Illuminate\\Database\\Connection->insert('insert into `co...', Array) #4 /home/obsessco/public_html/order2/vendor/illuminate/database/Query/Builder.php(2839): Illuminate\\Database\\Query\\Processors\\Processor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert into `co...', Array, 'id') #5 /home/obsessco/public_html/order2/vendor/illuminate/database/Eloquent/Builder.php(1422): Illuminate\\Database\\Query\\Builder->insertGetId(Array, 'id') #6 /home/obsessco/public_html/order2/vendor/illuminate/database/Eloquent/Model.php(902): Illuminate\\Database\\Eloquent\\Builder->__call('insertGetId', Array) #7 /home/obsessco/public_html/order2/vendor/illuminate/database/Eloquent/Model.php(867): Illuminate\\Database\\Eloquent\\Model->insertAndSetId(Object(Illuminate\\Database\\Eloquent\\Builder), Array) #8 /home/obsessco/public_html/order2/vendor/illuminate/database/Eloquent/Model.php(730): Illuminate\\Database\\Eloquent\\Model->performInsert(Object(Illuminate\\Database\\Eloquent\\Builder)) #9 /home/obsessco/public_html/order2/app/Http/Controllers/ConsignmentController.php(887): Illuminate\\Database\\Eloquent\\Model->save() #10 /home/obsessco/public_html/order2/app/Http/Controllers/ConsignmentController.php(189): App\\Http\\Controllers\\ConsignmentController->batchGDEXConsignment(Object(App\\Models\\Consignment), '753') #11 /home/obsessco/public_html/order2/vendor/illuminate/container/BoundMethod.php(36): App\\Http\\Controllers\\ConsignmentController->batchConsignment('GDEX', '27117', '753') #12 /home/obsessco/public_html/order2/vendor/illuminate/container/Util.php(37): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #13 /home/obsessco/public_html/order2/vendor/illuminate/container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #14 /home/obsessco/public_html/order2/vendor/illuminate/container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #15 /home/obsessco/public_html/order2/vendor/illuminate/container/Container.php(596): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #16 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(386): Illuminate\\Container\\Container->call(Array, Array) #17 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(352): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #18 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(326): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\ConsignmentController), 'batchConsignmen...', Array) #19 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(279): Laravel\\Lumen\\Application->callControllerAction(Array) #20 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(264): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #21 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(234): Laravel\\Lumen\\Application->handleFoundRoute(Array) #22 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(170): Laravel\\Lumen\\Application->handleDispatcherResponse(Array) #23 [internal function]: Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #24 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Routing/Pipeline.php(48): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request)) #25 /home/obsessco/public_html/order2/app/Http/Middleware/CorsMiddleware.php(30): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #26 /home/obsessco/public_html/order2/vendor/illuminate/pipeline/Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #27 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #28 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Routing/Pipeline.php(30): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request)) #29 /home/obsessco/public_html/order2/vendor/illuminate/pipeline/Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #30 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(423): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #31 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(172): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #32 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(109): Laravel\\Lumen\\Application->dispatch(NULL) #33 /home/obsessco/public_html/order2/public/index.php(28): Laravel\\Lumen\\Application->run() #34 {main} [previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '27117' for key 'order_id' at /home/obsessco/public_html/order2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18) [stacktrace] #0 /home/obsessco/public_html/order2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\\DBAL\\Driver\\PDO\\Exception::new(Object(PDOException)) #1 /home/obsessco/public_html/order2/vendor/illuminate/database/Connection.php(464): Doctrine\\DBAL\\Driver\\PDOStatement->execute() #2 /home/obsessco/public_html/order2/vendor/illuminate/database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('insert into `co...', Array) #3 /home/obsessco/public_html/order2/vendor/illuminate/database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('insert into `co...', Array, Object(Closure)) #4 /home/obsessco/public_html/order2/vendor/illuminate/database/Connection.php(465): Illuminate\\Database\\Connection->run('insert into `co...', Array, Object(Closure)) #5 /home/obsessco/public_html/order2/vendor/illuminate/database/Connection.php(417): Illuminate\\Database\\Connection->statement('insert into `co...', Array) #6 /home/obsessco/public_html/order2/vendor/illuminate/database/Query/Processors/Processor.php(32): Illuminate\\Database\\Connection->insert('insert into `co...', Array) #7 /home/obsessco/public_html/order2/vendor/illuminate/database/Query/Builder.php(2839): Illuminate\\Database\\Query\\Processors\\Processor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert into `co...', Array, 'id') #8 /home/obsessco/public_html/order2/vendor/illuminate/database/Eloquent/Builder.php(1422): Illuminate\\Database\\Query\\Builder->insertGetId(Array, 'id') #9 /home/obsessco/public_html/order2/vendor/illuminate/database/Eloquent/Model.php(902): Illuminate\\Database\\Eloquent\\Builder->__call('insertGetId', Array) #10 /home/obsessco/public_html/order2/vendor/illuminate/database/Eloquent/Model.php(867): Illuminate\\Database\\Eloquent\\Model->insertAndSetId(Object(Illuminate\\Database\\Eloquent\\Builder), Array) #11 /home/obsessco/public_html/order2/vendor/illuminate/database/Eloquent/Model.php(730): Illuminate\\Database\\Eloquent\\Model->performInsert(Object(Illuminate\\Database\\Eloquent\\Builder)) #12 /home/obsessco/public_html/order2/app/Http/Controllers/ConsignmentController.php(887): Illuminate\\Database\\Eloquent\\Model->save() #13 /home/obsessco/public_html/order2/app/Http/Controllers/ConsignmentController.php(189): App\\Http\\Controllers\\ConsignmentController->batchGDEXConsignment(Object(App\\Models\\Consignment), '753') #14 /home/obsessco/public_html/order2/vendor/illuminate/container/BoundMethod.php(36): App\\Http\\Controllers\\ConsignmentController->batchConsignment('GDEX', '27117', '753') #15 /home/obsessco/public_html/order2/vendor/illuminate/container/Util.php(37): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #16 /home/obsessco/public_html/order2/vendor/illuminate/container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #17 /home/obsessco/public_html/order2/vendor/illuminate/container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #18 /home/obsessco/public_html/order2/vendor/illuminate/container/Container.php(596): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #19 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(386): Illuminate\\Container\\Container->call(Array, Array) #20 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(352): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #21 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(326): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\ConsignmentController), 'batchConsignmen...', Array) #22 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(279): Laravel\\Lumen\\Application->callControllerAction(Array) #23 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(264): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #24 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(234): Laravel\\Lumen\\Application->handleFoundRoute(Array) #25 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(170): Laravel\\Lumen\\Application->handleDispatcherResponse(Array) #26 [internal function]: Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #27 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Routing/Pipeline.php(48): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request)) #28 /home/obsessco/public_html/order2/app/Http/Middleware/CorsMiddleware.php(30): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #29 /home/obsessco/public_html/order2/vendor/illuminate/pipeline/Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #30 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #31 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Routing/Pipeline.php(30): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request)) #32 /home/obsessco/public_html/order2/vendor/illuminate/pipeline/Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #33 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(423): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #34 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(172): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #35 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(109): Laravel\\Lumen\\Application->dispatch(NULL) #36 /home/obsessco/public_html/order2/public/index.php(28): Laravel\\Lumen\\Application->run() #37 {main} [previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '27117' for key 'order_id' at /home/obsessco/public_html/order2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117) [stacktrace] #0 /home/obsessco/public_html/order2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL) #1 /home/obsessco/public_html/order2/vendor/illuminate/database/Connection.php(464): Doctrine\\DBAL\\Driver\\PDOStatement->execute() #2 /home/obsessco/public_html/order2/vendor/illuminate/database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('insert into `co...', Array) #3 /home/obsessco/public_html/order2/vendor/illuminate/database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback('insert into `co...', Array, Object(Closure)) #4 /home/obsessco/public_html/order2/vendor/illuminate/database/Connection.php(465): Illuminate\\Database\\Connection->run('insert into `co...', Array, Object(Closure)) #5 /home/obsessco/public_html/order2/vendor/illuminate/database/Connection.php(417): Illuminate\\Database\\Connection->statement('insert into `co...', Array) #6 /home/obsessco/public_html/order2/vendor/illuminate/database/Query/Processors/Processor.php(32): Illuminate\\Database\\Connection->insert('insert into `co...', Array) #7 /home/obsessco/public_html/order2/vendor/illuminate/database/Query/Builder.php(2839): Illuminate\\Database\\Query\\Processors\\Processor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert into `co...', Array, 'id') #8 /home/obsessco/public_html/order2/vendor/illuminate/database/Eloquent/Builder.php(1422): Illuminate\\Database\\Query\\Builder->insertGetId(Array, 'id') #9 /home/obsessco/public_html/order2/vendor/illuminate/database/Eloquent/Model.php(902): Illuminate\\Database\\Eloquent\\Builder->__call('insertGetId', Array) #10 /home/obsessco/public_html/order2/vendor/illuminate/database/Eloquent/Model.php(867): Illuminate\\Database\\Eloquent\\Model->insertAndSetId(Object(Illuminate\\Database\\Eloquent\\Builder), Array) #11 /home/obsessco/public_html/order2/vendor/illuminate/database/Eloquent/Model.php(730): Illuminate\\Database\\Eloquent\\Model->performInsert(Object(Illuminate\\Database\\Eloquent\\Builder)) #12 /home/obsessco/public_html/order2/app/Http/Controllers/ConsignmentController.php(887): Illuminate\\Database\\Eloquent\\Model->save() #13 /home/obsessco/public_html/order2/app/Http/Controllers/ConsignmentController.php(189): App\\Http\\Controllers\\ConsignmentController->batchGDEXConsignment(Object(App\\Models\\Consignment), '753') #14 /home/obsessco/public_html/order2/vendor/illuminate/container/BoundMethod.php(36): App\\Http\\Controllers\\ConsignmentController->batchConsignment('GDEX', '27117', '753') #15 /home/obsessco/public_html/order2/vendor/illuminate/container/Util.php(37): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #16 /home/obsessco/public_html/order2/vendor/illuminate/container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #17 /home/obsessco/public_html/order2/vendor/illuminate/container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #18 /home/obsessco/public_html/order2/vendor/illuminate/container/Container.php(596): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #19 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(386): Illuminate\\Container\\Container->call(Array, Array) #20 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(352): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #21 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(326): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\ConsignmentController), 'batchConsignmen...', Array) #22 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(279): Laravel\\Lumen\\Application->callControllerAction(Array) #23 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(264): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #24 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(234): Laravel\\Lumen\\Application->handleFoundRoute(Array) #25 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(170): Laravel\\Lumen\\Application->handleDispatcherResponse(Array) #26 [internal function]: Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #27 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Routing/Pipeline.php(48): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request)) #28 /home/obsessco/public_html/order2/app/Http/Middleware/CorsMiddleware.php(30): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #29 /home/obsessco/public_html/order2/vendor/illuminate/pipeline/Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #30 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #31 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Routing/Pipeline.php(30): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request)) #32 /home/obsessco/public_html/order2/vendor/illuminate/pipeline/Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #33 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(423): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #34 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(172): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #35 /home/obsessco/public_html/order2/vendor/laravel/lumen-framework/src/Concerns/RoutesRequests.php(109): Laravel\\Lumen\\Application->dispatch(NULL) #36 /home/obsessco/public_html/order2/public/index.php(28): Laravel\\Lumen\\Application->run() #37 {main} "} [2025-03-06 18:20:07] production.INFO: "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'subscriptionID' cannot be null (SQL: insert into `poslaju_order_trackings` (`twsID`, `connoteNo`, `subscriptionID`, `otherInfo`, `eventCode`, `reasonCode`, `officeCode`, `dateTime`, `status`, `remark`, `response`, `updated_at`, `created_at`) values (?, ERD146930075MY, ?, ?, EM005, , 2804, 2025-03-06 18:19:12, ?, , {\"connoteNo\":\"ERD146930075MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-06 18:19:12\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-06 18:20:07, 2025-03-06 18:20:07))" [2025-03-06 19:05:07] production.INFO: "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'subscriptionID' cannot be null (SQL: insert into `poslaju_order_trackings` (`twsID`, `connoteNo`, `subscriptionID`, `otherInfo`, `eventCode`, `reasonCode`, `officeCode`, `dateTime`, `status`, `remark`, `response`, `updated_at`, `created_at`) values (?, ERD147281125MY, ?, ?, EM053, , 4332, 2025-03-06 19:03:16, ?, , {\"connoteNo\":\"ERD147281125MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM053\",\"reasonCode\":\"\",\"officeCode\":\"4332\",\"dateTime\":\"2025-03-06 19:03:16\",\"remark\":\"\",\"receiverName\":\"NAZLENA\",\"receiverId\":\"0000\",\"receiverSignature\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/sog?connoteNo=ERD147281125MY\",\"epod\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/epod?id=cf32fb370fc62cb36be2c0b55bf19923793e1a98057e231a607e94e457f5b6be25e8559d5ead05e735f20dd614730b1f2cbecdc770227ee6d186bb1c1b7839e1652cd806767099f8742effaa5daab98b\"}, 2025-03-06 19:05:07, 2025-03-06 19:05:07))"