Hi, after deleting the

Vehicle Condition

column from the model (

Vehicle

table), the data cannot be loaded -> error

LDM field label.vehicle.vehiclecondition.vehicleconditioncz is not mapped to any source column. The LDM field label.vehicle.vehiclecondition is not mapped to any source column

. The column was not used anywhere before it was deleted. Do you have any idea why this happened and how to fix it, please? Thanks 🙌

How did you delete this column? it seems it is not really deleted. Did you use the red “Delete” button in the manage section? Or did you do it in the modeller and published the changes like any other model change? The red “Delete” button in the manage section does not physically remove the attribute. It still remains in the model (and requires mapping and data loads) but it hides it from the UI.

Hi Luděk, I recommend checking the following Community post related to this issue: https://community.gooddata.com/data-models-58/error-when-loading-data-into-column-that-s-not-in-the-data-model-521

I'm 99% sure I deleted it in the modeler. But everything points to the fact that it is not deleted. I can't find the attribute anywhere in GD. Could you please advise me where I can check if it is really deleted and 1) delete it completely or 2) restore it?

Here would be steps to restore it if it was deleted with the “Delete” button: • as an administrator go to the URL: https/{HOSTNAME}/gdc/md/{WORKSPACE ID}/obj/identifierlabel.vehicle.vehiclecondition.vehicleconditioncz • if it still exists in the metadata, you will end up on a gray page of that label (not the attribute) - basically a metadata definition in JSON • on that page locate

"formOf"

(it will be somewhere around the top part and there will be a link (/gdc/md/{WORKSPACE_ID}/obj/{SOME_NUMBER}. Click this link • You will end up on a gray page of the attribute. Scroll all the way down to the

meta

section and check if you see

"deprecated" : "1"

there. If yes, then this attribute was just hidden. • To unhide follow these steps: ◦ check that the URL is https:/{HOSTNAME}/gdc/md/{WORKSPACE_ID}/obj/{SOME_NUMBER} ◦ add

?mode=edit

at the end of the URL and hit Enter ◦ the contents of page will load in a simple text editor ◦ scroll all the way down and change the

"deprecated" : "1"

to

"deprecated" : "0"

. Do not modify anything else. ◦ hit “Submit” ◦ your attribute should now be restored and visible in the UI • Now you should be able to see it in the modeller again and can remove it properly from there.

Thanks @Michal Hauzírek, I tried this, but I see deprecated = 0. And that's just weird.

this seems like a definition of a “column”, not “attribute” (see it in in the “category”) when you go to https/{HOSTNAME}/gdc/md/{WORKSPACE ID}/obj/identifierlabel.vehicle.vehiclecondition.vehicleconditioncz you should see “attributeDisplayForm” in the category and if you then click the “formOf” you should see “attribute” there. Is that what you see?

Yes, I see this, thanks, you are right, it was definition of a column. But, after changing "deprecated" from to 0, I have same error when loading table.

That is expected unless you also already deleted it from the modeller. This approach should not resolve the error directly. It should just “unhide” the attribute so you can see it in the modeller again and delete it properly from there. Then (after sucesfully publishing the model change) the error should be gone.

Coool, it works, thanks! It only shows attribute, not make it functional. Now its deleted and all works. 👏