Talend community forum / error when ruunig job

romyos · 2010-02-15 17:00:32

hello
I try to import data in TMDM usin TOS:
taccessInput------->TwriteXMLField--------->tMDMIput , but i have this message when running job:

Unable to get the key values in rootTag:Java .lang.nullPointException.

Can Someone please halp me?

Last edited by romyos (2010-02-16 08:17:59)

romyos · 2010-02-22 15:11:33

Hello
is there any idea please!

romyos · 2010-03-01 08:29:59

Hello,
Can Some one help me !!!

shong · 2010-03-01 08:42:22

Hello

taccessInput------->TwriteXMLField--------->tMDMIput ,

tMDMInput or tMDMOutput? Please check it and upload a screeshot of xml tree.

Best regards

shong

romyos · 2010-03-01 10:17:37

hello Shong

i use TMDMOutput component.
and this is my xml tree

Arbre Xml Colone Associée Status du noeud Valeur par default
-rootTag
nom nom
prenom prenom
id id Element de boucle

And this is the error mesage ="Unable to get the key value for the item rootTag:Java .lang.nullPointerException:Null".

Sorry i can't find how to upload my screens

shong · 2010-03-01 11:14:13

Hello
The root node is the entity name, is there a entity called rootTag? I think you have read the topic about how to use tMDMInput and tMDMOutput.
http://www.talendforge.org/forum/viewtopic.php?id=2223

Best regards

shong

romyos · 2010-03-01 16:46:56

problem resolved
Thank you

Franto · 2010-03-25 15:57:08

Hi romyos,

Could you please tell me how you fixed it?

I have got the same problem and I cannot fix it.

Thanks in advance!

Franto

magn · 2010-03-30 13:30:04

Hello,
I tried to use tmdmoutput component in order to import data in Talend Mdm.
I ve got this error :
Unable to get the key value for the item decharge

Iused :
Table decharge( Tmysqlinput) ----> tWritexmlField ----> tmdmoutput

my xml tree : decharge :
id
valeur

Could you please help me !!
Thanks in advance

Magn

tweber · 2010-03-30 14:14:23

Hi,

Could you please upload screen captures of the tMDMOutput component configuration, both for the "Basic" and "Advanced" settings ?

Which version of TOS are you using ?

Thanks.

magn · 2010-03-30 14:22:57

Sorry , but i don t know how to upload screen shots , i tried using [img][/img] but i ve got no result. is there an other way to do it ?
Thks

tweber · 2010-03-30 14:29:07

When you post a reply, use the "Image Upload" feature :

Uploaded Images

magn · 2010-03-30 15:23:49

Thanks

fonsw · 2010-03-30 15:25:12

I populated a sample data model "decharge" without the use of a "tWriteXMLField" transformation.

Decharge data model mapping example:

tRowGenerator_1 ----> tMDMOutput_1

tRowGenerator_1 (RowGenerator Editor):
Column Key Type
id X String
valeur String

tMDMOutput_1 (Edit Schema):
tRowGenerator_1 (Input - Main) tMDMOutput_1 (Output)
Column Key Type Column Key Type
id X String id X String
valeur String valeur String

Configure Xml Tree:
Linker Source Linker Target
Schema List XML Tree Related Column Node Status
id decharge
valeur id id loop element
valeur valeur

Make sure to rename the "rootTag" to the name of your data model. In this example I renamed the "rootTag" to "decharge".

magn · 2010-03-30 15:26:13

i try an other time!!

Uploaded Images

magn · 2010-03-30 15:59:18

Hello fonsw,
i tried your proposition, but i ve got the same error!

magn · 2010-03-30 16:00:21

error screen

magn · 2010-03-30 16:02:03

oops!

Uploaded Images

fonsw · 2010-03-30 16:41:22

Hello magn,

Can you please post the folowing two (2) screenshot from "tMDMOutput_1" :
1. Basic settings -> Edit schema ...
2. Advanced settings -> Configure Xml tree ...

magn · 2010-03-30 16:44:14

Hello,
i didn't specify that the entity "decharge" doesn't exist in talend mdm.
i tried ,using tos job, to create the entity and to populate it.
is is possible, i have doubts!!!
because i tried a lot of time without result!!

i tried two versions of TOS : TOS 3.2 (the 4 four screen shots i sent)
and TOS 4.0 ( using fonsw method)

I really need your help!!
Thanks in advance,

Magn

magn · 2010-03-30 16:49:20

ok

Uploaded Images

fonsw · 2010-03-30 17:24:58

Magn,

Your data model should have an entity named "decharge". That's the reason for the "Unable to get the key value for the item decharge:" error message.
The sample data model should look like this:

Uploaded Images

Last edited by fonsw (2010-03-30 17:29:01)

magn · 2010-03-30 17:30:52

In my situation , i have a database containing 20 tables, each table have 30 columns, so i can't create entities one by one.
That's why , i used a tos job .
You said that i should create the entity, ok!
but is there an other way to create automatically entities in Talend MDM ,using Tosjob and tmdmoutput component???

Magn

fonsw · 2010-03-30 17:52:23

Magn,

I mean that you should create an entity "decharge" in the data model created within Talend MDM Studio. To load data into the data model you should create a TOS job.
Watch my previous post for a data model screenshot.

magn · 2010-03-30 17:59:36

Ok,
So i can use the tos job only to load data into the data model.
I thought that i can create entity automatically and after load the data .

Thanks a lot

Magn

Announcement

Unanswered posts

#1 2010-02-15 17:00:32

error when ruunig job

#2 2010-02-22 15:11:33

Re: error when ruunig job

#3 2010-03-01 08:29:59

Re: error when ruunig job

#4 2010-03-01 08:42:22

Re: error when ruunig job

#5 2010-03-01 10:17:37

Re: error when ruunig job

#6 2010-03-01 11:14:13

Re: error when ruunig job

#7 2010-03-01 16:46:56

Re: error when ruunig job

#8 2010-03-25 15:57:08

Re: error when ruunig job

#9 2010-03-30 13:30:04

Re: error when ruunig job

#10 2010-03-30 14:14:23

Re: error when ruunig job

#11 2010-03-30 14:22:57

Re: error when ruunig job

#12 2010-03-30 14:29:07

Re: error when ruunig job

#13 2010-03-30 15:23:49

Re: error when ruunig job

#14 2010-03-30 15:25:12

Re: error when ruunig job

#15 2010-03-30 15:26:13

Re: error when ruunig job

#16 2010-03-30 15:59:18

Re: error when ruunig job

#17 2010-03-30 16:00:21

Re: error when ruunig job

#18 2010-03-30 16:02:03

Re: error when ruunig job

#19 2010-03-30 16:41:22

Re: error when ruunig job

#20 2010-03-30 16:44:14

Re: error when ruunig job

#21 2010-03-30 16:49:20

Re: error when ruunig job

#22 2010-03-30 17:24:58

Re: error when ruunig job

#23 2010-03-30 17:30:52

Re: error when ruunig job

#24 2010-03-30 17:52:23

Re: error when ruunig job

#25 2010-03-30 17:59:36

Re: error when ruunig job

Board footer