Lookup duplicateLookupKeyBehavior Log location

Follow

Don Graham

• December 06, 2019 19:28

On the lookup node there is an Exception Behavior option duplicateLookupKeyBehavior and one of the 3 values in the dropdown is Log

Log - A warning is logged for the first duplicate value encountered. Records from the main input will only ever match the first of the duplicates in the lookup input.

Where is it logged? What information is logged? 

0

• 

  Adrian Williams

  • December 09, 2019 18:14

  The base information for the warning message is contained in the node log file for the Lookup node. The node log files are stored in a sub-directory of the Analyze instance's site directory at:

  site/data/executions/<username>/<dataflow name>/<run uid>

  The folder will contain the intermediate data for the nodes in the data flow execution and the corresponding log file for each node.

  The log file only identifies the first occurrence where a duplicate key use was detected.  

  The error message indicates (for the first occurrence only) the record number on the 'lookup' input that contains the first instance of the the duplicate key and the corresponding record number on the 'lookup' input containing the duplicate key.

  The log also details the metadata for the 'data'  and 'lookup input pins, and the output metadata.

  Note. if there are multiple key values that have duplicates on the lookup pin these other duplicate occurrences are not logged.

  0

  Comment actions Permalink

Please sign in to leave a comment.