parsing XML column to dataset

rockgul88 · Post by **rockgul88** » Thu Mar 10, 2011 4:42 am

I tried to parse an XMLtype input column from an Oracle table to a datset....
The input column name is XML_STRING_TEXT which contains the following XML content...

"<?xml version="1.0" encoding="UTF-8" ?>
- <application>
<registrationCategory>Account for Child</registrationCategory>
<code>55</code>
<description>Coverdell</description>
- </application>"

I use the following flow:
Oracle stage->XML input->Dataset

The job is running fine...But no data is moving from XML input to Dataset..
A warning message is coming as below,

XML_Input_29,0: Warning: dsj_ProSurv_Dat_WIP1.XML_Input_29: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 1, column: 2): Expected an element name

please help on this issue....

eostic · Post by **eostic** » Thu Mar 10, 2011 6:15 am

First...make sure you can just retrieve the xml column and put it in a sequential file. Once you are certain that works effectively, correctly retreiving the entire document, move forward.

Sounds like you are doing validation (check box). Don't. Not for initial testing anyway. Get things working first.

How did you do the import of your metadata? Did you have an xsd? If not, but best alternative is to import the metadata from the document you wrote to disk in step 1 up above [import...table definitions....xml definitions...and then specifically check only the lowest/deepest "inside" check box for the elements and attributes that you care about in the tree].

Ernie

rockgul88 · Post by **rockgul88** » Thu Mar 10, 2011 6:53 am

Ya i checked that also...i am able to tetrieve the full XML doc in a sequential file directly....

I have also imported the metadata of the XML through the import->table definitions->XML table definitions and then i have given 'Auto Check' then saved it....

But still i am getting the same error....

chulett · Post by **chulett** » Thu Mar 10, 2011 7:54 am

Note that Ernie did not mention anything about 'Auto Check'... suggest you re-import the metadata as he suggested to see if that helps.

eostic · Post by **eostic** » Thu Mar 10, 2011 8:24 am

Reading it again, it might also be that there is some odd characters or other data causing issues.

Make absolutely sure that you can open the resulting document (from step 1) perfectly inside of IE or firefox without error, and/or consider checking it's well-formed-ness on the web at the w3.org site for xml or any other web based validator (just search google for something like "xml well formed test" or "xml validation")....

Ernie

rockgul88 · Post by **rockgul88** » Thu Mar 10, 2011 11:31 pm

Ya i checked in IE..there is no exception in XML file...

eostic · Post by **eostic** » Fri Mar 11, 2011 6:57 am

Just to be sure...eliminate Oracle from the picture. Simplest is to just write a quick test Server Job using Folder to send the xml to your xmlInput Stage. See if it gets the same error as your Oracle-to-XML EE Job.

Ernie

...if you haven't used Server Jobs for XML, create a Server job that has Folder---XML---Transformer----Sequential. Load the "Folder" Stage Table def (it is in the Built-in category of table definitions) into the link from the Folder Stage, and point the folder stage properties to the directory (Stage Level) and Filename (link level) for your test xml document. Then your xmlInput Stage will look just about the same, gteting the content from the Folder Stage instead of Oracle....

Let us know what happens. I find that Server sometimes yields more informative errors.

Ernie