Difference between revisions of "Troubleshooting"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
| Line 3: | Line 3: | ||
===Data Truncation Error=== | ===Data Truncation Error=== | ||
{{:Data Truncation Error}} | {{:Data Truncation Error}} | ||
===??? Error=== | ===??? Error=== | ||
This error occurs when referencing a field that has a null value. Prevent the error by using the ISNULL function in an IF statement: <tt>IF( ISNULL(field), value-to-use-when-true, expression-uses-the-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: <tt>IF( ISNULL(field), value-to-use-when-true, expression-uses-the-field ) | ||
Revision as of 03:35, 18 March 2014
Application Troubleshooting
Data Truncation Error
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).
??? Error
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), value-to-use-when-true, expression-uses-the-field )