Kbase P132072: Error 12112 or 2699 when deleting records from a table with a word index
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/26/2009 |
|
Status: Verified
SYMPTOM(s):
Error 12112 or 2699 when deleting records with a word index
Adding or updating a record in a GUI client and then attempting to delete it in a character client results in errors.
SYSTEM ERROR: proixdel failed for word indexing of array (2699)
In Progress 9.1x this results in error 2699, followed by a session crash.
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)
In OpenEdge 10.1x this results in error 12112, but the session does not crash.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
The code page of the database has been changed, but the corresponding word break table has not been applied to the database. So the database is still using its old word break definitions.
FIX:
After changing the code page of a database it is important that the collation .df file and the word break table for that particular code page is loaded. This includes converting databases from the undefined code page.
Failure to do this will give unpredictable results.