cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
ehchandlerjr
Level V

Not understanding the "cycle detected" log report

Hello - I'm having a cycle detected in one of my tables, and I can't seem to find documentation on cycles. Maybe its there, and google and JMP's help index are failing me, but I'm pretty confused what the cycle report means. I'm currently getting the following report:

Cycle detected for data column: Best concentration source

  1. Calculated concentration
    2. Best concentration value
0. Best concentration source
    2. ::RowColumn::
    2. Solution name
    2. ::GlobalVariableColumn::
    2. atomic weight (g/mol)[Element]
    2. Salt Identity
    2. Tube
    2. Tube + Metal Solution A
    2. Liquid A
    2. Calculation method
    2. ::TableVariableColumn::

Cycle detected for data column: Best concentration source

  1. Calculated concentration
    2. Best concentration value
0. Best concentration source
      3. Guessed concentration
    2. ::RowColumn::
    2. Solution name
    2. ::TableVariableColumn::
    2. ::GlobalVariableColumn::
    2. atomic weight (g/mol)[Element]
    2. Tube + Metal Solution A
    2. Volumetric Flask
    2. Tube
    2. Liquid A
    2. Calculation method
    2. Salt Identity
  1. ICP concentration

I guess I'm confused what the numbers mean, why different indents happen, etc.

 

P.S.

I'm assuming its not necessary to answer the question above, but here is the code that's the issue if that helps. It's part of a larger series of nested if statments in column :Calculated concentration.

((:"Tube + Metal Solution A"n - :Tube) / 1000) * (row_idx = Loc( :Solution name << Get Values, :Liquid A ) ; If( N Items( row_idx ) < 1,
	.,
	Lag( :Best concentration value, Row() - row_idx[1] )
))

while :Best concentration source has as a formula

If( Is Missing( :ICP concentration ),
	If( Is Missing( :Calculated concentration ),
		If( Is Missing( :Guessed concentration ),
			.,
			"Guessed concentration"
		),
		"Calculated concentration"
	),
	"ICP concentration"
)

Thanks!

Edward Hamer Chandler, Jr.
1 REPLY 1
Craige_Hales
Super User

Re: Not understanding the "cycle detected" log report

I'm pretty sure those cycle reports were created by the original developer for debugging the planner that determines which column should be calculated first. I agree, they seem not very useful for spotting the cycle. A cycle could be long: A depends on B depends on C depends on D ... depends on A.

 

Craige