General Network Error

[Einar Arne Skive]

Hi,

I have a query that frequently (but not always) throws an "General Network
error".

SELECT DISTINCT Top 500 cl_prefix, cl_suffix, cl_company, cl_next_call_date,
null, null, cl_contact_status, cl_acct_num, null, cl_last_name,
cl_first_name, null, null, null, null, null, null, null, null,
cl_mail_flag, a.ad_address_label , a.ad_line_1 , a.ad_line_2 , a.ad_city ,
a.ad_state , a.ad_zip , a.ad_country , a.ad_address_id, null, null, null,
null, null, cl_middle_name
FROM addrview p with (nolock), address a with (nolock), contact_address c
with (nolock) , contact_phone cp with (nolock)
WHERE ( ((cl_custom8 = 'SAND') And (cl_product_pref_25 = 'N') And
(cp.cp_phone_label = 'HOME') And (a.ad_zip >= '4600') And (a.ad_zip <=
'4645') And (ISNULL(cp.cp_phone_label,'')<>'') And (cl_contact_status =
P') )
)
AND p.cl_acct_num = c.cl_ad_acct_num AND c.cl_ad_address_id =
a.ad_address_id
AND p.cl_acct_num = cp_cl_acct_num


I have been able to get this call stack from the point of error.

General network error. Check your network documentation.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff, Int32
offset, Int32 len)
at System.Data.SqlClient.TdsParser.SkipBytes(Int64 num)
at System.Data.SqlClient.TdsParser.SkipRow(_SqlMetaData[] columns, Int32
startCol)
at System.Data.SqlClient.SqlDataReader.CleanPartialRead(TdsParser parser)
at System.Data.SqlClient.SqlDataReader.Read()
at modMain.TestSearch(StreamWriter oWriter, String SearchName, String
sSQL) in C:\Data\SourceSafe\Visual
Basic.Net\QubeSearch\QubeSearchTest\modMain.vb:line 74


Any one seen this before ? Suggestions to what can possibly be causing this
error ?.
Suggestions on how to instrument program to get a more detailed exception
error ?


Test Program and SQL-Server is running on the same machine.

Thanks
very much in advance.

Einar Arne

 

[William Ryan eMVP]

Einar:

The General Network Error is usually just that..it can be a lot of things:

Here are some links that may help you narrow it down:
http://weblogs.asp.net/ssadasivuni/archive/2003/12/06/41705.aspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;826829
http://tek-tips.com/gviewthread.cfm/lev2/ 4/lev3/32/pid/796/qid/733298

HTH,

Bill