Product TOSDI 7.1
I'm new in talend, and I'm trying to do the simple job tFileinputDelimited - tContextLoad - tDBInput - tLogRow.
I made my job according to the instruction https://help.talend.com/reader/msUNbYBQpYIfwxIKmvgeiw/xyC4fZXUfWwqQKC21ZLnqA
But when I try to run it I get the error on tContextLoad component
Error message: key cannot be resolved or is not a field
Error Line: 732
Detail Message: key cannot be resolved or is not a field
I designated all the needed context variable
The main difference from example from the documentation is that I use tDBInput (ORACLE) instead of tMysqlInput,
and I have variables in WHERE sql statement:
WHERE TNTREF.LOAD_STATUS.PROCESSING_MONTH = '"+context.LOADMONTH_PARM+"'
AND TNTREF.LOAD_STATUS.PROCESSING_DAY = '"+context.DAY_PARM+"'"
If I disable job with tContextLoad everything works fine ...
Also please find screenshots attached.
Solved! Go to Solution.
Thanks a lot for your interest in my issue!
I have figured out. I just forgot to make a copy from output schema (tContextLoad) to input schema (tFileInputDelim). I have attached a screenshot in case it might help someone else.
One more thanks!
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.