[JBoss JIRA] (TEIID-3951) Stored procedure in view model from SQL server 2000
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3951?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3951.
---------------------------------
> Stored procedure in view model from SQL server 2000
> ---------------------------------------------------
>
> Key: TEIID-3951
> URL: https://issues.jboss.org/browse/TEIID-3951
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.13
> Reporter: Mirco Marchitiello
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.1
>
> Attachments: testMirco.vdb
>
>
> There are some issues on some procedures developed on a SQL server 2000 when a view model reading the procedures from a source model is created.
> The source model is connected with the SQL server 2000 via jdts1.3.1 driver. When the source procedure is exteciting it works fine, while running the virtual procedure the stack trace is the following:
> 2016-02-04 11:59:16,769 WARN [org.teiid.CONNECTOR] (Worker93_QueryProcessorQueue1047) V/FcQRQWrBI2 TEIID30004 Connector returned a 0 row non-last batch: CASALE_GROUP.
> 2016-02-04 11:59:16,769 WARN [org.teiid.CONNECTOR] (Worker93_QueryProcessorQueue1049) V/FcQRQWrBI2 Connector worker process failed for atomic-request=V/FcQRQWrBI2.7.1.141: org.teiid.core.types.TransformationException: TEIID10072 Invalid integer format in String: Villa, Ground Floor - Tel. 9389
> at org.teiid.core.types.basic.StringToIntegerTransform.transformDirect(StringToIntegerTransform.java:43)
> at org.teiid.core.types.Transform.transform(Transform.java:47)
> at org.teiid.core.types.DataTypeManager.transformValue(DataTypeManager.java:942)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.correctTypes(ConnectorWorkItem.java:572)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:435)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:226)
> at sun.reflect.GeneratedMethodAccessor102.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:497)
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy57.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> 2016-02-04 11:59:16,785 WARN [org.teiid.PROCESSOR] (Worker92_QueryProcessorQueue1050) V/FcQRQWrBI2 TEIID30020 Processing exception for request V/FcQRQWrBI2.7 'TEIID10072 Invalid integer format in String: Villa, Ground Floor - Tel. 9389'. Originally TransformationException StringToIntegerTransform.java:43. Enable more detailed logging to see the entire stacktrace.
> The same procedure, with the same table and data on SQL Server 2008 works fine
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years, 1 month
[JBoss JIRA] (TEIID-3953) .TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal".
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3953?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3953.
---------------------------------
> .TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal".
> ----------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3953
> URL: https://issues.jboss.org/browse/TEIID-3953
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.9, 8.11.4
> Environment: Windows server 2012 R2
> Reporter: Lukas Mro
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.0, 8.12.5, 8.13.1
>
>
> 13:18:51,809 INFO [org.teiid.CONNECTOR] (Worker19_QueryProcessorQueue264) EWgzC7sVHcNy SimpleJDBCExecutionFactory Commit=true;DatabaseProductName=Firebird 2.5.WI;DatabaseProductVersion=WI-V2.5.3.26780;DriverMajorVersion=2;DriverMajorVersion=2;DriverName=Jaybird JCA/JDBC driver;DriverVersion=2.2;IsolationLevel=2
> 13:18:51,855 ERROR [org.teiid.TRANSPORT] (New I/O worker #4) null TEIID40113 Unhandled exception, aborting operation: org.teiid.transport.ObjectEncoder$FailedWriteException: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal". Please ensure that the column's modeled datatype matches the expected data.
> at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:136) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.jboss.netty.channel.Channels.write(Channels.java:704) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.Channels.write(Channels.java:671) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.jboss.netty.channel.AbstractChannel.write(AbstractChannel.java:248) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> at org.teiid.transport.SSLAwareChannelHandler$ObjectChannelImpl.write(SSLAwareChannelHandler.java:93) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.SocketClientInstance.send(SocketClientInstance.java:88) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.ServerWorkItem.sendResult(ServerWorkItem.java:135) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.ServerWorkItem$1.onCompletion(ServerWorkItem.java:105) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:980) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:662) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:223) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:194) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:457) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:267) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.11.4.jar:8.11.4]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> Caused by: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal". Please ensure that the column's modeled datatype matches the expected data.
> at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:878) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:319) [teiid-client-8.11.4.jar:8.11.4]
> at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1458) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1429) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1177) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) [rt.jar:1.7.0_75]
> at org.teiid.net.socket.Message.writeExternal(Message.java:61) [teiid-client-8.11.4.jar:8.11.4]
> at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1458) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1429) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1177) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) [rt.jar:1.7.0_75]
> at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:131) [teiid-runtime-8.11.4.jar:8.11.4]
> ... 25 more
> Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String
> at org.teiid.client.BatchSerializer$StringColumnSerializer3.writeObject(BatchSerializer.java:348) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:534) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:867) [teiid-client-8.11.4.jar:8.11.4]
> ... 36 more
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years, 1 month