errors in xml

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
knowledge
Participant
Posts: 101
Joined: Mon Oct 17, 2005 8:14 am

errors in xml

Post by knowledge »

Hi,

My job design is ,
folder....> xml input...> seq file .
1: I am processing xml files . in the xml files I do not have following tags , eg
'D01_05' or 'D01_19' etc but then too its giving me following error ,

********************88
Xalan error (publicId: , systemId: , line: 8, column: 13): Unknown element 'D01_05'
Xalan error (publicId: , systemId: , line: 12, column: 36): Unknown element 'D01_19'
*****************

2: 'E06_08' is defined as
<E06_04_0>


<E06_04>-20</E06_04>
<E06_05>-20</E06_05>
<E06_07>34</E06_07>

<E06_08>-20</E06_08>


</E06_04_0>


and while importing metadata I have
/ns1:EMSDataSet/ns1:Header/ns1:Record/ns1:E06/ns1:E06_04_0/ns1:E06_08/text()
then still I am getting following error .
*******************************************
Element 'E06_08' is not valid for content model: '(E06_01_0?,E06_04_0,E06_06?,E06_09?,E06_10?,E06_11,E06_12,E06_13,E06_14_0,E06_16?,E06_17?,E06_19_0?)'
****************************

Can anyone please suggest me how to get rid of these errors , please let me know if you want any details about my job.

Thanks


All errors are as follows:

**********************************************
Xalan error (publicId: , systemId: , line: 8, column: 13): Unknown element 'D01_05'
Xalan error (publicId: , systemId: , line: 12, column: 36): Unknown element 'D01_19'
Xalan error (publicId: , systemId: , line: 18, column: 9): Unknown element 'D02_01'
Xalan error (publicId: , systemId: , line: 19, column: 9): Unknown element 'D02_03'
Xalan error (publicId: , systemId: , line: 124, column: 21): Datatype error: Type:InvalidDatatypeValueException, Message:Value '-20' is not in enumeration
Xalan error (publicId: , systemId: , line: 183, column: 8): Element 'E06_08' is not valid for content model: '(E06_01_0?,E06_04_0,E06_06?,E06_09?,E06_10?,E06_11,E06_12,E06_13,E06_14_0,E06_16?,E06_17?,E06_19_0?)'

Xalan error (publicId: , systemId: , line: 308, column: 70): Required attribute 'Long' was not provided
Xalan error (publicId: , systemId: , line: 308, column: 70): Required attribute 'Lat' was not provided
Xalan error (publicId: , systemId: , line: 308, column: 73): No character data is allowed by content model

Xalan error (publicId: , systemId: , line: 798, column: 13): Element 'D01_02' is not valid for content model: '(D01_01,D01_03,D01_04,D01_07,D01_08,D01_09,D01_21,D02_07,Record+)'
Top
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Post by balajisr »

Are you validating xml with the xsd? Looks like xml does not conform with the xsd.
Top
knowledge
Participant
Posts: 101
Joined: Mon Oct 17, 2005 8:14 am

Post by knowledge »

[quote="balajisr"]Are you validating xml with the xsd? Looks like xml does not conform with the xsd.[/quote]
I am very new to xml , can you please tell me what to do .
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

:idea: Do you work with anyone who isn't quite so 'very new to xml', someone you can get some help from?

How about posting some of the XML you are trying to read?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
knowledge
Participant
Posts: 101
Joined: Mon Oct 17, 2005 8:14 am

Post by knowledge »

Hi ,
here is the sample of xml file :
Please let me know if I am doing something wrong ,
i am just processing tags <D01_01>,<E01_01>,<E02_12>, all <E14> tags in one of my job ,
I have marked <E14_01> as repeting element , I have checked all the option under transformation setting in input xml stage , I mean 1:repeting element required 2: format extracted xml fragment 3: replace nulls with empty values 4: replace empty values with nulls.
and I am getting all the errors posted earlier.
Please suggest me whats wrong in my job ,
Thanks
Last edited by knowledge on Thu Nov 15, 2007 8:05 pm, edited 1 time in total.
Top
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

hmm.. Another poorly designed xml document? Hard to tell for sure without looking at the entire file, but this one looks "scary." Seems like maybe they used relative record numbers for the suffix on each element name! ...then again, it's hard to absolutely tell...the values could in fact be entirely unique....

Can you find out if the authors of the xml are intending each of these to actually be individual columns? (ie...as though hundreds of coded fields in a giant COBOL FD?)....or "should" (for example --- there are many similar pairs throughout) E07_35 and E07_30 be two "instances" of the same thing?

Utlimately we'd finally expect a finite number of D's, E's, etc. for one "whole" record, and then many repeating nodes of this collection of elements that represent repeating "records" or rows.

Ernie
Top
knowledge
Participant
Posts: 101
Joined: Mon Oct 17, 2005 8:14 am

Post by knowledge »

Hi Ernie ,
thanks a lot for ur reply ,
First of all i am working time on xml for the first , so do not know , is it poorly documented xml or good one not .
This is just one file which represents one patient record , so all different elemments like <E07_30> etc represents different columns(info of same patient) ,
I have 30 k individual filesto process. every file looks like the one I posted earlier .
I think it is now clear to u that different D and E are different columns (information) of the same patient .
Can u please suggest anything?

Thanks
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”