Kbase P70627: LOAD of number of lines read do not match records created, 0
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/03/2004 |
|
Status: Unverified
SYMPTOM(s):
x lines read, x-n records created, 0 errors (1522)
LOAD of number of lines read do not match records created, 0 errors in (1522) message
lines read matches the wc -l count of the .d file that is loaded
CAUSE:
It is not safe to assume that each line is one record, especially on a table with records of varying length. Lines cannot be infinitely long as such 1 record can span more than one line. So this difference in the count of lines read to records created could very well be explained by this fact.
FIX:
Perform a pre- and post- FOR EACH record count rather.
for example:
DEF VAR CNT as INT.
FOR EACH table-name no-lock:
CNT = CNT + 1.
END.
DISPLAY CNT.
and this will give you a far better metric on the number of records that were dumped from were loaded into the new database.