<![CDATA[Dundas Support Zone - A circular reference has been detected in the Virtual Table definition]]>http://support.dundas.com/Dashboard5.A_circular_reference_has_been_detected.ashxWed, 17 Jun 2020 20:06:43 GMTScrewTurn Wiki RSS Feed Generator<![CDATA[A circular reference has been detected in the Virtual Table definition]]>http://support.dundas.com/Dashboard5.A_circular_reference_has_been_detected.ashx

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

]]>
nikhilb@dundas.com (nikhilb@dundas.com)Tue, 17 Jun 2014 19:59:25 GMTCE420ECCC5EACCF7A79FB2A1963C9DE8