Kbase P66318: Client is getting 1422 error on UTF-8 Database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/12/2010 |
|
Status: Verified
SYMPTOM(s):
Client is getting 1422 error.
SYSTEM ERROR: Index <> in <> for recid <> could not be deleted. (1422)
Unable to reconstruct the database as recommended.
DBA does not want to delete record as information is linked with another database.
FACT(s) (Environment):
Client is using 1252 code-page.
Database is UTF-8.
Progress 9.1x
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
When original database was dumped and loaded the wrong code page was used resulting in data corruption in current database. Clients code-page does not know how to handle the data found in the current database.
FIX:
In order to correct the records the index for the field to be changed must be deactivated.
Deactivate index via data dictionary.
Once that is done the field may be updated with the correct information.
Then rebuild indexes with " proutil dbname -C idxbuild "