Post reply

Sliding window partition error: Failed on a job step.

  • July 9, 2016 at 12:30 am

    #309025

    Hi Guys,

    I am stuck in a situation where the sliding window job is throwing me an error as such. I am not really sure on how to deal with this issue, since I am handling partitions for the first time itself...any suggestions or solutions. I googled for this error as well, but I could not find any information on how to resolve it.

    Duplicate range boundary values are not allowed in partition function boundary values list. The boundary value being added is already present at ordinal 4 of the boundary value list.

    Regards,

    Feivel

  • July 9, 2016 at 3:21 am

    #1889284

    ffarouqi (7/9/2016)

    Hi Guys,

    I am stuck in a situation where the sliding window job is throwing me an error as such. I am not really sure on how to deal with this issue, since I am handling partitions for the first time itself...any suggestions or solutions. I googled for this error as well, but I could not find any information on how to resolve it.

    Duplicate range boundary values are not allowed in partition function boundary values list. The boundary value being added is already present at ordinal 4 of the boundary value list.

    Regards,

    Feivel

    Quick thought, look for the part that adds the boundaries and amend it so it does not attempt to add existing values.

    😎

  • July 9, 2016 at 7:07 am

    #1889290

    Eirikur Eiriksson (7/9/2016)

    ffarouqi (7/9/2016)

    Hi Guys,

    I am stuck in a situation where the sliding window job is throwing me an error as such. I am not really sure on how to deal with this issue, since I am handling partitions for the first time itself...any suggestions or solutions. I googled for this error as well, but I could not find any information on how to resolve it.

    Duplicate range boundary values are not allowed in partition function boundary values list. The boundary value being added is already present at ordinal 4 of the boundary value list.

    Regards,

    Feivel

    Quick thought, look for the part that adds the boundaries and amend it so it does not attempt to add existing values.

    😎

    Can you explain a bit more exactly what do you mean by adding the boundaries, and amending it so it does not attempt to add existing values.

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

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