[2025-03-14 00:02:39] 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, ?, ?, EM009, , 4029, 2025-03-14 00:02:35, ?, , {\"connoteNo\":\"ERD148487179MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM009\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-14 00:02:35\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-14 00:02:39, 2025-03-14 00:02:39))"  
[2025-03-14 00:02:45] 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, ?, ?, EM009, , 4029, 2025-03-14 00:02:36, ?, , {\"connoteNo\":\"ERD148721305MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM009\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-14 00:02:36\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-14 00:02:45, 2025-03-14 00:02:45))"  
[2025-03-14 00:03:05] 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, ?, ?, EM009, , 4029, 2025-03-14 00:02:36, ?, , {\"connoteNo\":\"ERD148721305MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM009\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-14 00:02:36\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-14 00:03:05, 2025-03-14 00:03:05))"  
[2025-03-14 03:35: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 (?, ERD148721305MY, ?, ?, EM005, , 4029, 2025-03-14 03:35:33, ?, , {\"connoteNo\":\"ERD148721305MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-14 03:35:33\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-14 03:35:55, 2025-03-14 03:35:55))"  
[2025-03-14 04:24:43] 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, , 4029, 2025-03-14 04:22:33, ?, , {\"connoteNo\":\"ERD148487179MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-03-14 04:22:33\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-14 04:24:43, 2025-03-14 04:24:43))"  
[2025-03-14 09:21: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 (?, ERD148721305MY, ?, ?, EM005, , 1200, 2025-03-14 09:21:51, ?, , {\"connoteNo\":\"ERD148721305MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"1200\",\"dateTime\":\"2025-03-14 09:21:51\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-14 09:21:55, 2025-03-14 09:21:55))"  
[2025-03-14 12:15: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 (?, ERD148487179MY, ?, ?, EM053, , 4100, 2025-03-14 12:13:22, ?, , {\"connoteNo\":\"ERD148487179MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM053\",\"reasonCode\":\"\",\"officeCode\":\"4100\",\"dateTime\":\"2025-03-14 12:13:22\",\"remark\":\"\",\"receiverName\":\"NURAIN\",\"receiverId\":\"7350\",\"receiverSignature\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/sog?connoteNo=ERD148487179MY\",\"epod\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/epod?id=cf32fb370fc62cb36be2c0b55bf1992383ce431fd0c877ecf8b1da7eb352fa8978e4a30f1dc6147ced497d232a18408511fb73c0f36684d0c7696c6fa27b78dd6885cf106ad2f8f32cfd27a75b65db59\"}, 2025-03-14 12:15:13, 2025-03-14 12:15:13))"  
[2025-03-14 12:20:38] 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, ?, ?, EM013, , 1321, 2025-03-14 12:20:36, ?, , {\"connoteNo\":\"ERD148721305MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM013\",\"reasonCode\":\"\",\"officeCode\":\"1321\",\"dateTime\":\"2025-03-14 12:20:36\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-03-14 12:20:38, 2025-03-14 12:20:38))"  
[2025-03-14 13:07:44] 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, ?, ?, EM053, , 1321, 2025-03-14 13:07:41, ?, , {\"connoteNo\":\"ERD148721305MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM053\",\"reasonCode\":\"\",\"officeCode\":\"1321\",\"dateTime\":\"2025-03-14 13:07:41\",\"remark\":\"\",\"receiverName\":\"ZAILINI BINTI MOHD NOOR\",\"receiverId\":\"\",\"receiverSignature\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/sog?connoteNo=ERD148721305MY\",\"epod\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/epod?id=cf32fb370fc62cb36be2c0b55bf199232c438781a635e41189fdd1e25b3447fa337deeb5d36ea93c7921e971c1dfe01781b57913a76f7be9916e55d21da9aeb71bc3f7ccadbe8dd6aa4cbc2a4d4fe945\"}, 2025-03-14 13:07:44, 2025-03-14 13:07:44))"  
[2025-03-14 17:24:04] production.INFO: ninjavan created order27320 {"requested_tracking_number":"27320","tracking_number":"NVMYOBS3S000027320","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27320-140325"},"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":"Aifa Syazwani","phone_number":"+60146257463","email":"","address":{"address1":"No 6 Jalan 4A","address2":"Taman Sri Jenaris ,  ,  , Selangor","country":"MY"},"sort_code":"KV"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-15","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-17","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}]}}