Error Executing Data Request: Data Too Long for Column 'Data_Symbol' (Selecting a Plant or Other Block)

Issue

You received the following error message:

Error executing data request: Data too long for column 'data_symbol' ...

Cause

This issue usually occurs when when you try to select a block (such as a plant symbol) whose name is excessively long. Our block selection dialog box can only fit a limited number of characters in the field that contains the block name. Further, having excessively long block names is a less-than-ideal CAD practice, as Land F/X allows you to swap out blocks and plants quite easily.

On rarer occasions, you might receive this error when attempting to add a piece of irrigation equipment in the Irrigation Manager.

Solution

The easiest workaround is to rename the plant symbols, giving them shorter names.

As an alternative, you can increase the size of the field in the database. Copy and paste the following text into the Command line exactly as it appears below:

lx_connect
(fx:increasefield "data_symbol" 50)
lx_disconnect

To prevent this error in the future, we recommend giving each of your custom blocks a somewhat generic name, letting Land F/X take care of data such as which species of plant is assigned to it. If the error occurred with one of our default blocks, please let us know and we'll correct it.