[2025-03-13 09:32:48] production.INFO: ninjavan created order27287 {"requested_tracking_number":"27287","tracking_number":"NVMYOBS3S000027287","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27287-120325"},"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":"Noor Emilia Binti Abdul Hamid","phone_number":"+601153315316","email":"","address":{"address1":"G2-3-B4 BLOK G2","address2":"AMQ REJIMEN TUDM JUGRA BANTING ,  ,  , Selangor","country":"MY"},"sort_code":"KV"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-13","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-14","delivery_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"delivery_instructions":"-","allow_weekend_delivery":true,"dimensions":{"weight":0.45},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-03-13 12:39: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 (?, ERD148188869MY, ?, ?, EM053, , 9700, 2025-03-13 12:37:31, ?, , {\"connoteNo\":\"ERD148188869MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM053\",\"reasonCode\":\"\",\"officeCode\":\"9700\",\"dateTime\":\"2025-03-13 12:37:31\",\"remark\":\"\",\"receiverName\":\"NORAFIZA\",\"receiverId\":\"5876\",\"receiverSignature\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/sog?connoteNo=ERD148188869MY\",\"epod\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/epod?id=cf32fb370fc62cb36be2c0b55bf199234e89baa11725426cf8cb8aa831b433f03c6e4faf3ab1b78795c6f55fd1098c8fe7b318020c23cd95a10bc9b59049d8331fdd4aea81ba2f78432e05622a2c6431\"}, 2025-03-13 12:39:10, 2025-03-13 12:39:10))"  
[2025-03-13 13:02:01] 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 (?, ERD148721305MY, ?, ?, EM004, , 2804, 2025-03-13 13:02:00, ?, , {\"connoteNo\":\"ERD148721305MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM004\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-13 13:02:00\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-13 13:02:01, 2025-03-13 13:02:01))"  
[2025-03-13 13:02:03] 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 (?, ERD148487179MY, ?, ?, EM004, , 2804, 2025-03-13 13:02:00, ?, , {\"connoteNo\":\"ERD148487179MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM004\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-13 13:02:00\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-13 13:02:03, 2025-03-13 13:02:03))"  
[2025-03-13 14:39:49] 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, ?, ?, EM053, , 9700, 2025-03-13 14:37:02, ?, , {\"connoteNo\":\"ERD147849486MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM053\",\"reasonCode\":\"\",\"officeCode\":\"9700\",\"dateTime\":\"2025-03-13 14:37:02\",\"remark\":\"\",\"receiverName\":\"ILONA\",\"receiverId\":\"5513\",\"receiverSignature\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/sog?connoteNo=ERD147849486MY\",\"epod\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/epod?id=cf32fb370fc62cb36be2c0b55bf19923c813680428f0458c862c9f7e50ea0d58f50da0be548570bc4c37cc003d02d468dcf17434e25345838d618750184cd638a553bd1cade262eaa288d65434d19c00\"}, 2025-03-13 14:39:49, 2025-03-13 14:39:49))"  
[2025-03-13 18:40:36] 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 (?, ERD148487179MY, ?, ?, EM005, , 2804, 2025-03-13 18:39:45, ?, , {\"connoteNo\":\"ERD148487179MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-13 18:39:45\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-13 18:40:36, 2025-03-13 18:40:36))"  
[2025-03-13 18:40:37] 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 (?, ERD148721305MY, ?, ?, EM005, , 2804, 2025-03-13 18:39:45, ?, , {\"connoteNo\":\"ERD148721305MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"2804\",\"dateTime\":\"2025-03-13 18:39:45\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-13 18:40:37, 2025-03-13 18:40:37))"