416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
This is the support page for the legacy Dundas Dashboard application. For assistance with the current Dundas BI application please click here.
Dashboard v5.0

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

A circular reference has been detected in the Virtual Table definition

Hide navigation
RSS
Modified on Tue, 17 Jun 2014 03:59 PM Categorized as Errors, Troubleshooting, Virtual Tables

Error

[Dundas Dashboard v5.0.3.1000]

A circular reference has been detected in the Virtual Table definition.

[0] A circular reference has been detected in a virtual table definition.
[Dundas.Dashboard.CircularReferenceException] at Dundas.Dashboard.DDException..ctor(String message, Exception innerException)
at Dundas.Dashboard.CircularReferenceException..ctor(String message)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
...
...
...


Symptoms

This error is seen when a virtual table is previewed.

Cause

This error occurs when two virtual tables are joined and the second virtual is based of the first one i.e.:

  • Create Virtual Table 1 based on an existing Data Connector table or a manual virtual table.
  • Create Virtual Table 2 based on Virtual Table 1.
  • Create Virtual Table 3 based on Virtual Table 1 and Virtual Table 2, and add a join.
  • On preview, circular reference error will be shown.

Resolution

To avoid this error, re-create Virtual Table 2 separately based on the Data Connector Tables instead of another virtual table.

Related Topics

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2014 Dundas Data Visualization, Inc.