Thu Feb 13 2020 15:45:02 GMT+0000 (Coordinated Universal Time)

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"9c08dcfb-6d64-43d2-aafd-1a48ef27775c"},{"method":"Insert"},{"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: 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\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-02-13T15:38:32.360Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:32.360Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:45.066Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Vacuum 3\",\"isInRoom\":false,\"startTime\":\"2020-02-03T12:15:09.583Z\",\"zohoId\":\"4280752000001397225\",\"_id\":\"7e81d942-ce6f-4dc5-8cd7-634cbfe7817e\",\"_createdDate\":\"2020-02-03T12:15:09.827Z\",\"passDuration\":\"4\",\"price\":5,\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-03T12:15:46.415Z\",\"total\":0,\"code\":\"00794\",\"endTime\":\"2020-02-03T12:15:39.629Z\",\"rating\":5,\"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\":\"e8d11c29-e30e-4866-acba-8c0ec576ea92\",\"item\":\"42961a91-13f4-4989-91f5-87cba7d99b0e\",\"comments\":\"Sent to Zoho\"}]","updateId":"7e81d942-ce6f-4dc5-8cd7-634cbfe7817e","_id":"439574d7-797d-451c-80b7-db46f533f211"}}},{"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-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-02-13T15:38:32.360Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:32.360Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:45.066Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer1\",\"ip\":\"fabb36f8-7c44-ecb0-09dc-59b4d4b6a5cd\",\"isInRoom\":false,\"startTime\":\"2020-02-03T13:07:53.921Z\",\"zohoId\":\"4280752000001354845\",\"_id\":\"22456ac3-b1a1-4c0b-86cb-125871f661b7\",\"_createdDate\":\"2020-02-03T13:07:54.178Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-03T13:08:19.764Z\",\"total\":0.1,\"files\":\"[{\\\"label\\\":\\\"Untitled document.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/6f4c9e_ceb535b7b97e47e2847b834758cb77ef.pdf\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-02-03T13:07:54.914Z\",\"rating\":1,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"position\":\"1\",\"isOk\":true,\"title\":\"Printer1 EHS\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"6f4c9e0d-4ac0-408c-863d-1fdf53bd5ece\",\"item\":\"f09a60f2-b63d-4e2d-bd97-7d83d2b9a9f2\",\"comments\":\"Sent to Zoho\"}]","updateId":"22456ac3-b1a1-4c0b-86cb-125871f661b7","_id":"439574d7-797d-451c-80b7-db46f533f211"}}},{"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-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-02-13T15:38:32.360Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:32.360Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:45.066Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer2\",\"ip\":\"9a1b839b-e93a-d4ae-1421-aeec7bd94b2c\",\"isInRoom\":false,\"startTime\":\"2020-02-03T07:42:21.000Z\",\"zohoId\":\"4280752000001374578\",\"_id\":\"050b5fef-f3c4-4511-862b-a8244787d3f2\",\"_createdDate\":\"2020-02-03T07:42:21.694Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-13T09:07:15.511Z\",\"total\":\"0.2\",\"files\":\"[{\\\"label\\\":\\\"DB#3B - Differences In Articles.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/7c3831_8e75b5d131e44a67b1e4d0ebc52d95ae.pdf\\\",\\\"pageCount\\\":2}]\",\"endTime\":\"2020-02-03T07:42:21.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"position\":\"2\",\"isOk\":true,\"title\":\"Printer2 EHS\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"item\":\"a441821a-172d-4e0b-9541-c24fc4730ca0\",\"comments\":\"Sent to Zoho\"}]","updateId":"050b5fef-f3c4-4511-862b-a8244787d3f2","_id":"439574d7-797d-451c-80b7-db46f533f211"}}}]

User not available