Context variable is working fine in 6.4 DI ,but not in 7.1 DI

[SREE3]

Hi

I am implementing the SCD on table ,so I am taking the max value of that column at the start of the job and storing it in the context variable (X),which i declared as int .Now that context variable i am assigning in the numeric sequence  as " Numeric.sequnce('s1',X,1) ".

Though I get above warning in 7.1 DI I am able to load data into the table.The problem arises when I load multiple tables in the same job and use tdie component ,the job will stopped instead of loading the next table.

If i run the same job in talend 6.4 DI ,I am not getting any warning and able to load the data successfully.

Can anyone please help me how to avoid this warning in 7.1 DI.

Thanks & Regards,

Sreelekha.

[Anonymous]

Hi Screelekha

How and when you assign value to the context variable?
I suggest you check if the operation of "assigning the value to the context variable" ended before you start using it

[SREE3]

Hi

I am taking the max value of the column at the start of the job and storing it in the context variable (X),which i declared as int .Now that context variable i am assigning in the numeric sequence as " Numeric.sequnce('s1',X,1) " while loading the same column in table.

The same job is working fine in talend 6.4 DI ,but when comes to 7.1 DI ,it is throwing below warning.

"Null value will be used for context parameter  X: For input string: "context.X"

Thanks & Regards.

Sreelekha

[Anonymous]

Can you add screenshots?

[SREE3]

Hi 

Please find attached screenshots of the same job which is getting warning in talend 7.1 DI and not getting warning in talend 6.4 DI .

CONTEXT_6.4.JPG
CONTEXT_7.1.JPG
context_assigning.JPG
TALEND6.4.JPG
TALEND7.1.JPG

[Anonymous]

did you initialize the context variable in both cases?

you are assigning a value to the context variable in tmap
where are you using the context variable after assigning?

[SREE3]

Hi 

I am taking SOURCE_ID from STG_SOURCE  table and assigning this SOURCE_ID to context variable (context.SOURCE_ID) .

I am using this context.SOURCE_ID to load one column in output table. Data is loading properly ,but  I am getting this warning "Null value will be used for context parameter SOURCE_ID: For input string: "context.SOURCE_ID"

PFA screenshots.

Thanks & Regards,

Sreelekha.

tmap.JPG
1.JPG

[Anonymous]

Are you doing all that in the same job?

A context variable can only can only be used within the same job

[SREE3]

Hi 

Yeah ,I am doing that in same job.

Thanks & Regards,

Sreelekha

[Anonymous]

I'm facing the same problem after moving from Talend 7.0.1 to Talend 7.1.1 with BigDecimal parameters in context definitions.

As far as I've been able to see, the problem comes from the default value in the context itself. Previously, if a BigDecimal parameter had no value attached in its context definition, it translated as a null value (a correct value for BigDecimal). Now, any value put as default for the context parameter is taken as a String value, so no value is translated to empty String (""), which is not a valid BigDecimal value.

As it says in the warning, the job itself changes the empty string for a null value, so it works. However, it prints the "error" in every iteration, so it's really annoying. I'm still trying to see if I can deactivate this alert somehow (if I'm not able to make the context BigDecimal parameter understand the empty value as null instead of "").