November 14, 2010 at 5:54 pm
Hi,
I have a SSIS task that run on the same server where my database is. The task do:
-Truncate a table
-Drop indexes
-Insert into the table
-Recreate indexes
I got this message recently:
" failed with the following error: "[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly
I am wondering why I got a network error, since the SSIS and SQL server are on the same machine and all the sql commands are in the same Execure SQL task. This has never failed with this error before.
Do someone can help me understand this?
Thanks,
January 14, 2011 at 7:47 am
Can someone help here? I got the same issue again. The first time since a few months.
February 11, 2011 at 8:07 am
I cannot help much- but we too get this error- and we found that in our system logs there is an information message-
Log Name: System
Source: arcsas
Date: 2/11/2011 8:08:33 AM
Event ID: 129
Task Category: None
Level: Warning
Keywords: Classic
User: N/A
Computer: db1.ad.calspan.com
Description:
Reset to device, \Device\RaidPort0, was issued.
Event Xml:
this message would appear seconds before the SQL message appeared in the applications log. they are not one for one- we can have the "arcsas" message without a SQL failure. but all of our SQL messages has a corresponding "arcsas" message.
have you seen something similar?
however we dont have an answer... we moved our log files to a seperate drive and the occurences of the issue has dropped dramatically but the "arcsas" still occurs... as stated usually when under stress but not always. and we have occurrances where the on the performance monitor the memory hits many hard faults. still trying to figure that one out too- not sure they are related.
anyone else having this issue?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply