Let’s say we currently have some tables:TableATableBTableCTableD TableA and TableB are parents of TableC, then TableC is parent of TableD.So we have:Relationship Parent Table Child Table Rel1 TableA TableC Rel2 TableB TableC Rel3 TableC TableD We are trying to get rid of Table C, so that the new relationships will be:Relationship Parent Table Child Table Rel4 TableA TableD Rel5 TableB TableD I’ve tried to deploy the model and I get validation messages of missing parent values. Trouble is TableD is quite big in RDM terms (in the magnitude of 200k rows) and I think the application is struggling to start at the moment with all these failed validations.Is there some specific alter hints that can be used or am I going to have to anticipate going into repair mode somehow?

Question

Changing RDM relationships from one parent table to another (few)

Forum|Forum|4 months ago
July 11, 2025
3 replies
36 views

+4

may_kwok
Star Blazer L3
93 replies

Let’s say we currently have some tables:

TableA

TableB

TableC

TableD

TableA and TableB are parents of TableC, then TableC is parent of TableD.

So we have:

Relationship	Parent Table	Child Table
Rel1	TableA	TableC
Rel2	TableB	TableC
Rel3	TableC	TableD

We are trying to get rid of Table C, so that the new relationships will be:

Relationship	Parent Table	Child Table
Rel4	TableA	TableD
Rel5	TableB	TableD

I’ve tried to deploy the model and I get validation messages of missing parent values. Trouble is TableD is quite big in RDM terms (in the magnitude of 200k rows) and I think the application is struggling to start at the moment with all these failed validations.

Is there some specific alter hints that can be used or am I going to have to anticipate going into repair mode somehow?

+4

may_kwok
Author
Star Blazer L3
93 replies
Forum|Forum|4 months ago
July 11, 2025

Or is it better to take a backup of the data, truncate the table before deployment, then reload the data back in afterwards?

+4

may_kwok
Author
Star Blazer L3
93 replies
Forum|Forum|3 months ago
July 14, 2025

I forgot about the “fix pk” button in the repair data mode!

I

+2

Ilan.Boiangin
Ataccamer
7 replies
Forum|Forum|3 months ago
July 24, 2025

Hi May,

For this scenario since we are trying to remove the table as a whole I would suggest doing a truncate of the data if possible. This will ensure that when we load the data back in, the relationships wont be present which is most likely the cause for the validation errors. Assuming that we are changing the relationship configuration and removing table C from your logical model, it is important to do a generate under “app configuration” and deploying the new configuration.zip to the rdm admin portal.

Please let me know if you are able to get the deployment working!

Thank you,

Ilan

Sign up

Login to the Ataccama Community

Scanning file for viruses.

This file cannot be downloaded