Potential for Data Loss: The steps detailed in the resolution of this article may result in a loss of critical data if not performed properly. Before beginning these steps, make sure all important data is backed up in the event of data loss. If you are unsure or unfamiliar with any complex steps detailed in this article, please contact Product Support for assistance.
SigmaX - checking for duplicated segment and object names prior to EBO transition
Checking for duplicated segment and object names prior to transitioning Sigma to EBO.
With EBO, names cannot be duplicated within the same folder or segment, however in Sigma they could be, it was only the mnemonic that had to be different.
When Data Importing into EBO, duplicated names are revised by adding a postfix to the duplicated name e.g. if there are two ‘room temperature’ then the 2nd one is revised to ‘room temperature2’ so that the Data Import can continue to proceed.
In SigmaX, a report can be generated that will itemize any duplicated index or object names. Within SigmaX, these duplications can be renamed to a name of your choosing. Once, this is done, the Data Import will use the new names.
This video with SigmaX the 2nd one of three videos, the 1st SigmaX Quick Help Video will check for database errors primarily 'A' errors.