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

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"985e0257-4c85-4dbb-8b1b-65424cd6b0f3"},{"method":"Insert"},"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\":\"Vacuum 4\",\"isInRoom\":false,\"startTime\":\"2020-02-15T09:04:33.973Z\",\"zohoId\":\"4280752000003020043\",\"_id\":\"2fc139a8-cb4e-4a10-972c-a715064d883c\",\"_createdDate\":\"2020-02-15T09:04:34.340Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T09:04:34.340Z\",\"code\":\"00287\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"4\",\"isOk\":true,\"title\":\"Vacuum 4\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"7de66c11-28ca-4af4-9f85-9a2031389c68\",\"item\":\"f384c924-8eb7-4eb7-a042-d025d6316135\"},{\"serial\":\"Vacuum 4\",\"isInRoom\":false,\"startTime\":\"2020-02-15T09:04:33.000Z\",\"zohoId\":\"4280752000003020043\",\"_id\":\"2fc139a8-cb4e-4a10-972c-a715064d883c\",\"_createdDate\":\"2020-02-15T09:04:34.340Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T09:04:34.340Z\",\"code\":\"00287\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"4\",\"isOk\":true,\"title\":\"Vacuum 4\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"7de66c11-28ca-4af4-9f85-9a2031389c68\",\"item\":\"f384c924-8eb7-4eb7-a042-d025d6316135\",\"endTime\":null,\"total\":null,\"rating\":null,\"rentZohoId\":\"4280752000003801769\"},{\"isInRoom\":false,\"startTime\":\"2019-10-25T07:36:11.303Z\",\"email\":\"ben@repark.me\",\"_id\":\"be1f4af9-4657-40e9-b677-49e0ef405d9d\",\"_owner\":\"6aed1a59-2464-4251-a534-b1dba34018ab\",\"_createdDate\":\"2019-10-25T07:36:12.114Z\",\"price\":0,\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:48:00.175Z\",\"total\":0,\"files\":\"[{\\\"label\\\":\\\"חוות דעת בדיני חוזים - 7 - Copy 2.pdf\\\",\\\"value\\\":\\\"wix:document://v1/6aed1a_99137fcb58c548ecb9a472bbd1a2e56d.pdf/חוות דעת בדיני חוזים - 7 - Copy 2.pdf\\\"},{\\\"label\\\":\\\"חוות דעת בדיני חוזים - 7 - Copy 2.pdf\\\",\\\"value\\\":\\\"wix:document://v1/6aed1a_75eb663d5a03462cb3023f89d2b00eb7.pdf/חוות דעת בדיני חוזים - 7 - Copy 2.pdf\\\"},{\\\"label\\\":\\\"פורמט למטלת הניסוח קשיח.pdf\\\",\\\"value\\\":\\\"wix:document://v1/6aed1a_4e78994d816841fe8f312f5ca68eb541.pdf/פורמט למטלת הניסוח קשיח.pdf\\\"},{\\\"label\\\":\\\"פורמט למטלת הניסוח קשיח.pdf\\\",\\\"value\\\":\\\"wix:document://v1/6aed1a_2ee6f059fc6e4e41b33cb1c2586b0332.pdf/פורמט למטלת הניסוח קשיח.pdf\\\"},{\\\"label\\\":\\\"תרגול משולב 1.pdf\\\",\\\"value\\\":\\\"wix:document://v1/6aed1a_f2066c7c801c4ac8a5c2970a96b80036.pdf/תרגול משולב 1.pdf\\\"},{\\\"label\\\":\\\"פורמט למטלת הניסוח קשיח.pdf\\\",\\\"value\\\":\\\"wix:document://v1/6aed1a_3d1eb910e1a44ecf867ae6ad550c0df2.pdf/פורמט למטלת הניסוח קשיח.pdf\\\"},{\\\"label\\\":\\\"פורמט למטלת הניסוח קשיח.pdf\\\",\\\"value\\\":\\\"wix:document://v1/6aed1a_d1c291f5ba1646eca8c84df9fa1e39c5.pdf/פורמט למטלת הניסוח קשיח.pdf\\\"},{\\\"label\\\":\\\"פורמט למטלת הניסוח קשיח.pdf\\\",\\\"value\\\":\\\"wix:document://v1/6aed1a_917aa35afc5a4b48b480ef7b5625c767.pdf/פורמט למטלת הניסוח קשיח.pdf\\\"},{\\\"label\\\":\\\"פורמט למטלת הניסוח קשיח.pdf\\\",\\\"value\\\":\\\"wix:document://v1/6aed1a_c6e4fb78da15460fae6e8aa71566b401.pdf/פורמט למטלת הניסוח קשיח.pdf\\\"}]\",\"code\":\"\",\"endTime\":\"2019-10-25T10:01:45.697Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"0cc44936-f18e-4c6a-b4d5-424b51115727\",\"position\":0,\"isOk\":true,\"title\":\"מדפסת\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"6aed1a59-2464-4251-a534-b1dba34018ab\",\"item\":\"d373136a-dac1-4d41-a36d-70ed4f614e38\",\"comments\":\"Sent to Zoho\"}]","updateId":"be1f4af9-4657-40e9-b677-49e0ef405d9d","_id":"54427b7f-98ee-48e8-99a3-9b3f20cea7e1"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"Vacuum 4\",\"isInRoom\":false,\"startTime\":\"2020-02-15T09:04:33.973Z\",\"zohoId\":\"4280752000003020043\",\"_id\":\"2fc139a8-cb4e-4a10-972c-a715064d883c\",\"_createdDate\":\"2020-02-15T09:04:34.340Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T09:04:34.340Z\",\"code\":\"00287\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"4\",\"isOk\":true,\"title\":\"Vacuum 4\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"7de66c11-28ca-4af4-9f85-9a2031389c68\",\"item\":\"f384c924-8eb7-4eb7-a042-d025d6316135\"},{\"serial\":\"Vacuum 4\",\"isInRoom\":false,\"startTime\":\"2020-02-15T09:04:33.000Z\",\"zohoId\":\"4280752000003020043\",\"_id\":\"2fc139a8-cb4e-4a10-972c-a715064d883c\",\"_createdDate\":\"2020-02-15T09:04:34.340Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T09:04:34.340Z\",\"code\":\"00287\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"4\",\"isOk\":true,\"title\":\"Vacuum 4\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"7de66c11-28ca-4af4-9f85-9a2031389c68\",\"item\":\"f384c924-8eb7-4eb7-a042-d025d6316135\",\"endTime\":null,\"total\":null,\"rating\":null,\"rentZohoId\":\"4280752000003801769\"},{\"isInRoom\":false,\"startTime\":\"2019-10-24T07:43:40.393Z\",\"email\":\"ben@repark.me\",\"_id\":\"60b076f0-1537-483a-8a84-549853c867f3\",\"_owner\":\"6aed1a59-2464-4251-a534-b1dba34018ab\",\"_createdDate\":\"2019-10-24T07:43:41.768Z\",\"price\":0,\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:48:00.175Z\",\"total\":0,\"files\":\"[{\\\"label\\\":\\\"ירושה 1.pdf\\\",\\\"value\\\":\\\"wix:document://v1/b46dce_f406457acf6040f295be556e4e3cf6c9.pdf/ירושה 1.pdf\\\"},{\\\"label\\\":\\\"ירושה 2.pdf\\\",\\\"value\\\":\\\"wix:document://v1/b46dce_d1a4fc0b365943ef9e8edbe48440c9bc.pdf/ירושה 2.pdf\\\"},{\\\"label\\\":\\\"ירושה 3.pdf\\\",\\\"value\\\":\\\"wix:document://v1/b46dce_f1d22daaa292446b80254bbe91269542.pdf/ירושה 3.pdf\\\"},{\\\"label\\\":\\\"שטרות 1.pdf\\\",\\\"value\\\":\\\"wix:document://v1/b46dce_51708883e717496eba4ef160d579d59b.pdf/שטרות 1.pdf\\\"},{\\\"label\\\":\\\"שטרות 2.pdf\\\",\\\"value\\\":\\\"wix:document://v1/b46dce_c195455ce2e84c6bbb7da9005f87080e.pdf/שטרות 2.pdf\\\"}]\",\"code\":\"\",\"endTime\":\"2019-10-24T08:34:08.790Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"0cc44936-f18e-4c6a-b4d5-424b51115727\",\"position\":0,\"isOk\":true,\"title\":\"מדפסת\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"6aed1a59-2464-4251-a534-b1dba34018ab\",\"item\":\"d373136a-dac1-4d41-a36d-70ed4f614e38\",\"comments\":\"Sent to Zoho\"}]","updateId":"60b076f0-1537-483a-8a84-549853c867f3","_id":"54427b7f-98ee-48e8-99a3-9b3f20cea7e1"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"Vacuum 4\",\"isInRoom\":false,\"startTime\":\"2020-02-15T09:04:33.973Z\",\"zohoId\":\"4280752000003020043\",\"_id\":\"2fc139a8-cb4e-4a10-972c-a715064d883c\",\"_createdDate\":\"2020-02-15T09:04:34.340Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T09:04:34.340Z\",\"code\":\"00287\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"4\",\"isOk\":true,\"title\":\"Vacuum 4\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"7de66c11-28ca-4af4-9f85-9a2031389c68\",\"item\":\"f384c924-8eb7-4eb7-a042-d025d6316135\"},{\"serial\":\"Vacuum 4\",\"isInRoom\":false,\"startTime\":\"2020-02-15T09:04:33.000Z\",\"zohoId\":\"4280752000003020043\",\"_id\":\"2fc139a8-cb4e-4a10-972c-a715064d883c\",\"_createdDate\":\"2020-02-15T09:04:34.340Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T09:04:34.340Z\",\"code\":\"00287\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"4\",\"isOk\":true,\"title\":\"Vacuum 4\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"7de66c11-28ca-4af4-9f85-9a2031389c68\",\"item\":\"f384c924-8eb7-4eb7-a042-d025d6316135\",\"endTime\":null,\"total\":null,\"rating\":null,\"rentZohoId\":\"4280752000003801769\"},{\"isInRoom\":false,\"startTime\":\"2019-10-23T21:56:09.984Z\",\"_id\":\"1d609f06-bf9b-4419-a019-4da3b5ae5951\",\"_owner\":\"ad002d46-5812-45af-8dab-aa76c125601a\",\"_createdDate\":\"2019-10-23T21:56:10.592Z\",\"price\":5,\"roomType\":\"regular\",\"maxUsageTime\":3,\"_updatedDate\":\"2020-02-02T15:48:00.175Z\",\"total\":0,\"code\":\"00694\",\"endTime\":\"2019-10-23T21:56:18.641Z\",\"rating\":4,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b78358e8-9a04-4096-b540-3bb33f63c978\",\"position\":0,\"isOk\":true,\"title\":\"Drill\",\"room\":\"f76dc6f0-e820-4ef4-86b4-66550f7b095e\",\"user\":\"ad002d46-5812-45af-8dab-aa76c125601a\",\"item\":\"d806b800-a821-49a4-a184-e1ec585285c7\",\"comments\":\"Sent to Zoho\"}]","updateId":"1d609f06-bf9b-4419-a019-4da3b5ae5951","_id":"54427b7f-98ee-48e8-99a3-9b3f20cea7e1"}}},"run: getTableSchema",{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"Vacuum 4\",\"isInRoom\":false,\"startTime\":\"2020-02-15T09:04:33.973Z\",\"zohoId\":\"4280752000003020043\",\"_id\":\"2fc139a8-cb4e-4a10-972c-a715064d883c\",\"_createdDate\":\"2020-02-15T09:04:34.340Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T09:04:34.340Z\",\"code\":\"00287\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"4\",\"isOk\":true,\"title\":\"Vacuum 4\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"7de66c11-28ca-4af4-9f85-9a2031389c68\",\"item\":\"f384c924-8eb7-4eb7-a042-d025d6316135\"},{\"serial\":\"Vacuum 4\",\"isInRoom\":false,\"startTime\":\"2020-02-15T09:04:33.000Z\",\"zohoId\":\"4280752000003020043\",\"_id\":\"2fc139a8-cb4e-4a10-972c-a715064d883c\",\"_createdDate\":\"2020-02-15T09:04:34.340Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T09:04:34.340Z\",\"code\":\"00287\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"4\",\"isOk\":true,\"title\":\"Vacuum 4\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"7de66c11-28ca-4af4-9f85-9a2031389c68\",\"item\":\"f384c924-8eb7-4eb7-a042-d025d6316135\",\"endTime\":null,\"total\":null,\"rating\":null,\"rentZohoId\":\"4280752000003801769\"},{\"isInRoom\":false,\"startTime\":\"2019-10-25T09:22:30.131Z\",\"_id\":\"2eb80c48-d4bc-4785-9235-ba2b006501cd\",\"_createdDate\":\"2019-10-25T09:22:30.293Z\",\"price\":5,\"roomType\":\"smart\",\"maxUsageTime\":8,\"_updatedDate\":\"2020-02-02T15:48:00.175Z\",\"total\":2110,\"code\":\"\",\"endTime\":\"2019-11-17T13:20:00.878Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"87b3c643-44df-4696-9fd6-ab41b28b1e1a\",\"maxPrice\":30,\"position\":3,\"isOk\":true,\"title\":\"Scooter 3\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"e8d11c29-e30e-4866-acba-8c0ec576ea92\",\"item\":\"006ea117-e2f1-43e3-a51b-fe0a467b7dc4\",\"comments\":\"Sent to Zoho\"}]","updateId":"2eb80c48-d4bc-4785-9235-ba2b006501cd","_id":"54427b7f-98ee-48e8-99a3-9b3f20cea7e1"}}}]

User not available