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

HCL Domino Domino Forum
1

Hi,

I have an agent which customizes a mail(doc) and sends its to specified address.

I get the above error in line no.18 of below code… It looks wierd for me since the the ‘doc’ is getting saved in line no.1(no error), and after that its just updated with two fields, in which addresses(No.16 line) is just a simple text address(definitely not more than 5K)

And after that I just remove that mail from Inbox folder and save it, where I get this error…!

Any idea why am getting this error…?

And could someone tell me how can I find which field has exceeded 32K programmatically(am not able to get handle of this doc by script though)

my code

some code… then… below…

  1. Call doc.save(True,True)

  2. getaddress = getaddresses(doc.names1)

  3. Call s_LogMsg (0,"–> Forwarding email to " & Join(addresses, “,”) )

  4. Set forwarddoc = New NotesDocument(db)

  5. Call doc.CopyAllItems( forwarddoc, True )

  6. forwarddoc.principal = doc.from(0)

  7. forwarddoc.from = doc.from(0)

  8. forwarddoc.SendTo = addresses

  9. forwarddoc.CopyTo = “”

  10. forwarddoc.Region = region

  11. forwarddoc.SentList = groupname$

  12. forwarddoc.originalsendto = doc.sendto

  13. forwarddoc.originalcopyto = doc.copyto

  14. Call forwarddoc.Send( False)

  15. doc.Processed = “Yes”

  16. doc.addresses = addresses

  17. Call doc.RemoveFromFolder(“($Inbox)”)

  18. Call doc.Save(True, True)

Cheers,

Rakesh

2

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

I have not idea if this will make a difference, but what about adding a set after the fowarddoc line to “delete” the document as you don’t need it. I’m wondering if you’re just getting error message for something else.

Call forwarddoc.Send( False)

Set forwarddoc = Nothing

3

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

Am getting the error on line 18. When the ‘doc’ is saved. So I dont think its because of ‘forwarddoc’ object not being set to nothing.

4

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

I agree. It was just a case of I see a lot of documents being added to your database.

This maybe causing a Lotus Notes problem, and you’re just getting an error message on the save because you have maybe dozens or hundred or thousand of documents open that it’s tryiing to keep track of.

Or your doc could have some sort code in it that maybe references all those created documents.

Who knows. So I thought I’d pass along the tip.