Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

General SQL Error

Status
Not open for further replies.

MikeBronner

Programmer
May 9, 2001
756
US
Hi All,

We have been experiencing this problem for many years now, and even calls to Frontrange tech support didn't result in any lasting results.

I'll show the error, followed by the actions we tool to attempt to resolve it:

Code:
General SQL error.
Native SQL error: 10025

Context: SQLQuery: GM_GMBase:
set rowcount 1 SELECT * FROM dbo.CAL (NOLOCK)  WHERE ALARMFLAG = 'Y' AND USERID = 'PKHANDJI' AND (ALARMDATE <= '01/28/2008') ORDER BY ALARMFLAG ASC, USERID ASC, ALARMDATE ASC, ALARMTIME ASC set rowcount 0

1: Server message: Possible network error: Write to SQL Server Failed.  General network error.  Check your documentation.

BDE Error Cat:Code: [51:3]
BDE: 500 [4/11/1999]  GoldMine: 6.70.50123

User: PKHANDJI
Window: 
Template: 
Details:
NATIVEMSG: Possible network error: Write to SQL Server Failed.  General network error.  Check your documentation.

To fix this we were instructed to increase the MAXDBPROCESS setting in the BDEMgr by 1024. After initially have Frontrange tech support walk us through some configurations in the BDEMgr, we stopped seeing this problem for about 2 weeks. However, now it has come back and seems to occur on a daily basis again.

Does anyone have any ideas what this error means? Our thought is that something PREVIOUS to the shown query is causing the actual error, resulting in the following query to fail. Unfortunately none of the event logs (in Goldmine, SQL, and Windows) allude to anything being wrong.

Thanks!

Take Care,
Mike
 
Are you running optimization and indexing through SQL on a regular (daily) basis? I wonder if you have a corrupt record or index in your CAL file.

You can also try running individual maintenance on the Calendar file through GoldMine, which will drop and recreate the indexes on the table. Run that off-hours or when there are no users on the system.

SQL Errors like that don't show usually up in SQL or Windows event logs. It's frustrating and tough to trace.

__________
It's better to have loved and lost than live with the idiot for the rest of your life.
 
Thanks for the reply. We run database maintenance on a nightly basis, which does a backup, shrinks the logs, and checks the integrity.

Additionally, I have run many DBCC tests of my own on the various tables that the Goldmine errors list. (Un?)Fortunately they don't report any issues.

However, we also use QuoteWerks in connection with Goldmine, and while working on resolving an issue we encountered in QuoteWerks the other day, the thought of it possibly being the culprit occurred to me.

Has anyone else seen issues in Goldmine when using the QuoteWerks connector?

Thanks again!

Take Care,
Mike
 
What sql service pack are you on?

What version of sql client do you have installed on ALL your workstations?

What protocol(s) is your sql server listening on and what protocol(s) are the client using?

What OS is your server? What service pack is it on?


Doug Castell
Castell Computers
 
Our specs are:

Goldmine SQL Server Version: 8.0.194 (SP4)
Workstation SQL Client: None, we run Goldmine off the server install (on db server).
Protocols / ports: Runs on the db server (local).
Server OS: Windows NT 5.2 Build 3790 (Windows 2003 SP1)

Thanks for taking the time to help on this. :)

Take Care,
Mike
 
Sorry, I need to clarify on the SQL client tools installed on the workstations:

We DO have the client tools installed: SQL Server 2000 Client tools with SP4.

Take Care,
Mike
 
How about BDE versions?

What are the specs in:
-the Configuration tab under the MSSQL connector?
-the System|INIT area?
-the BDE alias for your SQL database?

In the sql server network utility and client tools, what's the primary protocol? Named pipes or TCP/IP or... ?

Doug Castell
Castell Computers
 
SQL Server 8.0.194 is the RTM (Release to Manufacturing) version. SP4 is 8.00.2039. You're not patched to SP4 if you're running a SELECT @@VERSION and getting 80.194. That could be part of your problem right there.

__________
It's better to have loved and lost than live with the idiot for the rest of your life.
 
BDE Version: 5.01
SQL Server Protocols have both Named Pipes and TCP/IP.

I have saved the BDE config file and pasted the content here:
Code:
   SYSTEM
FORMATS
DATE
SEPARATOR				/
MODE					0
FOURDIGITYEAR				FALSE
YEARBIASED				TRUE
LEADINGZEROM				FALSE
LEADINGZEROD				FALSE
NUMBER
DECIMALSEPARATOR			.
THOUSANDSEPARATOR			,
DECIMALDIGITS				2
LEADINGZERON				TRUE
TIME
TWELVEHOUR				TRUE
AMSTRING				AM
PMSTRING				PM
SECONDS					TRUE
MILSECONDS				FALSE

