Created by Monica Reategui on 01/07/2005. Modified: 01/07/2005 12:32

Message

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

Synopsis

not sure, i am trying to submit a form with a hidden field allowing certain users to see it and edit. the link they get on the email should have a query of: openView. i tried editdocument and they see a login page which is not what i want. help please

Solutions

From IBM

Bertrand on 01/14/2005 03:03

I've seen this issue before on one of the form in our web application. After checking with IBM PMR team, they replied that most probably the form has corrupted.

You should try to redeploy the template, or create a new form then copy-paste the designs into it, then see if the same problem reoccured

Neo on 09/04/2006 10:21 PM

It is a Problem with IBM also....

{Link}

Venugopal Reddy on 04/18/2007 05:46 AM

i don't know

mzt on 02/20/2008 02:50 AM

I was called in for a similar problem. Someone's email not not receiving in-line pictures with that very same error;

ERROR: Field is too large (32k) or View's column & selection formulas are too large.

1. Fixup made no difference (always start here)

2. Compacting made no difference (sometimes can)

3. Replace design (BINGO... corrupt design element) This is suggested by Neo. Good call.

Paul

Paul Grottoli on 02/20/2008 03:07 PM

>>>START<<<

Try

load compact -c -i -D {filepath}

This compacts with

-c = copy

-i = ignore errors

-D = delete view indexes

>>>END<<<

it deletes the buggy documents

Alex

Alexander Kogan on 10/08/2008 08:32 AM

I tried multiple techniques. Including a view to show all by noteID. I tried tools from Yria, and Notesman as well. The issue seems that you can't access these documents via Notes API at all so you can't delete them via script. The best method is to compact the databases. as per mr. kogan above.

Jose Zaldivar on 03/24/2009 11:41 PM

Find out how many hidden Text type fields are there. Check if they hold a @dblookup(...) in the "Default Value" of the field. Put the @dblookup in the field properties > Formula Window. Make the fiels Editable and not computed. Cause that too sometime gives the error.The Text field has crossed its data limit thus resulting in the error. Changing it a Textlist and then putting the formula in right place resolves the error.

Gayatri Gouda on 02/26/2010 05:18 AM

load compact -c -i -D

thanks it helps me.

tom on 03/23/2011 04:42 AM

After a lot of frustration I managed to eliminate this error by reducing the number of mail rules of the client - worked a charm !

Philip Regan on 11/29/2011 02:25 AM

Fixup -V helps (Domino 8.5.2FP3), all other tips failed, even ScanEZ couldn't delete the document.

12/01/2011 06:32:41 PM Remote console command issued by Michael Niermann/415/INT/EEC: Load Fixup "database.nsf" -V

12/01/2011 06:33:17 PM Queuing compact command for database.nsf by Michael Niermann/415/INT/EEC

12/01/2011 06:33:18 PM Document NT000216C6 in database D:\Lotus\Domino\Data\database.nsf is damaged: Field is too large (32K) or View's column & selection formulas are too large

12/01/2011 06:33:18 PM Document (UNID OF3E4B8880:85F8FDB7-ONC1257952:00348576) in database D:\Lotus\Domino\Data\database.nsf has been deleted

12/01/2011 06:33:29 PM Completed consistency check on database.nsf

12/01/2011 06:33:29 PM Database Fixup: Shutdown

Michael N on 12/01/2011 11:52 AM

Use this form to add a suggested cause or solution which you think might help.

Adding content is disabled. The spammer have won.