Getting more information on error found by SQL Trace

• webrunner

  SSC-Dedicated

  Points: 31865

  More actions

  January 20, 2016 at 9:46 am

  #307181

  Hello experts,

  I am helping developers troubleshoot a PHP error they are seeing in a scheduled job. But I don't seem to be getting sufficient information to tell them the exact cause of the error. It is a SELECT query that is being aborted but that is all I can tell so far.

  The key trace data I see is:

  EventClass: 12

  Error: 2

  I looked up those codes and see only the following:

  EventClass -> SQL:BatchCompleted Event Class

  Error -> '2=Abort'

  Ref.:

  https://msdn.microsoft.com/en-us/library/ms176010(v=sql.110).aspx

  Is there a way to find out more about what this abort result is or why it happens?

  Thanks for any help!

  - webrunner

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

• SQL Severe DBA

  Hall of Fame

  Points: 3579

  More actions

  January 20, 2016 at 10:27 am

  #1853224

  What is the error the job throwing . Have you checked SQL error log or Event viewer .

  IF the job was running fine before , what changed in the system recently ( that way easier to isolate the issue )