Fri Feb 14 2020 17:30:08 GMT+0000 (Coordinated Universal Time)

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"75961107-b2b0-4020-9d2a-3745a3ce672b"},{"method":"Insert"},"run: bigQueryJobs_update","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":"[{\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2019-12-19T01:22:02.000Z\",\"_id\":\"bd4775f2-49a3-4d55-8899-f288879340ac\",\"_createdDate\":\"2019-12-19T01:22:02.568Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":2,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T17:15:01.107Z\",\"total\":\"4\",\"code\":null,\"endTime\":\"2019-12-19T02:10:25.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b28e3aa1-6fc9-43ef-9d58-cec6a62c5d9b\",\"passPrice\":\"12\",\"position\":3,\"isOk\":true,\"title\":\"Robot Mop3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"641ee4c5-a416-4843-a57f-21df61ec35c5\",\"comments\":\"Sent to Zoho\",\"item\":\"85487031-221f-4522-be58-2f465cffed6c\",\"rating\":null,\"rentZohoId\":\"4280752000003757153\"},{\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2019-12-18T20:39:26.000Z\",\"_id\":\"7310b7a9-d7df-44df-908b-c8482b034bb6\",\"_createdDate\":\"2019-12-18T20:39:26.698Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":2,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T17:15:01.107Z\",\"total\":\"4\",\"code\":null,\"endTime\":\"2019-12-18T21:19:06.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"87b3c643-44df-4696-9fd6-ab41b28b1e1a\",\"passPrice\":\"12\",\"position\":2,\"isOk\":true,\"title\":\"Scooter2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"93391779-92aa-4c12-9e16-151170d5c29f\",\"comments\":\"Sent to Zoho\",\"item\":\"978cf2ec-60e7-4c0d-bcd2-7c0ab85f9c8a\",\"rating\":null,\"rentZohoId\":\"4280752000003728386\"},{\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2019-12-18T14:07:50.000Z\",\"_id\":\"87f86088-6822-4ec4-a308-3fb5f38e87e6\",\"_createdDate\":\"2019-12-18T14:07:50.697Z\",\"passDuration\":\"8\",\"price\":5,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":5,\"roomType\":\"smart\",\"maxUsageTime\":3,\"_updatedDate\":\"2020-02-14T17:30:02.758Z\",\"total\":null,\"code\":null,\"endTime\":\"2019-12-18T14:08:52.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"maxPrice\":null,\"passPrice\":\"30\",\"position\":3,\"isOk\":true,\"title\":\"Vacuum 3\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"e8d11c29-e30e-4866-acba-8c0ec576ea92\",\"comments\":\"Sent to Zoho\",\"item\":\"3f66ddb6-8e3f-42ae-ba64-e8248376029f\",\"rating\":null,\"rentZohoId\":\"4280752000003731464\"},{\"isInRoom\":false,\"startTime\":\"2019-12-18T11:19:00.000Z\",\"_id\":\"5414ccb6-bb54-4ccf-90dc-c8dd6e8b1dc5\",\"_owner\":\"6be9926f-2bc8-4b52-88c3-84828f2f4dc2\",\"_createdDate\":\"2019-12-18T11:19:08.336Z\",\"price\":2,\"baseTime\":30,\"baseCost\":2,\"roomType\":\"regular\",\"maxUsageTime\":5,\"_updatedDate\":\"2020-02-14T17:30:02.758Z\",\"total\":\"12\",\"code\":null,\"endTime\":\"2019-12-18T14:01:00.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"3c4d4c1d-0930-46b6-93ec-fbec3e3d71c0\",\"position\":0,\"isOk\":true,\"title\":\"Pong Pong\",\"room\":\"f76dc6f0-e820-4ef4-86b4-66550f7b095e\",\"user\":\"6be9926f-2bc8-4b52-88c3-84828f2f4dc2\",\"comments\":\"Sent to Zoho\",\"item\":\"2220f7bf-dd0e-42a7-a2a6-38fc8584ef97\",\"rating\":null,\"rentZohoId\":\"4280752000003731453\"},{\"ip\":\"31c66857-f958-20a2-8076-c1cf5639bb0d\",\"isInRoom\":false,\"startTime\":\"2019-12-18T17:09:02.000Z\",\"_id\":\"cf881515-d9c7-4686-baa1-7e1294efd31f\",\"_createdDate\":\"2019-12-18T17:09:02.232Z\",\"price\":0.1,\"baseTime\":30,\"baseCost\":0.1,\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-14T17:30:02.758Z\",\"total\":\"0.9\",\"files\":\"[{\\\"label\\\":\\\"Caroline Myer Finance Resume 12.3.19.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/350b3c_4d3ad4abffd545b58fdff3d97f4c014a.pdf\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2019-12-18T17:09:02.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"position\":2,\"isOk\":true,\"title\":\"Printer2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"fbe1b48d-eedc-4593-9c9c-582a626cad98\",\"comments\":\"Sent to Zoho\",\"item\":\"a441821a-172d-4e0b-9541-c24fc4730ca0\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003728537\"},{\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2019-12-18T17:39:11.000Z\",\"_id\":\"28914c8c-edc9-41cc-b365-9c14f4d16790\",\"_createdDate\":\"2019-12-18T17:39:11.757Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":2,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T17:30:02.758Z\",\"total\":\"2\",\"code\":null,\"endTime\":\"2019-12-18T17:44:34.000Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"2cfa54c9-23d3-4b98-b708-9f9e9611f706\",\"passPrice\":\"12\",\"position\":1,\"isOk\":true,\"title\":\"VR Headset1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"54c36a58-e118-4392-b8ce-fe24c6d953be\",\"comments\":\"Sent to Zoho\",\"item\":\"d17eb7fe-3744-48b9-89b0-8334f3628e33\",\"rentZohoId\":\"4280752000003757263\"},{\"isInRoom\":false,\"startTime\":\"2019-12-18T12:18:00.000Z\",\"_id\":\"cf227462-abe1-4a46-8871-67198e9a5ae4\",\"_owner\":\"6be9926f-2bc8-4b52-88c3-84828f2f4dc2\",\"_createdDate\":\"2019-12-18T12:18:22.580Z\",\"passDuration\":\"24,48\",\"price\":2,\"baseTime\":30,\"baseCost\":1,\"roomType\":\"regular\",\"maxUsageTime\":5,\"_updatedDate\":\"2020-02-14T17:30:02.758Z\",\"total\":\"39\",\"code\":null,\"endTime\":\"2019-12-23T13:24:00.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"3c4d4c1d-0930-46b6-93ec-fbec3e3d71c0\",\"passPrice\":\"12,12\",\"position\":0,\"isOk\":true,\"title\":\"Pong Pong\",\"room\":\"f76dc6f0-e820-4ef4-86b4-66550f7b095e\",\"user\":\"6be9926f-2bc8-4b52-88c3-84828f2f4dc2\",\"comments\":\"Sent to Zoho\",\"item\":\"2220f7bf-dd0e-42a7-a2a6-38fc8584ef97\",\"rating\":null,\"rentZohoId\":\"4280752000003757261\"}]","updateId":"cf227462-abe1-4a46-8871-67198e9a5ae4","_id":"1fe41b12-c648-45e7-9287-20fedcaff5f1"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2019-12-19T01:22:02.000Z\",\"_id\":\"bd4775f2-49a3-4d55-8899-f288879340ac\",\"_createdDate\":\"2019-12-19T01:22:02.568Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":2,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T17:15:01.107Z\",\"total\":\"4\",\"code\":null,\"endTime\":\"2019-12-19T02:10:25.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b28e3aa1-6fc9-43ef-9d58-cec6a62c5d9b\",\"passPrice\":\"12\",\"position\":3,\"isOk\":true,\"title\":\"Robot Mop3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"641ee4c5-a416-4843-a57f-21df61ec35c5\",\"comments\":\"Sent to Zoho\",\"item\":\"85487031-221f-4522-be58-2f465cffed6c\",\"rating\":null,\"rentZohoId\":\"4280752000003757153\"},{\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2019-12-18T20:39:26.000Z\",\"_id\":\"7310b7a9-d7df-44df-908b-c8482b034bb6\",\"_createdDate\":\"2019-12-18T20:39:26.698Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":2,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T17:15:01.107Z\",\"total\":\"4\",\"code\":null,\"endTime\":\"2019-12-18T21:19:06.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"87b3c643-44df-4696-9fd6-ab41b28b1e1a\",\"passPrice\":\"12\",\"position\":2,\"isOk\":true,\"title\":\"Scooter2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"93391779-92aa-4c12-9e16-151170d5c29f\",\"comments\":\"Sent to Zoho\",\"item\":\"978cf2ec-60e7-4c0d-bcd2-7c0ab85f9c8a\",\"rating\":null,\"rentZohoId\":\"4280752000003728386\"},{\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2019-12-18T14:07:50.000Z\",\"_id\":\"87f86088-6822-4ec4-a308-3fb5f38e87e6\",\"_createdDate\":\"2019-12-18T14:07:50.697Z\",\"passDuration\":\"8\",\"price\":5,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":5,\"roomType\":\"smart\",\"maxUsageTime\":3,\"_updatedDate\":\"2020-02-14T17:30:02.758Z\",\"total\":null,\"code\":null,\"endTime\":\"2019-12-18T14:08:52.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"maxPrice\":null,\"passPrice\":\"30\",\"position\":3,\"isOk\":true,\"title\":\"Vacuum 3\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"e8d11c29-e30e-4866-acba-8c0ec576ea92\",\"comments\":\"Sent to Zoho\",\"item\":\"3f66ddb6-8e3f-42ae-ba64-e8248376029f\",\"rating\":null,\"rentZohoId\":\"4280752000003731464\"},{\"isInRoom\":false,\"startTime\":\"2019-12-18T11:19:00.000Z\",\"_id\":\"5414ccb6-bb54-4ccf-90dc-c8dd6e8b1dc5\",\"_owner\":\"6be9926f-2bc8-4b52-88c3-84828f2f4dc2\",\"_createdDate\":\"2019-12-18T11:19:08.336Z\",\"price\":2,\"baseTime\":30,\"baseCost\":2,\"roomType\":\"regular\",\"maxUsageTime\":5,\"_updatedDate\":\"2020-02-14T17:30:02.758Z\",\"total\":\"12\",\"code\":null,\"endTime\":\"2019-12-18T14:01:00.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"3c4d4c1d-0930-46b6-93ec-fbec3e3d71c0\",\"position\":0,\"isOk\":true,\"title\":\"Pong Pong\",\"room\":\"f76dc6f0-e820-4ef4-86b4-66550f7b095e\",\"user\":\"6be9926f-2bc8-4b52-88c3-84828f2f4dc2\",\"comments\":\"Sent to Zoho\",\"item\":\"2220f7bf-dd0e-42a7-a2a6-38fc8584ef97\",\"rating\":null,\"rentZohoId\":\"4280752000003731453\"},{\"ip\":\"31c66857-f958-20a2-8076-c1cf5639bb0d\",\"isInRoom\":false,\"startTime\":\"2019-12-18T17:09:02.000Z\",\"_id\":\"cf881515-d9c7-4686-baa1-7e1294efd31f\",\"_createdDate\":\"2019-12-18T17:09:02.232Z\",\"price\":0.1,\"baseTime\":30,\"baseCost\":0.1,\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-14T17:30:02.758Z\",\"total\":\"0.9\",\"files\":\"[{\\\"label\\\":\\\"Caroline Myer Finance Resume 12.3.19.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/350b3c_4d3ad4abffd545b58fdff3d97f4c014a.pdf\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2019-12-18T17:09:02.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"position\":2,\"isOk\":true,\"title\":\"Printer2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"fbe1b48d-eedc-4593-9c9c-582a626cad98\",\"comments\":\"Sent to Zoho\",\"item\":\"a441821a-172d-4e0b-9541-c24fc4730ca0\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003728537\"},{\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2019-12-18T17:39:11.000Z\",\"_id\":\"28914c8c-edc9-41cc-b365-9c14f4d16790\",\"_createdDate\":\"2019-12-18T17:39:11.757Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":2,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T17:30:02.758Z\",\"total\":\"2\",\"code\":null,\"endTime\":\"2019-12-18T17:44:34.000Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"2cfa54c9-23d3-4b98-b708-9f9e9611f706\",\"passPrice\":\"12\",\"position\":1,\"isOk\":true,\"title\":\"VR Headset1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"54c36a58-e118-4392-b8ce-fe24c6d953be\",\"comments\":\"Sent to Zoho\",\"item\":\"d17eb7fe-3744-48b9-89b0-8334f3628e33\",\"rentZohoId\":\"4280752000003757263\"},{\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2019-12-18T17:15:02.000Z\",\"_id\":\"75961107-b2b0-4020-9d2a-3745a3ce672b\",\"_createdDate\":\"2019-12-18T17:15:02.487Z\",\"passDuration\":\"8\",\"price\":5,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":5,\"roomType\":\"smart\",\"maxUsageTime\":3,\"_updatedDate\":\"2020-02-14T17:30:02.758Z\",\"total\":\"10\",\"code\":null,\"endTime\":\"2019-12-18T17:51:52.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"maxPrice\":null,\"passPrice\":\"30\",\"position\":1,\"isOk\":true,\"title\":\"Vacuum 1\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"d0fa4f86-9f7c-45eb-a21d-b90a6ec5e754\",\"comments\":\"Sent to Zoho\",\"item\":\"c58647b8-8057-4a11-981b-c68120e5eba2\",\"rating\":null,\"rentZohoId\":\"4280752000003719490\"}]","updateId":"75961107-b2b0-4020-9d2a-3745a3ce672b","_id":"1fe41b12-c648-45e7-9287-20fedcaff5f1"}}}]

User not available