Google Analytics Connection Error

Get Help
1

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.

Screenshot%20(2)
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"
    }
  }
}
1 Like
2

Hi @asimumba
Looks like you have network issues - it cannot resolve the domain - so that is usually either DNS or firewall issues.

2 Likes
3

@flamber you’re right. I figured it out after I posted. Thanks though for your usual guidance.

1 Like
4

Please forgive me for asking this question but I’m not a very technical person: What can you gain from connecting your GA account with your MB account? I’m asking because on my site I’m using both systems separately and I’d like to know how I potentially could benefit from merging data from both accounts. Many thanks.

5

@english.best I think you’re misunderstanding the “account” part. Setting up GA as a data source in Metabase will allow you to create visualizations and add those to dashboards, which might contain visualizations from other data sources too.
GA is just a data source, like any of the other databases that can be connected to Metabase.
https://www.metabase.com/docs/latest/administration-guide/01-managing-databases.html

1 Like
6

Got it now, many thanks for the clarification :+1: