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.
Find out about Talend's 2019 Summer release
Talend continues to revolutionize how businesses leverage speed and manage scale
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend