[resolved] tHash_Lookup_row1 cannot be resolved - ????

Highlighted
One Star

[resolved] tHash_Lookup_row1 cannot be resolved - ????

I am trying to run a simple job that takes data from one access table and puts it into 1 mysql table.
there are a few FKs in the output table, but the values should already be in the tables. (i think they are as the tables are populated with all the records already)
So what does this error mean and how can i get rid of it?
On running the job, i get this:
tHash_Lookup_row1 cannot be resolved
row1HashKey cannot be resolved
tHash_Lookup_row1 cannot be resolved
tHash_Lookup_row1 cannot be resolved
row1HashKey cannot be resolved
tHash_Lookup_row1 cannot be resolved

Accepted Solutions
Highlighted
Seven Stars

Re: [resolved] tHash_Lookup_row1 cannot be resolved - ????

If you're using tHashInput directly connected to tMap as a lookup flow it won't work. It's a bug that can be circumvented by dropping a tFilterRow or tJavaRow in between the tHashInput and tMap.

View solution in original post


All Replies
Highlighted
Community Manager

Re: [resolved] tHash_Lookup_row1 cannot be resolved - ????

Hello
Open the 'code' tab and see if there are some compilation error in the generated code. If so, you have a job design error, check and correct it.
If you are not sure what's wrong, export your job and send it to me via email.
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Highlighted
Seven Stars

Re: [resolved] tHash_Lookup_row1 cannot be resolved - ????

If you're using tHashInput directly connected to tMap as a lookup flow it won't work. It's a bug that can be circumvented by dropping a tFilterRow or tJavaRow in between the tHashInput and tMap.

View solution in original post

Highlighted
One Star

Re: [resolved] tHash_Lookup_row1 cannot be resolved - ????

If you're using tHashInput directly connected to tMap as a lookup flow it won't work. It's a bug that can be circumvented by dropping a tFilterRow or tJavaRow in between the tHashInput and tMap.

Thank you very very much for the solution. I added a tFilterRow and it worked like a charm.
Highlighted
One Star

Re: [resolved] tHash_Lookup_row1 cannot be resolved - ????

By the way, in my case, it was tJDBCInput and tDB2Input that were directly connected to a tMap and caused the error. But the solution worked for this case, too.
Highlighted
One Star

Re: [resolved] tHash_Lookup_row1 cannot be resolved - ????

I was getting this error after switching around some DB connections, so I simply deleted and recreated the MySQLInput based on the new DB, and it resolved the errors.
Highlighted
One Star

Re: [resolved] tHash_Lookup_row1 cannot be resolved - ????

For all connections via the TMAP, check that the links are not all "lookup" and that the "main" link not missing.
(WRONG)
A --(lookup) -- TMAP1
B --(lookup) -- TMAP1
(GOOD)
A --(Main) -- TMAP1
B --(lookup) -- TMAP1

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog