Vince's Dominolog  

About Lotus and other stuff






Cleaning up is hard to do

Especially cleaning up code in databases you are not familiar with can be a real pain.
My take on this issue has always been if you are not certain, leave it alone (hands off approach), but apparently not everybody agrees.

One of my customers called with a question about a certain agent that gave him some problems. They were cleaning up the code but suddenly one of the agents showed red crosses in the designer client (yes, 8.5 designer finds those oddities for you even if you are not looking for them).
He tried to fix the crosses by recompiling the entire database (in production....mmmm.....) but that didn't fix it, could I take a look?
Sure, I can, and this is the problem:

The agent is still running



but the scriptlibraries are missing


They are in luck the agent wouldn't save on the recompile because without a scriptlibrary I'm sure it would not have been very functional otherwise.
After checking I found that the scriptlibraries have been missing for a loong time, the copy I had from a couple months back also missed that scriptlibrary so I hope they can find it on a backup somewhere.

Note: ALWAYS use monthly/halfyearly backups in addition to the weekly cycle. The data or code could be missing a long time before you notice it.