Tuesday, March 27, 2012

General network Error

I have some Jobs in the sceduler with the same problem.
The error is General network Error
The Client and the SErveur are the same, Only database or
table change.
I can have the error at any time a day.
I can have this error with Sceduler or directly into DTS.
I use the protocole TCP-IP only.
SQL SERVEUR version :
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003
Microsoft Corporation
Enterprise Edition on
Window's version :Windows NT 5.0 (Build 2195: Service Pack
4)
The last version of MDAC : MDAC 2.7 SP1 REFRESH with
Component Checker 2.0 from Microsoft.
---
-- E -- x -- e -- m -- p -- l -- e --
---
TSRun OnStart: DTSStep_DTSExecuteSQLTask_12
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_22
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_12
DTSRun OnStart: DTSStep_DTSDataPumpTask_15
DTSRun OnError: DTSStep_DTSDataPumpTask_15, Error = -
2147467259 (80004005)
Error string: [DBNETLIB][ConnectionWrite (send()).]
General network error. Check your network documentation.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
Error Detail Records:
Error: -2147467259 (80004005); Provider Error: 11 (B)
Error string: [DBNETLIB][ConnectionWrite (send()).]
General network error. Check your network documentation.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
DTSRun OnFinish: DTSStep_DTSDataPumpTask_15
DTSRun: Package execution complete.
---
Thanks for your help.Did you see any corresponding problems with your network card in the NT
System Even log?
Does the problem reproduce easily or is it only under stress?
Does the problem happen if you enable Named Pipes or create a Named Pipes
Alias on the machine?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I try severall test with the network card on this Server=20
and on another servers and the result are comparable.
In the past I have Named Pipes network librairy but for=20
few days, I dont get the General Network Error.
I can reproduce the problem but generaly with only 3 or 4=20
main jobs. ( ~8 DTS packages )
I have alias with TCP-IP but I have uncheck named Pipe=20
because I always got the error when this librairy is=20
checked.=20
ThankS,
Dominic H=E9bert
quote:

>--Original Message--
>Did you see any corresponding problems with your network=20

card in the NT=20
quote:

>System Even log?
>Does the problem reproduce easily or is it only under=20

stress?
quote:

>Does the problem happen if you enable Named Pipes or=20

create a Named Pipes=20
quote:

>Alias on the machine?
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and=20

confers no rights.
quote:

>
>.
>

No comments:

Post a Comment