xml error

knowledge · Post by **knowledge** » Thu Apr 17, 2008 8:30 pm

Hi I am processing xml file , job design is :
folder stage .......>input xml stage---------> seq file stage .

out of few thousand only 4 to 5 are getting rejected with the error that could not validate to main schema , I have unchecked the validate xml oprtion , but not sure why it is still validating against main schema ,which is risky as it is creating load to main schema.

pl suggest ,

I will also post errors from job tomorrow ,

thanks

knowledge · Post by **knowledge** » Fri Apr 18, 2008 12:21 pm

Hi all,

these are the errors I was getting :
..............

XmlLoad_mul_5_unix..XML_Input_22: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 0, column: 0): An exception occurred! Type:NetAccessorException, Message:Could not connect to the socket for URL '{0}'. Error={1}
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 10, column: 51): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 11, column: 51): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 12, column: 49): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 13, column: 53): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 14, column: 59): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 15, column: 56): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 16, column: 58): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 17, column: 53): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 18, column: 64): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 19, column: 60): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 20, column: 58): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 21, column: 56): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 22, column: 66): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 23, column: 65): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 24, column: 55): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 25, column: 61): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 26, column: 61): Fatal error encountered during schema scan
Xalan fatal error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 27, column: 57): Fatal error encountered during schema scan
Xalan error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 111, column: 75): Type not found in http://www.nemsis.org:E06
Xalan error (publicId: , systemId: http://www.nemsis.org/media/XSD/EMSDataSet.xsd, line: 111, column: 75): Untyped element: E06
..........................................

I dont know why it is going ahainst schema to validate .........since i have unchecked validate scema option,

I have namespace :
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:ns1="http://www.nemsis.org"
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"

and column definition for one of the column is :

/ns1:EMSDataSet/ns1:Header/ns1:Record/ns1:E02/ns1:E02_12/text()

Can you please tell me how it works , where it actually validate schema .

thanks .

lstsaur · Post by **lstsaur** » Fri Apr 18, 2008 1:01 pm

This line "xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" tells the XML parser that this document should be validated against a schema.
But couldn't connect to "http://www.nemsis.org/media/XSD/EMSDataSet.xsd" schema file.

knowledge · Post by **knowledge** » Fri Apr 18, 2008 2:27 pm

how can I say not to connect it to that scema , i do not want to connect to that scema ............

why only few files got rejected ...........if i run that single file it loads .........

lstsaur · Post by **lstsaur** » Fri Apr 18, 2008 3:02 pm

"that single file it loads..." does not have the namespace's problem. That's why it's loaded. So, either take the namespace out of that file and change the column definition accordingly or provide the namespace for the schema .xsd file location.