Kbase P57204: Error 4686 with international collations need the new *.wbt word break tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/26/2010 |
|
Status: Verified
SYMPTOM(s):
Error 4686 with international collations need the new *.wbt word break tables
Error 4684 when using CONTAINS with international collations.
QBW syntax error - an asterisk (*) is allowed only at the end of a word. (4686)
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
Many non basic collations can fail with the 4686 error because the database does not have the correct word break table applied for the collation used. With version 9 there are several new word break tables named *.wbt in the DLC/prolang/convmap directory. Depending on the database codepage used, one of these should be applied.
FIX:
Follow these steps to fix the problem:
1) Ensure there is a valid backup of the database, just in case it is necessary to go back to. Then find out the database code page (Data-Administration ->Utilities->Information).
2) Select the appropriate *.wbt file from DLC/prolang/convmap depending on
codepage.
database code page file to load
------------------ ------------
1252 %DLC%\PROLANG\m1252bas.wbt
iso8859-1 %DLC%\PROLANG\iso01bas.wbt
3) Compile the new version of word break table file to a number <N>:
proutil -C wbreak-compiler <file-name> <N>
where <N> is number between 1 and 255, and filename is the file selected in 2 above.
4) Place the newly-created file proword.<N> in %DLC% or define environment variable PROWD<N>=<file-directory>\proword.<N> (In Version 9.0A, you must set PROWD<N>.)
5) Apply the new word-rules to the database:
proutil <database> -C word-rules <N>
6) Rebuild the word indexes:
proutil <database> -C idxbuild <ALL or word indexes>