FME 2019.0 build 19238 Desktop on Windows 10 and Server on Linux (CentOS 7)
I'm trying to migrate a large dataset (tens millions records) from a Google BigQuery table into a PostgreSQL table, but the translation failed and this error was logged. Tried some times, the translation stops always with the same error.
Translation FAILED with 1 error(s) and 0 warning(s) (11375000 feature(s) output)
FME Session Duration: 59 minutes 9.9 seconds. (CPU: 1945.4s user, 53.5s system)
END - ProcessID: 11848, peak process memory usage: 1027252 kB, current process memory usage: 843964 kB
java.lang.Exception: Google BigQuery: Error retrieving query results from job '****************:********.********' executed on table job_*_***************. Provider error: 401 Unauthorized
{
"code" : 401,
"errors" : b {
"domain" : "global",
"location" : "Authorization",
"locationType" : "header",
"message" : "Invalid Credentials",
"reason" : "authError"
} ],
"message" : "Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.",
"status" : "UNAUTHENTICATED"
}
Program Terminating
Translation FAILED.I'm not sure why the authentication would be invalid while reading the data. Is there any workaround?