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!
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.