Hi,
I am facing issue while reading xml file through XML INPUT STAGE.I was able to create xml output stage from my table and same xml output file using to process through xml input stage.but getting the below error.
"XML_Input_59,0: Fatal Error: Fatal: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 0, column: 0): An exception occurred! Type:RuntimeException, Message:The primary document entity could not be opened. Id=E:/MBI/UB163_PERF_TUNE/SET UP/Check.xml"
I am trying to do hands on on xml stages as soon we are going to process xml files.
I am able to open my xml file in IE and my xml file data goes here.
" <?xml version="1.0" encoding="UTF-8" ?>
- <!--
- Generated by Ascential Software Corporation, DataStage - XMLOutput stage -
- Tue Mar 13 16:41:51 2012
-->
- <ns1:CustomerInfo xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="http://www.ibm.com/schemas/SimpleXMLDemo" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
- <ns1:CUST_INFO>
<ns1:BRTH_DT>1970-11-13 00:00:00.000000</ns1:BRTH_DT>
<ns1:IDV_ID>8</ns1:IDV_ID>
<ns1:FULL_NM>ChargesAMRTLOAN</ns1:FULL_NM>
</ns1:CUST_INFO>
<ns1:TYPE>IDV</ns1:TYPE>
</ns1:CustomerInfo>".
Can you please let me know what is the issue here?
Thanks,
LK
Issue in parsing xml file through XML Input Stage
Moderators: chulett, rschirm, roy
Just FYI, I have gone through most of the topics those are related to xml, still i couldn't able to get it resolve my issue.I have tried with below xml file as well,still facing same issue.
" <?xml version="1.0" encoding="UTF-8" ?>
- <!--
- Generated by Ascential Software Corporation, DataStage - XMLOutput stage -
- Tue Mar 13 16:41:51 2012
-->
- <ns1:CustomerInfo xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="http://www.ibm.com/schemas/SimpleXMLDemo" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
- <ns1:CUST_INFO>
- <ns1:TYPE>
IDV
<ns1:BRTH_DT>1970-11-13 00:00:00.000000</ns1:BRTH_DT>
<ns1:IDV_ID>8</ns1:IDV_ID>
<ns1:FULL_NM>ChargesAMRTLOAN</ns1:FULL_NM>
</ns1:TYPE>
</ns1:CUST_INFO>
</ns1:CustomerInfo> "
Help me out plz.
Thnaks,
LK
" <?xml version="1.0" encoding="UTF-8" ?>
- <!--
- Generated by Ascential Software Corporation, DataStage - XMLOutput stage -
- Tue Mar 13 16:41:51 2012
-->
- <ns1:CustomerInfo xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="http://www.ibm.com/schemas/SimpleXMLDemo" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
- <ns1:CUST_INFO>
- <ns1:TYPE>
IDV
<ns1:BRTH_DT>1970-11-13 00:00:00.000000</ns1:BRTH_DT>
<ns1:IDV_ID>8</ns1:IDV_ID>
<ns1:FULL_NM>ChargesAMRTLOAN</ns1:FULL_NM>
</ns1:TYPE>
</ns1:CUST_INFO>
</ns1:CustomerInfo> "
Help me out plz.
Thnaks,
LK