Skip to main content
Question

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


may_kwok
Star Blazer L3
Forum|alt.badge.img+4

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?

 

Did this topic help you find an answer to your question?

3 replies

may_kwok
Star Blazer L3
Forum|alt.badge.img+4
  • Author
  • Star Blazer L3
  • 91 replies
  • 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?


may_kwok
Star Blazer L3
Forum|alt.badge.img+4
  • Author
  • Star Blazer L3
  • 91 replies
  • July 14, 2025

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


Forum|alt.badge.img+2

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings