[2025-03-07 00:00:23] 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, ?, ?, EM009, , 4029, 2025-03-06 23:59:11, ?, , {\"connoteNo\":\"ERD146930075MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM009\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-06 23:59:11\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-07 00:00:23, 2025-03-07 00:00:23))"  
[2025-03-07 00:01: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, ?, ?, EM009, , 4029, 2025-03-06 23:59:11, ?, , {\"connoteNo\":\"ERD146930075MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM009\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-06 23:59:11\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-07 00:01:07, 2025-03-07 00:01:07))"  
[2025-03-07 10:06:41] production.INFO: Failed to create batch GDEX consignment due to wrong shipping address. order id 27131.{"s":"fail","r":"","e":"The ReceiverCountry field is required., The ReceiverPostcode field is required."}  
[2025-03-07 10:08:19] production.INFO: ninjavan created order27133 {"requested_tracking_number":"27133","tracking_number":"NVMYOBS3S000027133","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27133-060325"},"from":{"name":"Obsess Cosmetics","phone_number":"+60166002969","email":"obsess2you@gmail.com","address":{"address1":"No.79, Jalan Zapin Utama","address2":"Bandar Inderapura ,  , Jerantut , Pahang","country":"MY"}},"to":{"name":"KakSally","phone_number":"+60139033033","email":"","address":{"address1":"Lot 2152 Kg Larak","address2":"Jalan Cabang 3 Pendek, Kota Bharu ,  ,  , Kelantan","country":"MY"},"sort_code":"EC"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-07","pickup_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"pickup_approximate_volume":"Less than 3 Parcels","pickup_instructions":"Pickup with care!","delivery_start_date":"2025-03-08","delivery_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"delivery_instructions":"-","allow_weekend_delivery":true,"dimensions":{"weight":0.09},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-03-07 10:36:09] 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, ?, ?, EM013, , 1200, 2025-03-07 10:36:03, ?, , {\"connoteNo\":\"ERD146930075MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM013\",\"reasonCode\":\"\",\"officeCode\":\"1200\",\"dateTime\":\"2025-03-07 10:36:03\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-07 10:36:09, 2025-03-07 10:36:09))"  
[2025-03-07 11:19:02] 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, ?, ?, EM053, , 1200, 2025-03-07 11:18:57, ?, , {\"connoteNo\":\"ERD146930075MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM053\",\"reasonCode\":\"\",\"officeCode\":\"1200\",\"dateTime\":\"2025-03-07 11:18:57\",\"remark\":\"\",\"receiverName\":\"amir saifudin\",\"receiverId\":\"\",\"receiverSignature\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/sog?connoteNo=ERD146930075MY\",\"epod\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/epod?id=cf32fb370fc62cb36be2c0b55bf19923ec67a6acbd04a8e7a82916a3681bfa03e3188de13a09d013c700d9a3f9e9e8e93d017336b4eb02524d4fb2e63b240fb96daccf255ce0265096cc45187d0507ef\"}, 2025-03-07 11:19:02, 2025-03-07 11:19:02))"  
[2025-03-07 11:56:32] 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 (?, ERD147691417MY, ?, ?, EM004, , 2804, 2025-03-07 11:56:31, ?, , {\"connoteNo\":\"ERD147691417MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM004\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-07 11:56:31\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-07 11:56:32, 2025-03-07 11:56:32))"  
[2025-03-07 19:01: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 (?, ERD147691417MY, ?, ?, EM005, , 2804, 2025-03-07 19:00:41, ?, , {\"connoteNo\":\"ERD147691417MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-07 19:00:41\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-07 19:01:29, 2025-03-07 19:01:29))"