To GoodData homepage

Knowledge base
AnalyticsDashboards and Reports - KB articles8 Metrics and MAQL - KB articles23
Data modeling & IntegrationData models - KB articles9 Data sources - KB articles9
Development & AdministrationGoodData.UI - KB articles12 Administration - KB articles18 Solution architecture - KB articles8 SDKs and APIs - KB articles9
Community
WelcomeAbout GoodData13
AnalyticsDashboards and Reports161 Metrics and MAQL106
Data modeling & IntegrationData models35 Data sources68
Development & AdministrationGoodData.UI38 Administration86 Solution architecture13 SDKs and APIs28

Ask your question
Login

Community
Search

Replies posted by dastein

6 Replies

Newest first

Oldest first

dasteinParticipating Frequently

asked in Dashboards and Reports

Can't create Insights, results cache crashing

PS: This morning, the issue was gone, but after ~15 minutes of working with the Report Designer, it came back again. The initial problem seems to be memory-related:NAME READY STATUS RESTARTS AGEpod/gooddata-cn-result-cache-c8f8f9cb9-8l9ps 0/1 OOMKilled 151 16hpod/gooddata-cn-result-cache-c8f8f9cb9-mlcc2 0/1 CrashLoopBackOff 152 16h

dasteinParticipating Frequently

asked in Data sources

Can't initialize BigQuery connection - "Headless Exception" error

Test seems to work.

dasteinParticipating Frequently

asked in Data sources

Can't initialize BigQuery connection - "Headless Exception" error

Here are the captured logs from the two pods. Both show errors. The file ending with pod1 shows logs after I hit the button below "Data Source connected. Now scan the data." The file ending with pod2 show logs after I did the Data Source test over the API (with the same settings as the stored datasource"). sql-executor-pod1.log#85jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=sandbox-analytics-01;OAuthType=0;OAuthServiceAcctEmail=user@gooddata.com;DefaultDataset=dbt_production;OAuthPvtKeyPath=/tmp/tmp9519416683194855305bigquery_token.json When I runkubectl exec -it pod/gooddata-cn-sql-executor-5b9bd57544-s5n4g -n gooddata-cn -c sql-executor -- cat /tmp/tmp9519416683194855305bigquery_token.jsonit outputs the service account file (see below) in JSON. sql-executor-pod2.log#69jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=sandbox-analytics-01;OAuthType=0;OAuthServiceAcctEmail=user@gooddata.com;DefaultDataset=dbt_production;OAuthPvtKeyPath=/tmp/

dasteinParticipating Frequently

asked in Data sources

Can't initialize BigQuery connection - "Headless Exception" error

Where would I find this log message? In which pod/service?

dasteinParticipating Frequently

asked in Data sources

Can't initialize BigQuery connection - "Headless Exception" error

Certainly:{ "schema": "dbt_production", "type": "BIGQUERY", "url": "jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=sandbox-analytics-01;OAuthType=0", "username": "", "password": "", "token": "ewog....."}

dasteinParticipating Frequently

asked in Data sources

Can't initialize BigQuery connection - "Headless Exception" error

Hi @Dominik,thanks for the quick response: We do specify AuthType=0 in the JDBC URL, shouldn’t that be enough to set Service Account OAuth? Best,David

Powered by Gainsight

Welcome to the GoodData Community!Cookie settings

Sign up

Already have an account? Login

Social Login

or

Username (also your display name - please use John Doe rather than john.doe) *

E-mail address (if you already use GoodData, we encourage you to use the same e-mail address you use for the GoodData platform) *

Full Name

(Private)

Only you and moderators can see this information

*

Company

(Private)

Only you and moderators can see this information

*

I use the following GoodData products

(Private)

Only you and moderators can see this information

GoodData Platform GoodData Cloud GoodData.CN

Password *

I have read and agree to the GoodData Community and University Terms of Use and Privacy Policy.

loginBox.register.email_repeat

Login to the community

Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account

Social Login

or

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK