https://www.gooddata.com/ logo
Join Slack
Powered by
Hi Team, how should we go diagnosing issues that r...
# gooddata-cloud
j
Hi Team, how should we go diagnosing issues that result in this view:
The traceId is 
52c58a217ab96f5e8fdca29f21472cab
or 
34de6050ce0180725733969c706ed8ba
It seems like when i use properties from related datasets as filters or segmented by options i get an error.
đź‘€ 1
m
Hi Jeremy, from our logs, I can see that you’re using this metric there: m_pages.anonymous_id_count - and from our logs it seems that there may be an issue with the labels. Can you please check your LDM attributes used in the metric and see if you have issue (warning) in the mapping tab? Also, if you have made any changes recently, can you please try to Clear cache and see if this helps?
j
@Michael Ullock ok, i'm attempting to reconfigure some of the data model
Copy code
{
  "title": "Bad Request",
  "status": 400,
  "detail": "Report cannot be computed without primary keys being defined on items='dataset/pages/...'",
  "traceId": "d089e49d6688cde83b6bb34d0a1c5649"
}
I'm unsure how to set a Primary Key on this big query dataset
m
Copy code
Report cannot be computed without primary keys being defined on items='dataset/pages/30ecbeee9d2642529ac9f142fd626ba9'
As the error states, the error is caused by the absence of the primary key defined on the 
pages
dataset in your Logical Data Model (LDM). You’ll need to open the Logical Data Model editor in GoodData - Locate the 
pages
dataset. Then confirm if any attribute is marked as a primary key. You can find more details on Primary keys here: https://www.gooddata.com/docs/cloud/model-data/concepts/primary-key/
j
We're using BigQuery so there isn't a native primary key, how do we set a field as the primary key?
Ok, i found the 
Set Primary Key
option in the DataSet menu. However, i'm still getting the original error with a trace id of 
ca8e4e480cfcba3f9a0043ffd70f21a0
j
Hi Jeremy, the error in the logs is a little vague compared to the previous ones:
Copy code
Unsupported argument node type='class com.gooddata.calcique.generator.visitor.expressions.Lift' present in Filter.,<no detail>\n\tat
Could you send over a link to the viz itself so we can review all objects used there? You can send it in a DM to me or @Michael Ullock if it is easier.
b
Hi @Jeremy Moore, This is Branislav from the L2 Technical Support team. I have had a further look into the issue. Based on the notes from Michael and Joseph, I believe that the error might be raised because the following facts: 1.) When the filter is using "All" the dashboard can be visualized, because there is no filtering. As a result, the records are successfully "joined" based on their PK/FK (id). 2.) Once the "Channel Name" filter is applied, the problem starts because it is not a PK. As a result, the computation appears to be failing during the "joining" part. Since multiple datasources are involved, I would recommend reading the following documentation page: https://www.gooddata.com/docs/cloud/model-data/create-logical-data-model/ldm-advanced-use-cases/#using-multiple-data-sources-in-an-ldm It shares multiple tips and valuable information about the usage as well as several limitations of the implementation.
3 Views
Open in Slack
PreviousNext
Powered by