Categorized | Tech Tips

GoldMine Error: Invalid BLOB Handle In Record Buffer

Posted on 05 March 2010 by Bob Ritter

You keep getting a string of errors that says  ‘Invalid BLOB handle in record buffer’ when you are working in GoldMine.  

Nothing’s wrong with your GoldMine, really. What it’s saying is that the list of items you’re looking at (the History Tab , for instance) has more items with notes than can be handled by your Borland Database Engine’s setting for the number of notes fields to cache in memory.  This doesn’t mean the program or database has a problem, it just means that with your current BDE settings, you’re trying to work with too much data at one time.

If you continue to receive this error on even relatively short lists of information, you may need to increase the number of BLOBs that are cached in memory at any given time. To change this setting, open the BDE Administrator from the GoldMine tools menu (or the Windows Control Panel) and locate the proper database alias*.  Highlight it and note the BLOBS TO CACHE setting on the right side. Adjust it, as necessary. The higher the number you set, the more items you can work with in places like the activity list. Keep in mind, however, that the higher the number, the worse your performance could be. A happy medium is typically anywhere from 512 to 1024.

*If you’re not sure of your database alias, you can check it under Help|About|System in GoldMine. It will be listed for the GoldMine Files item. Your alias may look something like this: MSSQL: GoldMine_Data: dbo. The important part in this example is GoldMine_Data.

If you need further assistance contact First Direct Corp directly.

Leave a Reply

You must be logged in to post a comment.

Live chat