[2025-03-10 10:56:52] 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, ?, ?, EM013, , 9346, 2025-03-10 10:56:47, ?, , {\"connoteNo\":\"ERD147498095MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM013\",\"reasonCode\":\"\",\"officeCode\":\"9346\",\"dateTime\":\"2025-03-10 10:56:47\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-10 10:56:52, 2025-03-10 10:56:52))"  
[2025-03-10 11:36: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 (?, ERD147498095MY, ?, ?, EM053, , 9346, 2025-03-10 11:35:56, ?, , {\"connoteNo\":\"ERD147498095MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM053\",\"reasonCode\":\"\",\"officeCode\":\"9346\",\"dateTime\":\"2025-03-10 11:35:56\",\"remark\":\"\",\"receiverName\":\"Ticer Izzati\",\"receiverId\":\"\",\"receiverSignature\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/sog?connoteNo=ERD147498095MY\",\"epod\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/epod?id=cf32fb370fc62cb36be2c0b55bf199233bf676ca2db6d84fbfeb06a322f8ac30e8186f9326b6b22290c3710faf506a4ab52c76df64c7814e7af7178fc82dff4d80bda461a65a841dd9e6fed921a264a7\"}, 2025-03-10 11:36:04, 2025-03-10 11:36:04))"  
[2025-03-10 11:40:32] production.INFO: ninjavan created order27155 {"requested_tracking_number":"27155","tracking_number":"NVMYOBS3S000027155","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27155-090325"},"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":"Nurlin","phone_number":"+60179020749","email":"","address":{"address1":"no 3 lorong bukit setongkol 49 ,","address2":"taman cenderawasih indah,kuantan ,  ,  , Pahang","country":"MY"},"sort_code":"EC"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-11","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-12","delivery_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"delivery_instructions":"-","allow_weekend_delivery":true,"dimensions":{"weight":0.06},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-03-10 11:40:33] production.INFO: ninjavan created order27141 {"requested_tracking_number":"27141","tracking_number":"NVMYOBS3S000027141","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27141-080325"},"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":"Nurafifah Binti Jamaluddin","phone_number":"+60104292867","email":"","address":{"address1":"48 PPSK Rumpun Makmur","address2":" ,  ,  , Pahang","country":"MY"},"sort_code":"EC"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-11","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-12","delivery_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"delivery_instructions":"-","allow_weekend_delivery":true,"dimensions":{"weight":0.16},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-03-10 11:40:34] production.INFO: ninjavan created order27139 {"requested_tracking_number":"27139","tracking_number":"NVMYOBS3S000027139","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27139-070325"},"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":"Raidah Razak","phone_number":"+60136915920","email":"","address":{"address1":"Lot 2375 kampung telaga bata","address2":" ,  ,  , Kelantan","country":"MY"},"sort_code":"EC"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-11","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-12","delivery_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"delivery_instructions":"-","allow_weekend_delivery":true,"dimensions":{"weight":0.21},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-03-10 11:40:35] production.INFO: ninjavan created order27137 {"requested_tracking_number":"27137","tracking_number":"NVMYOBS3S000027137","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27137-070325"},"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":"FARINA FUAD","phone_number":"+60175259782","email":"","address":{"address1":"NO 104 JALAN DALMA 3","address2":"TAMAN DALMA ,  ,  , Selangor","country":"MY"},"sort_code":"KV"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-11","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-12","delivery_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"delivery_instructions":"-","allow_weekend_delivery":true,"dimensions":{"weight":0.36},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-03-10 15:01:08] 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 (?, ERD148188869MY, ?, ?, EM004, , 2804, 2025-03-10 15:00:12, ?, , {\"connoteNo\":\"ERD148188869MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM004\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-10 15:00:12\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-10 15:01:08, 2025-03-10 15:01:08))"  
[2025-03-10 15:01: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 (?, ERD147849486MY, ?, ?, EM004, , 2804, 2025-03-10 15:00:12, ?, , {\"connoteNo\":\"ERD147849486MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM004\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-10 15:00:12\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-10 15:01:09, 2025-03-10 15:01:09))"  
[2025-03-10 15:01:10] 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 (?, ERD147995360MY, ?, ?, EM004, , 2804, 2025-03-10 15:00:12, ?, , {\"connoteNo\":\"ERD147995360MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM004\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-10 15:00:12\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-10 15:01:10, 2025-03-10 15:01:10))"  
[2025-03-10 15:21: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 (?, ERD147691417MY, ?, ?, EM053, , 4709, 2025-03-10 15:19:15, ?, , {\"connoteNo\":\"ERD147691417MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM053\",\"reasonCode\":\"\",\"officeCode\":\"4709\",\"dateTime\":\"2025-03-10 15:19:15\",\"remark\":\"\",\"receiverName\":\"NURSHAHIRA\",\"receiverId\":\"0000\",\"receiverSignature\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/sog?connoteNo=ERD147691417MY\",\"epod\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/epod?id=cf32fb370fc62cb36be2c0b55bf19923b010329823d18e0440f5d6e730bf6281238b359e2012b76663e3769390e237355da1a5e4ba185b916b626098d503b3f4284c816ed292e3769a88b5681838da3e\"}, 2025-03-10 15:21:09, 2025-03-10 15:21:09))"