I have a problem with my job when I want to make a query with 2 context variables. I attached photos with my job and my components and when I run the job, it's giving me this error:
Exception in component tMysqlInput_1 (facebook_amazon_us)
What I want to do in this job: I have a csv file with multiple columns. The first one is called Reporting_Starts. I want to get the first registration from that column and put it in the query for a select like: SELECT * FROM my_table WHERE MONTH(my_table.Reporting_Starts)='"+context.month+"'. I cannot get why my tJava_4 sees the variables and tMysqlInput don't.
In my tJava_4 I have the following code:
Please let me know if you need any additional information about the job.
I think this because of the link between the components. could you please try removing iterate link from tInputFileDelimited_1 and connect javarow1 to java4 with onComponentOK link.