General network error. Check your network documentation.
-
All
Anyone ever see this before
General network error. Check your network documentation.
We are getting this error on a stored procedure, the problem is that it is happening randomly, as the proc works some times and other times it will stop in the middle. The problem only occurs while running the stored procedure from the application server, it cannot be duplicated while running from .
We have applied all patches and are fully up to date.
The odd thing is that the print statements in the proc, show that the proc stopps in the same place every time. It is just a simple set statement. In other procedures it will stop in mid cursor, or actually doing a statement, but for each procedure the stop is always in the same place.
Any memory settings that I may be missing where a threshold is being passed and the proc is being shut down??? The default is to let all procedures run.
Any suggestions would be helpful
Thanks in advance
Eric
-
Can you post the code? What does the proc do? This is usually when a connection cannot find the server. Are you sure you have a connection at this point?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com -
Erm... might not be useful but could it be due to the Network card? Just a guess cos I had the problem in the past when I was using a "Bridge" PC to transfer data from AS400 to SQL, and do some additional processing.... Somedays it fails, somedays it work!! Truth is that we never solve the problem. We replace the PC and it's working fine now!
-
- If it occurs while running the sp :
check your network-card/cable the computer where you get the error.
If it occurs on #-computers, check network-card/cable at the server.
- Check out if the server didn't failover/reboot. I've had this 24/7 application which is so critical it has to be up and running forever an absolutly no downtime can be afforted. When we rebooted the connected sqlserver they only called me after 4 hours that they -at that time- received the "general network error". In other words, the application hadn't been used for 4 hours.
So from that day on I consider that application 20/7
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I got this error on a stored procedure that was being called from an ASP.NET application that was using the Microsoft Data Access Application Block for .NET
http://msdn.microsoft.com/library/en-us/dnbda/html/daab-rm.asp. This class greatly simplifies calling stored procedures. The only way I was able to fix the General Network Error was to not use the Data Access Application Block and create the ADO.NET parameters myself.
The error never occured in any of the fifty other stored procedure calls I made using the Application Block.
Fred Peters
Fred Peters
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply