One Star

error when ruunig job

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?

25 REPLIES
One Star

Re: error when ruunig job

Hello
is there any idea please!
One Star

Re: error when ruunig job

Hello,
Can Some one help me !!!
Community Manager

Re: error when ruunig job

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

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

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: error when ruunig job

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
Community Manager

Re: error when ruunig job

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: error when ruunig job

problem resolved
Thank you
One Star

Re: error when ruunig job

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
One Star

Re: error when ruunig job

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
Employee

Re: error when ruunig job

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.
One Star

Re: error when ruunig job

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

Re: error when ruunig job

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

Re: error when ruunig job

Thanks
One Star

Re: error when ruunig job

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".
One Star

Re: error when ruunig job

i try an other time!!
One Star

Re: error when ruunig job

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

Re: error when ruunig job

error screen
One Star

Re: error when ruunig job

oops!
One Star

Re: error when ruunig job

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 ...
One Star

Re: error when ruunig job

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
One Star

Re: error when ruunig job

ok
One Star

Re: error when ruunig job

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:
One Star

Re: error when ruunig job

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
One Star

Re: error when ruunig job

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.
One Star

Re: error when ruunig job

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 Smiley Very Happy

Magn
Employee

Re: error when ruunig job

Hi,
In MDM projects, you usually do not create entities at runtime.
Because part of the job is about correctly modelling the entities/references.
Usually in a company the references are not exactly as reference tables.
Anyway, in the MDM studio, you can import items from XSL/XML.
Most metadata can be exported to these formats so you should be able to create the base structure of the entities in no time
regards,
benjamin