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!  

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download