Differences
This shows you the differences between two versions of the page.
— |
control_invalid_floating_point_operation [2019/01/27 11:28] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | =Error Message= | ||
+ | |||
+ | |||
+ | |||
+ | The user received an " | ||
+ | |||
+ | |||
+ | |||
+ | =Explanation of Error= | ||
+ | |||
+ | |||
+ | |||
+ | A " | ||
+ | |||
+ | |||
+ | |||
+ | This is almost always a case where Control is attempting to divide by a variable (usually quantity) that is zero. For example to get the unit cost they might take | ||
+ | |||
+ | |||
+ | |||
+ | =Severity= | ||
+ | |||
+ | **Normal**. This affects the users ability to work this the affected product or any order/ | ||
+ | |||
+ | |||
+ | |||
+ | =Possible Root Cause(s)= | ||
+ | |||
+ | |||
+ | |||
+ | ==#1 Bad Quantity Formula== | ||
+ | |||
+ | |||
+ | |||
+ | 9/ | ||
+ | |||
+ | |||
+ | |||
+ | [[code_formatpascal|code_formatpascal|code format=" | ||
+ | |||
+ | |||
+ | |||
+ | ParentVariableValue(Quantity, | ||
+ | |||
+ | |||
+ | |||
+ | < | ||
+ | For child line items, this worked fine. However, if that was promoted to or added as a top level item, it caused this error. | ||
+ | ===== Resolution ===== | ||
+ | Correct the affected formula to: | ||
+ | [[code_formatpascal|code_formatpascal|code format=" | ||
+ | |||
+ | |||
+ | |||
+ | ParentVariableValue(Quantity, | ||
+ | |||
+ | |||
+ | |||
+ | < | ||
+ | The following SQL can be used to identify all the products with this specific issue: | ||
+ | [[code format=" | ||
+ | |||
+ | |||
+ | |||
+ | Select Item.ID as ProductID, Item.ItemName as Product, V.Formula | ||
+ | |||
+ | |||
+ | |||
+ | From Variable V | ||
+ | |||
+ | |||
+ | |||
+ | Join PricingPlan PP on PP.ID = V.PricingPlanID | ||
+ | |||
+ | |||
+ | |||
+ | Join CustomerGoodsItem Item on Item.ID = PP.GoodsItemID | ||
+ | |||
+ | |||
+ | |||
+ | Where Formula like ' | ||
+ | |||
+ | |||
+ | |||
+ | and VariableName = ' | ||
+ | |||
+ | |||
+ | |||
+ | < | ||
+ | ===== Version Information ===== | ||
+ | * Reported : 09/2011 | ||
+ | * Version(s): 3.5+ | ||