[2025-05-09 10:14:30] production.INFO: ninjavan created order27951 {"requested_tracking_number":"27951","tracking_number":"NVMYOBS3S000027951","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27951-080525"},"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":"Siti Zaleha Osman","phone_number":"+60123582803","email":"","address":{"address1":"4-12, Residensi Kerinchi, Jalan Kerinchi Kiri 1,","address2":"Bangsar South, 59200 Kuala Lumpur ,  ,  , Kuala Lumpur","country":"MY"},"sort_code":"KV"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-05-09","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-05-10","delivery_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"delivery_instructions":"-","allow_weekend_delivery":true,"dimensions":{"weight":1.53},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-05-09 14:55: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 (?, ERD155537803MY, ?, ?, EM004, , 2804, 2025-05-09 14:55:06, ?, , {\"connoteNo\":\"ERD155537803MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM004\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-05-09 14:55:06\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-05-09 14:55:07, 2025-05-09 14:55:07))"  
[2025-05-09 19:03:22] 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 (?, ERD155537803MY, ?, ?, EM005, , 2804, 2025-05-09 19:02:53, ?, , {\"connoteNo\":\"ERD155537803MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-05-09 19:02:53\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-05-09 19:03:22, 2025-05-09 19:03:22))"