[2025-03-04 00:52:48] 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, ?, ?, EM009, , 4029, 2025-03-04 00:52:34, ?, , {\"connoteNo\":\"ERD146933505MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM009\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-04 00:52:34\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-04 00:52:48, 2025-03-04 00:52:48))"  
[2025-03-04 00:52:50] 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, ?, ?, EM009, , 4029, 2025-03-04 00:52:34, ?, , {\"connoteNo\":\"ERD146943471MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM009\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-04 00:52:34\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-04 00:52:50, 2025-03-04 00:52:50))"  
[2025-03-04 02:27: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 (?, ERD146933505MY, ?, ?, EM009, , 4029, 2025-03-04 02:27:41, ?, , {\"connoteNo\":\"ERD146933505MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM009\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-04 02:27:41\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-04 02:27:55, 2025-03-04 02:27:55))"  
[2025-03-04 14:14:33] production.INFO: ninjavan created order27085 {"requested_tracking_number":"27085","tracking_number":"NVMYOBS3S000027085","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27085-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":"Nabilah","phone_number":"+60177564523","email":"","address":{"address1":"Madrasah Tahfiz Al-quran At-Tanwiriah","address2":"Jalan Temenggong Ahmad ,  , Johor","country":"MY"},"sort_code":"ST"},"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.04},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-03-04 20:02: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 (?, ERD146619668MY, ?, ?, EM053, , 9345, 2025-03-04 19:58:59, ?, , {\"connoteNo\":\"ERD146619668MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM053\",\"reasonCode\":\"\",\"officeCode\":\"9345\",\"dateTime\":\"2025-03-04 19:58:59\",\"remark\":\"\",\"receiverName\":\"NUR AINUL\",\"receiverId\":\"0000\",\"receiverSignature\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/sog?connoteNo=ERD146619668MY\",\"epod\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/epod?id=cf32fb370fc62cb36be2c0b55bf19923b59f969ebf8498a07e49b1deda60b19cee13fc899855bce547d75ac87b82017136c1b53d2bfabe8c02c2b2756ae6d7c418b1a83d73e7e34991018dfa9eed77bc\"}, 2025-03-04 20:02:06, 2025-03-04 20:02:06))"