Databases
StackOverflow2013
Postsdbo
PO.Net Windows Service Throws EventType clr20r3 system.data.sqlclient.sql error
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO.Net Windows Service Throws EventType clr20r3 system.data.sqlclient.sql error
    primarykey
    data
    text
    <p>I have a .Net/c# 2.0 windows service. The entry point is wrapped in a try catch block that notifies me of problems and allows the service to continue operating normally yet when I look at the server's application event log I see a number of "EventType clr20r3" errors that are causing the service to die unexpectedly. The catch block has a "catch (Exception ex)" and does not rethrow the exception.</p> <p>Each sql commands is of the type "CommandType.StoredProcedure" and are executed with SqlDataReader's. These sproc calls function correctly 99% of time and have all been thoroughly unit tested, profiled, and QA'd. I additionally wrapped these calls in try catch blocks just to be sure and am still experiencing these unhandled exceptions.</p> <p>This only in our production environment and cannot be duplicated in our dev or staging environments (even under heavy load).</p> <p><strong>Why would my error handling not catch this particular error? Is there anyway to capture more detail as to the root cause of the problem?</strong></p> <p>Here is an example of the event log:</p> <blockquote> <pre><code>EventType clr20r3, P1 RDC.OrderProcessorService, P2 1.0.0.0, P3 4ae6a0d0, P4 system.data, P5 2.0.0.0, P6 4889deaf, P7 2490, P8 2c, P9 system.data.sqlclient.sql, P10 NIL. </code></pre> </blockquote> <p>Additionally</p> <blockquote> <pre><code>The Order Processor service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 60000 milliseconds: Restart the service. </code></pre> </blockquote>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMichael Petrotta
    1. USWilliam Edmondson
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PO.Net Windows Service Throws EventType clr20r3 system.data.sqlclient.sql error
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO.Net Windows Service Throws EventType clr20r3 system.data.sqlclient.sql error
      1. USPrabhu
      1. VTFavorite
    3. VO
      singulars
      1. PO.Net Windows Service Throws EventType clr20r3 system.data.sqlclient.sql error
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAre you sure that there are no other exceptions being logged in the EventLog?
      singulars
      1. PO.Net Windows Service Throws EventType clr20r3 system.data.sqlclient.sql error
      1. USAdam Robinson
    2. COHave you tried adding an AppDomain.UnhandledException event handler? http://msdn.microsoft.com/en-us/library/system.appdomain.unhandledexception.aspx Pretty much the problem is you have an unhandled SQL exception somewhere in your code.
      singulars
      1. PO.Net Windows Service Throws EventType clr20r3 system.data.sqlclient.sql error
      1. USSerapth
    3. COPositive. I just see pairs of messages indicating the above error and a messages indicating the service has been restarted.
      singulars
      1. PO.Net Windows Service Throws EventType clr20r3 system.data.sqlclient.sql error
      1. USWilliam Edmondson
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload