ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 3月9日巡检日志(General network error)的处理

3月9日巡检日志(General network error)的处理

原创 Linux操作系统 作者:sbps 时间:2009-03-10 10:30:10 0 删除 编辑
Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 1、巡检遇到很多问题,其中最典型的问题(General network error)描述如下:

DTSRun OnError:  DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)

Error string:  Error at Destination for Row number 75584. Errors encountered so far in this task: 1.Error source:  DTS Data Pump

 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 OnError:  DTSStep_DTSDataPumpTask_1, Error = -2147213206 (8004206A)

Error string:  The number of failing rows exceeds the maximum specified.

Error source:  Microsoft Data Transformation Services (DTS) Data Pump

Help file:  sqldts80.hlp

Help context:  0

Error Detail Records:

Error:  -2147213206 (8004206A); Provider Error:  0 (0)

Error string:  The number of failing rows exceeds the maximum specified.

Error source:  Microsoft Data Transformation Services (DTS) Data Pump

Help file:  sqldts80.hlp

 Help context:  0

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_1

DTSRun:  Package execution complete.


2、反复检查数据库日志文件和操作系统日志文件,发现如下设置:

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4

2009-02-28 16:47:39.79 server    SQL Server is starting at priority class 'high'(2 CPUs detected).

2009-02-28 16:47:41.32 server    Working Set size set to 773120 kilobytes.

初步判断是由于这两个参数设置引起的错误。


3、修正参数,命令如下:

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4   sp_configure 'set working set size', 0  

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4   sp_configure 'min server memory (MB)', 0 

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 sp_configure 'priority boost', 0


重新启动服务器后,问题得到解决

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/47232/viewspace-566558/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2009-03-06

  • 博文量
    2
  • 访问量
    2140