Gen Toolset and updating data record after an identifier attribute change

Products

• Gen
• Gen - Workstation Toolset
• Gen - Host Encyclopedia

Issue/Introduction

1. Have defined a new table in Gen 8.6 with a primary identifier.
   
   
2. After uploading the subset to the Host Encyclopedia (HE), it was noticed that one column is missing in identifier.
   
   
3. Created a subset and checked it out in delete mode.
   
   
4. While trying to delete the table in Data Structure List window, it is saying the table is protected.
   
   
5. When I checked Data Model List window, the delete option is disabled for the identifier and also table.

How to modify the table to add the identifier attribute?

Environment

Gen 8.6 Encyclopedia and Workstation Toolset

Resolution

Given the added attribute to the entity in question is an identifier and therefore needs to be added to the table index for the related table, the table needs to be dropped and re-implemented in order to get the new column/attribute within the index.

In order to do this:

1. Need to have a subset that has this data record in question in Delete/Default and in 'Design' phase.
   Also include the entity where the attribute was added within the subset as Delete/Default as well. If this particular entity/table does not have relationships (FK's) to any other entity/tables, there is no need to do anything else.
   
   
2. Ensure other 'checked out' subsets do not already have these objects within them that would potentially downgrade the subset. If other subsets are checked out, run an 'Expansion Conflict Report' which identifies potential conflicts for the subset with other checked out subsets, causing a downgrade. This report is located at...From the Main Menu, select Host Encyclopedia Functions, Subset management, Reports or enter (1.4.11).
   A side note, the entire model can be downloaded out to perform this, but again that would get downgrades if checked out subsets exist.

Once the subset is downloaded:

1. Go to the Data Structure List and delete the entire table (data record), then re-implement the table as mentioned earlier.
   
   
2. If using custom naming conventions the index names may need to be updated.
   
   
3. Take a snap shot of the table before deleting it to ensure it is implemented with the correct naming conventions.
   
   
4. Finally, upload the subset to complete the process.

Additional Information

Gen™ 8.6 > Encyclopedia > Host Encyclopedia > Host Encyclopedia Subsetting