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

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"7d2dfdcd-70b3-46d8-a80b-39d487a8aaea"},{"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",{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-01-18T17:06:00.000Z\",\"_id\":\"a00c6644-9ca9-421d-8898-52c11e9f4ced\",\"_createdDate\":\"2020-01-18T17:06:29.588Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":2,\"endTime\":\"2020-01-18T17:30:00.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"0d06f8fb-fd3d-4a8e-8456-d460a161c147\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\",\"comments\":\"Sent to Zoho\"}]","updateId":"a00c6644-9ca9-421d-8898-52c11e9f4ced","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-01-18T16:01:05.730Z\",\"_id\":\"ce302380-486b-42f9-8995-38bf88678ea7\",\"_createdDate\":\"2020-01-18T16:01:05.925Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":4,\"endTime\":\"2020-01-18T17:05:24.673Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"0d06f8fb-fd3d-4a8e-8456-d460a161c147\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\",\"comments\":\"Sent to Zoho\"}]","updateId":"ce302380-486b-42f9-8995-38bf88678ea7","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Window Robot 1\",\"isInRoom\":false,\"startTime\":\"2020-01-18T15:44:11.392Z\",\"_id\":\"42a40e0d-b26c-44da-a885-8940f6b80a0d\",\"_createdDate\":\"2020-01-18T15:44:11.601Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":15,\"code\":\"00761\",\"endTime\":\"2020-01-18T16:52:49.317Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"3ef7be44-a5f8-432a-8554-e7aadd8efc4f\",\"passPrice\":\"20\",\"position\":\"1\",\"isOk\":true,\"title\":\"Window Robot 1\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"b4d1b722-18ad-4f63-8316-102a9aa3a036\",\"item\":\"c1004df2-2290-4f9a-8aba-67275e05781c\",\"comments\":\"Sent to Zoho\"}]","updateId":"42a40e0d-b26c-44da-a885-8940f6b80a0d","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Vacuum 3\",\"isInRoom\":false,\"startTime\":\"2020-01-18T17:01:45.788Z\",\"_id\":\"a24dcdff-71df-4e66-a8b0-a69bbcfc2b69\",\"_createdDate\":\"2020-01-18T17:01:46.180Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":5,\"code\":\"00493\",\"endTime\":\"2020-01-18T17:21:18.690Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum 3\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"987d94fd-15bb-4e5f-8634-a94df80b3474\",\"item\":\"d1c25ee5-6f31-401b-9cdb-ddfc7661998d\",\"comments\":\"Sent to Zoho\"}]","updateId":"a24dcdff-71df-4e66-a8b0-a69bbcfc2b69","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}}]

User not available