Remote Server "Timeout" - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Remote Server "Timeout"

Author

Topic

Kristen
Test

22859 Posts

Posted - 2007-03-06 : 06:12:47

Any ideas please?

I'm getting either

"General network error"

or

Server: Msg 3624, Level 20, State 1, Procedure MySproc, Line 253

Location: recbase.cpp:1374
Expression: m_nVars > 0
SPID: 59
Process ID: 3544

Connection Broken

The command being run is:


SELECT	*
FROM	OPENQUERY(MyRemoteServer, 
'
SELECT	TOP 25000 *
FROM	MyRemoteDatabase.dbo.MyRemoteTable
WHERE	    MyDate > ''2007-03-05T14:08:09.983''
	OR (
		    MyDate = ''2005-10-05T12:55:55.413''
		AND MyStringPK > ''0157652''
	)
')

A revised query doing a COUNT(*) instead runs fine, and there are 45,000 rows that satisfy this condition. My logs show that this process runs a max of 5,000 except for a couple of occasions when it ran 8,000 and 10,000. (The Remote Server is itself getting data (from Oracle) with a limit of 5,000 per hour, hence the 5,000 Max even though this process is set to max at 25,000 - its set that way to allow it to "catch up" with the up-stream process if it stalls for some reason)

I've dropped the SELECT TOP down and at 1,000 it runs OK, but even 5,000 it gives network errors.

It was running 5,000 per hourly run for the 3 hours up to the point that it failed (yesterday)

Thanks

Kristen

Kristen
Test

22859 Posts

Posted - 2007-03-06 : 06:55:06

OK, so I got around to running CHECKDB ...

... the local database is bust (and [master])

Edit: See Corruption in Master

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources