Table Relations

Solved1.05K viewsDVE Dynamic Vir Dynamic virtuals elements SLElement
2
0 Comments

Hi All,

I am currently seeing this error in my logs:

SLElement.exe|7688|TableRelations::SplitTableFkRelationsInternal|ERR|0|!! No link in relation for 60200 -> 12200/60200 [chain=]

However looking at the xml there are relations for this table:

        <Relation name="xxx"   path="55000;54900;60200;12200" />
        <Relation name="xxx"   path="55100;54900;60200;12200" />
        <Relation name="xxx"   path="55200;54900;60200;12200" />
        <Relation name="xxx"   path="55300;54900;60200;12200" />
        <Relation name="xxx"    path="56000;54900;60200;12200" />
        <Relation name="xxx"    path="56100;54900;60200;12200" />
        <Relation name="xxx"    path="56200;54900;60200;12200" />
        <Relation name="xxx"   path="56300;54900;60200;12200" />
        <Relation name="xxx"   path="56400;54900;60200;12200" />

Am I missing anything? Is there any way to find out what specific relation is missing?

ryan yahia Selected answer as best 1st June 2022

1 Answer

2
7.72K 1 Comment

Hi,

Is there in the xml a column in table 60200 that has a foreignkey=12200 option defined? That column should then contain as parameter value the primary key of the row in table 12200 to where it's pointing to.

See help

ryan yahia Selected answer as best 1st June 2022
ryan yahia commented

Thank you Laurens for you answer, there is no column that points to the table of 12200, so I think this must be the cause of this error