How to identify unprocessed data in File listener?
I have a CSV file with 100 records to be processed by File Listener. only 90 was processed and inserted into my application. How can i identify those 10 unprocessed records?
JPMC
IN
@BimboT50 Could you explain what does unprocessed mean? Are these records read by file listener but while processing them due to some exception were they skipped? If yes, I guess we need to explicitly handle this as part of the processing activity by either inserting into a table with the error message encountered.
Accenture
PH
@BhanuPrakash_G YES. correct. all has special characters thats why file listener didnt processed them. If we explicitply handle this how is it to identify/get those unprocessed data.
I mean, is there a way how to identify and get those unprocessed data? how?
Updated: 19 Jan 2023 2:51 EST
JPMC
IN
@BimboT50 Could you share the file listener configuration without sharing any sensitive information? Could you also highlight as to where it is failing.