[2025-03-03 11:54:27] 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, ?, ?, EM004, , 2804, 2025-03-03 11:54:25, ?, , {\"connoteNo\":\"ERD146943471MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM004\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-03 11:54:25\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-03 11:54:27, 2025-03-03 11:54:27))"  
[2025-03-03 11:54:27] 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, ?, ?, EM004, , 2804, 2025-03-03 11:54:25, ?, , {\"connoteNo\":\"ERD146933505MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM004\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-03 11:54:25\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-03 11:54:27, 2025-03-03 11:54:27))"  
[2025-03-03 14:06:00] production.INFO: ninjavan created order27074 {"requested_tracking_number":"27074","tracking_number":"NVMYOBS3S000027074","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27074-030325"},"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":"Hawaa Abdullah","phone_number":"+60105456421","email":"","address":{"address1":"BLK A 21-01 , LARKIN UTAMA CONDOMINIUM","address2":"JALAN ABDUL RAZAK, SUSUR 5 ,  ,  , Johor","country":"MY"},"sort_code":"ST"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-04","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-05","delivery_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"delivery_instructions":"-","allow_weekend_delivery":true,"dimensions":{"weight":0.2},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-03-03 14:06:02] production.INFO: ninjavan created order27066 {"requested_tracking_number":"27066","tracking_number":"NVMYOBS3S000027066","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27066-020325"},"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":"norlin binti kadir","phone_number":"+60103183585","email":"","address":{"address1":"no.12-037 perumahan dara perwira jaya","address2":"felda selancar 1 ,  ,  , Pahang","country":"MY"},"sort_code":"EC"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-04","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-05","delivery_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"delivery_instructions":"-","allow_weekend_delivery":true,"dimensions":{"weight":0.38},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-03-03 14:06:02] production.INFO: ninjavan created order27064 {"requested_tracking_number":"27064","tracking_number":"NVMYOBS3S000027064","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27064-020325"},"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":"Meryam Omar","phone_number":"+60148409962","email":"","address":{"address1":"Lot 3733, Belakang SMKA Syeikh Abdul Malek","address2":"Kuala Terengganu ,  ,  , Terengganu","country":"MY"},"sort_code":"EC"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-04","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-05","delivery_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"delivery_instructions":"-","allow_weekend_delivery":true,"dimensions":{"weight":0.05},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-03-03 14:06:03] production.INFO: ninjavan created order27063 {"requested_tracking_number":"27063","tracking_number":"NVMYOBS3S000027063","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27063-020325"},"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":"Saleha bt Muhamed","phone_number":"+60167066273","email":"","address":{"address1":"Lot 5842 Jalan Limau Manis","address2":"Kg Oren Ulu Tiram ,  ,  , Johor","country":"MY"},"sort_code":"ST"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-04","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-05","delivery_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"delivery_instructions":"-","allow_weekend_delivery":true,"dimensions":{"weight":0.28},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-03-03 14:10:13] 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 (?, ERD146619668MY, ?, ?, EM076, AEX43, 9312, 2025-03-03 14:10:12, ?, , {\"connoteNo\":\"ERD146619668MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM076\",\"reasonCode\":\"AEX43\",\"officeCode\":\"9312\",\"dateTime\":\"2025-03-03 14:10:12\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-03 14:10:13, 2025-03-03 14:10:13))"  
[2025-03-03 19:36: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 (?, ERD146933505MY, ?, ?, EM005, , 2804, 2025-03-03 19:35:48, ?, , {\"connoteNo\":\"ERD146933505MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-03 19:35:48\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-03 19:36:54, 2025-03-03 19:36:54))"  
[2025-03-03 19:36:55] 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, ?, ?, EM005, , 2804, 2025-03-03 19:35:48, ?, , {\"connoteNo\":\"ERD146943471MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-03 19:35:48\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-03 19:36:55, 2025-03-03 19:36:55))"