Talend community forum / ETL : Problem migrating TOS 2.1.2 to 2.2.1

Slum · 2007-11-02 15:44:46

Hi team,

I've encounted problems while migrating my Talend Open Studio project.
On few jobs, I've got the following message :

Code:

Exception IN component tMysqlRow_1
java.lang.NullPointerException
    at pmi_stat.job5b.Job5b.tMysqlInput_48Process(Job5b.java:21222)
    at pmi_stat.job5b.Job5b.tMysqlInput_1Process(Job5b.java:20355)
    at pmi_stat.job5b.Job5b.tMysqlInput_45Process(Job5b.java:2308)
    at pmi_stat.job5b.Job5b.tMysqlInput_49Process(Job5b.java:1267)
    at pmi_stat.job5b.Job5b.tFileList_1Process(Job5b.java:1060)
    at pmi_stat.job5b.Job5b.tJava_1Process(Job5b.java:21666)
    at pmi_stat.job5b.Job5b.runJob(Job5b.java:40122)
    at pmi_stat.job5b.Job5b.main(Job5b.java:40067)

Here's tMySqlrow_1 request :

Code:

"UPDATE INSTANCE SET QTE_DELAI_ENCOURS="+calcul_age_post2.DELAI_QUALITE+" WHERE ID_INSTANCE="+calcul_age_post2.ID_INSTANCE

Tried everything (check nullable checkbox, replace in and out metadata, ...) but nothing works... Worked fine on 2.1.2

Do you have an issue ?

Thanx a lot for your help...

Note :
Pic of job's part. If i delete everything after tMySQLOutput_1, job fully works

Last edited by Slum (2007-11-02 15:48:22)

shong · 2007-11-05 06:33:18

Hi

Can you show a screenshot of tJavaRow properties panel. I wonder what you have done in tJavaRow.

Best regards

shong

Slum · 2007-11-05 08:59:50

Thank you for helping me.

Here's a pic of tJavaRow_3 properties :

Code:

calcul_age_post2.ID_INSTANCE=calcul_age_pre2.ID_INSTANCE;
calcul_age_post2.DELAI_QUALITE=delaiQualite.calculer(calcul_age_pre2.DT_FIN_PHASE_9,calcul_age_pre2.DT_DEBUT_PHASE_1);

Last edited by Slum (2007-11-05 09:04:58)

nrousseau · 2007-11-05 09:52:13

Hi.

I think we found the problem. I created this bug : [Bugtracker, bug 2410, fixed] [tMysqlRow] Null Pointer can appear if the code in the main part is not executed.

This error appear only if one part of the code is not executed.
I think that your tMysqlOutput_1 don't call the tMysqlInput_48...(there should be an error) so the code of the tMysqlRow component is never called...

I think if you use a clause like "Insert or Update" or such, maybe you should just use a ThenRun instead of "OnOk". (as if there is duplicate data, then it will generate some errors).

Slum · 2007-11-05 10:44:55

Hi, thank you for taking knowledge of my bug.
Can't use ThenRun instead of OnOK.
I can use only "Main" or "Rejects".

I'm just going to wait next Talend vers. ^^'

shong · 2007-11-06 03:34:45

Hi Slum

you can create your job like this, using ThenRun instead of OnOK.

Please see the screenshot.

Best regards

shong

Uploaded Images

Slum · 2007-11-23 09:17:01

Hi !

I tried to make my jobs working on 2.2.2
Seems to be great, but I encount another problem :

Code:

tarting job Job5a at 09:06 23/11/2007.
[statistics] connecting to socket on port 3602
[statistics] connected
Job5a - STATS - Rapatriement des demandeurs
[statistics] disconnected
Exception in thread "main" java.lang.Error: Unresolved compilation problem: 
    OnOk cannot be resolved

    at pmi_stat.job5a.Job5a.tMysqlRow_4Process(Job5a.java:10538)
    at pmi_stat.job5a.Job5a.tMysqlInput_15Process(Job5a.java:10336)
    at pmi_stat.job5a.Job5a.tMysqlInput_16Process(Job5a.java:8308)
    at pmi_stat.job5a.Job5a.tDenormalize_1_DenormalizeInProcess(Job5a.java:18878)
    at pmi_stat.job5a.Job5a.tMysqlInput_1Process(Job5a.java:1989)
    at pmi_stat.job5a.Job5a.tMysqlInput_17Process(Job5a.java:910)
    at pmi_stat.job5a.Job5a.tFileList_1Process(Job5a.java:692)
    at pmi_stat.job5a.Job5a.tJava_1Process(Job5a.java:11085)
    at pmi_stat.job5a.Job5a.runJob(Job5a.java:18972)
    at pmi_stat.job5a.Job5a.main(Job5a.java:18903)
Job Job5a ended at 09:06 23/11/2007. [exit code=1]

Here's the part of job :

I tried to use ThenRun instead of OnOk but I can't select this link :

Any help would be greatful

Thank you.

shong · 2007-11-23 10:03:05

Hi

"ThenRun" is a link between two subjobs and a ThenRun link is not followed if the origin subjob fails. a subjob is a sequence of components linked by iterate/row/merge links, in the generated code, a subjob produces a function.
So, you can use this link from the first component of one subjob.

Best regards

shong

Announcement

Unanswered posts

#1 2007-11-02 15:44:46

ETL : Problem migrating TOS 2.1.2 to 2.2.1

Code:

Code:

#2 2007-11-05 06:33:18

Re: ETL : Problem migrating TOS 2.1.2 to 2.2.1

#3 2007-11-05 08:59:50

Re: ETL : Problem migrating TOS 2.1.2 to 2.2.1

Code:

#4 2007-11-05 09:52:13

Re: ETL : Problem migrating TOS 2.1.2 to 2.2.1

#5 2007-11-05 10:44:55

Re: ETL : Problem migrating TOS 2.1.2 to 2.2.1

#6 2007-11-06 03:34:45

Re: ETL : Problem migrating TOS 2.1.2 to 2.2.1

#7 2007-11-23 09:17:01

Re: ETL : Problem migrating TOS 2.1.2 to 2.2.1

Code:

#8 2007-11-23 10:03:05

Re: ETL : Problem migrating TOS 2.1.2 to 2.2.1

Board footer