Sat Feb 15 2020 18:45:06 GMT+0000 (Coordinated Universal Time)

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"2146e9a5-f6a4-4e2d-81c5-e9881526097a"},{"method":"Insert"},{"res: getTableSchema":"ok"},"run: insertToTable",{"res: insertToTable":"ok"},{"res: upsertTable":"ok"},"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: upsertTable":1},{"run: upsertTable":"users"},"run: upsertTable","run: getTableSchema",{"res: getTableSchema":"ok"},"run: insertToTable",{"res: insertToTable":"ok"},{"res: upsertTable":"ok"},{"run: upsertTable":2},{"run: upsertTable":"items"},"run: upsertTable","run: getTableSchema",{"res: getTableSchema":"ok"},"run: insertToTable",{"res: insertToTable":"ok"},{"res: upsertTable":"ok"},{"run: upsertTable":3},{"run: upsertTable":"rents"},"run: upsertTable","run: getTableSchema","run: bigQueryJobs_update",{"res: getTableSchema":"ok"},"run: insertToTable",{"res: insertToTable":"ok"},{"res: upsertTable":"ok"},"End OK",{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"Vacuum 3\",\"isInRoom\":false,\"startTime\":\"2020-02-15T17:57:32.017Z\",\"zohoId\":\"4280752000001397225\",\"_id\":\"a333a9c4-3a32-4be9-a0b1-6441beb40ae0\",\"_createdDate\":\"2020-02-15T17:57:32.241Z\",\"passDuration\":\"4\",\"price\":5,\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T18:00:01.900Z\",\"code\":\"00135\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum 3\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"ea4be266-7b13-4cd2-b304-68c8be369bdb\",\"comments\":\"Sent to Zoho\",\"item\":\"42961a91-13f4-4989-91f5-87cba7d99b0e\",\"endTime\":\"2020-02-15T18:30:24.379Z\",\"total\":5},{\"serial\":\"Vacuum 3\",\"isInRoom\":false,\"startTime\":\"2020-02-15T17:57:32.000Z\",\"zohoId\":\"4280752000001397225\",\"_id\":\"a333a9c4-3a32-4be9-a0b1-6441beb40ae0\",\"_createdDate\":\"2020-02-15T17:57:32.241Z\",\"passDuration\":\"4\",\"price\":5,\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T18:30:24.539Z\",\"total\":\"5\",\"code\":\"00135\",\"endTime\":\"2020-02-15T18:30:24.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum 3\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"ea4be266-7b13-4cd2-b304-68c8be369bdb\",\"comments\":\"Sent to Zoho\",\"item\":\"42961a91-13f4-4989-91f5-87cba7d99b0e\",\"rating\":null,\"rentZohoId\":\"4280752000003821509\"},{\"serial\":\"Vacuum 3\",\"isInRoom\":false,\"startTime\":\"2020-02-15T17:57:32.000Z\",\"zohoId\":\"4280752000001397225\",\"_id\":\"a333a9c4-3a32-4be9-a0b1-6441beb40ae0\",\"_createdDate\":\"2020-02-15T17:57:32.241Z\",\"passDuration\":\"4\",\"price\":5,\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003821509\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T18:30:26.254Z\",\"total\":\"5\",\"code\":\"00135\",\"endTime\":\"2020-02-15T18:30:24.000Z\",\"rating\":2,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum 3\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"ea4be266-7b13-4cd2-b304-68c8be369bdb\",\"comments\":\"Sent to Zoho\",\"item\":\"42961a91-13f4-4989-91f5-87cba7d99b0e\"},{\"serial\":\"Football\",\"isInRoom\":false,\"startTime\":\"2020-02-15T17:13:16.000Z\",\"zohoId\":\"4280752000001358815\",\"_id\":\"2f309d39-db85-4f94-aad6-033df3068454\",\"_createdDate\":\"2020-02-15T17:13:16.665Z\",\"passDuration\":\"24,48\",\"baseTime\":\"60\",\"rentZohoId\":\"4280752000003830018\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T17:15:01.541Z\",\"total\":4,\"code\":null,\"endTime\":\"2020-02-15T18:36:53.553Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"2366dbbb-5db2-4ca8-b066-24c4b1762078\",\"passPrice\":\"10,20\",\"isOk\":true,\"title\":\"Football\",\"room\":\"79c4d41a-0294-446b-b306-b0413963c9ac\",\"user\":\"c8e459bf-964d-431a-abe2-51eb67ef47bc\",\"comments\":\"Sent to Zoho\",\"item\":\"476805d7-bf0e-4793-8c57-0195f8497f0c\"},{\"serial\":\"Football\",\"isInRoom\":false,\"startTime\":\"2020-02-15T18:37:44.873Z\",\"zohoId\":\"4280752000001358815\",\"_id\":\"089c2506-0a7e-4da5-96fc-d1b76ddae8a0\",\"_createdDate\":\"2020-02-15T18:37:45.090Z\",\"passDuration\":\"24,48\",\"baseTime\":\"60\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T18:37:45.090Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"2366dbbb-5db2-4ca8-b066-24c4b1762078\",\"passPrice\":\"10,20\",\"isOk\":true,\"title\":\"Football\",\"room\":\"79c4d41a-0294-446b-b306-b0413963c9ac\",\"user\":\"c8e459bf-964d-431a-abe2-51eb67ef47bc\",\"item\":\"476805d7-bf0e-4793-8c57-0195f8497f0c\"},{\"serial\":\"Football\",\"isInRoom\":false,\"startTime\":\"2020-02-15T18:37:44.000Z\",\"zohoId\":\"4280752000001358815\",\"_id\":\"089c2506-0a7e-4da5-96fc-d1b76ddae8a0\",\"_createdDate\":\"2020-02-15T18:37:45.090Z\",\"passDuration\":\"24,48\",\"baseTime\":\"60\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T18:37:45.090Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"2366dbbb-5db2-4ca8-b066-24c4b1762078\",\"passPrice\":\"10,20\",\"isOk\":true,\"title\":\"Football\",\"room\":\"79c4d41a-0294-446b-b306-b0413963c9ac\",\"user\":\"c8e459bf-964d-431a-abe2-51eb67ef47bc\",\"item\":\"476805d7-bf0e-4793-8c57-0195f8497f0c\",\"endTime\":null,\"total\":null,\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003825300\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-15T18:40:31.666Z\",\"zohoId\":\"4280752000001373652\",\"_id\":\"4a275109-71d3-4bd2-b9e4-dbe1182978e7\",\"_createdDate\":\"2020-02-15T18:40:31.902Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T18:40:31.902Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"e555aa2b-012a-4962-9f63-0614647e94c3\",\"user\":\"5de0df48-b7f5-43d2-86ad-77590a928630\",\"item\":\"c0ae6018-ace1-4ca1-bd17-5ede49e97566\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-15T18:40:31.000Z\",\"zohoId\":\"4280752000001373652\",\"_id\":\"4a275109-71d3-4bd2-b9e4-dbe1182978e7\",\"_createdDate\":\"2020-02-15T18:40:31.902Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T18:40:31.902Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"e555aa2b-012a-4962-9f63-0614647e94c3\",\"user\":\"5de0df48-b7f5-43d2-86ad-77590a928630\",\"item\":\"c0ae6018-ace1-4ca1-bd17-5ede49e97566\",\"endTime\":null,\"total\":null,\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003826242\"},{\"serial\":\"Washer\",\"ip\":\"http://77.139.186.173:5000/washer\",\"isInRoom\":false,\"startTime\":\"2020-02-15T14:26:21.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-15T14:30:03.455Z\",\"total\":null,\"code\":null,\"endTime\":null,\"rating\":3,\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"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\"},{\"serial\":\"Dryer\",\"ip\":\"http://77.139.186.173:5000/dryer\",\"isInRoom\":false,\"startTime\":\"2020-02-15T18:44:17.218Z\",\"zohoId\":\"4280752000001354929\",\"_id\":\"1de66fc9-788d-4f95-9f99-aa11996e491a\",\"_createdDate\":\"2020-02-15T18:44:18.842Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T18:44:18.842Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c70cd8f1-1f75-443d-94ee-e7295edc4462\",\"passPrice\":\"10\",\"isOk\":true,\"title\":\"Dryer\",\"room\":\"76199668-5950-4c41-b428-578a5c9e0b70\",\"user\":\"dd424fdc-5d52-4683-ba62-eeed3919ae38\",\"item\":\"c4ac966d-4dc9-4e79-a199-d9feff8d43de\"},{\"serial\":\"Dryer\",\"ip\":\"http://77.139.186.173:5000/dryer\",\"isInRoom\":false,\"startTime\":\"2020-02-15T18:44:17.000Z\",\"zohoId\":\"4280752000001354929\",\"_id\":\"1de66fc9-788d-4f95-9f99-aa11996e491a\",\"_createdDate\":\"2020-02-15T18:44:18.842Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T18:44:18.842Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c70cd8f1-1f75-443d-94ee-e7295edc4462\",\"passPrice\":\"10\",\"isOk\":true,\"title\":\"Dryer\",\"room\":\"76199668-5950-4c41-b428-578a5c9e0b70\",\"user\":\"dd424fdc-5d52-4683-ba62-eeed3919ae38\",\"item\":\"c4ac966d-4dc9-4e79-a199-d9feff8d43de\",\"endTime\":null,\"total\":null,\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003827294\"},{\"ip\":\"http://37.142.66.54:5000/washer\",\"isInRoom\":false,\"startTime\":\"2019-07-25T17:48:59.311Z\",\"email\":\"\",\"_id\":\"21958cf5-99d6-4b33-aadd-03addd5e151f\",\"_createdDate\":\"2019-07-25T17:48:59.528Z\",\"price\":5,\"roomType\":\"smart\",\"maxUsageTime\":8,\"_updatedDate\":\"2020-02-02T15:51:38.141Z\",\"total\":10,\"code\":\"789\",\"endTime\":\"2019-07-25T18:23:24.364Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"f073848c-a830-4a1c-9d28-1c5c026467b0\",\"maxPrice\":20,\"position\":0,\"isOk\":true,\"title\":\"Washer\",\"room\":\"76199668-5950-4c41-b428-578a5c9e0b70\",\"user\":\"850e616b-f57b-4ce2-a879-1722a1efa451\",\"item\":\"3da7e725-ca78-4041-aeb3-3527501cb22f\",\"comments\":\"Sent to Zoho\"}]","updateId":"21958cf5-99d6-4b33-aadd-03addd5e151f","_id":"3cb88a7d-e686-464b-a456-402244d7790d"}}}]

User not available