[SOLVED] Alert Message: Uniface patches R121 and E102: Changing Trigger code of Model Field will create Entity with no name
Author: daniel.iseli@uniface.com (diseli)
From Frontline:
Alert message:
Uniface patches R121 and E102: Changing Trigger code of Model Field will create Entity with no name
Uniface patches R121 and E102 contain a problem that may cause corruption of Model definitions and should not be used for editing the model. For this reason the patches are no longer available for download.
More details can be found in the article bellow.
Frontline article:
Uniface patches R121 and E102: Changing Trigger code of Model Field will create Entity with no name
When the Trigger code of a modeled field is changed then this will create an Entity with no name in the current Model.
Consider the following scenario:
- Open an existing model : MOD1
- Open an entity ENT1 from MOD1
- Open the field FLD1 from ENT1
- Update a trigger from field FLD1 and save the changes.
- The user returns again to the Define Entity screen
The user will now see an entity without a name.
Warning: Do not try to delete the invalid entity record from within the Development Environment (UDE) using either the Define Entity or Global Updates screen (menu item Go To > Administration > Global Actions). In the worst case all fields and entities belonging to the model with the invalid entity record will be deleted (for example when the repository is stored in a Microsoft SQL Server or Solid database).
Workaround:
Caution: The following information involves manipulating the Uniface Repository outside the Development Environment (UDE). Carrying out operations other than those described here may cause data corruption, possibly rendering your Uniface Repository unusable. Please use extreme caution any time you manipulate the Uniface Repository outside the UDE. Make sure you create a backup of the Repository data before carrying out the described operations .
Delete the invalid entity record(s) from the SQL Workbench (or a SQL Editor of your choice), by deleting the rows in UCTABLE where the field U_TLAB is empty. For example:
- delete from uctable where u_tlab=''