SnTT: Getting around the "Field is too large (32K)" error

laurette rynne - April 07, 2006
I have been working on creating a snapshot of our current Lotus Notes environment, and as part of doing this I have been pulling all the information I can about our users and applications into a couple of key databases. I had just completed pulling together a large amount of data and went to open a document to view the results when I got the following message:

"Field is too large (32K) or View's column & selection formulas are too large"

Ahh, of course, I didn't think about protecting the document against large field sizes. A silly mistake which could have been easily avoided if I'd thought about it first. Anyway, now I had about 20 documents which couldn't be opened.

Confident in my knowledge, I created a quicky @Formula agent to remove the problematic field from the documents. But alas, the agent won't run on the corrupted documents. Change the field to Rich Text and refresh-selected... nope. Hmm, well, I'll just delete them. Nope, couldn't delete them either.

...more »