Cannot write database row. Possibly out of space
When importing a large MID/MIF file into MapInfo Professional, the following
error is encountered:
Cannot write database row. Possibly out of disk space.
Whilst I've observed this error when importing, given the cause, it could
quite possibly occur in other situations as well.
MapInfo does not appear to support data files more than 2GB (231bytes)
in size (the limit of addressing using 32bit signed numbers). In the above
example of importing a MID/MIF file, the .dat file that contained the imported
data grew to 2,097,152KB (231 bytes). When MapInfo needed to extend the
file beyond this point the above error is raised.
Presumably this error would also be obtained if disk space had been exhausted.
- If you have hit this error because you have run out of disk space
then free up some disk space and try again.
Remedy for 2GB limit - None, but as a work around:
- When importing data, if possible split the MID/MIF file into two
or more separate (smaller) files and import those individually.
- For other scenarios, understand what you are doing, whether it is
likely that you are hitting the 2GB data size limit and whether there
is an alternative approach that would avoid the limit.
These notes are believed to be correct for MapInfo v7.5
running on Windows 2000 and may apply to other versions as well.
About the author: Brian Cryer
is a dedicated software developer and webmaster. For his day job he
develops websites and desktop applications as well as providing
IT services. He moonlights as a technical author and consultant.