Warning
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.
Issue
SigmaX - checking for duplicated segment and object names prior to EBO transition
Product Line
Satchwell Sigma
Environment
SigmaX
Cause
Checking for duplicated segment and object names prior to transitioning Sigma to EBO.
Resolution
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 is the second of three videos, the first SigmaX Quick Help Video will check for database errors primarily 'A' errors and the third video will check for Programmable Objects with different types of RETURN statements.
When launching the SigmaX application, see the Knowledge Base articles for Side by Side errors and errors regarding missing SigmaX files should they occur.