cursor issue

• Phil Parkin

  SSC Guru

  Points: 246991

  More actions

  June 29, 2011 at 4:40 am

  #1345787

  glen.wass (6/29/2011)

  ---

  That error sounds like somting your calculating has a null value so you need to find out what and eliminate the null.

  Do you have any representative data we can use to parse your cursor?

  A zero surely. Dividing by NULL returns NULL.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• SGT_squeequal

  SSCertifiable

  Points: 7167

  More actions

  June 29, 2011 at 6:30 am

  #1345856

  ys i agree 0 divided by null yeilds null, i had a simmilar issue with the same error and once i sorted out the null value the script worked fine

  ***The first step is always the hardest *******

• tfifield

  SSCrazy Eights

  Points: 9655

  More actions

  June 29, 2011 at 2:28 pm

  #1346236

  shilpa.shankar87 (6/28/2011)

  ---

  Below error the job is throwing:

  Message

  Executed as user: . Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Divide by zero error encountered. [SQLSTATE 22012] (Error 8134) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.

  Shilpa,

  Find out which procedure is doing the divide by zero. Use the simple logging method I mentioned above and you'll find it. You need to fix that procedure.

  Todd Fifield