3 Replies Latest reply on Jun 7, 2012 9:38 AM by Ramesh Reddy

    Teiid Mat View Error [UTFDataFormatException]

    Wen Yao Phua Newbie

      Hi,

       

      I encountered a problem with materialized views. I cannot do a simple select statement on any materialized views and MATVIEWS.loadStatus will always be loading status. This is the error from the log file.

      I am using 7.3 version. Hope that someone will help me to understand this error.

       

      2012-06-04 17:49:51,868 ERROR [org.teiid.PROCESSOR] (Worker4076_QueryProcessorQueue1671590) Unexpected exception for request E/soJZ8Avq5L.0

      [TeiidComponentException]Error reading 341375

      1 [UTFDataFormatException]

                at org.teiid.common.buffer.impl.BufferManagerImpl$ManagedBatchImpl.getBatch(BufferManagerImpl.java:299)

                at org.teiid.common.buffer.SPage.getValues(SPage.java:163)

                at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:209)

                at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:155)

                at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:154)

                at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274)

                at org.teiid.query.processor.relational.SelectNode.nextBatchDirect(SelectNode.java:96)

                at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274)

                at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:162)

                at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274)

                at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:161)

                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:662)

      Caused by: java.io.UTFDataFormatException

                at java.io.ObjectInputStream$BlockDataInputStream.readUTFSpan(ObjectInputStream.java:3081)

                at java.io.ObjectInputStream$BlockDataInputStream.readUTFBody(ObjectInputStream.java:3006)

                at java.io.ObjectInputStream$BlockDataInputStream.readUTF(ObjectInputStream.java:2819)

                at java.io.ObjectInputStream.readString(ObjectInputStream.java:1598)

                at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1319)

                at java.io.ObjectInputStream.readObject(ObjectInputStream.java:350)

                at org.teiid.client.BatchSerializer$ColumnSerializer.readObject(BatchSerializer.java:153)

                at org.teiid.client.BatchSerializer$ColumnSerializer.readColumn(BatchSerializer.java:144)

                at org.teiid.client.BatchSerializer.readBatch(BatchSerializer.java:409)

                at org.teiid.common.buffer.TupleBatch.readExternal(TupleBatch.java:186)

                at org.teiid.common.buffer.impl.BufferManagerImpl$ManagedBatchImpl.getBatch(BufferManagerImpl.java:285)

                ... 22 more