Solved

Goldmine - Native SQL error 0

Posted on 2009-05-07
15
1,649 Views
Last Modified: 2013-11-15
Hey guys,

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

User: AMEET
Window: Gail Cassidy

Template:
Details:



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.
0
Comment
Question by:ahmzie
  • 8
  • 6
15 Comments
 
LVL 11

Expert Comment

by:stevengraff
ID: 24333290
I don't know what this is, and my guesses may as well be right as wrong... so, in that spirit, here are a few things to look at:

1. Be sure your SQL server is communicating on tcp/ip. To ensure this, turn off all other protocols, especially Named Pipes.
2. You don't mention whether either of your new servers is 64 bit. This could be a problem; this version of GoldMine does not purport to run in a 64-bit environment. (Though it seems that it should, I think.)
3. Does the error message always implicate the CAL table? or does it name a different table from time to time?
4. If you have a good backup you could try doing a full rebuild of the database. Not normally recommended, somewhat extreme, but it could help weed out data issues.
5. How did you move the db? The right way is backup/restore. The less right way is detach/attach.
6. Can you temporarily a) put the db back where it was and see if that helps? and/or b) put the files back and see if that helps?

Is it a coincidence that your error message started popping up after you moved GoldMine? Or is the root cause somewhere in that before/after scenario?
0
 

Author Comment

by:ahmzie
ID: 24350472
1. We tried that, all protocols are working perfectly.
2. We are running Windows Server 2003 32 bit Enterprise Edition
3. Implicates CAL, LOOKUP, FIELDS5, MAILBOX etc.
4. What are the pros and cons? Any recommendations with it?
5. Backup/Restore
6. Ok will give that a go.

We have never that particular error before (NATIVE SQL ERROR 0). And it only started after the move.
0
 
LVL 6

Expert Comment

by:automationstation
ID: 24351287
Some ideas...

Make sure you are using a TCP/IP Alias in the SQL Client Network Utility... Ideally, the alias would be given the Server Name in the top box and the Server's IP Address in the lower box. This will help the workstation know where the server is by IP Address.

I would also reset the user's INI files... there may be some older references to the older server.

Did you run the LInkDocMover from Prior Analytics (http://www.prior-analytics.com/support.aspx?page=61) could be some old references to linked documents by server name.

Are you using an internal DNS Server (do an IPCONFIG /all at a cmd prompt to see where your DNS server is. Ideally , DNS should be an internal (private IP) Address.

What antivirus do you use? Have you tried disabling it to see if the errors go away?
0
 

Author Comment

by:ahmzie
ID: 24351340
I just had a look aat the TCP/IP alis in the SQL Client Network Utility on my workstation. It was empty, i added in the server name and IP address to TCP/IP protocol.

I reset one of the user's INI file a week ago thinking this might solve it, however that user started to receive errors very soon. The error seems more like a pest.

Yes we are using an internal DNS server which is independent of the goldmine server.

Well,. we had the anti virus running prior to the new goldmine server. Goldmine was functioning fine runing of the old server with the antivirus running in the background.
0
 
LVL 11

Expert Comment

by:stevengraff
ID: 24353661
Again, regarding my #1 point, turning off all the other protocols will force GoldMine to run over TCP/IP. If Named Pipes is turned on, GoldMine will use it if tcp/ip is faulty. If tcp/ip is, for some reason, not working right, GoldMine will automatically use Named Pipes. If Named Pipes is turned off, and tcp/ip is faulty, you'll get an error message -- this is what you want to determine. GoldMine is optimized to use tcp/ip. It will work over Named Pipes, but not properly.

If you discover that tcp/ip isn't working after all, that's what you'll need to fix first; but you really should verify this point.
0
 

Author Comment

by:ahmzie
ID: 24381696
At 10:30 AM

I am getting one the users to use Goldmine on the server for the day and check if the errors pop up, if they don't then we can somewhat conclude that it could be the workstations. However this is just a hunch.

Progress at 2:15 PM
      
Ok the result of using Goldmine directly on the server resulted in 0 errors. The users who kopped the most errors were on the server today together terminally. The peformance was much faster, no freezes, crashes (obviously because it was on the goldmine server). However no database errors. Could it be the workstations? Majority of the workstations use MS SQL client, some of them have BDE admin in the common files foder of program files. What could I possibly reset on the workstations and then try goldmine?
0
 
LVL 11

Expert Comment

by:stevengraff
ID: 24384384
You haven't yet demonstrated that tcp/ip is operational as a protocol on your SQL server.

Try this:

1. Open a command prompt on a workstation.
2. Enter this command:

telnet  <servername>  1433

hit enter, and see what you get. If the screen turns black instantly, your tcp/ip is operational. If not, then you need to fix that, typically by installing the latest sql service pack.
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

Author Comment

by:ahmzie
ID: 24408309
Domain Controller telnet resulted in connection failed.

Goldmine server telnet worked straight away.

However strangely,telnet was disabled on both the Domain Controller and the Goldmine Server.

Domain Controller telnet resulted in black screen (port 23), it did not work with 1433

Goldmine server telnet worked straight away again to port 1433 but not to port 23
0
 
LVL 11

Expert Comment

by:stevengraff
ID: 24411315
Some computers (usually vista or Win 2008) do not have the telnet program on them.

If you find that you can't use the telnet command to port 1433 on your sql server, that means your sql server is not listening on tcp/ip. You should correct this situation. The easiest, most reliable fix, is to install the most recent service pack for sql. If 1433 tests good from your sql server (i.e. not going through your lan) but not from workstations, this would indicate a firewall problem, i.e. 1433 is blocked from external access on your sql server.
0
 

Author Comment

by:ahmzie
ID: 24417255
Telnet works fine through port 1433 to the SQL server.
0
 

Author Comment

by:ahmzie
ID: 24417327
I have done a complete Windows update on the server as of last night.
0
 
LVL 11

Expert Comment

by:stevengraff
ID: 24428426
I'm not 100% sure that a Windows update will also automatically update SQL.  Your best bet is to open a query window and enter the following query:

select @@Version

Just curious... did you get a chance to try #6 yet?

Another thought... your bde settings are in hklm\software\borland\database engine\configfile01. This registry entry may have changed during your move. You might try finding the idapi32.cfg file from your old bde location, and copy it into the new bde location.
0
 
LVL 11

Assisted Solution

by:stevengraff
stevengraff earned 20 total points
ID: 24492145
Ahmzie, any progress?
0
 

Accepted Solution

by:
ahmzie earned 0 total points
ID: 24670661
hi
sorry about the delay, thank you all for your help.. windows update had fixed the problem. I guess it may have been a windows SR2 bug.
0
 

Author Comment

by:ahmzie
ID: 24672059
thanks
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

GoldMine CRM has a fairly open database architecture , however in this case the email distribution list is stored in a quirky way and does not allow easy access for external use. This article will give details of this and provide a method to extr…
The need for Texting We all wear many hats. Part of this article's focus is the marketing hat... and another part is the consumer hat. Those of us who are consumers frequently are either ambivalent toward, or hiding from... those of us who are mark…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now