Kbase P118566: Running entity import creates multiple datafields having name ending with number in parentheses (n)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/09/2006 |
|
Status: Unverified
FACT(s) (Environment):
Dynamics
SYMPTOM(s):
Running entity import creates multiple datafields having name ending with number in parentheses (n)
After each consecutive retry to run entity import on the table one of it's data fields gets imported in multiple instances, with names followed by a (n) where "n" is the number of times entity import procedure has been run
After first run of entity import a datafield is added named e.g. customer_obj(1), after second run - customer_obj(2) and so on
CAUSE:
Dynamics repository contains orphan entity records in repository table ryc_object_instance
FIX:
Start the Dynamics development session and open the Procedure Editor.
Execute the following query in the procedure editor:
For each ryc_smartobject where object_filename = '<table>' no-lock:
For each ryc_object_instance where
ryc_object_instance.container_smartobject_obj = ryc_smartobject.smartobject_obj no-lock:
display
ryc_object_instance.instance_name
ryc_object_instance.smartobject_obj.
End.
End.
There will be more than one ryc_object_instance record having the same
instance_name, but with different smartobject_obj values. Either manually
delete the offending ryc_object_instance record using 4GL, or delete the
entity record in the Repository Maintenance Tool.