Kbase P167614: Running proutil dbname -C convchar convert UTF-8 without indexes falsely reports success
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/10/2010 |
|
Status: Unverified
SYMPTOM(s):
Running proutil dbname -C convchar convert UTF-8 without indexes falsely reports success
Added special characters to the database.
Dumped and loaded the database.
proutil dbname -C convchar convert UTF-8 logs a complete message and a successful message.
Some character are missing and fields that had data that needed translation were not translated.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
OpenEdge Category: I18N
CAUSE:
Binary load without build option does not enforce data integrity because it does not create keys for the records it loads, after the load user is warned with the following message:
YOU SHOULD REBUILD THE FOLLOWING INDEXES IN TABLE tname.
Convchar uses index search to find what record fields need to be converted, you can not eliminate the index rebuild process prior to the conversion
CAUSE:
Bug# OE00198157
FIX:
Since, indexes active or not are required to correctly run proutil dbname -C convchar convert UTF-8, we should not be reporting the conversion process as a successful completion when there are no indexes after a dump and load. Or, we should give a message that it can't be done with out first rebuilding the indexes.
To truly run proutil dbname -C convchar convert UTF-8 successfully after a dump and load, you must use steps similar to those listed below:
1. Create the new database - prostrct create dbname dbname.st -blocksize 8192
2. Copy in the empty8 database - procopy /opvt/v101c/empty8 dbname
3. Load in the database definitions - pro dbname (dictionary/load/df)
4. Load all the dumped files - proutil dbname -C load (dumped files) -i
5. Index rebuild the database - proutil dbname -C idxbuild all -TM 31 -TB 32 -SG 65 -T /cidx
6. Convert the database to UTF-8 - proutil dbname -C convchar convert UTF-8
7. Load the word rules for UTF-8 - proutil dbname -C word rules 254
8. Load the _tran.df file - pro dbname (dictionary/load/df/) /opt/v101c/prolong/utf/_tran.df
9. Index rebuild the database - proutil dbname -C idxbuild all -TM 31 -TB 32 -SG 65 -T /cidx