Welcome, Guest
Username: Password: Remember me
Data Warehousing and Data integration
  • Page:
  • 1

TOPIC: various XML schema and their consumption

various XML schema and their consumption 2 months 3 days ago #19804

  • shoes
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 1
Hi, I have wroten xml consumer from file, but this files has variuos XMLs inside, and i sometimes I get error

Transformation: Transformer2 Execution Aborted: Table's Structure Has Changed (The Number of fields is different)

and is true sometimes number of fields is more, but never less than i need ...

how to prevent this error, and independenlty from number of fields save them, for example as empty string?

and strange thing is this that this works when i run process by hand, but I use schedule this error eccurs... what is diffrence?

Thanks 4 answer!

Please Log in or Create an account to join the conversation.

various XML schema and their consumption 2 months 3 days ago #19805

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7809
  • Karma: 33
  • Thank you received: 468
The problem with XML that it is too flexible. One file has 5 tags another 6 tags and the next file has tags in a different order.
The way to deal with it is to convert it into stable format using XSLT

Here are some wiki articles you will find useful

www.etl-tools.com/wiki/knowledgebase/xml1

www.etl-tools.com/wiki/knowledgebase/etl_and_xslt
Mike
The following user(s) said Thank You: shoes

Please Log in or Create an account to join the conversation.

various XML schema and their consumption 2 months 3 days ago #19806

  • shoes
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 1
all right! i will do it, why sometimes i get error from execution agent

Information 01.04.2020 12:41:33 Preparing to execute: xkafka- Clone
Information 01.04.2020 12:41:33 Executing Transformation: xkafka- Clone
Error 01.04.2020 12:42:48 Access violation at address 0000000001D4651C in module 'aetlcl.exe'. Read of address 0000000000000000
Error 01.04.2020 12:42:48 Execution of Transformation has failed
Error 01.04.2020 12:42:48 Failed
?

Please Log in or Create an account to join the conversation.

various XML schema and their consumption 2 months 2 days ago #19807

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7809
  • Karma: 33
  • Thank you received: 468
Can you try the latest version, please, just download and install it on top.
Mike

Please Log in or Create an account to join the conversation.

various XML schema and their consumption 2 months 1 day ago #19808

  • shoes
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 1
Hi, I updated but still the same error when using scheduler.... is working a few minutes than crash... he has processor and ram so no idea whats wrong...

Please Log in or Create an account to join the conversation.

various XML schema and their consumption 2 months 1 day ago #19809

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7809
  • Karma: 33
  • Thank you received: 468
Support will contact you shortly.
Mike

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 133 guests and 3 members online