[2025-03-05 09:09:00] production.INFO: ninjavan created order27094 {"requested_tracking_number":"27094","tracking_number":"NVMYOBS3S000027094","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27094-040325"},"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":"Izzah Binti Bahari","phone_number":"+60139715998","email":"","address":{"address1":"No 17, Jalan Keruing 4A, Taman Keruing, 44200, Rasa, Selangor","address2":" ,  ,  , Selangor","country":"MY"},"sort_code":"KV"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-05","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-06","delivery_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"delivery_instructions":"-","allow_weekend_delivery":true,"dimensions":{"weight":0.1},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-03-05 11:23:17] 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, ?, ?, EM005, , 9807, 2025-03-05 11:22:56, ?, , {\"connoteNo\":\"ERD146933505MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"9807\",\"dateTime\":\"2025-03-05 11:22:56\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-05 11:23:17, 2025-03-05 11:23:17))"  
[2025-03-05 11:36:57] 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 (?, ERD146943471MY, ?, ?, EM013, , 7701, 2025-03-05 11:36:43, ?, , {\"connoteNo\":\"ERD146943471MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM013\",\"reasonCode\":\"\",\"officeCode\":\"7701\",\"dateTime\":\"2025-03-05 11:36:43\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-05 11:36:57, 2025-03-05 11:36:57))"  
[2025-03-05 14:12:31] production.INFO: Failed to create batch GDEX consignment due to wrong shipping address. order id 27098.{"s":"fail","r":"","e":"The ReceiverCountry field is required., The ReceiverPostcode field is required."}  
[2025-03-05 14:21:54] production.INFO: ninjavan created order27099 {"requested_tracking_number":"27099","tracking_number":"NVMYOBS3S000027099","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27099-050325"},"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":"Asyiqin Bt Abd wahab","phone_number":"+601111979571","email":"","address":{"address1":"282, Jalan Nusari Bayu 1/4","address2":"Bandar Sri Sendayan, Seremban ,  ,  , Negeri Sembilan","country":"MY"},"sort_code":"ST"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-06","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-07","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-05 14:22:41] production.INFO: ninjavan created order27104 {"requested_tracking_number":"27104","tracking_number":"NVMYOBS3S000027104","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27104-050325"},"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":"husna","phone_number":"+60197544143","email":"","address":{"address1":"No 115, Jalan Midah Barat,","address2":"Taman Midah,cheras ,  ,  , Kuala Lumpur","country":"MY"},"sort_code":"KV"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-06","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-07","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-05 14:35: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 (?, ERD147498095MY, ?, ?, EM004, , 2804, 2025-03-05 14:35:27, ?, , {\"connoteNo\":\"ERD147498095MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM004\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-05 14:35:27\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-05 14:35:29, 2025-03-05 14:35:29))"  
[2025-03-05 14:35: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, ?, ?, EM004, , 2804, 2025-03-05 14:35:27, ?, , {\"connoteNo\":\"ERD147281125MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM004\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-05 14:35:27\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-05 14:35:29, 2025-03-05 14:35:29))"  
[2025-03-05 14:35:30] 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, ?, ?, EM004, , 2804, 2025-03-05 14:35:27, ?, , {\"connoteNo\":\"ERD147192221MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM004\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-05 14:35:27\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-05 14:35:30, 2025-03-05 14:35:30))"  
[2025-03-05 16:17:58] 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 (?, ERD146943471MY, ?, ?, EM053, , 7701, 2025-03-05 16:17:53, ?, , {\"connoteNo\":\"ERD146943471MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM053\",\"reasonCode\":\"\",\"officeCode\":\"7701\",\"dateTime\":\"2025-03-05 16:17:53\",\"remark\":\"\",\"receiverName\":\"Akmalina\",\"receiverId\":\"\",\"receiverSignature\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/sog?connoteNo=ERD146943471MY\",\"epod\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/epod?id=cf32fb370fc62cb36be2c0b55bf1992336a2076d8882b1d9d608c473a87532402c72f6b4761d4b00c702562582e0e316dfc18c5a7b57e43834451e0feba819cbf01ef57cc7db079fd2547326e00029b0\"}, 2025-03-05 16:17:58, 2025-03-05 16:17:58))"  
[2025-03-05 18:33:54] 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, , 2804, 2025-03-05 18:32:33, ?, , {\"connoteNo\":\"ERD147498095MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-05 18:32:33\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-05 18:33:54, 2025-03-05 18:33:54))"  
[2025-03-05 18:33:54] 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, ?, ?, EM005, , 2804, 2025-03-05 18:32:33, ?, , {\"connoteNo\":\"ERD147192221MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-05 18:32:33\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-05 18:33:54, 2025-03-05 18:33:54))"  
[2025-03-05 18:33:54] 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, , 2804, 2025-03-05 18:32:33, ?, , {\"connoteNo\":\"ERD147281125MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-05 18:32:33\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-05 18:33:54, 2025-03-05 18:33:54))"