Kbase P72217: Error 1422 when updating a record with a Unique index
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
SYMPTOM(s):
Error when trying to update a record
Unique Index was recently added to the database table.
Index <indexname> in <tablename> for recid <recid> could not be deleted. (1422)
CAUSE:
Unique field in the database table has non-unique values.
FIX:
The records where the unique field has duplicate values will need to be modified so that all the entries in the field are unique.
1) Deactivate the unique index.
2) Update the records that have the non-unique values in the field that is suppose to be unique and is being referenced by the index.
3) Reactivate the index by running idxbuild or idxfix (option 3).