IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
  • 1.  SAXParseException:- No character data is allowed by content model

    Posted 08/06/08 09:45 PM

    Originally posted by: Rajeev30


    Hi,

    I am facing the strange issue. I have created one Type Tree using XSD. After that I have created one input map card only using the same tree and when i test my input card for validation using sample xml file it gives me following error.

    <TypeEntry>
    <TypeName></TypeName>
    <Type>226</Type>
    <ParentType>224</ParentType>
    <Level>8</Level>
    <DocumentType>XML_SIMPLECONTENT</DocumentType>
    <LogicalOffset>934</LogicalOffset>
    <LogicalLength>24</LogicalLength>
    <Length>0</Length>
    <ObjectNumber>25</ObjectNumber>
    <Data></Data>
    </TypeEntry>
    <TypeEntry>
    <TypeName>createdDate</TypeName>
    <Type>224</Type>
    <ParentType>154</ParentType>
    <Level>7</Level>
    <DocumentType>XML_ELEMENT</DocumentType>
    <LogicalOffset>934</LogicalOffset>
    <LogicalLength>24</LogicalLength>
    <Length>0</Length>
    <ObjectNumber>26</ObjectNumber>
    <Data></Data>
    </TypeEntry>
    <TypeEntry UnorderedGroup="true">
    <TypeName></TypeName>
    <Type>254</Type>
    <ParentType>253</ParentType>
    <Level>8</Level>
    <DocumentType>XML_ATTRIBUTELIST</DocumentType>
    <LogicalOffset>758133037</LogicalOffset>
    <LogicalLength>8</LogicalLength>
    <Length>0</Length>
    <ObjectNumber>27</ObjectNumber>
    <Data></Data>
    </TypeEntry>
    <StatusMessage>XMLParser: Input XML data is invalid.</StatusMessage>
    <DetailedStatusMessage>
    Error (-1), "XMLParser: Input XML data is invalid."
    SAXParseException, Error line: 23 column: 59 No character data is allowed by content model

    </DetailedStatusMessage>
    <ReturnCode>-1</ReturnCode>
    </Card>
    </XMLRunLog>

    I am attaching XSD and Sample XML which I am trying .WTX version i am using is 8.2.0.2.

    Regards,
    Rajeev
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: SAXParseException:- No character data is allowed by content model

    Posted 08/07/08 04:16 AM

    Originally posted by: janhess


    The xml doesn't seem to match the schema. It won't validate in XMLSpy.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: SAXParseException:- No character data is allowed by content model

    Posted 08/07/08 04:20 AM

    Originally posted by: Rajeev30


    Hi,

    But when I try to validate it in XMLspy i am not getting any error. can you please let me know what exactly issue I am getting in WTX

    thanks,
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 4.  Re: SAXParseException:- No character data is allowed by content model

    Posted 08/07/08 04:24 AM

    Originally posted by: janhess


    According to my XMLSpy you need a tag serviceTime before person
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 5.  Re: SAXParseException:- No character data is allowed by content model

    Posted 08/07/08 04:34 AM
      |   view attached

    Originally posted by: Rajeev30


    Hi,

    If I add ServiceTime and status Tag than I am getting different different error.

    <Level>4</Level>
    <DocumentType>XML_ATTRIBUTELIST</DocumentType>
    <LogicalOffset>350</LogicalOffset>
    <LogicalLength>0</LogicalLength>
    <Length>0</Length>
    <ObjectNumber>3</ObjectNumber>
    <Data></Data>
    </TypeEntry>
    <TypeEntry UnorderedGroup="true">
    <TypeName></TypeName>
    <Type>24</Type>
    <ParentType>23</ParentType>
    <Level>5</Level>
    <DocumentType>XML_ATTRIBUTELIST</DocumentType>
    <LogicalOffset>1702130533</LogicalOffset>
    <LogicalLength>75</LogicalLength>
    <Length>0</Length>
    <ObjectNumber>4</ObjectNumber>
    <Data></Data>
    </TypeEntry>
    <TypeEntry UnorderedGroup="true">
    <TypeName></TypeName>
    <Type>28</Type>
    <ParentType>27</ParentType>
    <Level>6</Level>
    <DocumentType>XML_ATTRIBUTELIST</DocumentType>
    <LogicalOffset>0</LogicalOffset>
    <LogicalLength>0</LogicalLength>
    <Length>0</Length>
    <ObjectNumber>5</ObjectNumber>
    <Data></Data>
    </TypeEntry>
    <StatusMessage>XMLParser: Input XML data is invalid.</StatusMessage>
    <DetailedStatusMessage>
    Error (-1), "XMLParser: Input XML data is invalid."
    SAXParseException, Error line: 14 column: 54 xsi:nil must not be specified for the element serviceTime with nillable equals false

    </DetailedStatusMessage>
    <ReturnCode>-1</ReturnCode>
    </Card>
    </XMLRunLog>
    After that I save my WCCResponse in UTF-8 format also and than I get different error.

    <?xml version="1.0" encoding="UTF-8"?>
    <?xml-stylesheet type="text/xsl" href="C:\IBM\WebSphere Transformation Extender 8.2\xvallog.xsl"?>
    <XMLRunLog version="1.0" HomeDir="C:\\IBM
    WebSphere Transformation Extender 8.2
    ">
    <Card Name="WCCResp">
    <InputName Size="15319" BaseOffset="0">C:\WTX\XML_To_Cobol\MappingProj\WCCResponse.xml</InputName>
    <!--Building the Object Model.... -->
    <!--Building the Object Model.... -->
    <!--Parsing the internal buffer.... -->
    <!--schema location : -->
    <!--http://schemas.xmlsoap.org/soap/envelope/ C:\WTX\XML_To_Cobol\MappingProj\WCCSearchResponse.xsd -->
    <!--Document Verification : ON -->
    <!--Start of document -->
    <StatusMessage>XMLParser: Input XML data is invalid.</StatusMessage>
    <DetailedStatusMessage>
    Error (-1), "XMLParser: Input XML data is invalid."
    SAXParseException, Fatal error line: 1 column: 1 Invalid document structure

    </DetailedStatusMessage>
    <ReturnCode>-1</ReturnCode>
    </Card>
    </XMLRunLog>
    Can you please help in solving these three errors. I am attaching new WCCResponse.xml file

    Thanks,
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender

    Attachment(s)



  • 6.  Re: SAXParseException:- No character data is allowed by content model

    Posted 08/07/08 04:41 AM

    Originally posted by: janhess


    Your error message gives you the problem

    xsi:nil must not be specified for the element serviceTime with nillable equals false
    it is defined as
    <xsd:element name="serviceTime" type="xsd:duration"/>
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 7.  Re: SAXParseException:- No character data is allowed by content model

    Posted 08/07/08 05:04 AM

    Originally posted by: Rajeev30


    Sorry, can you please explain in little detail as I am not able to understand your point.

    Thanks.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 8.  Re: SAXParseException:- No character data is allowed by content model

    Posted 08/07/08 05:30 AM

    Originally posted by: janhess


    Well if you generate XML from the schema in XMLSpy it gives a value of <serviceTime>P1Y2M3DT10H30M</serviceTime> which must correspont to type="xsd:duration"
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 9.  Re: SAXParseException:- No character data is allowed by content model

    Posted 08/07/08 05:48 AM


  • 10.  Re: SAXParseException:- No character data is allowed by content model

    Posted 08/07/08 07:11 AM
      |   view attached

    Originally posted by: janhess


    If it's of any help the attached xml works.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender

    Attachment(s)



  • 11.  Re: SAXParseException:- No character data is allowed by content model

    Posted 08/11/08 12:25 AM

    Originally posted by: Rajeev30


    hi,

    Thanks i have corrected my XSD and XML and its working fine now.

    Regards,
    Rajeev
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender