I added a new file to our model and then started a...
# gooddata-cloudg
Greg Lindstrom
12/06/2024, 7:34 PMI added a new file to our model and then started a column chart but after placing the first field I get an error. please review and help if you can. thanks!
m
Moises Morales
12/06/2024, 8:04 PMHi Greg, it looks like the insight is failing to compute due to the amount of elements in the primary key. It's most likely timing out on the DB end. Could you try adding attributes/metrics to insight? Is it computing now? Please also consider applying filters if it's still taking too long to compute.
g
Greg Lindstrom
12/06/2024, 8:24 PMString. It's a small flat file with only 13 records and 29 columns. the error message comes up immediately, it doesn't even churn for a while. I want to count the values in trans_id field so that's why i added it to the metric area. I deleted the file from the model and re-added it. seems to be the same error.
Greg Lindstrom
12/06/2024, 8:34 PMI meant to say 'strange' not 'string'
Greg Lindstrom
12/09/2024, 7:25 PMWe can close out this thread, I found was causing the issue - there were two fields with identical names in my SQL view - xyz and xyz_1 (sql added the '1' when I saved the view. These appeared as xyz and xyz_1 in the gooddata model too. Evidently gooddata could tell that both fields sourced back to the same sql table field and couldn't process it. Anyway I eliminated one of the fields from the view and all is processing normally in gooddata now.
✅ 1
m
Moises Morales
12/09/2024, 7:30 PMThanks for letting us know Greg!