Sun Feb 09 2020 12:45:05 GMT+0000 (Coordinated Universal Time)

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"929af92a-d9f0-42d7-aecd-cbb685dc4f9b"},{"method":"Insert"},"run: bigQueryJobs_update",{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"Vacuum 2\",\"isInRoom\":false,\"startTime\":\"2020-02-09T12:12:34.000Z\",\"zohoId\":\"4280752000001570143\",\"_id\":\"929af92a-d9f0-42d7-aecd-cbb685dc4f9b\",\"_createdDate\":\"2020-02-09T12:12:34.541Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003214608\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-09T12:12:36.248Z\",\"total\":null,\"code\":\"00564\",\"rating\":5,\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum 2\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"144ddee0-4409-4e76-a936-edb41e0057bf\",\"item\":\"9791766b-efbd-4e32-9393-23ae530bb188\"},{\"startTime\":\"2020-02-09T10:00:00.000Z\",\"_id\":\"4dee6315-bf05-456f-8f9d-f94b5ba9c44d\",\"_createdDate\":\"2020-02-09T12:39:22.375Z\",\"passDuration\":\"4\",\"baseTime\":30,\"rentZohoId\":\"4280752000003270857\",\"baseCost\":5,\"_updatedDate\":\"2020-02-09T12:39:22.375Z\",\"total\":null,\"code\":null,\"rating\":null,\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"3ef7be44-a5f8-432a-8554-e7aadd8efc4f\",\"passPrice\":\"20\",\"title\":\"Window Robot\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"6be9926f-2bc8-4b52-88c3-84828f2f4dc2\",\"item\":\"9371de69-cde7-44ef-ba51-6dcb2b22c2dd\"},{\"startTime\":\"2020-02-09T10:00:00.000Z\",\"_id\":\"4dee6315-bf05-456f-8f9d-f94b5ba9c44d\",\"_createdDate\":\"2020-02-09T12:39:22.375Z\",\"passDuration\":\"4\",\"baseTime\":30,\"rentZohoId\":\"4280752000003270857\",\"baseCost\":5,\"_updatedDate\":\"2020-02-09T12:39:22.375Z\",\"total\":null,\"code\":null,\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"3ef7be44-a5f8-432a-8554-e7aadd8efc4f\",\"passPrice\":\"20\",\"title\":\"Window Robot\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"6be9926f-2bc8-4b52-88c3-84828f2f4dc2\",\"item\":\"9371de69-cde7-44ef-ba51-6dcb2b22c2dd\",\"endTime\":\"2020-02-09T12:39:58.000Z\"},{\"startTime\":\"2020-02-09T10:00:00.000Z\",\"_id\":\"4dee6315-bf05-456f-8f9d-f94b5ba9c44d\",\"_createdDate\":\"2020-02-09T12:39:22.375Z\",\"passDuration\":\"4\",\"baseTime\":30,\"rentZohoId\":\"4280752000003270857\",\"baseCost\":5,\"_updatedDate\":\"2020-02-09T12:39:59.116Z\",\"total\":null,\"code\":null,\"endTime\":\"2020-02-09T12:39:58.000Z\",\"rating\":null,\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"3ef7be44-a5f8-432a-8554-e7aadd8efc4f\",\"passPrice\":\"20\",\"title\":\"Window Robot\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"6be9926f-2bc8-4b52-88c3-84828f2f4dc2\",\"item\":\"9371de69-cde7-44ef-ba51-6dcb2b22c2dd\"},{\"_id\":\"4dee6315-bf05-456f-8f9d-f94b5ba9c44d\",\"startTime\":\"2020-02-09T10:00:00.000Z\",\"_createdDate\":\"2020-02-09T12:39:22.375Z\",\"passDuration\":\"4\",\"baseTime\":30,\"rentZohoId\":\"4280752000003270857\",\"baseCost\":5,\"_updatedDate\":\"2020-02-09T12:40:39.063Z\",\"total\":null,\"code\":null,\"rating\":null,\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"3ef7be44-a5f8-432a-8554-e7aadd8efc4f\",\"passPrice\":\"20\",\"title\":\"Window Robot\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"6be9926f-2bc8-4b52-88c3-84828f2f4dc2\",\"item\":\"9371de69-cde7-44ef-ba51-6dcb2b22c2dd\"},{\"startTime\":\"2020-02-09T10:00:00.000Z\",\"_id\":\"4dee6315-bf05-456f-8f9d-f94b5ba9c44d\",\"_createdDate\":\"2020-02-09T12:39:22.375Z\",\"passDuration\":\"4\",\"baseTime\":30,\"rentZohoId\":\"4280752000003270857\",\"baseCost\":5,\"_updatedDate\":\"2020-02-09T12:41:20.983Z\",\"total\":null,\"code\":null,\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"3ef7be44-a5f8-432a-8554-e7aadd8efc4f\",\"passPrice\":\"20\",\"title\":\"Window Robot\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"6be9926f-2bc8-4b52-88c3-84828f2f4dc2\",\"item\":\"9371de69-cde7-44ef-ba51-6dcb2b22c2dd\",\"endTime\":\"2020-02-09T12:42:12.000Z\"},{\"startTime\":\"2020-02-09T10:00:00.000Z\",\"_id\":\"4dee6315-bf05-456f-8f9d-f94b5ba9c44d\",\"_createdDate\":\"2020-02-09T12:39:22.375Z\",\"passDuration\":\"4\",\"baseTime\":30,\"rentZohoId\":\"4280752000003270857\",\"baseCost\":5,\"_updatedDate\":\"2020-02-09T12:42:12.931Z\",\"total\":null,\"code\":null,\"endTime\":\"2020-02-09T12:44:14.000Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"3ef7be44-a5f8-432a-8554-e7aadd8efc4f\",\"passPrice\":\"20\",\"title\":\"Window Robot\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"6be9926f-2bc8-4b52-88c3-84828f2f4dc2\",\"item\":\"9371de69-cde7-44ef-ba51-6dcb2b22c2dd\"},{\"startTime\":\"2020-02-09T10:00:00.000Z\",\"_id\":\"4dee6315-bf05-456f-8f9d-f94b5ba9c44d\",\"_createdDate\":\"2020-02-09T12:39:22.375Z\",\"passDuration\":\"4\",\"baseTime\":30,\"rentZohoId\":\"4280752000003270857\",\"baseCost\":5,\"_updatedDate\":\"2020-02-09T12:44:15.959Z\",\"total\":null,\"code\":null,\"endTime\":null,\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"3ef7be44-a5f8-432a-8554-e7aadd8efc4f\",\"passPrice\":\"20\",\"title\":\"Window Robot\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"6be9926f-2bc8-4b52-88c3-84828f2f4dc2\",\"item\":\"9371de69-cde7-44ef-ba51-6dcb2b22c2dd\"},{\"serial\":\"Vacuum 2\",\"isInRoom\":false,\"startTime\":\"2020-02-09T12:12:00.000Z\",\"zohoId\":\"4280752000001570143\",\"_id\":\"929af92a-d9f0-42d7-aecd-cbb685dc4f9b\",\"_createdDate\":\"2020-02-09T12:12:34.541Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003214608\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-09T12:30:34.043Z\",\"code\":\"00564\",\"rating\":5,\"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\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum 2\",\"room\":{\"ip\":\"82.81.0.67\",\"zohoId\":\"4280752000001570066\",\"_id\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"_createdDate\":\"2020-01-04T14:22:14.056Z\",\"apiUrl\":\"http://82.81.0.67:5000\",\"_updatedDate\":\"2020-01-26T07:54:47.277Z\",\"building\":\"aa29240f-7b7d-4d47-ade8-855bb4a5956a\",\"pingThisRoom\":true,\"version\":\"0741e4f7-ba1c-4a8e-99cb-407e533769c9\",\"port\":\"5000\",\"status\":\"dfc89896-8bf1-4399-865c-32094f0aa160\",\"title\":\"Meonot TAU - Bike Room\",\"link-rooms-_id\":\"/rooms/e6ea3108-beb7-4692-be45-a53e85601a5a\"},\"user\":\"144ddee0-4409-4e76-a936-edb41e0057bf\",\"item\":{\"serial\":\"Vacuum 2\",\"isInRoom\":false,\"zohoId\":\"4280752000001570143\",\"_id\":\"9791766b-efbd-4e32-9393-23ae530bb188\",\"_createdDate\":\"2020-01-04T14:26:43.049Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"_updatedDate\":\"2020-02-09T12:12:34.508Z\",\"holder\":\"144ddee0-4409-4e76-a936-edb41e0057bf\",\"code\":\"00564\",\"passPrice\":\"20\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum 2\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"item\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\"},\"comments\":\"\"}]","updateId":"929af92a-d9f0-42d7-aecd-cbb685dc4f9b","_id":"1f89eea1-6edb-4c79-a239-cf10f4231263"}}}]

User not available