Sliding window partition error: Failed on a job step.

Question

Sliding window partition error: Failed on a job step.

Feivel

SSCertifiable

Points: 7524
More actions
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

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

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

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 1

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.

😎

Feivel SSCertifiable Points: 7524 More actions · Answer 2

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.