Hi, I'm having a problem creating databases if I d...
# gooddata-cloudf
Filip Turniški
03/10/2023, 9:16 AMHi, I'm having a problem creating databases if I drag and drop them, before that was working
Filip Turniški
03/10/2023, 9:16 AMerror id: b6b3130472358309
Filip Turniški
03/10/2023, 9:16 AMimage.png
Filip Turniški
03/10/2023, 9:16 AMi
Ivana Gasparekova
03/10/2023, 11:06 AMHi @Filip Turniški,
Could you review your data and mapping please and make sure the Reference is in this format, please?
referencePrefix__tableBaseName__referenceBaseNameIvana Gasparekova
03/10/2023, 11:11 AMMay I know what data source are you usually working with?
f
Filip Turniški
03/10/2023, 11:27 AMWe were naming tables and fields by this naming convention and it was working a few days back. This now was on PG database
i
Ivana Gasparekova
03/10/2023, 11:52 AMGreat, that is the correct one to follow.
The error indicates, there is something missing, as it should consist of the prefix, tableBaseName and referenceBaseName.
Could you double-check if there were no changes in your source PG database, please?
f
Filip Turniški
03/13/2023, 7:34 AMI think we found the problem. I think this error occurred because some other table on our schema did not follow this naming convention. Is that a new feature that all tables on that schema have to follow this naming convention?
i
Ivana Gasparekova
03/13/2023, 8:54 PMGlad to hear so, however, I am not aware of any recent change like this. Truth is, the LDM itself cannot generate references if referential integrity is not maintained in the source database. Could this be your case?