Kbase P101081: Loading a .d file gives error 76
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/6/2005 |
|
Status: Unverified
SYMPTOM(s):
Loading a .d file errors
Error in table_name.e
Invalid character in numeric input ?. (76)
CAUSE:
A decimal field has invalid data such as a ^ character.
FIX:
1. Change the "Acceptable Error Percentage" to 100 when loading the .d file
2. Check the resulting table_name.e file (in the WRK directory) for the lines with errors.
3. Open the .d file in the Procedure Editor (select show all files *.*) and select Search>>Go to Line
4. Type in the first line that errored from the table_name.e file
5. Determine if there are any invalid characters in the line.
6. Each quoted section of data is a field from the .df file in order. Look at the .df file for the field name and check its data format. If the character is not allowed for the data format, remove it and reload the .d. Do this for every line that errored and the load will complete without errors.
For example:
Table_name.e has the error
>> ERROR READING LINE #1346 (Offset=321954): ** Invalid character in numeric input ?. (76)
Lookup Line 1346 in the .d using the Procedure Editor. It shows
"0000868149 " "15541-55.500 " .4000^ "LB"
Since the problem is in the third field, check the .df file and look at the data type for the third field. In this case let's say it is decimal. Since the ^ is not allowed in the decimal Data Format (see Progress Documentation, Data Formats), remove the ^ and reload the .d.