Error with LookupJoin

marcdoesbi

• September 23, 2014 00:00

• Answered

Follow

I'm a newbie with Clover and am currently banging my head against a wall on something that should be simple.

I have a simple graph that is trying to leverage the LookupJoin component with a Database Lookup Table. I get this error:

--------------------------------------------- Error details ----------------------------------------------
Component [LookupJoin:LOOKUP_JOIN] finished with status ERROR. (In0: 1 recs, Out0: 0 recs, Out1: 0 recs)
Error on field 'computerid'
The column index is out of range: 1, number of columns: 0.
----------------------------------------------------------------------------------------------------------

The attached file shows the basic graph...it might help with the troubleshooting.

Many thanks for any help you can provide,

Marc

• CloverETL Error.jpg

• 

  marcdoesbi

  • September 24, 2014 23:35

  0

  Comment actions Permalink

  All - I created a support ticket and they identified the most likely place for the issue was bad syntax related to the "?" in the Lookup Table definition. That pointed me in the right direction and I tracked down the issue and resolved it. I had intentionally left them out because I didn't want to filter the lookup table (I wanted it all in memory). Root cause identified and resolved.
  
  Moving on to the next stage of my CloverETL evaluation...but thumbs up for the support so far.
  
  Thanks,
  
  Marc

Please sign in to leave a comment.