SYMPTOM:
When using a date prompt in Strategy 9.x-10.x and a Netezza warehouse, the following error may be seen:
Records trailing string space set to XXXX is too small: Bump it up using the environment variable NZ_SPRINGFIELD_SIZE
CAUSE:Netezza has a specific issue where its warehouse column datatypes are tied to a specific byte length, and when a column is called, it must have at least double the size set for its byte string than the data that is being called. For example, if the data string being called from the warehouse is 255 bytes in length, the column must be set to a size of at least 512 bytes for the call to be executed. The NZ_SPRINGFRIELD_SIZE controls this size limit in the Netezza warehouse and can be adjusted by the DBA.
ACTION:In certain scenarios, the VLDB setting Select/Insert > GROUP BY Non-ID Attribute, may be modified to allow aggregate field larger than 512. Clear the default check box and change the radio button from "Use Max" to "Use" Group By.
If the error persists, follow up with the DBA about increasing the environmental variable NZ_SPRINGFIELD_SIZE.
