"Field too large" error while only <32K fields are used

HCL Domino Domino Forum
1

In a web application, I use a WebQuerySave agent that saves DocUNIDs into a number of fields.For instance, I create 12 multi-valued fields containing each 250 document universal IDs from a ViewEntryCollection.

When I do a doc.save in my Java agent, I get the following error :

4000:Notes error: Field is too large (32K) or View’s column & selection formulas are too large

NotesException: Notes error: Field is too large (32K) or View’s column

& selection formulas are too large

at lotus.domino.local.Document.Nsave(Native Method)

at lotus.domino.local.Document.save(Unknown Source)

at lotus.domino.local.Document.save(Unknown Source)

at org.myComp.myAgent.NotesMain(myAgent.java:149)

at lotus.domino.AgentBase.runNotes(Unknown Source)

at lotus.domino.NotesThread.run(NotesThread.java:208)

"

It doesn’t occur when I collect, say, 1000 IDs.

However, the fields themselves don’t seem to take more than 32K.

Does someone know why I get this error ? Is the size of the document

limited ?

Thanks in advance.

2

Subject: “Field too large” error while only <32K fields are used

Sorry, Frederick, We just got back from talking to Lotus about this very problem. There are a couple things you should know:

  1. There was no problem in R5, ND6 broke it.

  2. The Software Problem Report (SPR) is BASO5ZZQFT and has several PMRs attached to it.

  3. Here is Lotus’s Solution:

SPR: BASO5ZZQFT states that this is under investigation by Lotus QE. This does not happen in R5 nor does it happen if the text fields are changed to Rich Text fields.

Not much help right now, I know, but Tthe folks at Lotus are aware of the problem and are working on it. I’m told that if 6.5 doesn’t fix it, then 7 will.

Regards,

Jack

3

Subject: Try calling NotesItem.setSummary(false) on your 12 fields before saving

4

Subject: RE: Try calling NotesItem.setSummary(false) on your 12 fields before saving

OK, it works.Thanks a lot

5

Subject: “Field too large” error while only <32K fields are used

Frederic,

Text fields have a 32 KB limit. Change them to rich text and you’ll be fine. The syntax for writing to a rich text field is a little more complicated – requiring the hassle of getting a handle to a NotesRichTextItem – but Designer Help has examples.

Ken

6

Subject: RE: “Field too large” error while only <32K fields are used

Well, each of my field contains (number of elements) * (number of characters) * (size of a character in bytes), i.e.250 * 32 * 2 bytes = 16000 bytes, much less than the limit.

Furthermore, if I treat 1000 DocIDs (so in 4 fields of identical length), the problem doesn’t appear.