Goldmine - Native SQL error 0
Posted on 2009-05-07
I have been using the forum for information and education purpose for a while now. Recently we got new servers (domain controller and database server) running on Windows Server 2003 enterprise and Windows Server 2003 Standard respectively. We migrated all our SQL goldmine DB files from the old server to the new ones. Since then Goldmine has been working fine, all data gets updated etc. Everything seems to be going well, however since the day we migrated we have been bombarbed with a particualr SQL error that has puzzled us and the Goldmine consultants. The error looks a bit like this:
General SQL error.
Native SQL error: 0
Context: skip 1
MSSQL: GoldMine_GMBase: dbo.CAL
1: Server message:
BDE Error Cat:Code: [51:3]
BDE: 500 [4/11/1999] GoldMine: 6.70.50123
Window: Gail Cassidy
Now, researching on the net it pointed to a network issue but we had a continuous ping on a few workstations to the DB server and it did not fail all day however the error keeps coming on at random times. We have many things but to fail everytime. Has anyone found a solution for this particular error? I would really appreciaate some help.
We are running Goldmine 6.70.50123 CE and all workstations are running Win XP SP2.
The worst part is we are a medical centre and it causes a lot of stress to some staff when goldmine pops with the error and at times pops up the error report closing goldmine completely.