Question:
Hi All,
during the flatfile load I didn't get any Error Messages
if there are Errors, e.g. length of characteristics defined 3 digits in BW
and the coresponding flatfile entry is 5 digits. It seems that
this record was ignored and the following records could imported
successfully.
Does anyone know how to catch that Errors.
best regards
Answer:
For whatever reason, (*IF* memory serves me correctly) BW does not consider truncating data an error. If you have an issue of a field being defined too short, you need to check your data to make sure fields are defined at the correct length.
When we were loading our legacy data, we encountered this issue and simply adjusted our objects in BW to match our data (or fixed our data before sending it to BW.
If you need to check this, you may want to use the formula builder to build a check for legth and return an error if it is longer then the field it is mapped to.