Urs Meli

Yesterday I made NSFDB2 working on my test servers. I had this strange errormessage: "Error managing DB2 groups....DB2 Authorization violation" when I tried to compact a database to DB2.

I did the installation 3 or 4 times. DB2 enable ran successfull but compacting never succeeded.  After checking every parameter several times I found the mistake. I entered a path for the "DB2 datastore directory". When I removed the entry for this field, compacting ran without issues.

Today I was forced to recompile a database with Notes 8.0.2. I was very surprised.

Recompile time dropped from about an hour (in Notes 7.0.2) to 5 minutes.

Short tipp: If you plan to enable db2 on a remote server, don't start the local DB2 command center.

I did it to test the connection between my domino server and the db2 server. Afterwards I was not able to enable the db2 on the domino server.
I got a strange communication error. And some hint about the catalog.

So I started the command center, removed my db2 node from the list. Tada! Now I could enable  the db2 on my domino.

Seems that Installpump is back in business.

see:

Here the link to the Homepage Softquest

DB2 integration is quite tricky. Converting a notes database to DB2 is simple. But the impacts can be horrible
I tried it with a simple database, no problem.
A more advanced database with 350 views didn't work as expected. I was able to open the database but some views won't display.
I got a "index is corrupt...." message when I've tried to open it. Compact, fixup, updall nothing worked. I tried it with 3 different copies, all with the same result.

Either google nor the notes forum had a solution for that problem. Tomorrow I have to test it with some other databases...

Today I tested the NSFDB2. The installation was *cough* easy. The hardes part, was to find the Tutorial from last years course

After 4h I got eveything up and running on my VMWare server. Setup looks like:

1 Domain Controller Win2003

1 Domino 8.0.2 Server

1 DB2 Enterprise 9.5 Server

Impressions so far:

• My first database got corrupted, when I transfered it to the DB2.
• When I transfered the second database, my db2 server ran out of hd space
• After expanding the disksize, I encountered several errors 1042c, 1065n
  It turned out that my db2 server lost the connection to my domain controller, therefor the db2 service account was not able to start.
  Rebooting the whole VMWare server, and checking all the network configurations, everything is now ok.

I hope it works all fine now.

 Today I updated a lotus connections 1.0.2 pilot to lotus connections 2.0. There's a great guide on the connections wiki site which covered all the basic topics.

 

Everything went fine, but the activities wont start anymore. Activity Service not available is the only message I get.

The Websphere Console says that the activities ear is up and running....

Edit 29.8.08: 

Uninstalling the activities and re-installing solved the issue. It wors fine now.

 

Today I found a way to shoot yourself in the foot with vmware server.

It is very simple, if you store your vmware images on USB drives like I do.
I tried to be smart. To copy some big files in the vm I mounted a second USB drive into the vm.

Everything worked fine.
When I went home I stopped the vm's and removed the drives.

Next time I startet the vm windows xp accidentially changed my drive letters.
Now the when the vm tried to start, it took over the USB drive which hosted the vm.

BOOOM.

The vm crashed with a very strange error message (I forgot to take a screenshot).
The USB was not accessible in windows anymore too.

 

A month ago I encountered a strange problem with a LEI Server.

 

Today we didn't find the problem, but found the solution.

 

After removing LEI from the server (and all *.nsf *.ntf) and reinstalling it, LEI seems to work.

Can anybody remember every single username/password for every website?

I mean I'm registered in dozens of websites: ebay, facebook, xing, gmail, gmx, bleedyellow, jazz.net, openntf.

Some good sites like bleedyellow let me choose my mail address as a login name.

 

Other sites like jazz.net want me to find some fanzy login/screenname.

Grrrreat. My preferred name is always occupied by some other moron.

By now I have dozens of loginnames with different numbers etc.

When I visit a site after some time, I can't remember my loginname. I know my password, because I change it on a regular basis (once per year).

So I know, I created the account 2 years ago, so it must be that password, but what the hell is my loginname.

Sure I can click on recover password, or I forgot my loginname.. but that's annoying and it fills up my mailbox quite a lot....

 

 

Why can't I simply log in with my bloody emailaddress........ It would save me lots of frustration.

 

It's hard enough to remember the passwords!

 

Today I tested my agent, which updated some calendar entries, which were replicated via LEI from a MSSQL database.

Lei replicated the data in a notesdatabase in under a minute. After the replication, LEI started my agent, which took more then 1900 seconds to process around 1000 entries.

 

The problem was, that the LEI replication job started every 30 minutes. The agent stopped with the error "document has been deleted".

Change the replication schedule would solve the problem. But more than 30 minutes for my agent? I can do better.

 

The agent used a lot of Notesdatabase.search() calls to prevent duplicated entries in the users calendar.

 

Refactoring the Notesdatabase.search() to Notesview.getAlldocumentsbyKey() and some minor improvements made a nice performance boost.

The result: from around 1900 Seconds to 160  to 190 seconds for the same amount of documents.

 

The use of the search() method has been chosen to avoid changing the mailtemplate (multilingual environment R7 migrating to  R8). And in

the test environment I only used too less data....

 

Now the agent checks wether a special view is available and creates it if needed.

 

The first solution is not necessary the best.....

 

There's not a lot to say about the clientsetup.

After registring a user over the webconfiguration, adding a new workstation to the domain, logging in with the user, starting the batchfile from the user's homedrive. Some keystrokes and some mouseclicks and the notes client is up and running.

 

There has to be some bugs. It was all tooo easy

 

more infos under http://lotusfoundations.blogspot.com/

 Today I got the Lotus Foundations 1 Server on my vmware server up and running.

The installation was very easy: connect the iso image to the server and boot.

 

All the configuration is done through a simple webinterface

 

The domino installation and configuration was fully automated.

After 3 hours (on my slow vm) I had a complete windows domain controller, domino, ftp, fileserver, dns server,.... up and running.

 

Next point will be the Notes Client installation. but it is too late now

Yesterday we fought a very strange problem in LEI 8.0.1.

We created a new replication activity from an MS SQL source to a Notes database. About 80'000 records.
 Every time we stop this activity, either by hand or by timeout,  the server will crash.

The server then reboots and crashes again with the same errormessage:




To start the server, we had to disable the LEI task in the notes.ini file, start the server, delete all the entries in LEILOG.nsf, enabel LEI in the notes.ini and restart the server again.

I found the following link today:
Lotus Support 6.0

Maybe the Notes.ini Setting EIUseOSMemory=1 will help.

We have to try this and look what happens.


Seems that the ini setting saved my day.

 

Today, while I was editing a webagent my domino 8.0.1 testserver suddenly crashed.
Everytime I started the agent, my server would crash.

NSD showed just a FATAL error in nhttp with a "Access Violation" message.
I added lots of debug messages to the openlog database. These messages showed me, that the agent had finished successfull before the server crashed.

After investigating the agent a lttle more, adding some additional Print statements, I found the problem.
To have a clean HTML output I added the code: print "content-type:text/html" so my output had the right mime-type.
While refactoring the code I split it into several subroutines and made the mistake to add content type to a string.
My code looked like this

dim result as string

result = "content-type:text/html"
result = result & "<html><head>"
.... [lots of html code here]
print result

After changing the first result= back to print, the agent was working as expected and without crashing the server.

Seems that messing with the content type can crash a domino server.

If this is a bug in domino, than every one, which can create Lotusscript agents and run them through the browser, would be able to crash the server.