Kbase P7775: Repository Maintenance Tool fails with AF:103
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/03/2003 |
|
Status: Unverified
FACT(s) (Environment):
Dynamics 1.1A
SYMPTOM(s):
Dynamics: adding SmartDataField to SmartDataViewer using the Repository Maintenance Tool fails with AF:103.
Cannot update ryc_attribute_value because ryc_attribute does not exist!(AF:103)
*** Error: AF-103 Program: error-message icf/trg/rycavtrigw.p
Entries in ryc_attribute_value that do not have parent entries in ryc_attribute.
CHANGE:
Applied Dynamics service pack 3.
CAUSE:
Some attribute values had an incorrect site number. The replication triggers were failing due to the missing attributes/objects, causing fixattribvalues.p to fail, but without displaying any errors.
FIX:
Write a procedure to delete the rogue attribute value records, then run fixattribvalues.p.
The following code identifies the rogue attribute values:
FOR EACH ryc_attribute_value
NO-LOCK:
IF NOT can-find(ryc_attribute
WHERE ryc_attribute_value.attribute_group_obj = ryc_attribute.attribute_group_obj
AND ryc_attribute_value.attribute_label = ryc_attribute.attribute_label
AND ryc_attribute_value.attribute_type_tla = ryc_attribute.attribute_type_tla)
THEN
DISPLAY ryc_attribute_value.attribute_label ryc_attribute_value.attribute_type_tla.
END.