Handle key change failure

If the Upgrade Utility fails to apply certain key changes, error information is logged into the except.log file. Review the log file and make appropriate operations.

Error message 1: Failed to add <key_type> key: <field_name> to table <table_name>. You must add it manually.

Follow these steps to handle this error:

1. Type dbdict in the Service Manager command line, and press Enter.
2. In the File Name field, type the table name indicated by the error message, and click Search.
3. Click the Keys tab.
4. Position the mouse point in the key name part of an empty key structure, and click New Field/Key.
5. Select the appropriate key type from the combo list, and add the appropriate field to the key, as indicated by the error message.
6. Click Add, and click Yes to confirm.
7. Click the Keys tab, and click OK to save the change.
8. Continue to follow steps 1 through step 7 for each key that failed to be added.

Error message 2: Failed to update <key_type> key: <old_field_name> to <new_field_name> in table <table_name>. You must update it manually.

Follow these steps to handle this error:

1. Type dbdict in the Service Manager command line, and press Enter.
2. In the File Name field, type the table name indicated by the error message, and click Search.
3. Click the Keys tab.
4. From the key list, select the key name that is indicated by the error message, and click Edit Field/Key.
5. Update the fields in the key according to the field names indicated by the error message.
6. Click OK, and click Yes to confirm.
7. Click the Keys tab, and click OK to save the change.
8. Continue to follow steps 1 through step 7 for each key that failed to be updated.

Error message 3: Failed to remove <key_type> key: <field_name> from table <table_name>. You must remove it manually.

Follow these steps to handle this error:

1. Type dbdict in the Service Manager command line, and press Enter.
2. In the File Name field, type the table name indicated by the error message, and click Search.
3. Click the Keys tab.
4. From the key list, select the key name that is indicated by the error message, and click Edit Field/Key.
5. Click Delete, and click Yes to confirm.
6. Click the Keys tab, and click OK to save the change.
7. Continue to follow steps 1 through step 6 for each key that failed to be removed.

In addition, you may encounter the following Unique Key errors:

Error: dbdict:Approval, Unique Key is {"unique.key", "file.name", "name"} -- expected to be:{"unique.key", "file.name", "name", "component"}

Error: dbdict:ApprovalLog, Unique Key is {"counter", "file.name", "unique.key"} -- expected to be:{"counter", "file.name", "unique.key", "component"}