1 2 Previous Next 22 Replies Latest reply: Dec 13, 2010 3:18 PM by Steven Hawkins RSS

    Unable to parse xml

    Balaji Seshadri Newbie

      Im 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

        1 2 Previous Next