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:

@Implode(@Trim(@Subset(@DbColumn("":"NoCache";"";"content";3);10));"")

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
:-P


Other Recent Stories...

  1. 03/21/2018Domino Apps on IOS is a Game Changer. Quit holding back.BOOM. This will be as important for the platform as Traveler. If your company has ditched Notes and Domino, I feel sorry for you. For companies that do use Notes/Domino this is a game changer and Apple should be paying attention. Here's why: There are hundreds of little Notes client applications you'd never spend the time and money to build and deploy for your internal user base on IOS that we use Notes for all the time (those of us still using it). Now, those are suddenly ALL available on the iPad. ...... 
  2. 02/15/2018Andrew’s Proposed Gun LawsThese are my current thoughts on gun laws that would radically change the culture and safety of gun ownership in the United States without removing the rights of gun owners or compromising their privacy rights. * Please feel free to link to, or just copy, these ideas. It would be wonderful to see them spread widely and eventually become the basis for something to rally around and become legislation. Update: 3/3/2018 I added #7, increasing the age to purchase. Update: 4/27/2018 Please be aware that I am not ...... 
  3. 05/05/2016Is the growing social-sourced economy the modern back door into socialism?Is the growing social-sourced economy the modern back door into socialism? I read a really insightful post a couple of days ago that suggested the use of social network funding sites like “Go Fund Me” and “Kickstarter” have come about and gained popularity in part because the existing economy in no longer serving its purpose for anyone who isn’t already wealthy. Have the traditional ways to get new ventures funded become closed to all but a few who aren’t already connected to them and so onerous as to make ...... 
  4. 04/20/2016Want to be whitelisted? Here are some sensible rules for web site advertising 
  5. 12/30/2015Fantastic new series on Syfy called “The Expanse” – for people who love traditional science fiction 
  6. 10/20/2015My suggestion is to stay away from PayAnywhere(dot)com  
  7. 08/07/2015Here is one for you VMWARE gurus - particularly if you run ESXi without fancy drive arrays 
  8. 08/06/2015The Killer of Orphans (Orphan Documents) 
  9. 06/02/2015Homeopathic Marketing: Traveler on my Android is now calling itself VERSE. Allow me to translate that for the IBM Notes community... 
  10. 03/17/2015A review of British Airways Premium Economy Service – How to destroy customer goodwill all at once 
Click here for more articles.....


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

Please wait while your document is saved.