AnsweredAssumed Answered

Setting non-unique variable to unique

Question asked by Adam Sheppard on Apr 11, 2019
Latest reply on Apr 12, 2019 by Gorkem Bicen

We are a few months into adopting PDM and need to change a variable from non-unique to unique. The variable is Number and it is the primary identifier of the file in our system. We need to change it to a unique variable but are currently unable to do so due to existing files that have duplicate values for Number.

 

Our first step was to renumber all duplicates in the system, which we completed. Having done so, we tried to turn on the "unique values" setting and were met with the following error.

Capture2.PNGCapture.PNG

These files DO NOT HAVE duplicate values on the Number variable. They previously did, but we changed this in our initial sweep.

 

Is this an issue with previous versions that are still in the system? If so, how can we resolve this?

Outcomes