Sat Feb 15 2020 21:00:03 GMT+0000 (Coordinated Universal Time)

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"032445bc-e37c-444b-b865-20247241c4de"},{"method":"Insert"},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"Chairs\",\"isInRoom\":false,\"startTime\":\"2020-02-15T18:16:25.996Z\",\"zohoId\":\"4280752000001355529\",\"_id\":\"75976933-1b9f-4052-90b1-f889f2c7830e\",\"_owner\":\"2dc9e08a-2100-46a1-b63e-55002460cf67\",\"_createdDate\":\"2020-02-15T18:16:29.099Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-15T18:30:01.882Z\",\"code\":\"00589\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"fabff8c6-b89c-47f6-a1d8-13448c0f3674\",\"passPrice\":\"10\",\"isOk\":true,\"title\":\"Chairs (Set of 4)\",\"room\":\"f76dc6f0-e820-4ef4-86b4-66550f7b095e\",\"user\":\"2dc9e08a-2100-46a1-b63e-55002460cf67\",\"comments\":\"Sent to Zoho\",\"item\":\"d5c97c4c-fa40-4405-bedb-4885f97d5ef6\",\"endTime\":\"2020-02-15T20:51:20.430Z\",\"total\":10},{\"serial\":\"Chairs\",\"isInRoom\":false,\"startTime\":\"2020-02-15T18:16:25.000Z\",\"zohoId\":\"4280752000001355529\",\"_id\":\"75976933-1b9f-4052-90b1-f889f2c7830e\",\"_owner\":\"2dc9e08a-2100-46a1-b63e-55002460cf67\",\"_createdDate\":\"2020-02-15T18:16:29.099Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-15T18:30:01.882Z\",\"code\":\"00589\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"fabff8c6-b89c-47f6-a1d8-13448c0f3674\",\"passPrice\":\"10\",\"isOk\":true,\"title\":\"Chairs (Set of 4)\",\"room\":\"f76dc6f0-e820-4ef4-86b4-66550f7b095e\",\"user\":\"2dc9e08a-2100-46a1-b63e-55002460cf67\",\"comments\":\"Sent to Zoho\",\"item\":\"d5c97c4c-fa40-4405-bedb-4885f97d5ef6\",\"endTime\":\"2020-02-15T20:51:20.000Z\",\"total\":\"10\",\"rating\":null,\"rentZohoId\":\"4280752000003832432\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-15T20:51:32.104Z\",\"zohoId\":\"4280752000001368695\",\"_id\":\"4ba40d53-231a-4fff-b4a6-fab655b15a39\",\"_createdDate\":\"2020-02-15T20:51:32.311Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T20:51:32.311Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"28fcb079-d42d-467e-9936-a7185885506a\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Home Theater Projector 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"965fe1cc-945a-47fa-ad21-49c80db896d3\",\"item\":\"ecbae392-8c70-4f36-96db-7cc248d494f4\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-15T20:51:32.000Z\",\"zohoId\":\"4280752000001368695\",\"_id\":\"4ba40d53-231a-4fff-b4a6-fab655b15a39\",\"_createdDate\":\"2020-02-15T20:51:32.311Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T20:51:32.311Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"28fcb079-d42d-467e-9936-a7185885506a\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Home Theater Projector 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"965fe1cc-945a-47fa-ad21-49c80db896d3\",\"item\":\"ecbae392-8c70-4f36-96db-7cc248d494f4\",\"endTime\":null,\"total\":null,\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003835145\"},{\"serial\":\"Washer\",\"ip\":\"http://77.139.186.173:5000/washer\",\"isInRoom\":false,\"startTime\":\"2020-02-15T16:26:00.000Z\",\"zohoId\":\"4280752000001359731\",\"_id\":\"30cd3303-ddd3-4c3f-8269-d68c14c2b1d5\",\"_createdDate\":\"2020-02-15T14:26:23.711Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003821081\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T18:43:32.015Z\",\"total\":10,\"code\":null,\"endTime\":\"2020-02-15T19:38:00.000Z\",\"rating\":3,\"status\":{\"_id\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"_owner\":\"97c9a0ae-5d58-4ba2-8800-4289402c8ce8\",\"_createdDate\":\"2019-04-30T09:58:35.138Z\",\"statusNumber\":1,\"_updatedDate\":\"2019-04-30T09:58:59.358Z\",\"title\":\"active\"},\"itemType\":\"f073848c-a830-4a1c-9d28-1c5c026467b0\",\"passPrice\":\"10\",\"isOk\":true,\"title\":\"Washer\",\"room\":{\"ip\":\"77.139.186.173\",\"zohoId\":\"4280752000001257306\",\"_id\":\"76199668-5950-4c41-b428-578a5c9e0b70\",\"_owner\":\"ad002d46-5812-45af-8dab-aa76c125601a\",\"_createdDate\":\"2019-07-18T11:45:20.161Z\",\"apiUrl\":\"http://77.139.186.173:5000\",\"_updatedDate\":\"2019-12-25T12:51:51.566Z\",\"building\":\"ab84e746-ab9b-4755-875a-2293ca949b64\",\"pingThisRoom\":true,\"version\":\"730c961d-5955-41c3-823a-ddfff8e52990\",\"port\":\"5000\",\"status\":\"dfc89896-8bf1-4399-865c-32094f0aa160\",\"title\":\"Tcharnichovsky\",\"link-rooms-_id\":\"/rooms/76199668-5950-4c41-b428-578a5c9e0b70\"},\"user\":{\"_id\":\"dd424fdc-5d52-4683-ba62-eeed3919ae38\",\"loginEmail\":\"pergum@bezeqint.net\",\"name\":\"מרגלית פרג\",\"firstName\":\"מרגלית\",\"lastName\":\"פרג\",\"picture\":\"https://ui-avatars.com/api/?name=פרג מרגלית&rounded=true&background=d61c56&color=fff\",\"nickname\":\"מרגלית פרג\",\"slug\":\"pergum\",\"language\":\"en\",\"status\":\"ACTIVE\",\"_createdDate\":\"2019-11-03T16:44:39.000Z\",\"_updatedDate\":\"2019-11-03T16:44:39.060Z\",\"lastLogin\":\"2020-02-14T10:24:23.000Z\",\"emails\":[\"pergum@bezeqint.net\"],\"phones\":[\"972547251006\"],\"mainPhone\":\"972547251006\",\"groups\":[],\"contactId\":\"dd424fdc-5d52-4683-ba62-eeed3919ae38\"},\"comments\":\"Sent to Zoho\",\"item\":{\"serial\":\"Washer\",\"ip\":\"http://77.139.186.173:5000/washer\",\"isInRoom\":false,\"zohoId\":\"4280752000001359731\",\"_id\":\"3da7e725-ca78-4041-aeb3-3527501cb22f\",\"_owner\":\"ad002d46-5812-45af-8dab-aa76c125601a\",\"_createdDate\":\"2019-07-18T11:49:59.334Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"_updatedDate\":\"2020-02-15T14:26:23.683Z\",\"holder\":\"dd424fdc-5d52-4683-ba62-eeed3919ae38\",\"passPrice\":\"10\",\"isOk\":true,\"title\":\"Washer\",\"room\":\"76199668-5950-4c41-b428-578a5c9e0b70\",\"item\":\"f073848c-a830-4a1c-9d28-1c5c026467b0\"}},{\"serial\":\"Washer\",\"ip\":\"http://77.139.186.173:5000/washer\",\"isInRoom\":false,\"startTime\":\"2020-02-15T16:26:00.000Z\",\"zohoId\":\"4280752000001359731\",\"_id\":\"30cd3303-ddd3-4c3f-8269-d68c14c2b1d5\",\"_createdDate\":\"2020-02-15T14:26:23.711Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003821081\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T20:59:56.127Z\",\"total\":10,\"code\":null,\"endTime\":\"2020-02-15T19:38:00.000Z\",\"rating\":3,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"f073848c-a830-4a1c-9d28-1c5c026467b0\",\"passPrice\":\"10\",\"isOk\":true,\"title\":\"Washer\",\"room\":\"76199668-5950-4c41-b428-578a5c9e0b70\",\"user\":\"dd424fdc-5d52-4683-ba62-eeed3919ae38\",\"comments\":\"Sent to Zoho\",\"item\":\"3da7e725-ca78-4041-aeb3-3527501cb22f\"},{\"startTime\":\"2019-06-21T09:07:05.839Z\",\"_id\":\"195dcbb3-85f1-4b3a-814d-dad3f758fb51\",\"_owner\":\"193b99e2-3d40-4062-b51c-e93efd5142be\",\"_createdDate\":\"2019-06-21T09:07:09.242Z\",\"price\":5,\"_updatedDate\":\"2020-02-02T15:52:07.808Z\",\"total\":10,\"endTime\":\"2019-06-21T09:46:39.706Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"3ef7be44-a5f8-432a-8554-e7aadd8efc4f\",\"title\":\"Window Robot\",\"user\":\"193b99e2-3d40-4062-b51c-e93efd5142be\",\"item\":\"001523c3-f17d-4691-9519-326fa6aff42f\",\"comments\":\"Sent to Zoho\"},{\"startTime\":\"2019-06-22T15:21:09.000Z\",\"_id\":\"5c683995-0541-4c4a-b9f6-73d4a2c3fcc3\",\"_owner\":\"3aa20526-2d1b-45b8-876c-fd255455e3b5\",\"_createdDate\":\"2019-06-22T15:21:11.332Z\",\"price\":5,\"_updatedDate\":\"2020-02-15T21:00:01.073Z\",\"total\":\"5\",\"endTime\":\"2019-06-22T15:49:59.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"title\":\"Vacuum\",\"user\":\"3aa20526-2d1b-45b8-876c-fd255455e3b5\",\"comments\":\"Sent to Zoho\",\"item\":\"2be4426d-5d07-4629-9c0a-ed1e6572a7e5\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003832470\"},{\"startTime\":\"2019-06-23T03:35:44.000Z\",\"_id\":\"b0ef97d1-a452-484e-9dc6-abf03eb06324\",\"_owner\":\"8cc5332d-146a-412f-afb1-1c0098054e9d\",\"_createdDate\":\"2019-06-23T03:35:50.511Z\",\"price\":5,\"_updatedDate\":\"2020-02-15T21:00:01.073Z\",\"total\":\"5\",\"endTime\":\"2019-06-23T04:01:29.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"title\":\"Vacuum\",\"user\":\"8cc5332d-146a-412f-afb1-1c0098054e9d\",\"comments\":\"Sent to Zoho\",\"item\":\"c58647b8-8057-4a11-981b-c68120e5eba2\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003832469\"},{\"startTime\":\"2019-06-21T08:24:32.000Z\",\"_id\":\"07cb794f-b532-46a2-8a81-8a228dd761e7\",\"_owner\":\"ed32385c-a27c-458c-8901-588f9e3c29c1\",\"_createdDate\":\"2019-06-21T08:23:45.453Z\",\"price\":2,\"_updatedDate\":\"2020-02-15T21:00:01.073Z\",\"total\":\"6\",\"endTime\":\"2019-06-21T09:24:35.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"f035d04b-24b3-4609-9fdf-3179aa1c0e4c\",\"title\":\"Ladder\",\"user\":\"ed32385c-a27c-458c-8901-588f9e3c29c1\",\"comments\":\"Sent to Zoho\",\"item\":\"c7f21cc2-d1d9-4a1e-a9e5-8f1d06fe5127\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003836151\"}]","updateId":"07cb794f-b532-46a2-8a81-8a228dd761e7","_id":"3df0ce74-42a5-482f-9f35-cdf7ca6da32c"}}}]

User not available