INIT
VERSION					4.0
LOCAL SHARE				TRUE
MINBUFSIZE				128
MAXBUFSIZE				4096
LANGDRIVER				DBWINUS0
MAXFILEHANDLES				999
SYSFLAGS				0
LOW MEMORY USAGE LIMIT			32
AUTO ODBC				FALSE
DEFAULT DRIVER				DBASE
SQLQRYMODE				
SHAREDMEMSIZE				6144
SHAREDMEMLOCATION			7000
MEMSIZE					24
DATA REPOSITORY
DRIVERS
PARADOX

INIT
NET DIR					C:\
VERSION					4.0
TYPE					FILE
LANGDRIVER				ascii
TABLE CREATE
LEVEL					4
BLOCK SIZE				2048
FILL FACTOR				95
STRICTINTEGRTY				TRUE
DB2
DB OPEN
USER NAME				MYNAME
DB2 DSN					DB2_SERVER
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
LANGDRIVER				
SQLQRYMODE				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
SCHEMA CACHE TIME			-1
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
ENABLE BCD				FALSE
ROWSET SIZE				20
BLOBS TO CACHE				64
BLOB SIZE				64

INIT
VERSION					4.0
TYPE					SERVER
DLL					SQLD_DB2.DLL
DLL32					SQLDB232.DLL
DRIVER					IBM DB2 DRIVER
DRIVER FLAGS				
TRACE MODE				0
DBASE
INIT
VERSION					4.0
TYPE					FILE
LANGDRIVER				DBWINUS0
TABLE CREATE
LEVEL					5
MDX BLOCK SIZE				1024
MEMO FILE BLOCK SIZE			512
INFORMIX
DB OPEN
SERVER NAME				INF_SERVER
DATABASE NAME				MY_DATABASE
USER NAME				MYNAME
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
LANGDRIVER				
SQLQRYMODE				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
LOCK MODE				5
DATE MODE				0
DATE SEPARATOR				/
SCHEMA CACHE TIME			-1
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
ENABLE BCD				FALSE
LIST SYNONYMS				NONE
DBNLS				
COLLCHAR				
BLOBS TO CACHE				64
BLOB SIZE				64

INIT
VERSION					4.0
TYPE					SERVER
DLL					SQLD_IN5.DLL
DRIVER FLAGS					
DLL32					SQLINF32.DLL
TRACE MODE				0
INTRBASE
DB OPEN
SERVER NAME				IB_SERVER:/PATH/DATABASE.GDB
USER NAME				SYSDBA
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
LANGDRIVER				
SQLQRYMODE				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
SCHEMA CACHE TIME			-1
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
ENABLE BCD				FALSE
BLOBS TO CACHE				64
BLOB SIZE				64

INIT
VERSION					4.0
TYPE					SERVER
DLL					SQLD_IB.DLL
DRIVER FLAGS				
DLL32					SQLINT32.DLL
TRACE MODE				0
MSACCESS
DB OPEN
LANGDRIVER				
DATABASE NAME				
USER NAME				
OPEN MODE				READ/WRITE

INIT
VERSION					4.0
TYPE					SERVER
DLL32					IDDAO32.DLL
DRIVER FLAGS				
TRACE MODE				0
MSSQL
DB OPEN
DATABASE NAME				
SERVER NAME				MSS_SERVER
USER NAME				MYNAME
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
BLOB EDIT LOGGING				
LANGDRIVER				
SQLQRYMODE				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
DATE MODE				0
SCHEMA CACHE TIME			-1
MAX QUERY TIME				900
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
HOST NAME				
APPLICATION NAME				
NATIONAL LANG NAME				
ENABLE BCD				FALSE
TDS PACKET SIZE				4096
BLOBS TO CACHE				64
BLOB SIZE				64
MAX DBPROCESSES				31

INIT
VERSION					4.0
TYPE					SERVER
DLL					SQLD_SS.DLL
DLL32					SQLMSS32.DLL
VENDOR INIT				
CONNECT TIMEOUT				60
TIMEOUT					3000
DRIVER FLAGS				
TRACE MODE				0
ORACLE
DB OPEN
SERVER NAME				ORA_SERVER
USER NAME				MYNAME
NET PROTOCOL				MYNETPROTOCOL
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
LANGDRIVER				
SQLQRYMODE				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
SCHEMA CACHE TIME			-1
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
ENABLE BCD				FALSE
ENABLE INTEGERS				FALSE
LIST SYNONYMS				NONE
ROWSET SIZE				20
BLOBS TO CACHE				64
BLOB SIZE				64
OBJECT MODE				TRUE

