Unable to extend an ID table – insufficient memory March 23, 2009
Posted by svenm in Administration.Tags: Administration, server
trackback
Now this is nice. The database that I was talking about the other day is having a serious problem: I can no longer open the damn thing! Due to the heavy import load it seems that the ID table has overflowed. The database currently is 5.684 Mb and contains 3.393.081 documents. I still have to do 3 more imports before I can automate my weekly updates. This weekly update will be an xml file of about 11Mb.
After a little googling I found out that the only thing I can do is copy the entire database because that deletes all the view indices and all the deletion stubs but will keep the replica ids of the documents.
Here’s the technote that I found.
UPDATE: A collegue of mine just opened the database without a problem! When I tried opening the db again I kept on getting the same error. I even tried on 2 different laptops. Turns out that a simple solution was right there: I removed the db from my workspace and compated the workspace. After that I could open the db again!! This saved me a lot of time and problems…

We came up against exactly this situation on some very large old mail boxes recently.
The kicker is that it started causing our BES servers to crash when the BES servers were accessing the mailboxes.
There is a tool on OpenNTF.org which can help you with this:
Data Migration Tool:
http://www.openntf.org/Projects/pmt.nsf/ProjectLookup/Database%20Migration%20Utility