Unable to parse xml
balaji.seshadri Oct 20, 2010 6:52 PMIm getting below error while parsing 70mB xml file using XMLPARSE function,looks like character encoding issue.
Please let me know of any work arounds.
2010-10-20 16:23:21,678 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue7) [Ljava.lang.Object;@13fbd4e
[ExpressionEvaluationException]Unable to evaluate XMLPARSE(DOCUMENT F.file): Value is not valid XML
1 [ExpressionEvaluationException]Value is not valid XML
2 [TransformationException]Value is not valid XML
3 [WstxIOException]Input length = 1
4 [UnmappableCharacterException]Input length = 1
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:606)
at org.teiid.query.eval.Evaluator.evaluateXQuery(Evaluator.java:846)
at org.teiid.query.processor.relational.XMLTableNode.nextBatchDirect(XMLTableNode.java:120)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:262)
at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69)
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69)
at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:81)
at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:91)
at org.teiid.query.processor.relational.NestedTableJoinStrategy.process(NestedTableJoinStrategy.java:120)
at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:196)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:262)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:159)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:262)
at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69)
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69)
at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:81)
at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48)
at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:214)
at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:168)
at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:96)
at org.teiid.query.processor.relational.SortNode.nextBatchDirect(SortNode.java:85)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:262)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:107)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:150)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:184)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: [ExpressionEvaluationException]Value is not valid XML
1 [TransformationException]Value is not valid XML
2 [WstxIOException]Input length = 1
3 [UnmappableCharacterException]Input length = 1
at org.teiid.query.eval.Evaluator.evaluateXMLParse(Evaluator.java:695)
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:662)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:604)
... 34 more
Caused by: [TransformationException]Value is not valid XML
1 [WstxIOException]Input length = 1
2 [UnmappableCharacterException]Input length = 1
at org.teiid.core.types.basic.StringToSQLXMLTransform.isXml(StringToSQLXMLTransform.java:74)
at org.teiid.query.eval.Evaluator.validate(Evaluator.java:726)
at org.teiid.query.eval.Evaluator.evaluateXMLParse(Evaluator.java:691)
... 36 more
Caused by: com.ctc.wstx.exc.WstxIOException: Input length = 1
at com.ctc.wstx.sr.StreamScanner.throwFromIOE(StreamScanner.java:708)
at com.ctc.wstx.sr.BasicStreamReader.next(BasicStreamReader.java:1086)
at org.teiid.core.types.basic.StringToSQLXMLTransform.isXml(StringToSQLXMLTransform.java:71)
... 38 more
Caused by: java.nio.charset.UnmappableCharacterException: Input length = 1
at java.nio.charset.CoderResult.throwException(CoderResult.java:261)
at org.teiid.core.util.InputStreamReader.read(InputStreamReader.java:84)
at com.ctc.wstx.io.MergedReader.read(MergedReader.java:101)
at com.ctc.wstx.io.ReaderSource.readInto(ReaderSource.java:84)
at com.ctc.wstx.io.BranchingReaderSource.readInto(BranchingReaderSource.java:57)
at com.ctc.wstx.sr.StreamScanner.loadMore(StreamScanner.java:992)
at com.ctc.wstx.sr.StreamScanner.loadMore(StreamScanner.java:1034)
at com.ctc.wstx.sr.StreamScanner.getNextChar(StreamScanner.java:794)
at com.ctc.wstx.sr.BasicStreamReader.parseNormalizedAttrValue(BasicStreamReader.java:1900)
at com.ctc.wstx.sr.BasicStreamReader.handleNsAttrs(BasicStreamReader.java:3035)
at com.ctc.wstx.sr.BasicStreamReader.handleStartElem(BasicStreamReader.java:2934)
at com.ctc.wstx.sr.BasicStreamReader.nextFromTree(BasicStreamReader.java:2846)
at com.ctc.wstx.sr.BasicStreamReader.next(BasicStreamReader.java:1019)
... 39 more