INIT
VERSION					4.0
TYPE					SERVER
DLL					SQLD_ORA.DLL
VENDOR INIT				MTXOCI.DLL
DRIVER FLAGS				
DLL32					SQLORA8.DLL
TRACE MODE				0
SYBASE
DB OPEN
DATABASE NAME				
SERVER NAME				SYB_SERVER
USER NAME				MYNAME
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
BLOB EDIT LOGGING				
LANGDRIVER				
SQLQRYMODE				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
DATE MODE				0
SCHEMA CACHE TIME			-1
MAX QUERY TIME				
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
HOST NAME				
APPLICATION NAME				
NATIONAL LANG NAME				
ENABLE BCD				FALSE
TDS PACKET SIZE				512
BLOBS TO CACHE				64
BLOB SIZE				64
MAX DBPROCESSES				31

INIT
VERSION					4.0
TYPE					SERVER
DLL					SQLD_SS.DLL
CONNECT TIMEOUT				60
TIMEOUT					3000
DRIVER FLAGS				
DLL32					SQLSSC32.DLL
VENDOR INIT				
TRACE MODE				0
DATABASES
MSSQL_GoldMine
DB INFO
TYPE					MSSQL
PATH				
DB OPEN
DATABASE NAME				GoldMine
SERVER NAME				YOUR-NT-SERVER-NAME
USER NAME				sa
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
BLOB EDIT LOGGING				
LANGDRIVER				
SQLQRYMODE				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
DATE MODE				0
SCHEMA CACHE TIME			-1
MAX QUERY TIME				300
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
HOST NAME				
APPLICATION NAME				
NATIONAL LANG NAME				
ENABLE BCD				FALSE
TDS PACKET SIZE				4096
BLOBS TO CACHE				64
BLOB SIZE				32

IB_GoldMine
DB INFO
TYPE					INTRBASE
PATH				
DB OPEN
SERVER NAME				IB_SERVER:/PATH/DATABASE.GDB
USER NAME				SYSDBA
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
LANGDRIVER				
SQLQRYMODE				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
SCHEMA CACHE TIME			-1
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
ENABLE BCD				FALSE
BLOBS TO CACHE				64
BLOB SIZE				32

MQIS
DB OPEN
DATABASE NAME				
USER NAME				
ODBC DSN				MQIS
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
SQLQRYMODE				
LANGDRIVER				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
SCHEMA CACHE TIME			-1
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
ENABLE BCD				FALSE
ROWSET SIZE				20
BLOBS TO CACHE				64
DB INFO
TYPE					SQL Server
PATH				 

LocalServer
DB OPEN
DATABASE NAME				
USER NAME				
ODBC DSN				LocalServer
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
SQLQRYMODE				
LANGDRIVER				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
SCHEMA CACHE TIME			-1
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
ENABLE BCD				FALSE
ROWSET SIZE				20
BLOBS TO CACHE				64
DB INFO
TYPE					SQL Server
PATH				 

GM_GMBase
DB INFO
TYPE					MSSQL
PATH				
DB OPEN
DATABASE NAME				gm_gmbase
SERVER NAME				gms01
USER NAME				gm6user
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
BLOB EDIT LOGGING				
LANGDRIVER				
SQLQRYMODE				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
DATE MODE				0
SCHEMA CACHE TIME			-1
MAX QUERY TIME				300
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
HOST NAME				
APPLICATION NAME				
NATIONAL LANG NAME				
ENABLE BCD				FALSE
TDS PACKET SIZE				4096
BLOBS TO CACHE				1024
BLOB SIZE				1024
MAX DBPROCESSES				31

gm_common
DB INFO
TYPE					MSSQL
PATH				
DB OPEN
DATABASE NAME				gm_common
SERVER NAME				gms01
USER NAME				gm6user
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
BLOB EDIT LOGGING				
LANGDRIVER				
SQLQRYMODE				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
DATE MODE				0
SCHEMA CACHE TIME			-1
MAX QUERY TIME				300
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
HOST NAME				
APPLICATION NAME				
NATIONAL LANG NAME				
ENABLE BCD				FALSE
TDS PACKET SIZE				4096
BLOBS TO CACHE				1024
BLOB SIZE				1024
MAX DBPROCESSES				31

gm_contacts
DB INFO
TYPE					MSSQL
PATH				
DB OPEN
DATABASE NAME				gm_contacts
SERVER NAME				gms01
USER NAME				gm6user
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
BLOB EDIT LOGGING				
LANGDRIVER				
SQLQRYMODE				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
DATE MODE				0
SCHEMA CACHE TIME			-1
MAX QUERY TIME				300
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
HOST NAME				
APPLICATION NAME				
NATIONAL LANG NAME				
ENABLE BCD				FALSE
TDS PACKET SIZE				4096
BLOBS TO CACHE				1024
BLOB SIZE				1024
MAX DBPROCESSES				31

