I continually get the same error on the parsing of a lookup file. I have no idea what it means.
" Pre-Execution of lookup table [TransactionHistoryLookup:LookupTable1]failed.
Error when parsing record #1 field TransactionHistory
Parsing error: Unexpected end of file (1PersNo…"
is the file too big to run a lookupjoin on??
Here’s a different error related to the same thing:
Pre-Execution of lookup table [PeopleActiveLookup:LookupTable2]failed.
Error when parsing record #1 field PeopleActiveID
Parsing error: Unexpected record delimiter, probably record has too few fields. (10024
)
Hi S.Alex.Johnson,
both of those errors indicate a problem with the inconsistency of the lookup source data and the respective metadata used. For instance, the metadata set up in the lookup configuration (Outline pane > Lookups > your lookup > Table definition > Metadata) do not coincide with the content of the source file (Outline pane > Lookups > your lookup > Data source > File URL) so the source file cannot be parsed by using that metadata.
If you are not sure how to correct this, feel free to attach your graph along with the lookup data source (and externalized metadata definition if there is any). Of course, if we are dealing with sensitive data here, kindly try providing dummy information sources which you can manufacture the same errors with.
Regards,