Fatal Exception Error: 17310, Severity: 20, State: 1

• dajonx

  SSCertifiable

  Points: 6950

  More actions

  November 1, 2011 at 7:03 am

  #262183

  Hi,

  Has anyone stumbled upon this fatal exception error? Mine is EXCEPTION_INT_DIVIDE_BY_ZERO. We have resolved the fatal exception by changing a date value in a look-up table, but I don't see how this particular exception applies to us.

  Note1: As you can see, I have removed the names for confidentiality purposes...

  Note2: Changing the date value in table1 [Col1] fixed it...

  ALTER PROCEDURE [dbo].[sp_exception]

  @i1 INT,

  @t1 DECIMAL(20,5) = NULL OUTPUT,

  @c1 INT = NULL OUTPUT

  AS

  DECLARE @d1 SMALLDATETIME, @a1 SMALLDATETIME, @a2 INT, @a3 INT

  SELECT @d1 = CONVERT(VARCHAR, GETDATE(), 101), @a2 = 8, @a3 = 23

  SELECT @a1 = [Col1]

  FROM table1

  WHERE [Col2] = 1

  SELECT @c1 = SUM([Col1]), @t1 = SUM([Col2])

  FROM (

  SELECT 3 AS [Num], 3 * [Col4] AS [Tot]

  FROM table3

  WHERE [Col1] = @i1

  AND [Col3] <= @a1

  AND MONTH = DATEPART(MONTH, @d1)

  AND [Col3] >= DATEADD(HOUR, @a2, @d1)

  AND [Col3] <= DATEADD(HOUR, @a3, @d1)

  UNION ALL

  SELECT 1 AS [Num], [Col4] AS [Tot]

  FROM table2 r

  WHERE [Col1] = @i1

  AND [Col3] >= @a1

  AND MONTH = DATEPART(MONTH, @d1)

  AND [Col6] >= DATEADD(HOUR, @a2, @d1)

  AND [Col6] <= DATEADD(HOUR, @a3, @d1)

  ) a

  Does anyone know why that particular fatal exception was thrown?

  Thank you!

  My Blog!