topic Metadata XML Input problem - schema dissapeared in Talend Studio

Metadata XML Input problem - schema dissapeared

Anonymous — Wed, 22 Oct 2014 14:07:42 GMT

Hi,
Im facing problems mapping quite complicated XML file in metadata (lets call it bigXML, its 30MB). The goal is to load parts of the bigXML in the DB tables. I created many Input XML metadata files to map certain looping parts of the bigXML to load those parts to ceratin tables according to table structure. Imagine bigXML contains all the information about one organisation and part of it is looping element <owner>, so i wanna load all the owners to table org_owners. I had many buglike problems doing that but i will start with one, which is obvious.
Exact problem: After Input XML file is crerated it misses its schema. I didit happen before while i was creating more of the files as you can see on the attached screenshot. As I click on the file it gives me the error (attached screenshot and log file). As you can see schema is suddenly gone from more files I was creating in the one session.
I assume I could be connected to memory issues as lots of XML metadata consume up to 2GB of my memory, but how i can avoid it?
Could you think of alternative solution for my use-case?
Thx

log.txt.txt

Re: Metadata XML Input problem - schema dissapeared

Anonymous — Thu, 23 Oct 2014 03:13:54 GMT

Hi,
Could you please show us your quite complicated XML file on forum? Screenshot of tFileInputXMl component setting(Metadata XML Input) will be helpful for us to address your issue.
Best regards
Sabrina

Re: Metadata XML Input problem - schema dissapeared

Anonymous — Thu, 23 Oct 2014 10:35:46 GMT

Hi, thanks for reaction. I guess my screenshot is not attached, check here .. I attach the log file and bigXML. Which step of Input XML process you want to see? Mind that creation of Input XML works (sometimes if Talend does not fall) fine, but schema is disappeared suddenly afterwards. See stuff attached. In general on the screenshot u can see file xml without schema which is generally wrong.
BIG.XML I'M TRYING TO MAP BY SEVERAL (30-40) INPUT XML FILES
here

LOG WITH ERROR WHILE CLICK ON XML METADATA FILE

!SESSION 2014-10-22 14:01:01.650 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.7.0_67
java.vendor=Oracle Corporation
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_USCommand-line arguments:  -os win32 -ws win32 -arch x86_64!ENTRY org.talend.amc.

To see the whole post, download it here
OriginalPost.pdf

Re: Metadata XML Input problem - schema dissapeared

Anonymous — Tue, 04 Nov 2014 08:29:14 GMT

Hi,
Are you using Talend Enterprise Subscription 5.5.1? Does this issue repro on other studios?
Best regards
Sabrina