Thu Feb 13 2020 20:00:02 GMT+0000 (Coordinated Universal Time)

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"ad84ab96-af7c-40da-b8f3-42e5f34dda70"},{"method":"Insert"},{"res: getTableSchema":"ok"},"run: insertToTable","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: insertToTable":"ok"},{"res: upsertTable":"ok"},{"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-13T19:58:02.433Z\",\"zohoId\":\"4280752000002386207\",\"_id\":\"d9d108db-6a1c-4471-b5b3-29f89b49d36b\",\"_createdDate\":\"2020-02-13T19:58:02.628Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T19:58:02.628Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"61925fbf-8c67-4130-9ae3-a1fee327a8db\",\"passPrice\":\"6\",\"isOk\":true,\"title\":\"Tool Box\",\"room\":\"3aa51b21-0757-46b7-841c-7288a72cff1c\",\"user\":\"47a3d01c-4a80-4d81-b778-ee391d59ef3c\",\"item\":\"982f6f77-032d-456f-9cae-710257d190be\"},{\"serial\":\"Home Theater Projector1\",\"isInRoom\":false,\"startTime\":\"2020-01-29T23:25:05.044Z\",\"_id\":\"6fca9d87-dc55-48d7-bb18-1f7422c15075\",\"_createdDate\":\"2020-01-29T23:25:05.233Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:39:15.202Z\",\"total\":0,\"endTime\":\"2020-01-29T23:26:16.927Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"28fcb079-d42d-467e-9936-a7185885506a\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Home Theater Projector1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"b5b1410f-3259-48df-8e70-2f5ac55d571c\",\"item\":\"ecbae392-8c70-4f36-96db-7cc248d494f4\",\"comments\":\"Sent to Zoho\"}]","updateId":"6fca9d87-dc55-48d7-bb18-1f7422c15075","_id":"dc77c873-7f2b-405f-b094-ceade1eef177"}}},{"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-13T19:58:02.433Z\",\"zohoId\":\"4280752000002386207\",\"_id\":\"d9d108db-6a1c-4471-b5b3-29f89b49d36b\",\"_createdDate\":\"2020-02-13T19:58:02.628Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T19:58:02.628Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"61925fbf-8c67-4130-9ae3-a1fee327a8db\",\"passPrice\":\"6\",\"isOk\":true,\"title\":\"Tool Box\",\"room\":\"3aa51b21-0757-46b7-841c-7288a72cff1c\",\"user\":\"47a3d01c-4a80-4d81-b778-ee391d59ef3c\",\"item\":\"982f6f77-032d-456f-9cae-710257d190be\"},{\"serial\":\"Printer2\",\"ip\":\"9a1b839b-e93a-d4ae-1421-aeec7bd94b2c\",\"isInRoom\":false,\"startTime\":\"2020-01-30T01:21:12.370Z\",\"_id\":\"d77ddeaf-7192-4f74-983f-f430cd57abfc\",\"_createdDate\":\"2020-01-30T01:21:12.623Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:39:15.204Z\",\"total\":0.2,\"files\":\"[{\\\"label\\\":\\\"Michelle-Vodopyanova-Resume.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/2cd4b5_bc153a4afb124145b5a94adf01c969b8.pdf\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-01-30T01:21:13.283Z\",\"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\",\"user\":\"992f287b-8add-4117-ac32-b80dd695631d\",\"item\":\"a441821a-172d-4e0b-9541-c24fc4730ca0\",\"comments\":\"Sent to Zoho\"}]","updateId":"d77ddeaf-7192-4f74-983f-f430cd57abfc","_id":"dc77c873-7f2b-405f-b094-ceade1eef177"}}},{"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-13T19:58:02.433Z\",\"zohoId\":\"4280752000002386207\",\"_id\":\"d9d108db-6a1c-4471-b5b3-29f89b49d36b\",\"_createdDate\":\"2020-02-13T19:58:02.628Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T19:58:02.628Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"61925fbf-8c67-4130-9ae3-a1fee327a8db\",\"passPrice\":\"6\",\"isOk\":true,\"title\":\"Tool Box\",\"room\":\"3aa51b21-0757-46b7-841c-7288a72cff1c\",\"user\":\"47a3d01c-4a80-4d81-b778-ee391d59ef3c\",\"item\":\"982f6f77-032d-456f-9cae-710257d190be\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-01-29T21:00:45.216Z\",\"_id\":\"ad84ab96-af7c-40da-b8f3-42e5f34dda70\",\"_createdDate\":\"2020-01-29T21:00:45.415Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:39:15.201Z\",\"total\":3,\"endTime\":\"2020-01-29T22:23:28.416Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"61925fbf-8c67-4130-9ae3-a1fee327a8db\",\"passPrice\":\"6\",\"isOk\":true,\"title\":\"Tool Box\",\"room\":\"8c460d4c-50f6-4f31-bf08-1f1323b8fb2c\",\"user\":\"47a572e5-776a-49b6-8b24-ebe5d2b848ed\",\"item\":\"ceea5db7-2715-45f8-b69a-5173ceade7b1\",\"comments\":\"Sent to Zoho\"}]","updateId":"ad84ab96-af7c-40da-b8f3-42e5f34dda70","_id":"dc77c873-7f2b-405f-b094-ceade1eef177"}}},{"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-13T19:58:02.433Z\",\"zohoId\":\"4280752000002386207\",\"_id\":\"d9d108db-6a1c-4471-b5b3-29f89b49d36b\",\"_createdDate\":\"2020-02-13T19:58:02.628Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T19:58:02.628Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"61925fbf-8c67-4130-9ae3-a1fee327a8db\",\"passPrice\":\"6\",\"isOk\":true,\"title\":\"Tool Box\",\"room\":\"3aa51b21-0757-46b7-841c-7288a72cff1c\",\"user\":\"47a3d01c-4a80-4d81-b778-ee391d59ef3c\",\"item\":\"982f6f77-032d-456f-9cae-710257d190be\"},{\"serial\":\"Bluetooth Speaker2\",\"isInRoom\":false,\"startTime\":\"2020-01-29T21:49:27.677Z\",\"_id\":\"6d190f8a-aba7-4526-9101-43321af6d937\",\"_createdDate\":\"2020-01-29T21:49:27.884Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:39:15.204Z\",\"total\":4,\"endTime\":\"2020-01-29T23:29:02.474Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"f63190a5-81cc-4f84-ba8e-b0edaf62b276\",\"passPrice\":\"6\",\"position\":\"2\",\"isOk\":true,\"title\":\"Bluetooth Speaker2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e535cb03-580d-412d-b0a8-767acd4dceee\",\"item\":\"a1874147-6680-4977-a28d-8b8579b31fd9\",\"comments\":\"Sent to Zoho\"}]","updateId":"6d190f8a-aba7-4526-9101-43321af6d937","_id":"dc77c873-7f2b-405f-b094-ceade1eef177"}}},{"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-13T19:58:02.433Z\",\"zohoId\":\"4280752000002386207\",\"_id\":\"d9d108db-6a1c-4471-b5b3-29f89b49d36b\",\"_createdDate\":\"2020-02-13T19:58:02.628Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T19:58:02.628Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"61925fbf-8c67-4130-9ae3-a1fee327a8db\",\"passPrice\":\"6\",\"isOk\":true,\"title\":\"Tool Box\",\"room\":\"3aa51b21-0757-46b7-841c-7288a72cff1c\",\"user\":\"47a3d01c-4a80-4d81-b778-ee391d59ef3c\",\"item\":\"982f6f77-032d-456f-9cae-710257d190be\"},{\"serial\":\"Robot Mop3\",\"isInRoom\":false,\"startTime\":\"2020-01-29T23:20:28.600Z\",\"_id\":\"1813ebe5-0979-41e3-b910-f14bf1eb49a0\",\"_createdDate\":\"2020-01-29T23:20:28.941Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:39:15.200Z\",\"total\":0,\"endTime\":\"2020-01-29T23:21:55.036Z\",\"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\":\"b5b1410f-3259-48df-8e70-2f5ac55d571c\",\"item\":\"85487031-221f-4522-be58-2f465cffed6c\",\"comments\":\"Sent to Zoho\"}]","updateId":"1813ebe5-0979-41e3-b910-f14bf1eb49a0","_id":"dc77c873-7f2b-405f-b094-ceade1eef177"}}}]

User not available