Kbase P3034: Error 1422 when trying to update a given record in Progress 9.1C
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/12/2004 |
|
Solution ID: P3034
FACT(s) (Environment):
Progress 9.1C
SYMPTOM(s):
Converted Progress Version 8 Database to Version 9
Error 1422 when trying to update a given record
SYSTEM ERROR: Index in for recid could not be deleted. (1422)
Cannot execute user defined function '<function name>' in an ASSIGN statement after a key field change. (7954)
Proutil Index Rebuild applied to index
Error 1422 reappears after Proutil Index Rebuild always on the same field of the same table.
CAUSE:
Trying to update an index that contains non-ASCII characters generates the 1422 error.
FIX:
To resolve this problem do the following:
1) Install the latest available patch for Progress 9.1C.
2) Rebuild the index that generated the error.