I have a grid that loads an entire table with over 5000 records. I have two filters, one for the month, and one for the year, set to default values on launch. However if I change the filter values to show, say, everything from 2013, the widget gives me this data error:
"VV00060 - Exception encountered during SQL execution, likely resulting in truncated data or an empty data set (SQLSTT=22003 - SQL0802 - Data conversion or data mapping error.). Exception occurred on record number 445 in the record set."
This only seems to happen if the widget loads to many rows. I can circumvent the error by turning on infinite scroll, but I also have a total summary row at the bottom which will refuse to calculate if this error would show up. This results in the total summary retaining its values from whatever the grid loaded with the last filter values.
When filtering for everything from 2013, the table only had 484 records total, so i would find it hard to believe its actually a size issue.
"VV00060 - Exception encountered during SQL execution, likely resulting in truncated data or an empty data set (SQLSTT=22003 - SQL0802 - Data conversion or data mapping error.). Exception occurred on record number 445 in the record set."
This only seems to happen if the widget loads to many rows. I can circumvent the error by turning on infinite scroll, but I also have a total summary row at the bottom which will refuse to calculate if this error would show up. This results in the total summary retaining its values from whatever the grid loaded with the last filter values.
When filtering for everything from 2013, the table only had 484 records total, so i would find it hard to believe its actually a size issue.
Comment