Hi all,
I would like to find out if anybody is facing this error on Google Analytics. For context, I have had a working implementation of GA dashboards that have stopped working, checking the connection for the GA database, shows this error when authenticating.
Sample error log
[3537c9e9-98d5-4be7-838a-bc5aa23d9c02] 2020-11-10T23:25:36+02:00 DEBUG metabase.middleware.log GET /api/field/6867/values 200 6.8 ms (3 DB calls) App DB connections: 1/10 Jetty threads: 4/50 (3 idle, 0 queued) (124 total active threads) Queries in flight: 3 (0 queued)
[3537c9e9-98d5-4be7-838a-bc5aa23d9c02] 2020-11-10T23:25:36+02:00 DEBUG metabase.middleware.log GET /api/field/6867 200 7.3 ms (6 DB calls) App DB connections: 0/10 Jetty threads: 3/50 (4 idle, 0 queued) (124 total active threads) Queries in flight: 3 (0 queued)
[3537c9e9-98d5-4be7-838a-bc5aa23d9c02] 2020-11-10T23:25:36+02:00 DEBUG metabase.middleware.log GET /api/field/6858/values 200 6.4 ms (3 DB calls) App DB connections: 1/10 Jetty threads: 4/50 (3 idle, 0 queued) (124 total active threads) Queries in flight: 3 (0 queued)
[3537c9e9-98d5-4be7-838a-bc5aa23d9c02] 2020-11-10T23:25:36+02:00 DEBUG metabase.middleware.log GET /api/field/6858 200 18.2 ms (6 DB calls) App DB connections: 0/10 Jetty threads: 3/50 (4 idle, 0 queued) (124 total active threads) Queries in flight: 3 (0 queued)
[3537c9e9-98d5-4be7-838a-bc5aa23d9c02] 2020-11-10T23:25:36+02:00 DEBUG metabase.middleware.log GET /api/field/6827 200 3.8 ms (6 DB calls) App DB connections: 0/10 Jetty threads: 3/50 (4 idle, 0 queued) (124 total active threads) Queries in flight: 3 (0 queued)
[3537c9e9-98d5-4be7-838a-bc5aa23d9c02] 2020-11-10T23:25:36+02:00 DEBUG metabase.middleware.log GET /api/field/6827/values 200 2.5 ms (3 DB calls) App DB connections: 0/10 Jetty threads: 3/50 (4 idle, 0 queued) (124 total active threads) Queries in flight: 3 (0 queued)
[3537c9e9-98d5-4be7-838a-bc5aa23d9c02] 2020-11-10T23:25:36+02:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 36,
:started_at #t "2020-11-10T23:25:35.854021+02:00[Africa/Lusaka]",
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:js-int-to-string? true},
:database 36,
:query {:source-table 627, :aggregation [[:metric "ga:sessions"]], :breakout [[:field-id 6834]]},
:parameters [],
:async? true,
:cache-ttl nil},
:native
{:query {:include-empty-rows false, :ids "ga:208599493", :metrics "ga:sessions", :dimensions "ga:browser", :start-date "2005-01-01", :end-date "today", :sort "ga:browser", :max-results 10000},
:mbql? true},
:status :failed,
:class java.net.UnknownHostException,
:stacktrace
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.183 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.9+11-Ubuntu-0ubuntu1.20.04",
"java.vendor": "Ubuntu",
"java.vendor.url": "https://ubuntu.com/",
"java.version": "11.0.9",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.9+11-Ubuntu-0ubuntu1.20.04",
"os.name": "Linux",
"os.version": "5.4.0-52-generic",
"user.language": "en",
"user.timezone": "Africa/Lusaka"
},
"metabase-info": {
"databases": [
"sqlserver",
"googleanalytics"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "8.0.22-0ubuntu0.20.04.2"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.6.2"
}
},
"run-mode": "prod",
"version": {
"date": "2020-10-26",
"tag": "v0.37.0.2",
"branch": "release-x.37.x",
"hash": "ba7be09"
},
"settings": {
"report-timezone": "Africa/Harare"
}
}
}