Fri Feb 14 2020 03:00:03 GMT+0000 (Coordinated Universal Time)

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"f4aecdb6-5f8f-4622-81e9-c6f5447b8a5d"},{"method":"Insert"},{"res: getTableSchema":"ok"},"run: insertToTable","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update",{"res: insertToTable":"ok"},{"res: upsertTable":"ok"},{"run: upsertTable":1},{"run: upsertTable":"items"},"run: upsertTable",{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer TAU1\",\"ip\":\"a4f59581-f76e-b4c6-c901-a031d32a0b54\",\"isInRoom\":false,\"startTime\":\"2020-01-20T11:07:44.314Z\",\"_id\":\"b824fd9c-5ee2-43a0-9398-6a459235f537\",\"_createdDate\":\"2020-01-20T11:07:45.076Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:35.641Z\",\"total\":0.6,\"files\":\"[{\\\"label\\\":\\\"העצמה אישית וקבוצתית לאיחוד שלי, מרכז רותם.docx\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/6fdc68_5f5881740e3b49c4a577f9d29ba47da6.docx\\\",\\\"pageCount\\\":3}]\",\"code\":\"111\",\"endTime\":\"2020-01-20T11:07:45.843Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"isOk\":true,\"title\":\"Printer Doorms_Bike_Room\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"b445aaf6-d9ac-478c-a459-d6fc6baa00e5\",\"item\":\"abf60330-d8b5-475c-b94d-f77f232a1719\",\"comments\":\"Sent to Zoho\"}]","updateId":"b824fd9c-5ee2-43a0-9398-6a459235f537","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Vacuum 1\",\"isInRoom\":false,\"startTime\":\"2020-01-20T10:22:56.655Z\",\"_id\":\"5fb73e6d-e46b-4db7-affa-e25a30d94f5c\",\"_createdDate\":\"2020-01-20T10:22:57.029Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:35.641Z\",\"total\":0,\"code\":\"00746\",\"endTime\":\"2020-01-20T10:25:12.950Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum 1\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"69ec503d-5903-462d-8cde-403062dedf81\",\"item\":\"3e978b61-60da-4760-a1bc-2e6c92fe9688\",\"comments\":\"Sent to Zoho\"}]","updateId":"5fb73e6d-e46b-4db7-affa-e25a30d94f5c","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}}]

User not available