SQL Server 2005 Non-Fatal Error

Asked By Brad Tod 0 points N/A Posted on - 12/19/2011

Hi everyone,

I have done some upgrades to components on my system and reinstalling Windows XP with SP2.

Also,we had to make some software updates to the server so it can support more connections.

Recently error message appears. Now I am confused, because I thought that we had made all right updates (SQL Server 2005 all available updates are installed) so that we don’t have to buy new server..

Any suggestions?

Thank you

Brad

Non-Fatal Error

Retrieving the list of recent order summaries failed. (mscorlib)

Additional information:

DoaProxy :unable to intercept  method name ‘FindAllSummaries’, cause : A transport- level error has occurred when sending the request  to the server .(provider : TCP Provider,error :0 – An existing connections was forcibly closed by the remote host.)(IBatisNet.DataAccess)

A transport-level error has occurred when sending the request to the server.(provider : TCP

Provider, error: 0 – An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)

• Status: Open
• Question Views: 1268
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Thompson Locker 10 points N/A #123355

SQL Server 2005 Non-Fatal Error

If you are receive an error within a stored procedure, what you will need to do, especially if the error is a non-fatal error like it is you your case, is to halt the sequential processing of the code, and after you have done that you can either choose to branch to another code segment in the procedure or you can as well choose to return processing to the calling application.

The non-fatal errors will not abort processing a procedure, and neither will they affect the connection with the client application. In the event that there is occurrence of a nonfatal error within a procedure, the processing will just continue on the line of code that follows the one that caused the error.

-Thompson Locker

 

About Thompson Locker

Questions
0

Answers
619

Best Answers
77

• Vote Up 0 Vote Down

• Posted on - 01/01/2012
• Question Category: MS SQL Server