4Site
Support Request System
View Patch #50.023.038
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02563 -
Memory error running query tool
Symptoms:
Running a query did not load all of the expected data. The error displayed at the bottom of the grid was 'Memory error'
Solution:
The Microsoft Grid control, that we typically use to display table data, has a hard 350,000 cell limit. See http://support.microsoft.com/kb/q191006/ Attempting to exceed this limit results in the out-of-memory error no matter how much memory the computer actually has. Microsoft provides a newer version of their grid that is only limited by the amount of memory on the computer, so is able to display much larger data sets. I have switched to using the newer grid control and the problem is alleviated for the most part...attempting to retrieve obscene amounts of data such as the millions of rows from the trndtl table can exhaust all the memory on the computer and fail. In addition: When saving a new query or the changes to an existing query, a message box displays "Object doesn't support this property or method". The query is still saved successfully. The error checking had been removed that specifically ignored this error when appropriate. This error checking has been re-added so the error should no longer be displayed. An unencoded string was being compared to an encoded string. If the encoded string contained a slash and/or comma, then the comparison would not succeed when compared to the unencoded string. This was fixed by ensuring that both string involved are in the same state by decoding the encoded string before comparison.
Browse Patches
Find a Patch
Return to Request System Menu
