Kbase P124416: Error 12112 when attempting to delete records with iso8859-1 client
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/03/2009 |
|
Status: Verified
SYMPTOM(s):
Error 12112 when attempting to delete records
Unable to delete old values for the index of a word-indexed field (index <index-name> of table <table-name>). The index may be damaged. (12112)
Word index field causes error 12112.
The database uses the iso8859-1 code page.
Windows GUI client uses iso8859-1 for cpinternal and cpstream.
Index rebuild works without reporting any errors, but the 12112 error remains when trying to delete the record.
FACT(s) (Environment):
Windows
OpenEdge 10.x
CAUSE:
The records being deleted contain characters that the iso8859-1 code page does not support (for example the Euro ?). Subsequently when the index is rebuilt these characters are corrupting the index.
This is ultimately due to a change made in OpenEdge 10 in order to support the UTF-8 client. For more information see solution P77617.
FIX:
Use the Microsoft 1252 code page on the client instead of iso8859-1. So change the -cpinternal and -cpstream startup.pf entries to use 1252 instead of iso8859-1.