Hi :wave:,
Could any of you please help me with th...
# gooddata-cloudb
Brunno Araujo
04/08/2024, 4:45 PMHi 👋,
Could any of you please help me with this trace id? 💡
0966b24d1cd3245ab0bfd26271831bd5j
Julius Kos
04/08/2024, 5:05 PMHi Brunno,
Could you please give us some more context? I can see some general errors in our logs, for example:
Copy code
A result cache error has occurred during the calculation of the resultJulius Kos
04/08/2024, 5:05 PMCan you please clarify what exactly triggers this error?
b
Brunno Araujo
04/08/2024, 5:08 PMHi Julius, thanks for the answer!
I have a view that uses a federated query from redshift to postgres. When I'm building an Insight and I try to add some columns, this happens.
Brunno Araujo
04/08/2024, 5:09 PMI notice that it happens when I'm adding columns from joined tables
Brunno Araujo
04/08/2024, 5:09 PMI can see all data in the same view using any other redshift client. Including the columns good data is not loading
j
Julius Kos
04/08/2024, 5:22 PMThanks for the information, so do I understand correctly that you are using the data-source-manager?
b
Brunno Araujo
04/08/2024, 5:25 PMNo (kind of?)... I have a Redshift data source connected to Good Data and this Redshift database has a connection with a postgres database
👀 1
Brunno Araujo
04/08/2024, 6:04 PMFor some reason Good Data is aborting the query.
I can capture the query that Good Data is sending to Redshift and copying that same query, it loads when using another Redshift client.
When I filter for a very small amount of data, 5 or 10 rows, it works in Good Data.
j
Julius Kos
04/08/2024, 6:42 PMI can see that in the previous thread with my colleague, you were able to solve the situation by amending your datasource view is that correct? As the issue still persist, I would also like to ask you to send an email to support@gooddata.com with all the information you’ve provided so far.
Also, please include the information regarding how did the fix looked like last time (the view before, and amended view which fixed the last issue).
Hopefully it will shed some light on the problem.
b
Brunno Araujo
04/08/2024, 6:43 PMSorry, the last one was not a solution. I realized that’s the same issue.