Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine 6 » Invalid BLOB Handle in record buffer.
Post new topic  Reply to topic View previous topic :: View next topic 
Invalid BLOB Handle in record buffer.
PostPosted: Thu Mar 24, 2011 5:56 am Points: 0 Reply with quote
king123
Cuckoo for GoldMine Puffs
Joined: 02 Sep 2009
Posts: 374




We just upgraded to SQL and occasionally we are getting the error, while we are in real-time tab. Any ideas?
View user's profile Send private message

PostPosted: Thu Mar 24, 2011 6:25 am Points: 0 Reply with quote
ronanc
GoldMine Veteran
Joined: 10 Sep 2007
Posts: 723




In the alias for the GoldMine database in the BDE Administrator try setting the "Blob Size" and "Blobs to cache" settings to 256.
View user's profile Send private message

PostPosted: Thu Mar 24, 2011 6:47 am Points: 0 Reply with quote
king123
Cuckoo for GoldMine Puffs
Joined: 02 Sep 2009
Posts: 374




What does it do? it's now set to 1024 ?
View user's profile Send private message

PostPosted: Thu Mar 24, 2011 7:02 am Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




Did you perform full maintenance (rebuild with sort/verify) before hosting to sqL?

I agree with ronan. Here are the specific instruction in the area that he suggests:

Quote:
Go into BDE Administrator
In the Database tab select your alias eg GoldMine_Sales
On the right you'll see Blobs to Cache - set this to 1024 (or higher)
Save and exit.
Restart GoldMine... this will probably fix the problem... if it dose not post again.


You may need to host the data back to dBase then perform full maintenance then host back to SQL.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Thu Mar 24, 2011 7:23 am Points: 0 Reply with quote
ronanc
GoldMine Veteran
Joined: 10 Sep 2007
Posts: 723




If its already set to 1024 then chaning it wont make much difference. I recommend setting it to 256 because the default is something like 8.

What version of SQL is your database sitting in?
View user's profile Send private message

PostPosted: Thu Mar 24, 2011 7:55 am Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




I listed my details just to make sure that he was looking at the correct alias. Over the years, the numbers I suggested had become one of the standard fixes though it takes more memory.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Thu Mar 24, 2011 10:48 am Points: 0 Reply with quote
king123
Cuckoo for GoldMine Puffs
Joined: 02 Sep 2009
Posts: 374




It's SQL 2000, so will it make any differnce if ill change it to 256 ?
I'm not sure if full maintenance was performed before the upgrade, if not - is there another way to fix it, other than converting back?
View user's profile Send private message

PostPosted: Thu Mar 24, 2011 11:14 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




http://www.castellcomputers.com/?p=50

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Thu Mar 24, 2011 12:16 pm Points: 0 Reply with quote
king123
Cuckoo for GoldMine Puffs
Joined: 02 Sep 2009
Posts: 374




thanks!
View user's profile Send private message

Invalid BLOB Handle in record buffer.
  ContactReview Forum Index » GoldMine 6
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin