Error: "Field Is too Large (32K) or View's Column & Selection Formulas
Category Usability
I'm sure every Notes developer has seen this error message some time. Of course the error message indicates that....well..the field is too large, but the error doesn't tell you which field that is. Got it today in an application that has several large fields, so after half an hour of poking around and not finding any problem with my fields, read somewhere that this can happen when the $UpdatedBy field gets too large. I went into the database properties and in the last tab set the "Limit entries in $UpdatedBy fields" to 10, and no more error messages. Gotta love Notes error messages!
I'm sure every Notes developer has seen this error message some time. Of course the error message indicates that....well..the field is too large, but the error doesn't tell you which field that is. Got it today in an application that has several large fields, so after half an hour of poking around and not finding any problem with my fields, read somewhere that this can happen when the $UpdatedBy field gets too large. I went into the database properties and in the last tab set the "Limit entries in $UpdatedBy fields" to 10, and no more error messages. Gotta love Notes error messages!
Comments
Posted by Emmanuel At 06:23:31 AM On 08/16/2006 | - Website - |
Thanks,
Ragini
Posted by Ragini At 05:03:09 AM On 03/19/2007 | - Website - |
Thanks,
Ragini
Posted by Ragini At 05:06:13 AM On 03/19/2007 | - Website - |
Is anybody found a solution for it. Pls suggest
regards
Murali V
murali.v@axa-tech.com
Posted by Murali At 11:50:39 PM On 06/06/2007 | - Website - |
Can't find a way to run agents or do anything to affected documents.
In my case documents were created by agents. Individual field sizes were not a problem because they were max around 2K but because there were so many fields it was the total document summary caused the issue (as mentioned above the limit is 64K for thew whole document).
I modified the agent to remove the summary flag for all items larger than 1000 bytes when saving/mailing the document and that got rid of the error.
Use item.setSummary (false) in Java/API
Use item.isSummary=False in LotusScript
Incidentally if you copy an item to another document using document.replaceItemValue it will add the summary flag back because it is on in new items by default.
Posted by Mark Eley At 09:45:25 AM On 09/19/2007 | - Website - |
Posted by RH At 02:48:18 PM On 05/16/2008 | - Website - |
The solution to this is that need to change the field type to rich text in which u are facing the 32 k ( you can the field by looking into the text of field).
Posted by saleem Javeed At 05:46:01 AM On 06/25/2008 | - Website - |
MS Access is a 'personal productivty tool' NOT a corporate IT tool.
It cannot support more than 10 concurrent users in a coherent fashion. Much better to use SQL or something similar, hey how about Lotus Notes??
Posted by BA At 07:43:19 AM On 09/29/2008 | - Website - |
Posted by R.A.Danny At 02:29:14 PM On 03/24/2009 | - Website - |
Notes/Domino 6.x and later have the following limits regarding Summary fields: 32k per field, 64k per document.
Relative to memos: The limit for sending to individual names and locally expanded groups is 15k.
1.If the limit is relative to a particular field, workarounds are as follows:
- If the field must be of the Type Summary (allowing it to display in views) then the only workaround is to remove some of the text or place some of the text into another field (it is unlikely that 32k worth of data would be displayed in a view).
- If the field does not need to be displayed in a view then change the Type of the field to Rich Text or Rich Text Lite.
- Relative to memos: Remove names from the recipient fields and send a second memo or create one or more public groups and address the memo to the group(s) instead.
2.If the limit is relative to the total document, workarounds are as follows:
- Change whatever fields that do not need to be displayed in a view to Rich Text or Rich Text Lite.
- If the fields must be displayed in a view then there is no alternative but to break the information up into two documents.
Posted by Raj At 05:49:36 AM On 08/24/2009 | - Website - |