Google Analytics Importer appears stuck

Support & Bugs
1

Using On-Premises. I started an import several days ago. For a while data was coming in to tables matomo_archive_blob_YYYY_MM and matomo_archive_numeric_YYYY_MM). However it seems no data has come in for a couple of days, although the status report shows it is apparently running with an estimated completion time of “1 day”.

But there are only tables for each month of 2023; there are no tables dated with earlier months. The import date range starts with 2007. Our traffic would be considered on the low side with about a thousand unique visitors per day.

Why does the import appear to be “stuck”?

3

Thanks for the response! Regarding your points:

  1. I understand it could take a long time. But I would expect it to move forward more each day. We get seven and ten day periods where “nothing happens”.

  2. Our server should have capacity. I do notice in the System Check that LOAD INFILE is not functioning. I have take the steps to enable this, except we are back level in our PHP level. That will be fixed real soon now. Would the issue with LOAD INFILE slow down the import?

  3. You mention that missing tables could be a problem. I did not see documented a step to manually create the tables for each date. I could certainly create those tables, but that seems a bit odd. And it is a lot of tables for a sixteen year period!

  4. The log viewer shows a lot of warnings on GoogleAnalyticsImporter, but no errors. Warning as like “unknown browser” or “unable to import goal”.

  5. I did not see a reference to a troubleshooting guide for the Importer.

I do get messages that appear on the web page status area about problems such as I believe I already posted in this question or another. For example, an error message follows. In the error message it mentions “Credenials” and “UNAUTHENTICATED”, and “unexpected”. That seems like it is in the middle of importing and suddenly loses authentication. That’s odd.

credential. See https://developers.google.com/identity/sign-in/web/devconsole.project."
“errors”: [f
“message”:
“Invalid
Credentials”
“domain”:
“global”
“reason”:
“authError”
“location”:
“Authorization”
“locationTvoe”:
“header” 11.
“status”:
“UNAUTHENTICATED”
}}
These errors are
unexpected and
will likely
continue every
time you run the
import on this
day. To resolve
this issue, please
ask on the
forums. If you
can provide
access to your
GA account to a
member of
Matomo’s
support team it
will provide a
quicker
resolution.

4

Hi @jasimon9
The previous answer was from a spammer (response generated by an IA)
Did you finally solve your issue?
Can you check your credential is still valid on Google?

5

This question was pertaining to issues we were having. We finally decided to just let the import run. We imported data going back to 2007.

The import finally finished–but it did take all of four months!

So this issue can be closed.

1 Like