I added a new column to my pdm, and now I'm gettin...
# gd-beginnersd
Daniel Wakefield
04/07/2023, 6:40 PMI added a new column to my pdm, and now I'm getting this error: Source detail: "Source column should not be empty for table='PdmTable(path=[mmgooddata, call_events], ldmDatasetId='dataset/call_events/e096a91d0c7f45f086676c52b9d8843c', type=VIEW)'and primary label of the attribute='Attribute(header=Header(space=e096a91d0c7f45f086676c52b9d8843c, id=contact_number, title=, description=, tags=[]), labels=[Label(header=Header(space=e096a91d0c7f45f086676c52b9d8843c, id=contact_number, title=, description=, tags=[]), primary=true, sourceColumn=, type=label, sourceColumnDataType=null)], granularity=null, type=attribute, sourceColumnDataType=null)'."
However, the contact_number column does not have any empty entries. I don't know what this error means, and I can't find any documentation on it.
But as a result, my entire dashboard is broken.
i
Ivana Gasparekova
04/07/2023, 7:01 PMHi Daniel,
By PDM, do you mean your source data, please? May I know if you are working with GD Paltform or GD Cloud?
Also, did you update your LDM - Logical Data Model as well?
d
Daniel Wakefield
04/07/2023, 7:01 PMYeah, source data
Daniel Wakefield
04/07/2023, 7:01 PMYes, updated the LDM
Daniel Wakefield
04/07/2023, 7:01 PMGD Cloud
i
Ivana Gasparekova
04/07/2023, 7:03 PMThanks a lot. Did you initiate the data reload of related dataset as well?
d
Daniel Wakefield
04/07/2023, 7:04 PMHow do you do that?
Daniel Wakefield
04/07/2023, 7:05 PMI did click the little circular arrow that says: Connect to data source and refresh tables and views.
Daniel Wakefield
04/07/2023, 7:07 PMAlso, went to the data source and cleared the cache. This didn't help either.
i
Ivana Gasparekova
04/07/2023, 7:09 PMYes, this updates the model itself.
Good point about the cache. How do you usually upload your data, please? Via API by chance?
d
Daniel Wakefield
04/07/2023, 7:10 PMI mean, I just update the data in the db, and then click the circular arrow
✅ 1
i
Ivana Gasparekova
04/07/2023, 7:14 PMOk, thanks. Let me check what we can do with the error.
Please bear with me for a moment.
👍 1
Ivana Gasparekova
04/07/2023, 7:15 PMJust one quick question - may I know what DB are you using, please?
d
Daniel Wakefield
04/07/2023, 7:16 PM<redacted>
i
Ivana Gasparekova
04/07/2023, 7:17 PMOh sorry, I meant - what kind of a DB. Is it a Google BigQuery one, or something else?
d
Daniel Wakefield
04/07/2023, 7:19 PMPostgres, in amazon RDS
✅ 1
i
Ivana Gasparekova
04/07/2023, 7:20 PMThanks again!
Ivana Gasparekova
04/07/2023, 7:25 PMIn the meanwhile, please check this article. Maybe you can find some hints there as well:
https://www.gooddata.com/developers/cloud-native/doc/cloud/model-data/evolve-your-model/#alter-the-relational-model-of-the-database
d
Daniel Wakefield
04/07/2023, 7:37 PMOkay, I read through it. It seems to outline the steps I followed.
Daniel Wakefield
04/07/2023, 8:14 PMI didn't find anything in the article, did you find anything on your end?
Daniel Wakefield
04/07/2023, 9:18 PMI think I found the issue. It turns out I didn't correctly connect the newly added fact to the DB field.
Daniel Wakefield
04/07/2023, 9:18 PMAlthough it is weird it broke all the other metrics though.
i
Ivana Gasparekova
04/10/2023, 3:33 PMWere you able to map the newly added fact to your source data, please?