On selecting a file in the Import Processor, get error 7 "out of memory":
The information in the article refers to:
Monitor-Pro MP-5
Applies to:
| Product: | MP-5 |
| Reported Version: | MP5.0.1 |
| Applies to: | All MP-5 versions |
| Area of effect | Import Processor |
Overview
On selecting a file in the Import Processor, get error 7 "out of memory"
Details
This error is caused by the Import Processor trying to load a file on to the grid that has many failed resolutions.
It's not directly related to the file size, as a very large file with no resolutions will import with no problems.
It does not mean that the computer necessarily has run out of memory, but that the space allocated for the grid has. The number of rows that it will accept varies from PC to PC but is typically in the order of 15,000 rows.
Solution
If your file has thousands of resolutions to be made, maybe the Import Processor isn't the fastest place to resolve them. Check the file contents, make corrections and re-import. Alternately split the file into smaller sections and re-import.
This will address the error 7. You will still have the problem that your original file will still be in the Import Processor.
To clear the original file, choose it in the drop-down list on the Import Processor, wait for the error 7 to appear, and press cancel to clear it. Next, press "Reject" in the bottom right corner.
If you have a number of files giving problems, you can clear the whole Import Processor, you can run a script via the admin tool.
Instructions:
Copy and paste the following line into a text file:
Truncate table tblimportdata
Save the text file and rename the suffix to be .sql
Run the script through the admin tool.
Note: THIS COMMAND CLEARS THE WHOLE IMPORT TABLE SO YOU MUST ENSURE THAT ANY IMPORTANT OTHER FILES AWAITING IMPORT ARE CLEARED FIRST OTHERWISE THEY WILL BE LOST FROM THE IMPORT PROCESSOR.
Related articles:
For instructions on using the admin tool click here