When trying to import an excel file into a blank gINT database, I get the following error message (also attached):
7 Out of Memory===gInt8a
If I click ok, I get the following error message:
File not found
gINT
This happens on both computers that have gINT in my office. We upload excel files into gINT on a daily basis and I can't find any issues with either the spreadsheet or the correspondance file.
Is gINT actually out of memory?
Hello D.,
I have seen this error when there were empty rows saved as part of the data in at least one of the Excel worksheets. You can find which worksheet has this problem, by pressing ^ + End key in each worksheet. If doing so goes below rows with data, this worksheet has the problem.
The code loads each worksheet into memory for processing. We have seen where there are over a million empty rows in a worksheet. That one request for the data to Excel causes the out of memory because of the number of rows. gINT would eventually discard those empty rows (after a lot of processing to find out they are empty) but it never gets the chance.
Once you find the problem worksheet(s), copy just the rows with data, paste into new worksheet(s), delete the original worksheet(s), then rename the new worksheet(s) with the same name(s) as the original.
If you have questions about this please contact support: appsnet.bentley.com/.../addcall.aspx.
I had the same issue once when importing large amounts of CPT data. The excel file had close to 100,000 lines (multiple borings, readings at every 0.1', etc) and generated the error you mention on import. Problem was solved by splitting the excel file into 2-3 smaller files and importing each file one at a time. This allowed gINT to read the entire file into memory before importing without generating the memory error. Once in gINT, it is fine and gINT can handle the large amount of data with no problem. The final project file was not excessively large either.