Post reply

Null value is eliminated by an aggregate or other SET

  • October 22, 2005 at 3:41 pm

    #169201

    Hi,

    I appreciate if somebody can help me out withthe following warning occuring in one of the job.This job uses like 50 stored procedures and Can any body tell me how to capture information about which stored procedure or sql statement causing this warning.Can I use profiler someway?

    Warning: Null value is eliminated by an aggregate or other SET

    operation.

    I don't want to switch off ANSI_WARNING.

     

    Thanks,

    Sree

     

     

     

     

    Thanks,
    SR

  • October 24, 2005 at 11:01 am

    #599600

    Sree-

    Option I:

    Turn on profiler to trace all errors and stored procedures. Check the proc name where the error appears

    Option II:

    Go step by step in the job for each procedure ..in query analyzer until you hit the "set" error. (this is the long way)

    Option III: update all procedures with error code to print out errors and more importantly the procedures name when it fails so you can at least narrow down the sp name.

    Hope this helps.

    Jonas Irwin

    jonas.irwin@netapp.com

  • October 24, 2005 at 11:12 am

    #599603

    Sree-

    Option I:

    Turn on profiler to trace all errors and stored procs.

    Option II:

    Go step by step in the job for each proc ..in query analyzer until you hit the "set" error.

    Option III: update all procs with error code to spit out errors and more importantly the procerdure name when it fails so you can at least narrow the sp name.

    Hope this helps.

    Jonas Irwin

    jonas.irwin@netapp.com

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply