Mon Feb 10 2020 11:45:05 GMT+0000 (Coordinated Universal Time)

Msg: Error - sendToBigQuery
Info: ["run: runBigQueryJobs",{"res: runBigQueryJobs_query":3},{"run: upsertTable":0},{"run: upsertTable":"users"},"run: upsertTable","run: getTableSchema",{"res: getTableSchema":"ok"},"run: insertToTable",{"res: insertToTable":"ok"},{"res: upsertTable":"ok"},{"run: upsertTable":1},{"run: upsertTable":"oneSignal_users"},"run: upsertTable","run: getTableSchema",{"res: getTableSchema":"ok"},"run: insertToTable",{"res: insertToTable":"ok"},{"res: upsertTable":"ok"},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_REQUEST_TIMED_OUT"},"item":{"method":"Insert","table":"oneSignal_users","data":"[{\"appBuild\":\"1.0.9\",\"customData_userId\":\"b07f6e99-8df5-443e-9a78-859c3221a26c\",\"oneSignalPushToken\":\"441b50a59e02ff716e6260ad95461c409f57e967166b9ae67005021279d19b5b\",\"model\":\"iPhone\",\"_id\":\"b91c2c6f-9d2e-4367-98bd-0af77c9fa1ac\",\"_createdDate\":\"2020-01-28T11:55:35.077Z\",\"tags\":\"{\\\"email\\\":\\\"yanivoron@gmail.con\\\",\\\"phone\\\":\\\"972522204429\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"Community Center Magid\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"C373A16E-3B6A-447D-B482-C6B375188B0F\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-10T11:37:52.458Z\",\"hardware\":\"iPhone9,1\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"he-US\",\"carrierName\":\"Partner Israel\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.2\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"d4336852-3f38-438e-9dc4-1483a1c3eadb\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"appBuild\":\"1.0.9\",\"customData_userId\":\"6f4c9e0d-4ac0-408c-863d-1fdf53bd5ece\",\"oneSignalPushToken\":\"fce796efc1ca6832ddc48c60c046ab1265da6b214e328885eff3691370bd299a\",\"model\":\"iPhone\",\"_id\":\"aab5bab0-de16-41d7-8c72-d149c5551ae7\",\"_createdDate\":\"2020-01-29T11:07:03.048Z\",\"tags\":\"{\\\"email\\\":\\\"kim.dewu@baruchmail.cunt.edu\\\",\\\"phone\\\":\\\" 16465485423\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"1760 Third Avenue\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"9720C8BD-4420-4FA4-8452-A43347260CE0\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-10T11:38:32.697Z\",\"hardware\":\"iPhone11,2\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"en-US\",\"carrierName\":\"Sprint\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.3\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"1ab5f08b-e1e0-4427-b6ce-6e63bfe0600a\",\"timeZone\":\"America/New_York\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"appBuild\":\"1.0.9\",\"customData_userId\":\"6f4c9e0d-4ac0-408c-863d-1fdf53bd5ece\",\"oneSignalPushToken\":\"fce796efc1ca6832ddc48c60c046ab1265da6b214e328885eff3691370bd299a\",\"model\":\"iPhone\",\"_id\":\"aab5bab0-de16-41d7-8c72-d149c5551ae7\",\"_createdDate\":\"2020-01-29T11:07:03.048Z\",\"tags\":\"{\\\"email\\\":\\\"kim.dewu@baruchmail.cunt.edu\\\",\\\"phone\\\":\\\" 16465485423\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"1760 Third Avenue\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"9720C8BD-4420-4FA4-8452-A43347260CE0\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-10T11:38:33.536Z\",\"hardware\":\"iPhone11,2\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"en-US\",\"carrierName\":\"Sprint\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.3\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"1ab5f08b-e1e0-4427-b6ce-6e63bfe0600a\",\"timeZone\":\"America/New_York\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"customData_userId\":\"6be9926f-2bc8-4b52-88c3-84828f2f4dc2\",\"model\":\"Xiaomi Redmi Note 4\",\"_id\":\"0752afde-a498-4e81-9f1e-f5e9dda2d821\",\"_createdDate\":\"2019-10-29T16:47:24.334Z\",\"tags\":\"{\\\"email\\\":\\\"asb@amitsh.com\\\",\\\"phone\\\":\\\"972525022333\\\",\\\"userType\\\":\\\"admin\\\",\\\"building\\\":\\\"Levontin 30\\\"}\",\"distribution\":\"playstore\",\"installationId\":\"282152b8-72ec-40ca-b233-28c3fb0c92b2\",\"appVersion\":\"1.0.7\",\"os\":\"Android\",\"_updatedDate\":\"2020-02-10T11:39:50.817Z\",\"hardware\":\"xiaomi/mido/mido:7.0/NRD90M/V10.2.3.0.NCFMIXM:user/release-keys\",\"oneSignalRequiresUserPrivacyConsent\":true,\"oneSignalSubscribed\":true,\"language\":\"iw\",\"carrierName\":\"012 Mobile\",\"publicKey\":\"nnakrm\",\"osVersion\":\"7.0\",\"appId\":\"com.tulou.app\",\"platform\":\"android\",\"appVersionCode\":11,\"oneSignalRegistrationId\":\"APA91bFa9YJheozFMYQqy8xCiphnbPNkhxxrBxI3xY5JUg6k6wOfbfjMwrSfcX7PBm1JTdGGbeKHZSQSDDZjD0eRHR8Z3YzNQABt2_wBkVwNfcHIqxIC7aY\",\"oneSignalUserId\":\"69567fab-6fd9-45bf-9914-af85cc0f0458\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"customData_userId\":\"6be9926f-2bc8-4b52-88c3-84828f2f4dc2\",\"model\":\"Xiaomi Redmi Note 4\",\"_id\":\"0752afde-a498-4e81-9f1e-f5e9dda2d821\",\"_createdDate\":\"2019-10-29T16:47:24.334Z\",\"tags\":\"{\\\"email\\\":\\\"asb@amitsh.com\\\",\\\"phone\\\":\\\"972525022333\\\",\\\"userType\\\":\\\"admin\\\",\\\"building\\\":\\\"Levontin 30\\\"}\",\"distribution\":\"playstore\",\"installationId\":\"282152b8-72ec-40ca-b233-28c3fb0c92b2\",\"appVersion\":\"1.0.7\",\"os\":\"Android\",\"_updatedDate\":\"2020-02-10T11:39:54.801Z\",\"hardware\":\"xiaomi/mido/mido:7.0/NRD90M/V10.2.3.0.NCFMIXM:user/release-keys\",\"oneSignalRequiresUserPrivacyConsent\":true,\"oneSignalSubscribed\":true,\"language\":\"iw\",\"carrierName\":\"012 Mobile\",\"publicKey\":\"nnakrm\",\"osVersion\":\"7.0\",\"appId\":\"com.tulou.app\",\"platform\":\"android\",\"appVersionCode\":11,\"oneSignalRegistrationId\":\"APA91bFa9YJheozFMYQqy8xCiphnbPNkhxxrBxI3xY5JUg6k6wOfbfjMwrSfcX7PBm1JTdGGbeKHZSQSDDZjD0eRHR8Z3YzNQABt2_wBkVwNfcHIqxIC7aY\",\"oneSignalUserId\":\"69567fab-6fd9-45bf-9914-af85cc0f0458\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"appBuild\":\"1.0.9\",\"customData_userId\":\"6f4c9e0d-4ac0-408c-863d-1fdf53bd5ece\",\"oneSignalPushToken\":\"fce796efc1ca6832ddc48c60c046ab1265da6b214e328885eff3691370bd299a\",\"model\":\"iPhone\",\"_id\":\"aab5bab0-de16-41d7-8c72-d149c5551ae7\",\"_createdDate\":\"2020-01-29T11:07:03.048Z\",\"tags\":\"{\\\"email\\\":\\\"kim.dewu@baruchmail.cunt.edu\\\",\\\"phone\\\":\\\" 16465485423\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"1760 Third Avenue\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"9720C8BD-4420-4FA4-8452-A43347260CE0\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-10T11:41:08.020Z\",\"hardware\":\"iPhone11,2\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"en-US\",\"carrierName\":\"Sprint\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.3\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"1ab5f08b-e1e0-4427-b6ce-6e63bfe0600a\",\"timeZone\":\"America/New_York\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"appBuild\":\"1.0.9\",\"customData_userId\":\"b07f6e99-8df5-443e-9a78-859c3221a26c\",\"oneSignalPushToken\":\"441b50a59e02ff716e6260ad95461c409f57e967166b9ae67005021279d19b5b\",\"model\":\"iPhone\",\"_id\":\"b91c2c6f-9d2e-4367-98bd-0af77c9fa1ac\",\"_createdDate\":\"2020-01-28T11:55:35.077Z\",\"tags\":\"{\\\"email\\\":\\\"yanivoron@gmail.con\\\",\\\"phone\\\":\\\"972522204429\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"Community Center Magid\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"C373A16E-3B6A-447D-B482-C6B375188B0F\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-10T11:41:48.115Z\",\"hardware\":\"iPhone9,1\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"he-US\",\"carrierName\":\"Partner Israel\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.2\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"d4336852-3f38-438e-9dc4-1483a1c3eadb\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"appBuild\":\"1.0.9\",\"customData_userId\":\"b07f6e99-8df5-443e-9a78-859c3221a26c\",\"oneSignalPushToken\":\"441b50a59e02ff716e6260ad95461c409f57e967166b9ae67005021279d19b5b\",\"model\":\"iPhone\",\"_id\":\"b91c2c6f-9d2e-4367-98bd-0af77c9fa1ac\",\"_createdDate\":\"2020-01-28T11:55:35.077Z\",\"tags\":\"{\\\"email\\\":\\\"yanivoron@gmail.con\\\",\\\"phone\\\":\\\"972522204429\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"Community Center Magid\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"C373A16E-3B6A-447D-B482-C6B375188B0F\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-10T11:41:50.276Z\",\"hardware\":\"iPhone9,1\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"he-US\",\"carrierName\":\"Partner Israel\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.2\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"d4336852-3f38-438e-9dc4-1483a1c3eadb\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"appBuild\":\"1.0.9\",\"customData_userId\":\"ab663f91-36f4-4b80-b186-4b53c03b9b5b\",\"oneSignalPushToken\":\"0252e811981b850e6dfa3b2c977ee83aec9d2458a92904945755067251bfd80a\",\"model\":\"iPhone\",\"_id\":\"198202b4-53a5-4ca2-8c0f-7e59556825f1\",\"_createdDate\":\"2020-02-10T11:42:08.133Z\",\"distribution\":\"appstore\",\"installationId\":\"56E38C1B-512C-44E6-87A1-35946B6D0728\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-10T11:42:08.133Z\",\"hardware\":\"iPhone11,2\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"he-IL\",\"carrierName\":\"Carrier\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.3\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"bf1efbc4-16f8-4de5-bc65-4ef7cccbc58b\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"appBuild\":\"1.0.9\",\"customData_userId\":\"6f4c9e0d-4ac0-408c-863d-1fdf53bd5ece\",\"oneSignalPushToken\":\"fce796efc1ca6832ddc48c60c046ab1265da6b214e328885eff3691370bd299a\",\"model\":\"iPhone\",\"_id\":\"aab5bab0-de16-41d7-8c72-d149c5551ae7\",\"_createdDate\":\"2020-01-29T11:07:03.048Z\",\"tags\":\"{\\\"email\\\":\\\"kim.dewu@baruchmail.cunt.edu\\\",\\\"phone\\\":\\\" 16465485423\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"1760 Third Avenue\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"9720C8BD-4420-4FA4-8452-A43347260CE0\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-10T11:42:08.397Z\",\"hardware\":\"iPhone11,2\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"en-US\",\"carrierName\":\"Sprint\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.3\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"1ab5f08b-e1e0-4427-b6ce-6e63bfe0600a\",\"timeZone\":\"America/New_York\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"appBuild\":\"1.0.9\",\"customData_userId\":\"ab663f91-36f4-4b80-b186-4b53c03b9b5b\",\"oneSignalPushToken\":\"0252e811981b850e6dfa3b2c977ee83aec9d2458a92904945755067251bfd80a\",\"model\":\"iPhone\",\"_id\":\"198202b4-53a5-4ca2-8c0f-7e59556825f1\",\"_createdDate\":\"2020-02-10T11:42:08.133Z\",\"tags\":\"{\\\"email\\\":\\\"macmetlv@gmail.com\\\",\\\"phone\\\":\\\"+972542151162\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"Dizengoff /Tchernichovsky 59\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"56E38C1B-512C-44E6-87A1-35946B6D0728\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-10T11:42:39.837Z\",\"hardware\":\"iPhone11,2\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"he-IL\",\"carrierName\":\"Carrier\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.3\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"bf1efbc4-16f8-4de5-bc65-4ef7cccbc58b\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"appBuild\":\"1.0.9\",\"customData_userId\":\"6f4c9e0d-4ac0-408c-863d-1fdf53bd5ece\",\"oneSignalPushToken\":\"fce796efc1ca6832ddc48c60c046ab1265da6b214e328885eff3691370bd299a\",\"model\":\"iPhone\",\"_id\":\"aab5bab0-de16-41d7-8c72-d149c5551ae7\",\"_createdDate\":\"2020-01-29T11:07:03.048Z\",\"tags\":\"{\\\"email\\\":\\\"kim.dewu@baruchmail.cunt.edu\\\",\\\"phone\\\":\\\" 16465485423\\\",\\\"userType\\\":\\\"user\\\",\\\"building\\\":\\\"1760 Third Avenue\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"9720C8BD-4420-4FA4-8452-A43347260CE0\",\"appVersion\":\"1.0.9\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-10T11:44:12.203Z\",\"hardware\":\"iPhone11,2\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"en-US\",\"carrierName\":\"Sprint\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.3\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"1ab5f08b-e1e0-4427-b6ce-6e63bfe0600a\",\"timeZone\":\"America/New_York\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"},{\"appBuild\":\"1.0.8\",\"customData_userId\":\"c1b1798b-6de9-4370-b222-7cb43d09522b\",\"oneSignalPushToken\":\"05fb88774db6b218d9df557c8c9d9ea5252a9c3908593967a937d491b893733d\",\"model\":\"iPhone\",\"_id\":\"0e6b8f12-f9ce-45ef-a4c4-98fe91bed3cf\",\"_createdDate\":\"2019-12-04T14:43:15.662Z\",\"tags\":\"{\\\"email\\\":\\\"roni@tulu.io\\\",\\\"phone\\\":\\\" 972506655647\\\",\\\"userType\\\":\\\"admin\\\",\\\"building\\\":\\\"Community Center Magid\\\"}\",\"distribution\":\"appstore\",\"installationId\":\"719F87AF-E884-48C6-90D1-D60A577F1988\",\"appVersion\":\"1.0.8\",\"os\":\"iOS\",\"_updatedDate\":\"2020-02-10T11:44:59.157Z\",\"hardware\":\"iPhone12,1\",\"oneSignalRequiresUserPrivacyConsent\":false,\"isFirstLaunch\":false,\"oneSignalSubscribed\":true,\"language\":\"he-IL\",\"carrierName\":\"Partner Israel\",\"publicKey\":\"nnakrm\",\"osVersion\":\"13.2.3\",\"appId\":\"com.tulou.app\",\"platform\":\"ios\",\"oneSignalUserId\":\"1224ec5c-15c4-4fab-b3a3-50169d145b37\",\"timeZone\":\"Asia/Jerusalem\",\"deviceRegKey\":\"56mz2a5cbt4680m7n5jkkm4ytc\"}]","updateId":"0e6b8f12-f9ce-45ef-a4c4-98fe91bed3cf","_id":"fcc161a4-2640-4a83-a93d-42700ba009f2"}}}]

User not available