Jump to content
We've recently updated our Privacy Statement, available here. ×

problem solving cyclic dependencies.


todd jones 3

Recommended Posts

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.

Link to comment
Share on other sites

  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...