Bug while generating a Surrogate key for Incremental Load.

[Anonymous]

Hi,

I have a job in which i am loading two tables, in those tables i am generating Surrogate id,

The process which I am generating this is, before running the job I am taking the max value of that column into a context and using this context for incrementing by 1 for each row.

Here the bug which I found is that, Suppose I am loading the 1st job after that i am using onsubjobOk to start the second job.

in this case the context value of 1st job itself is taking by 2nd job as well, instead of taking its own context value.

Can anyone help me how to avoid this situation.

Quick help is appreciated.

Regards

ShaX

[Anonymous]

Hi,

    Could you please mark where you are updating the context variable in the attached screenshot? Component screenshots will be helpful to understand your flow better .

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi @nthampi ,

Thanks for the reply, PFA images below.

This is the jobHere am taking the max value of the column n storing it in the context.That context am using to populate the column.

Please help me on this.

Regards

ShaX

[Anonymous]

Hi,

    Since you are using assignment to context, could you please use tjavarow instead of tMap?

     Please also print the context variable before and after to confirm that the value is changing using System.out.println(context.variable_name)

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi @nthampi ,

As told by you, instead of Tmap, i took Tjavarow to assign value to the context.

However this method also didn't work.

PFA screenshot for your reference.

Can you help me on this.

Regards

ShaX

[Anonymous]

Hi,

   Could you please share the component screenshot along with print output?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi @nthampi,

 

This is how I am  loading the tables using contex.

[Anonymous]

Hi,

    That is fine. But where are you verifying the current value of the context variable?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi @nthampi ,

My issue is resolved,

what is did is, if  i am loading 10 tables in 1 job, earlier i used to use "S1" in all table in numeric sequence, but now am using from "S1" to "S10" for tables respectively.

I don't know weather this is the correct approach, but it is working fine as of now.

Regards

Shax.

[Anonymous]

Hi @nthampi ,

Am facing same issue again after 2 days of job run.

Can you help me what can be done.

Here you can see am printing the value.

The problem is coming while loading all tables in bulk.

Is there any other way to assign a context and use where i can avoid this issue.

Currently am assigning  "context.TEST = row1.KEY" and using "Numeric.sequence("s2",context.TEST,1) "

regards

ShaX.