Kbase P85147: Problem loading data using 1256 codepage - error 132
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/18/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
OpenEdge 10.0x
SYMPTOM(s):
Problem loading data using 1256 codepage
Unable to load data in a non-English environment
Unable to load data in Arabic environment
Unable to load data in Finnish environment
** <file-name> already exists with <field/value...>. (132)
Using -cpinternal 1256 and -cpstream 1256
CAUSE:
Using a wrong collation within the database. As a result of that, the special and normal characters (c and c with caron for example) are considered to be a same and they are violation primary key in this particular case.
FIX:
In order to fix the problem:
1) delete the content of a table you are trying to load (or create a db from scratch)
2) go to data administration and apply 1256.df or arb91256.df (first is for basic collation, second is for arabic collation) from $DLC/prolang/arb
3) rebuild the indexes of the database using "proutil db -C idxbuild all -cpstream 1256 -cpinternal 1256)
4) load the data again