Kbase P17987: Getting message 10853 when running binary load from a Progress 9 database into OpenEdge 10
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/10/2008 |
|
Status: Verified
SYMPTOM(s):
Getting message 10853 when running binary load from a Progress 9 database into OpenEdge 10
If you are certain the .bd file originated from a database with code page <name> then enter Y to continue. (10853)
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.0A
CAUSE:
Bug# OE00070700
FIX:
Prior to Open Edge 10.0B the proutil dump facility did not record the code page in the resulting dump file. If this file is then loaded into a database with a different code page, since no conversion is performed with the binary dump and load, the data is loaded as-is and leads to data corruption. Moreover, Binary dump and load allows to dump and load data between codepages presented in convmap.cp. But since there is no conversion performed with the binary dump and load, this leads to data corruption.
As of OpenEdge 10.0B, a new feature was introduced to prevent this occurring. The codepage used during the creation of the binary dump file is recorded in the resulting .bd file. As such, when trying to load a binary dumped file into an OpenEdge 10.0B (and above) database, which has a different codepage, this will now fail with errors 10855 and 6255.
example:
Code page of .bd file (iso8859-2) does not match code page of database(ibm852). (10855)
Binary Load failed. (6255)
If a binary dump file created with any version prior to OpenEdge 10.0B is loaded into an OpenEdge 10.0B (or above) database, the binary load process will first provide the following warning because the codepage in the binary dump file remains undefined in previous versions:
If you are certain the .bd file originated from a database with code page then enter Y to continue. (10853)
continuing the above example:
Warning: input .bd file contains no code page information.
If you are certain the .bd file originated from a database with code page ibm852 then enter Y to continue. (10853)
To automate the binary load, assuming absolute certainty that this is the case, a response "y" should be created as a input for each table loaded.
For example:
echo Y | proutil db-name -C load bd-file