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"}}},"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\":\"***\",\"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 1\",\"isInRoom\":false,\"startTime\":\"2020-01-18T19:09:00.000Z\",\"zohoId\":\"4280752000002907678\",\"_id\":\"9e0741f1-3990-41cf-870f-6fa8c2fff1c1\",\"_createdDate\":\"2020-01-18T17:09:59.453Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T09:07:49.958Z\",\"code\":\"00674\",\"endTime\":\"2020-01-18T19:17:00.000Z\",\"rating\":\"1\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum 1\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"3fd2deb3-edbf-48f5-97d6-53baf42a4a93\",\"item\":\"b082bc4d-88fd-4b43-871e-920f1059fee4\",\"comments\":\"Sent to Zoho\"}]","updateId":"9e0741f1-3990-41cf-870f-6fa8c2fff1c1","_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 Cleaner 1\",\"isInRoom\":false,\"startTime\":\"2020-01-18T15:00:00.000Z\",\"Position_Text\":\"Available in the TULU room on the Lobby floor\",\"_id\":\"049e93f7-a34e-41d0-a3f0-6fb4becfb9a1\",\"_createdDate\":\"2020-01-18T15:00:39.901Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":1.6,\"endTime\":\"2020-01-18T15:32:00.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum Cleaner 1\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"6df1b6b6-907c-4fd3-b67b-5f2102c38b5d\",\"item\":\"81bfdb1e-09ea-4b53-aaad-7b2263be8e1f\",\"comments\":\"Sent to Zoho\"}]","updateId":"049e93f7-a34e-41d0-a3f0-6fb4becfb9a1","_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\":\"Sewing machine\",\"isInRoom\":false,\"startTime\":\"2020-01-18T15:59:26.808Z\",\"_id\":\"05bb5913-f1e0-4b3c-8f69-3a1e3c9f84b5\",\"_createdDate\":\"2020-01-18T15:59:27.009Z\",\"passDuration\":\"24,48\",\"baseTime\":\"60\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":20,\"endTime\":\"2020-01-18T21:37:21.868Z\",\"rating\":1,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"d8dc287c-d8ca-4a33-a69e-56a4468f7377\",\"passPrice\":\"20,20\",\"isOk\":true,\"title\":\"Sewing machine\",\"room\":\"79c4d41a-0294-446b-b306-b0413963c9ac\",\"user\":\"6c8787d9-8b5d-4b86-b51f-e254933a2ebb\",\"item\":\"008c3bea-62b8-437d-94d5-acae57a98f85\",\"comments\":\"Sent to Zoho\"}]","updateId":"05bb5913-f1e0-4b3c-8f69-3a1e3c9f84b5","_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 1\",\"isInRoom\":false,\"startTime\":\"2020-01-18T12:46:13.632Z\",\"_id\":\"7fc5ebe8-f91f-49cd-9632-62a3dadeca93\",\"_createdDate\":\"2020-01-18T12:46:14.025Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":5,\"code\":\"00746\",\"endTime\":\"2020-01-18T13:16:53.895Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum 1\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"1a7c2568-46f7-47e5-a907-a2960e26f651\",\"item\":\"3e978b61-60da-4760-a1bc-2e6c92fe9688\",\"comments\":\"Sent to Zoho\"}]","updateId":"7fc5ebe8-f91f-49cd-9632-62a3dadeca93","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}}]

User not available