PROBLEMS with LookupJoin Component

s.alex.johnson

• July 25, 2019 00:00

• Answered

Follow

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??

• 

  s.alex.johnson

  • July 26, 2019 21:32

  0

  Comment actions Permalink

  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
  )
• 

  Vladimir Barton

  • August 05, 2019 13:25

  0

  Comment actions Permalink

  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,

Please sign in to leave a comment.