unable to read invalid characters from xml
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
On the server job side, I have had to put a transformer stage between the sequential, in my case a folder stage, and the xml stage. In the transformer, I use the convert() function to change or remove the problem characters. The key is to identify those characters.
Chuck Smith
www.anotheritco.com
www.anotheritco.com
How certain are you that XMLInput is losing the row....could it be that the Trx is dropping it...perhaps due to nulls somewhere or other datatype issue?
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
...try two things as debugging aids:
a) Use the External Source stage to read the input name of the xml document... see www.dsrealtime.com for instructions (go to the table of contents and find XML ... reading xml content for details)
b) try it in a Server job for test purposes, reading the xml document using a folder stage. If XMLInput was dying, you'd get "1" row from Seq and 0 rows from XML.
...can't say what it is exactly, but I don't trust how the Sequential Stage in EE might be reading the document.
Ernie
a) Use the External Source stage to read the input name of the xml document... see www.dsrealtime.com for instructions (go to the table of contents and find XML ... reading xml content for details)
b) try it in a Server job for test purposes, reading the xml document using a folder stage. If XMLInput was dying, you'd get "1" row from Seq and 0 rows from XML.
...can't say what it is exactly, but I don't trust how the Sequential Stage in EE might be reading the document.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
and does the same logic fail when written in Server?
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Looking at this again, what "exactly" are the characters? Can you share the string in hex here, just in case we're not seeing exactly what is represented?
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 17
- Joined: Fri Jul 30, 2004 1:16 am