problem solving cyclic dependencies.

[todd jones 3]

Trying to solve a cyclic dependency issue.

My main table has relations to 17 other tables.

All tables added from information links residing in the same location as the main table.

Also using data on demand to limit the amount of data pulled in by the other tables. Fairly certain I've got all the relations and limits for loading set correctly.

Everything works correctly until I start adding columns from the other tables into the main one.

A pivot is required to add columns from another table. After they are added, there is an alert that on demand loading for the table that the columns were added from has been turned off due to cyclic dependencies. Alert text pasted below..

Turning off automatic on-demand loading for table UDCONTEXT.

Automatic on-demand loading cannot be performed due to cyclic dependencies.

Cycle found:

Data Column: [T_RDB_GENERALBASIC].[DEVICETYPEOBJID]

Data Column: [T_RDB_GENERALBASIC].[sTEPOBJID]

Data Column: [T_RDB_GENERALBASIC].[PROCESSMATERIALOBJID]

Data Column: [T_RDB_GENERALBASIC].[PROCESSACTIONOBJID]

Data Column: [T_RDB_GENERALBASIC].[MODELGROUPOBJID]

Data Column: [T_RDB_GENERALBASIC].[MACHINEOBJID]

Data Column: [T_RDB_GENERALBASIC].[CONTROLGROUPOBJID]

Data Column: [T_RDB_GENERALBASIC].[RUNCODEOBJID]

Data Column: [T_RDB_GENERALBASIC].[PROCESSACTION]

Data Column: [T_RDB_GENERALBASIC].[CONTROLSTRATEGYREV]

Data Column: [T_RDB_GENERALBASIC].[CONTROLSTRATEGYDOCUMENTOBJID]

Data Column: [T_RDB_GENERALBASIC].[TIMESTAMP]

Data Column: [T_RDB_GENERALBASIC].[RUNID]

Data Column: [T_RDB_GENERALBASIC].[GSOOP]

Data Column: [uDCONTEXT].[VALUE]

Data Column: [uDCONTEXT].[NAME]

Data Column: [uDCONTEXT].[TYPE]

Data Column: [uDCONTEXT].[RUNID]

Data Column: [uDCONTEXT].[RUNOBJID]

Data Column: [T_RDB_GENERALBASIC].[RUNOBJID]

Data On Demand

I am relating the tables by [RUNOBJID] which I am also using to limit the data on demand.

When I add the columns I don't use [RUNOBJID] in the pivot.

[Khushboo Rabadia]

If there is interdependency between the joined tables then you will get cyclic dependency error:

https://support.tibco.com/s/article/Warning-message-The-relation-could-n...

You can create alias for data tables causing the cyclic loop.