Andrew Pollack's Blog

Technology, Family, Entertainment, Politics, and Random Noise

I ran into an upgrade issue when I moved from Domino 7.0 to 7.01 this weekend.

By Andrew Pollack on 05/15/2006 at 01:24 PM EDT

This lost me several hours over the weekend. It seems that 7.0.1 along with 6.5.4 there are some changes in the backend classes or in the LotusScript interface to those cases when storing data into fields. When moving from Domino 7.0 to 7.01 I ran into a problem which was oddly similar to the one I described last week.

In this case, a web application just stopped working correctly. It took me several hours to track down, because it happened that I wasn't upgrading a server, I was installing a new one and replicating the data over to it. I assumed for quite a while it was a data problem. It wasn't. A content area on a web application is populated by using a lookup to a view, then taking the most recent "n" entries from that view and displaying them as an html region. The formula looks like this:


This formula just wouldn't work, it kept returning @ERROR -- and @Text() around it wouldn't give me the error. I could view the columns in designer, client and even on the web by going to that view. It changed nothing. Finally, by paring down the layers over and over I got to an actual error message logged to the console of the server.

05/14/2006 12:58:41 PM HTTP Web Server: Lotus Notes Exception - Field is too large (32K) or View's column & selection formulas are too large [url]

Aha. You see, the lookup was the exact same size on the 7.0 server, but the 7.0.1 server balked at it. I had to make the view selection formula smaller in order to accomplish what I wanted more quickly. Its important to note that this lookup happens on COMPUTED TEXT not a field, and would never have been saved -- thus would never have been in a view column or selection formula, and would never have been summary data. It was done at display time and not saved.

A quick performance note: If I was worried about performance in this application, a MUCH smarter way to write this would be to run an agent once ever 5 or 15 minutes that did a similar lookup and wrote the results to a static value on a profile document or something.

There are  - loading -  comments....

you probably need IF1 or whatever it's calledBy Ken Yee on 05/16/2006 at 03:39 PM EDT
But PITA Lotus requires you to call into support and ask for it. It'll be
fixed in 7.02 and 6.55.

Basically, if your @dblookup returns an interim result bigger than 64K, it used
to be ok, but not in 7.01/6.54. It was beat to dead in the BP forum a few
months back, although I'm really disappointed Lotus didn't release 7.02 sooner

Other Recent Stories...

  1. 01/26/2023Better Running VirtualBox or VMWARE Virtual Machines on Windows 10+ Forgive me, Reader, for I have sinned. I has been nearly 3 years since my last blog entry. The truth is, I haven't had much to say that was worthy of more than a basic social media post -- until today. For my current work, I was assigned a new laptop. It's a real powerhouse machine with 14 processor cores and 64 gigs of ram. It should be perfect for running my development environment in a virtual machine, but it wasn't. VirtualBox was barely starting, and no matter how many features I turned off, it could ...... 
  2. 04/04/2020How many Ventilators for the price of those tanks the Pentagon didn't even want?This goes WAY beyond Trump or Obama. This is decades of poor planning and poor use of funds. Certainly it should have been addressed in the Trump, Obama, Bush, Clinton, Bush, and Reagan administrations -- all of which were well aware of the implications of a pandemic. I want a military prepared to help us, not just hurt other people. As an American I expect that with the ridiculous funding of our military might, we are prepared for damn near everything. Not just killing people and breaking things, but ...... 
  3. 01/28/2020Copyright Troll WarningThere's a copyright troll firm that has automated reverse-image searches and goes around looking for any posted images that they can make a quick copyright claim on. This is not quite a scam because it's technically legal, but it's run very much like a scam. This company works with a few "clients" that have vast repositories of copyrighted images. The trolls do a reverse web search on those images looking for hits. When they find one on a site that looks like someone they can scare, they work it like ...... 
  4. 03/26/2019Undestanding how OAUTH scopes will bring the concept of APPS to your Domino server 
  5. 02/05/2019Toro Yard Equipment - Not really a premium brand as far as I am concerned 
  6. 10/08/2018Will you be at the NYC Launch Event for HCL Domino v10 -- Find me! 
  7. 09/04/2018With two big projects on hold, I suddenly find myself very available for new short and long term projects.  
  8. 07/13/2018Who is HCL and why is it a good thing that they are now the ones behind Notes and Domino? 
  9. 03/21/2018Domino Apps on IOS is a Game Changer. Quit holding back. 
  10. 02/15/2018Andrew’s Proposed Gun Laws 
Click here for more articles.....

pen icon Comment Entry
Your Name
*Your Email
* Your email address is required, but not displayed.
Your thoughts....
Remember Me  

Please wait while your document is saved.