Kbase P137702: ASCII load loads less records than expected
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/02/2009 |
|
Status: Verified
SYMPTOM(s):
Load via Data Administration tool loads less records than expected
loading a .d file on a windows platform fails to load more than one record
1 record loaded, total errors : 0 expected records : 63
no errors on the screen, no errors in the database log file
if the first line in the .d is removed and load again only the first record loads
data is ascii dumped without error and contains all expected records
FACT(s) (Environment):
The correct amount of records are loaded if the load takes place on a non Windows OS (for example AIX)
OpenEdge 10.x
Windows
OpenEdge Category: Database
CAUSE:
The resulting .d file contains a special character which is interpreted as either an "end of file" or STOP condition by the Data Administration tool. In this specific case it was a control character HEX 1A which translates to "Substitue" in iso-8895-1 present in every line.
FIX:
Open the .d file in a HEX editor and remove all occurance of the errant character manually, then load the .d again.
Note, although all the records load without error in the UNIX example, the content is never-the-less not seen as it is inteneded ie: missing letters/words.
To prevent this from re-curring, the method that the data was originally imported to the database needs to be reviewed.