tContextLoad compilation error "key cannot be resolved or is not a field"

Highlighted
Four Stars

tContextLoad compilation error "key cannot be resolved or is not a field"

Hi Guys!

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.

 


Accepted Solutions
Forteen Stars

Re: tContextLoad compilation error "key cannot be resolved or is not a field"

hi

 

from the end:

you job work with disabled tContextLoad subjob because You already define context variables inside Talend

 

so, you need to check - what wrong in first 2 components 

-----------

All Replies
Forteen Stars

Re: tContextLoad compilation error "key cannot be resolved or is not a field"

hi

 

from the end:

you job work with disabled tContextLoad subjob because You already define context variables inside Talend

 

so, you need to check - what wrong in first 2 components 

-----------
Four Stars

Re: tContextLoad compilation error "key cannot be resolved or is not a field"

Hi Vapukov,

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!  

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch