Hi,
We have a Web Based Database that is causing an issue for us when it contains several thousand documents.
There is an agent on the form that performs a db lookup and retrieves a list of documents, which is then used to build up the body of the form being dispayed to the end user.
The problem is that we’re now getting the error
HTTP Web Server: Item value exceeds maximum allowable size.
Is there any trick/utility/debug setting that can be used to identify which field is causing the issue?
Many Thanks
Ian
Subject: HTTP Web Server: Item value exceeds maximum allowable size.
I got this error on two occasions.
One, I was using “parentunid=123…789” in a url, and the unid value was for a document that was not in the database.
Two, I was doing a dblookup with a key value that was computed using @urlquertystring(someparametervalue).
Even though the @dblookup was set to [FailSilent] AND wrapped in an @IfError(@DBLookup(…) , “”); I still got this error.
Subject: HTTP Web Server: Item value exceeds maximum allowable size.
Use a WebQueryOpen agent and a computed rich text field (computed to itself) instead of an @DbLookup to create the content. See this post (and more) at Jake Howlett’s Codestore for some ideas:
http://www.codestore.net/store.nsf/unid/BLOG-20070810/