Subject UDF glitch...
Author Woody
I have started having a glitch where the FB server seems to lose contact with the UDF DLL functions. I can't drop them and recreate them within the database. I keep getting BLR offsett errors with some (random) UDF calls like RTRIM, LTRIM and others. When I go to reassign the UDF function, FB complains that it can't find the entry point.

The only way to clear this up is to uninstall FB and reinstall. Then all works fine again without having to reassign any UDFs or make any changes. This has happened twice now.

The FB server is:

FB 1.5 RC 9 WI-V1.5.0.4288
Windows Server 2003 SE Service Pack 1
AMD Athlon XP 3300
3 gig ram
Adaptec SCSI RAID 22005 controller

A little history:

Originally, the client was running IB 6.0 on a Win2K machine and nothing like this ever happened. We moved everything over to the new machine and switched to FB 1.5. All databases were backed up on old server and restored on new server using proper techniques and corresponding gbak programs on each server.

This problem never appeared before the switchover. Do I need to drop and then recreate the UDF function links in all the databases?

Woody (TMW)

[Non-text portions of this message have been removed]