Difference between revisions of "Troubleshooting"

Revision as of 01:24, 20 March 2014

This error occurs when referencing a field that has a null value. Prevent the error by using the ISNULL function in an IF statement:

IF( ISNULL(field), expression-to-use-when-field-is-null, expression-that-uses-the-field )

A data truncation error occurs when incoming data is too large to be stored. The error can occur for a number of reasons:

In a Multi Select Picklist or Multi Checkbox field, the combination of selected values could be larger than the maximum storage size for the field.

The default maximum size is 32 characters.
If all values are selected, the number of characters required for N labels is the sum of the sizes of all N labels plus N-1 commas.
That number can be reduced only if there are combinations of values that are never selected.

In a single-selection Picklist, Global Picklist, or Dependent Picklist a value available for selection might be longer than the maximum storage size specified for the field.
The combination of all fields defined in the record could be larger than the maximum size of a MySQL row (65,535 bytes).

@@ Line 2: / Line 2: @@
 ==Application Troubleshooting==
 ===Exception: Enter Value for Field===
-This error occurs when referencing a field that has a null value. Prevent the error by using the ISNULL function in an IF statement:
+{{:Exception: Enter Value for Field}}
-: <tt>IF( ISNULL(field), expression-to-use-when-field-is-null, expression-that-uses-the-field )</tt>
 ===Data Truncation Error===
 {{:Data Truncation Error}}