Post reply

[SQLSTATE 01003] (Message 8153)

  • May 6, 2010 at 8:02 am

    #146922

    Trying to figure out this error any help is appreciated.......

    -------------------------------

    Date5/3/2010 10:57:40 AM

    LogJob History (List_proc_temp)

    Step ID1

    ServerIBMCORE-DOC1

    Job NameList_proc_temp

    Step NameTRADE_FILE

    Duration00:3:21

    Sql Severity0

    Sql Message ID0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted0

    Message

    Executed as user: DCONTASA. Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Final Extract [SQLSTATE 01000] (Message 0). The step succeeded.

  • May 6, 2010 at 8:36 am

    #1163267

    What are you trying to do ?

    Did you search on "Null value is eliminated by an aggregate or other SET operation"

    I found lots of hits, but not sure which one applies to your situation.

  • May 6, 2010 at 8:40 am

    #1163272

    I do not have any idea. its the stored procedure that causes this.

  • May 6, 2010 at 10:29 am

    #1163430

    Then I would think the next thing to do is look at the SP code, and the data coming in.

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

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