Wed Feb 26 2020 10:15:03 GMT+0000 (Coordinated Universal Time)

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"29b6f49c-2bdc-4397-9c30-41efaef85639"},{"method":"Insert"},{"run: upsertTable":3},{"run: upsertTable":"users"},"run: upsertTable","run: getTableSchema","run: bigQueryJobs_update",{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"oneSignal_users","data":"[{\"appBuild\":\"1.0.9\",\"customData_userId\":\"80f405df-7a42-410b-97a9-527cdf6062a4\",\"oneSignalPushToken\":\"b317b5a107eefdaf4cb3d52d97a45afe0de67fd470009ca57561a18261fecbd6\",\"model\":\"iPhone\",\"_id\":\"4c512dce-280c-4225-9fed-97663a9fffaa\",\"_createdDate\":\"2020-02-18T18:55:19.455Z\",\"tags\":\"{\\\"email\\\":\\\"adighbish@mail.tau.ac.il\\\",\\\"phone\\\":\\\" 972509563550\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"TAU Dorms - G Lobby\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"67004669-3BA6-4AFD-8972-0BBD7C371B61\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-26T10:04:41.808Z\",\"hardware\":\"iPhone10,6\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"en-IL\",\"carrierName\":\"Pelephone\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.3.1\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"4d065871-32cd-411f-b025-70b45d3588cf\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"appBuild\":\"1.0.9\",\"customData_userId\":\"80f405df-7a42-410b-97a9-527cdf6062a4\",\"oneSignalPushToken\":\"39d2cb12564acdc9983b804ad436ffb4af0b493852da1e08b1d28e6afece2e6f\",\"model\":\"iPhone\",\"_id\":\"031e375f-d0a7-4240-a602-daf642111246\",\"_createdDate\":\"2020-01-19T20:24:54.233Z\",\"tags\":\"{\\\"email\\\":\\\"adighbish@mail.tau.ac.il\\\",\\\"phone\\\":\\\" 972509563550\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"TAU Dorms - G Lobby\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"5907A2D8-B4C4-45EA-BC48-6079E1779F37\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-26T10:04:42.144Z\",\"hardware\":\"iPhone10,6\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"en-IL\",\"carrierName\":\"Pelephone\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.3\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"d5ecc30b-1e6c-4b5f-8272-c94b3b1a6843\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"appBuild\":\"1.0.9\",\"customData_userId\":\"80f405df-7a42-410b-97a9-527cdf6062a4\",\"oneSignalPushToken\":\"b317b5a107eefdaf4cb3d52d97a45afe0de67fd470009ca57561a18261fecbd6\",\"model\":\"iPhone\",\"_id\":\"4c512dce-280c-4225-9fed-97663a9fffaa\",\"_createdDate\":\"2020-02-18T18:55:19.455Z\",\"tags\":\"{\\\"email\\\":\\\"adighbish@mail.tau.ac.il\\\",\\\"phone\\\":\\\" 972509563550\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"TAU Dorms - G Lobby\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"67004669-3BA6-4AFD-8972-0BBD7C371B61\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-26T10:06:50.890Z\",\"hardware\":\"iPhone10,6\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"en-IL\",\"carrierName\":\"Pelephone\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.3.1\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"4d065871-32cd-411f-b025-70b45d3588cf\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"appBuild\":\"1.0.9\",\"customData_userId\":\"80f405df-7a42-410b-97a9-527cdf6062a4\",\"oneSignalPushToken\":\"39d2cb12564acdc9983b804ad436ffb4af0b493852da1e08b1d28e6afece2e6f\",\"model\":\"iPhone\",\"_id\":\"031e375f-d0a7-4240-a602-daf642111246\",\"_createdDate\":\"2020-01-19T20:24:54.233Z\",\"tags\":\"{\\\"email\\\":\\\"adighbish@mail.tau.ac.il\\\",\\\"phone\\\":\\\" 972509563550\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"TAU Dorms - G Lobby\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"5907A2D8-B4C4-45EA-BC48-6079E1779F37\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-26T10:06:51.193Z\",\"hardware\":\"iPhone10,6\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"en-IL\",\"carrierName\":\"Pelephone\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.3\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"d5ecc30b-1e6c-4b5f-8272-c94b3b1a6843\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"appBuild\":\"1.0.9\",\"customData_userId\":\"80f405df-7a42-410b-97a9-527cdf6062a4\",\"oneSignalPushToken\":\"b317b5a107eefdaf4cb3d52d97a45afe0de67fd470009ca57561a18261fecbd6\",\"model\":\"iPhone\",\"_id\":\"4c512dce-280c-4225-9fed-97663a9fffaa\",\"_createdDate\":\"2020-02-18T18:55:19.455Z\",\"tags\":\"{\\\"email\\\":\\\"adighbish@mail.tau.ac.il\\\",\\\"phone\\\":\\\" 972509563550\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"TAU Dorms - G Lobby\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"67004669-3BA6-4AFD-8972-0BBD7C371B61\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-26T10:06:52.419Z\",\"hardware\":\"iPhone10,6\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"en-IL\",\"carrierName\":\"Pelephone\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.3.1\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"4d065871-32cd-411f-b025-70b45d3588cf\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"appBuild\":\"1.0.9\",\"customData_userId\":\"80f405df-7a42-410b-97a9-527cdf6062a4\",\"oneSignalPushToken\":\"39d2cb12564acdc9983b804ad436ffb4af0b493852da1e08b1d28e6afece2e6f\",\"model\":\"iPhone\",\"_id\":\"031e375f-d0a7-4240-a602-daf642111246\",\"_createdDate\":\"2020-01-19T20:24:54.233Z\",\"tags\":\"{\\\"email\\\":\\\"adighbish@mail.tau.ac.il\\\",\\\"phone\\\":\\\" 972509563550\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"TAU Dorms - G Lobby\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"5907A2D8-B4C4-45EA-BC48-6079E1779F37\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-26T10:06:52.751Z\",\"hardware\":\"iPhone10,6\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"en-IL\",\"carrierName\":\"Pelephone\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.3\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"d5ecc30b-1e6c-4b5f-8272-c94b3b1a6843\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"customData_userId\":\"e8d11c29-e30e-4866-acba-8c0ec576ea92\",\"model\":\"samsung SM-A530F\",\"_id\":\"38610f6e-d97b-4111-ba39-e0e9cf820528\",\"_createdDate\":\"2019-10-31T16:33:30.612Z\",\"tags\":\"{\\\"email\\\":\\\"rusotours2@gmail.com\\\",\\\"phone\\\":\\\"0507781997\\\",\\\"userType\\\":\\\"admin\\\",\\\"building\\\":\\\"1760 Third Avenue\\\"}\",\"distribution\":\"playstore\",\"installationId\":\"4efe8978-7680-47b1-8ac7-bb7b50c16dfc\",\"appVersion\":\"1.0.7\",\"os\":\"Android\",\"_updatedDate\":\"2020-02-26T10:10:18.985Z\",\"hardware\":\"samsung/jackpotltexx/jackpotlte:9/PPR1.180610.011/A530FXXU4CSCD:user/release-keys\",\"oneSignalRequiresUserPrivacyConsent\":true,\"oneSignalSubscribed\":true,\"language\":\"iw\",\"carrierName\":\"\",\"publicKey\":\"nnakrm\",\"osVersion\":\"9\",\"appId\":\"com.tulou.app\",\"platform\":\"android\",\"appVersionCode\":11,\"oneSignalRegistrationId\":\"APA91bFysbUH8MJ0yaqjjSywJLl-3pWpoG5MkzvOhSjUL2XpjejvDmz3p0bMJzpmHga2p6Q8Kdh2ogRHbiyDS1woFxPRDdZCUALTV1BQUZHhvLQEDajm3VI\",\"oneSignalUserId\":\"95bb24cd-5374-45b8-8002-5f21469caf3e\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"customData_userId\":\"c6d22340-04c9-48e1-9887-cf256f707f39\",\"model\":\"samsung SM-G960F\",\"_id\":\"29b6f49c-2bdc-4397-9c30-41efaef85639\",\"_createdDate\":\"2020-01-28T09:07:53.693Z\",\"tags\":\"{\\\"email\\\":\\\"einat.besser@gmail.com\\\",\\\"phone\\\":\\\"972523484777\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"Community Center Magid\\\"}\",\"distribution\":\"playstore\",\"installationId\":\"c28a4199-9537-424b-9a08-d8a7243bfd4c\",\"appVersion\":\"1.0.9\",\"os\":\"Android\",\"_updatedDate\":\"2020-02-26T10:15:00.271Z\",\"hardware\":\"samsung/starltexx/starlte:9/PPR1.180610.011/G960FXXU4CSE3:user/release-keys\",\"oneSignalRequiresUserPrivacyConsent\":true,\"oneSignalSubscribed\":true,\"language\":\"iw\",\"carrierName\":\"Pelephone\",\"publicKey\":\"nnakrm\",\"osVersion\":\"9\",\"appId\":\"com.tulou.app\",\"platform\":\"android\",\"appVersionCode\":19,\"oneSignalRegistrationId\":\"APA91bGK2f1w7mw9-C-CaqPwO2mDb7-hdJh-Vpetmw5mUA0EQI2wyaOkwP75DyCS-YnIOXBICnNjVdjWtw8E9FJJEcgFbDXaHteojFIyBka8Zq8N-PN0jCM\",\"oneSignalUserId\":\"650f3f6e-dc5a-4da0-8b11-e344f92a3ed0\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"customData_userId\":\"c6d22340-04c9-48e1-9887-cf256f707f39\",\"model\":\"samsung SM-G960F\",\"_id\":\"29b6f49c-2bdc-4397-9c30-41efaef85639\",\"_createdDate\":\"2020-01-28T09:07:53.693Z\",\"tags\":\"{\\\"email\\\":\\\"einat.besser@gmail.com\\\",\\\"phone\\\":\\\"972523484777\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"Community Center Magid\\\"}\",\"distribution\":\"playstore\",\"installationId\":\"c28a4199-9537-424b-9a08-d8a7243bfd4c\",\"appVersion\":\"1.0.9\",\"os\":\"Android\",\"_updatedDate\":\"2020-02-26T10:15:02.778Z\",\"hardware\":\"samsung/starltexx/starlte:9/PPR1.180610.011/G960FXXU4CSE3:user/release-keys\",\"oneSignalRequiresUserPrivacyConsent\":true,\"oneSignalSubscribed\":true,\"language\":\"iw\",\"carrierName\":\"Pelephone\",\"publicKey\":\"nnakrm\",\"osVersion\":\"9\",\"appId\":\"com.tulou.app\",\"platform\":\"android\",\"appVersionCode\":19,\"oneSignalRegistrationId\":\"APA91bGK2f1w7mw9-C-CaqPwO2mDb7-hdJh-Vpetmw5mUA0EQI2wyaOkwP75DyCS-YnIOXBICnNjVdjWtw8E9FJJEcgFbDXaHteojFIyBka8Zq8N-PN0jCM\",\"oneSignalUserId\":\"650f3f6e-dc5a-4da0-8b11-e344f92a3ed0\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"}]","updateId":"29b6f49c-2bdc-4397-9c30-41efaef85639","_id":"ba5336eb-5400-4d57-a43d-53a463d8b902"}}}]

User not available