5 Replies Latest reply on Dec 18, 2014 8:00 AM by Steven Hawkins

    The modeled datatype x for column y doesn't match the runtime type z

    gadeyne.bram Master

      Hi,

       

      I have an issue in Teiid 8.9. This might be related to TEIID-3190.

       

      I get the following exception: TEIID20001 The modeled datatype timestamp for column 4 doesn't match the runtime type "java.lang.String". Please ensure that the column's modeled datatype matches the expected data.

       

      This is also the stack trace:

       

      16:05:36,176 ERROR [org.teiid.TRANSPORT] (New I/O worker #1) null TEIID40113 Unhandled exception, aborting operation: org.teiid.transport.ObjectEncoder$FailedWriteException: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype timestamp for column 4 doesn't match the runtime type "java.lang.String". Please ensure that the column's modeled datatype matches the expected data.

       

              at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:136) [teiid-runtime-8.9.0.Final.jar:8.9.0.Final]

       

              at org.jboss.netty.channel.Channels.write(Channels.java:704) [netty-3.6.7.Final-redhat-1.jar:3.6.7.Final-redhat-1]

       

              at org.jboss.netty.channel.Channels.write(Channels.java:671) [netty-3.6.7.Final-redhat-1.jar:3.6.7.Final-redhat-1]

       

              at org.jboss.netty.channel.AbstractChannel.write(AbstractChannel.java:248) [netty-3.6.7.Final-redhat-1.jar:3.6.7.Final-redhat-1]

       

              at org.teiid.transport.SSLAwareChannelHandler$ObjectChannelImpl.write(SSLAwareChannelHandler.java:93) [teiid-runtime-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.transport.SocketClientInstance.send(SocketClientInstance.java:87) [teiid-runtime-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.transport.ServerWorkItem.sendResult(ServerWorkItem.java:135) [teiid-runtime-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.transport.ServerWorkItem$1.onCompletion(ServerWorkItem.java:105) [teiid-runtime-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:953) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:647) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:223) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:194) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:449) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:331) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:259) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]

       

              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]

       

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]

       

              at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]

       

      Caused by: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype timestamp for column 4 doesn't match the runtime type "java.lang.String". Please ensure that the column's modeled datatype matches the expected data.

       

              at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:851) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:319) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

       

              at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1456) [rt.jar:1.7.0_25]

       

              at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1427) [rt.jar:1.7.0_25]

       

              at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1175) [rt.jar:1.7.0_25]

       

              at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) [rt.jar:1.7.0_25]

       

              at org.teiid.net.socket.Message.writeExternal(Message.java:61) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

       

              at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1456) [rt.jar:1.7.0_25]

       

              at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1427) [rt.jar:1.7.0_25]

       

              at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1175) [rt.jar:1.7.0_25]

       

              at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) [rt.jar:1.7.0_25]

       

              at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:131) [teiid-runtime-8.9.0.Final.jar:8.9.0.Final]

       

              ... 25 more

       

      Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to java.sql.Timestamp

       

              at org.teiid.client.BatchSerializer$TimestampColumnSerializer.writeObject(BatchSerializer.java:788) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:506) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

       

              at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:840) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

       

              ... 36 more

       

      I'm not sure if I can create a working example to reproduce this.

       

      The problem seems to occur on some max() columns in my select statement with group by clause. I have 12 columns in my query. If I remove 4 of them, the query is executed.

       

      Is this message counting the columns from 0 or from 1? I'm not sure about this but it seems like the column that is indicated (counting from 1) is actually reported as beiing of type for the next columns. It always expects String...