gm_public_relations
DB INFO
TYPE					MSSQL
PATH				
DB OPEN
DATABASE NAME				gm_public_relations
SERVER NAME				gms01
USER NAME				gm6user
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
BLOB EDIT LOGGING				
LANGDRIVER				
SQLQRYMODE				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
DATE MODE				0
SCHEMA CACHE TIME			-1
MAX QUERY TIME				300
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
HOST NAME				
APPLICATION NAME				
NATIONAL LANG NAME				
ENABLE BCD				FALSE
TDS PACKET SIZE				4096
BLOBS TO CACHE				1024
BLOB SIZE				1024
MAX DBPROCESSES				31

gm_ni2002
DB INFO
TYPE					MSSQL
PATH				
DB OPEN
DATABASE NAME				gm_ni2002
SERVER NAME				gms01
USER NAME				gm6user
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
BLOB EDIT LOGGING				
LANGDRIVER				
SQLQRYMODE				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
DATE MODE				0
SCHEMA CACHE TIME			-1
MAX QUERY TIME				300
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
HOST NAME				
APPLICATION NAME				
NATIONAL LANG NAME				
ENABLE BCD				FALSE
TDS PACKET SIZE				4096
BLOBS TO CACHE				1024
BLOB SIZE				1024
MAX DBPROCESSES				31

MS Access Database
DB OPEN
DATABASE NAME				
USER NAME				
ODBC DSN				MS Access Database
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
SQLQRYMODE				
LANGDRIVER				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
SCHEMA CACHE TIME			-1
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
ENABLE BCD				FALSE
ROWSET SIZE				20
BLOBS TO CACHE				64
DB INFO
TYPE					Microsoft Access Driver (*.mdb)
PATH				 

Excel Files
DB OPEN
DATABASE NAME				
USER NAME				
ODBC DSN				Excel Files
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
SQLQRYMODE				
LANGDRIVER				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
SCHEMA CACHE TIME			-1
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
ENABLE BCD				FALSE
ROWSET SIZE				20
BLOBS TO CACHE				64
DB INFO
TYPE					Microsoft Excel Driver (*.xls)
PATH				 

dBASE Files
DB OPEN
DATABASE NAME				
USER NAME				
ODBC DSN				dBASE Files
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
SQLQRYMODE				
LANGDRIVER				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
SCHEMA CACHE TIME			-1
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
ENABLE BCD				FALSE
ROWSET SIZE				20
BLOBS TO CACHE				64
DB INFO
TYPE					Microsoft dBase Driver (*.dbf)
PATH				 

GM_Historical
DB INFO
TYPE					MSSQL
PATH				
DB OPEN
DATABASE NAME				gm_historical
SERVER NAME				gms01
USER NAME				gm6user
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
BLOB EDIT LOGGING				
LANGDRIVER				
SQLQRYMODE				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
DATE MODE				0
SCHEMA CACHE TIME			-1
MAX QUERY TIME				300
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
HOST NAME				
APPLICATION NAME				
NATIONAL LANG NAME				
ENABLE BCD				FALSE
TDS PACKET SIZE				4096
BLOBS TO CACHE				1024
BLOB SIZE				1024
MAX DBPROCESSES				31

gm_callblitz
DB INFO
TYPE					MSSQL
PATH				
DB OPEN
DATABASE NAME				GM_CallBlitz
SERVER NAME				gms01
USER NAME				gm6user
OPEN MODE				READ/WRITE
SCHEMA CACHE SIZE			8
BLOB EDIT LOGGING				
LANGDRIVER				
SQLQRYMODE				
SQLPASSTHRU MODE			SHARED AUTOCOMMIT
DATE MODE				0
SCHEMA CACHE TIME			-1
MAX QUERY TIME				900
MAX ROWS				-1
BATCH COUNT				200
ENABLE SCHEMA CACHE			FALSE
SCHEMA CACHE DIR				
HOST NAME				
APPLICATION NAME				
NATIONAL LANG NAME				
ENABLE BCD				FALSE
TDS PACKET SIZE				4096
BLOBS TO CACHE				1024
BLOB SIZE				1024
MAX DBPROCESSES				31

Take Care,
Mike
 
Thanks for the info on the SQL version. I have the SELECT as you described with the following result:
Code:
Microsoft SQL Server  2000 - 8.00.194 (Intel X86)   Aug  6 2000 00:57:48   Copyright (c) 1988-2000 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

So what you are saying here is that because we installed SQL Server 2000 RTM, and even though we ran the SP4 update, it didn't apply because it wasn't the official production release? Or is it because the SP4 was actually not applied, even though we may think it was (it was a previous IT crew, before my time). Looking at nother SQL 2000 server it does show the version you describe: 8.00.2039.

I will try running the update and see what happens. Thanks for the info on this!

Take Care,
Mike
 
Running the SP4 exe that's downloaded from Microsoft only unpacks it. You then have to go into the directory created, under \x86\setup and run the setupsql.exe.




__________
It's better to have loved and lost than live with the idiot for the rest of your life.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top