[2025-02-28 00:17:53] 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 (?, ERD146642882MY, ?, ?, EM009, , 4029, 2025-02-28 00:17:40, ?, , {\"connoteNo\":\"ERD146642882MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM009\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-02-28 00:17:40\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-02-28 00:17:53, 2025-02-28 00:17:53))"  
[2025-02-28 00:17:57] 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, ?, ?, EM009, , 4029, 2025-02-28 00:17:41, ?, , {\"connoteNo\":\"ERD146619668MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM009\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-02-28 00:17:41\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-02-28 00:17:57, 2025-02-28 00:17:57))"  
[2025-02-28 04:20: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 (?, ERD146642882MY, ?, ?, EM005, , 4029, 2025-02-28 04:20:39, ?, , {\"connoteNo\":\"ERD146642882MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM005\",\"reasonCode\":\"\",\"officeCode\":\"4029\",\"dateTime\":\"2025-02-28 04:20:39\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-02-28 04:20:49, 2025-02-28 04:20:49))"  
[2025-02-28 09:42: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 (?, ERD146642882MY, ?, ?, EM013, , 4300, 2025-02-28 09:41:57, ?, , {\"connoteNo\":\"ERD146642882MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM013\",\"reasonCode\":\"\",\"officeCode\":\"4300\",\"dateTime\":\"2025-02-28 09:41:57\",\"remark\":\"\",\"receiverName\":\"\",\"receiverId\":\"\",\"receiverSignature\":\"\",\"epod\":\"\"}, 2025-02-28 09:42:01, 2025-02-28 09:42:01))"  
[2025-02-28 11:16:55] production.INFO: ninjavan created order27017 {"requested_tracking_number":"27017","tracking_number":"NVMYOBS3S000027017","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27017-280225"},"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":"Anis","phone_number":"+60195718531","email":"","address":{"address1":"NO 22 JALAN MP 2 TAMAN MAWAR PERDANA","address2":"SEPANG ,  ,  , Selangor","country":"MY"},"sort_code":"KV"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-02-28","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-01","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-02-28 11:16:56] production.INFO: ninjavan created order27015 {"requested_tracking_number":"27015","tracking_number":"NVMYOBS3S000027015","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27015-270225"},"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":"Amy Amielda","phone_number":"+60192700069","email":"","address":{"address1":"Add C-6-15 mahkota garden condo, jalan mahkota garden, bandar mahkota cheras,43200 cheras selangor  l","address2":" ,  ,  , Selangor","country":"MY"},"sort_code":"KV"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-02-28","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-01","delivery_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"delivery_instructions":"-","allow_weekend_delivery":true,"dimensions":{"weight":0.22},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-02-28 11:16:57] production.INFO: ninjavan created order27014 {"requested_tracking_number":"27014","tracking_number":"NVMYOBS3S000027014","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27014-270225"},"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 Azura Bidu","phone_number":"+60129299778","email":"","address":{"address1":"D-T.07-U.01, Fasa 8R2,","address2":"Jalan P8G, Presint 8, ,  ,  , Putrajaya","country":"MY"},"sort_code":"KV"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-02-28","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-01","delivery_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"delivery_instructions":"-","allow_weekend_delivery":true,"dimensions":{"weight":0.27},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-02-28 11:17: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 (?, ERD146642882MY, ?, ?, EM053, , 4300, 2025-02-28 11:17:17, ?, , {\"connoteNo\":\"ERD146642882MY\",\"subscriptionCode\":\"obsesscosmetics\",\"eventCode\":\"EM053\",\"reasonCode\":\"\",\"officeCode\":\"4300\",\"dateTime\":\"2025-02-28 11:17:17\",\"remark\":\"\",\"receiverName\":\"ZAPINA BINTI MUSTAPHA\",\"receiverId\":\"\",\"receiverSignature\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/sog?connoteNo=ERD146642882MY\",\"epod\":\"https:\\\/\\\/trackingintegration.pos.com.my\\\/tracking.webhookv3.portal\\\/epod?id=cf32fb370fc62cb36be2c0b55bf199232fb0cc96b86dd28854ac2dc07efa9ee6992a9f7b4a3624924a20f734f024721122e8ff964f8396fe3bb45cd6ccb482e4989c069c18bb12ec023fd5d9558d8f79\"}, 2025-02-28 11:17:26, 2025-02-28 11:17:26))"  
[2025-02-28 14:43:54] production.INFO: ninjavan created order27021 {"requested_tracking_number":"27021","tracking_number":"NVMYOBS3S000027021","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27021-280225"},"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":"Mohd Hafiz Bin Abu Seman","phone_number":"+60178470539","email":"","address":{"address1":"Lot 5198 , Jalan Dato Ahmad Razali , Kampung Sungai pinang, Pulau Indah","address2":" ,  , Selangor","country":"MY"},"sort_code":"KV"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-01","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-03","delivery_timeslot":{"start_time":"09:00","end_time":"12:00","timezone":"Asia/Kuala_Lumpur"},"delivery_instructions":"-","allow_weekend_delivery":true,"dimensions":{"weight":0.12},"items":[{"item_description":"Sample description","quantity":1,"is_dangerous_good":false}]}}  
[2025-02-28 16:18:12] production.INFO: ninjavan created order27024 {"requested_tracking_number":"27024","tracking_number":"NVMYOBS3S000027024","service_type":"Parcel","service_level":"STANDARD","reference":{"merchant_order_number":"Inv-27024-280225"},"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 Affliana Binti Noor Affandy","phone_number":"+601137016472","email":"","address":{"address1":"6-2 Kuarters institusi pendidikan Seri bintang selatan, 3/91A taman shamelin perkasa","address2":"Taman shamelin perkasa ,  ,  , Kuala Lumpur","country":"MY"},"sort_code":"KV"},"parcel_job":{"is_pickup_required":true,"pickup_service_type":"Scheduled","pickup_service_level":"Standard","pickup_date":"2025-03-01","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-03","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}]}}