[JBoss JIRA] (TEIID-4299) Object translator null values correctly
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4299?page=com.atlassian.jira.plugin... ]
Van Halbert reassigned TEIID-4299:
----------------------------------
Assignee: Van Halbert (was: Steven Hawkins)
> Object translator null values correctly
> ---------------------------------------
>
> Key: TEIID-4299
> URL: https://issues.jboss.org/browse/TEIID-4299
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 9.x, 8.12.5
> Reporter: Van Halbert
> Assignee: Van Halbert
> Priority: Critical
>
> The object translator wasn't handling the setting of null values when its tried to be set on a native attribute (i.e., long, int, boolean).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
- 1
- 0
[JBoss JIRA] (TEIID-4285) TEIID30019 Unexpected exception for request ... java.lang.AssertionError: Batch not found in storage
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-4285?page=com.atlassian.jira.plugin... ]
Steve Tran commented on TEIID-4285:
-----------------------------------
Go ahead and close it for now. This isn't something that is easily reproduced.
> TEIID30019 Unexpected exception for request ... java.lang.AssertionError: Batch not found in storage
> ----------------------------------------------------------------------------------------------------
>
> Key: TEIID-4285
> URL: https://issues.jboss.org/browse/TEIID-4285
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
> My VDB stopped accepting ODBC-based connections. I wasn't able to identify the root cause, but I've gathered some facts.
> - JDBC connections still worked
> - ODBC connections to other VDBs worked fine
> - Reloading via web-console of this particular VDB restored functionality
> - Here's the stack trace
> {code}
> [Server:cdtssoa126d-jdv-one] 10:06:23,830 ERROR [org.teiid.PROCESSOR] (Worker2055_QueryProcessorQueue3763648) TEIID30019 Unexpected exception for request Z/WnBvmBk+w1.2: java.lang.AssertionError: Batch not found in storage 16855
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:306) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.getValues(SPage.java:237) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.search(SPage.java:139) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.STree.find(STree.java:246) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.setPage(TupleBrowser.java:146) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:295) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jboss.TransportService$2.invoke(TransportService.java:226) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:174) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:258) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:172) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.getPgColInfo(ODBCServerRemoteImpl.java:1099) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.access$100(ODBCServerRemoteImpl.java:80) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl$4.onCompletion(ODBCServerRemoteImpl.java:455) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:516) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:920) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:646) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:218) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:189) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one]
> [Server:cdtssoa126d-jdv-one] 10:06:24,246 ERROR [org.teiid.PROCESSOR] (Worker2055_QueryProcessorQueue3763650) TEIID30019 Unexpected exception for request Z/WnBvmBk+w1.4: java.lang.AssertionError: Batch not found in storage 11173
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:306) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.getValues(SPage.java:237) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:223) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.process(EnhancedSortMergeJoinStrategy.java:383) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:269) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:202) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortNode.getBuffer(SortNode.java:208) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:250) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:289) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:149) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one]
> [Server:cdtssoa126d-jdv-one] 10:06:24,467 ERROR [org.teiid.PROCESSOR] (New I/O worker #17) TEIID30019 Unexpected exception for request Z/WnBvmBk+w1.5: java.lang.AssertionError: Batch not found in storage 14803
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:306) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.getValues(SPage.java:237) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.search(SPage.java:139) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.STree.find(STree.java:246) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.setPage(TupleBrowser.java:146) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:295) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jboss.TransportService$2.invoke(TransportService.java:226) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:174) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:258) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:172) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.getPgColInfo(ODBCServerRemoteImpl.java:1099) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.prepare(ODBCServerRemoteImpl.java:502) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one]
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
- 1
- 0
[JBoss JIRA] (TEIID-4299) Object translator null values correctly
by Van Halbert (JIRA)
Van Halbert created TEIID-4299:
----------------------------------
Summary: Object translator null values correctly
Key: TEIID-4299
URL: https://issues.jboss.org/browse/TEIID-4299
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 9.x, 8.12.5
Reporter: Van Halbert
Assignee: Steven Hawkins
Priority: Critical
The object translator wasn't handling the setting of null values when its tried to be set on a native attribute (i.e., long, int, boolean).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
- 1
- 0
[JBoss JIRA] (TEIID-4285) TEIID30019 Unexpected exception for request ... java.lang.AssertionError: Batch not found in storage
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4285?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4285:
---------------------------------------
Unless there are more details to add or this can be reproduced on a later version we'll need to close this on the community side.
> TEIID30019 Unexpected exception for request ... java.lang.AssertionError: Batch not found in storage
> ----------------------------------------------------------------------------------------------------
>
> Key: TEIID-4285
> URL: https://issues.jboss.org/browse/TEIID-4285
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
> My VDB stopped accepting ODBC-based connections. I wasn't able to identify the root cause, but I've gathered some facts.
> - JDBC connections still worked
> - ODBC connections to other VDBs worked fine
> - Reloading via web-console of this particular VDB restored functionality
> - Here's the stack trace
> {code}
> [Server:cdtssoa126d-jdv-one] 10:06:23,830 ERROR [org.teiid.PROCESSOR] (Worker2055_QueryProcessorQueue3763648) TEIID30019 Unexpected exception for request Z/WnBvmBk+w1.2: java.lang.AssertionError: Batch not found in storage 16855
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:306) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.getValues(SPage.java:237) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.search(SPage.java:139) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.STree.find(STree.java:246) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.setPage(TupleBrowser.java:146) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:295) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jboss.TransportService$2.invoke(TransportService.java:226) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:174) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:258) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:172) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.getPgColInfo(ODBCServerRemoteImpl.java:1099) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.access$100(ODBCServerRemoteImpl.java:80) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl$4.onCompletion(ODBCServerRemoteImpl.java:455) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:516) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:920) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:646) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:218) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:189) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one]
> [Server:cdtssoa126d-jdv-one] 10:06:24,246 ERROR [org.teiid.PROCESSOR] (Worker2055_QueryProcessorQueue3763650) TEIID30019 Unexpected exception for request Z/WnBvmBk+w1.4: java.lang.AssertionError: Batch not found in storage 11173
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:306) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.getValues(SPage.java:237) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:223) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.process(EnhancedSortMergeJoinStrategy.java:383) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:269) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:202) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortNode.getBuffer(SortNode.java:208) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:250) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:289) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:149) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one]
> [Server:cdtssoa126d-jdv-one] 10:06:24,467 ERROR [org.teiid.PROCESSOR] (New I/O worker #17) TEIID30019 Unexpected exception for request Z/WnBvmBk+w1.5: java.lang.AssertionError: Batch not found in storage 14803
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:306) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.getValues(SPage.java:237) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.search(SPage.java:139) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.STree.find(STree.java:246) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.setPage(TupleBrowser.java:146) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:295) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jboss.TransportService$2.invoke(TransportService.java:226) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:174) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:258) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:172) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.getPgColInfo(ODBCServerRemoteImpl.java:1099) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.prepare(ODBCServerRemoteImpl.java:502) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one]
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
- 1
- 0
[JBoss JIRA] (TEIID-4292) VDB file extention must be all lowercase
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4292?page=com.atlassian.jira.plugin... ]
Steven Hawkins reassigned TEIID-4292:
-------------------------------------
Assignee: Ramesh Reddy (was: Steven Hawkins)
> VDB file extention must be all lowercase
> ----------------------------------------
>
> Key: TEIID-4292
> URL: https://issues.jboss.org/browse/TEIID-4292
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Reporter: Steve Tran
> Assignee: Ramesh Reddy
> Priority: Minor
>
> Might be obvious, but the file extension of a VDB must be all lowercase. The web console looked like it deployed and enabled it, but if you go into the Runtime tab, the VDB is not there.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
- 1
- 0
[JBoss JIRA] (TEIID-3834) Error during (re) adding connection factory using CLI
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3834?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3834:
---------------------------------------
Captured again for WildFly 10.
> Error during (re) adding connection factory using CLI
> -----------------------------------------------------
>
> Key: TEIID-3834
> URL: https://issues.jboss.org/browse/TEIID-3834
> Project: Teiid
> Issue Type: Sub-task
> Components: Server
> Affects Versions: 8.13
> Reporter: Kylin Soong
> Assignee: Ramesh Reddy
>
> enable datasource command
> {code}
> /subsystem=datasources/data-source=h2:enable
> {code}
> seems redundant, cause datasource add already enable it, so if execute setup.cli
> {code}
> ./bin/jboss-cli.sh --connect --file=setup.cli
> {code}
> will cause a eror
> {code}
> {
> "outcome" => "failed",
> "failure-description" => "WFLYCTL0158: Operation handler failed: org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered",
> "rolled-back" => true
> }
> 14:35:55,436 ERROR [org.jboss.as.controller.management-operation] (management-handler-thread - 9) WFLYCTL0013: Operation ("enable") failed - address: ([
> ("subsystem" => "datasources"),
> ("data-source" => "h2")
> ]): org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered
> at org.jboss.msc.service.ServiceRegistrationImpl.setInstance(ServiceRegistrationImpl.java:158)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
- 1
- 0
[JBoss JIRA] (TEIID-4295) TEIID31150 when using date function with MSSQL
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4295?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4295:
---------------------------------------
In particular TEIID-4124 added a full notion of date type support to the translator.
> TEIID31150 when using date function with MSSQL
> ----------------------------------------------
>
> Key: TEIID-4295
> URL: https://issues.jboss.org/browse/TEIID-4295
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
>
> I'm using teiid version 8.11.3
> I have a field of type date over mssql 2012, when applying a date function over it, i get directly the error :
> org.teiid.jdbc.TeiidSQLException: TEIID31150 The function 'YEAR(testmark.mydate)' is ambiguous. Use schema qualification.
> if I change the field type to datetime, the query executes successfully.
> Here is the simplified query i'm testing with:
> select YEAR("testmark"."mydate") as "testmark_mydate" from "implify_dataModel_at"."implify_data"."implify_red2"."testmark" "testmark" LIMIT 0 , 10
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
- 1
- 0
[JBoss JIRA] (TEIID-4295) TEIID31150 when using date function with MSSQL
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4295?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4295:
---------------------------------------
What is the source query that is generated, and does this still occur on later versions?
> TEIID31150 when using date function with MSSQL
> ----------------------------------------------
>
> Key: TEIID-4295
> URL: https://issues.jboss.org/browse/TEIID-4295
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
>
> I'm using teiid version 8.11.3
> I have a field of type date over mssql 2012, when applying a date function over it, i get directly the error :
> org.teiid.jdbc.TeiidSQLException: TEIID31150 The function 'YEAR(testmark.mydate)' is ambiguous. Use schema qualification.
> if I change the field type to datetime, the query executes successfully.
> Here is the simplified query i'm testing with:
> select YEAR("testmark"."mydate") as "testmark_mydate" from "implify_dataModel_at"."implify_data"."implify_red2"."testmark" "testmark" LIMIT 0 , 10
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
- 1
- 0
[JBoss JIRA] (TEIID-4289) Add transaction command support for syntax BEGIN/ROLLBACK/COMMIT WORK
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4289?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4289.
-----------------------------------
Resolution: Done
Added handling for a trailing work/transaction keyword.
> Add transaction command support for syntax BEGIN/ROLLBACK/COMMIT WORK
> ---------------------------------------------------------------------
>
> Key: TEIID-4289
> URL: https://issues.jboss.org/browse/TEIID-4289
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 8.7.6.6_2
> Reporter: Marc Shirley
> Assignee: Steven Hawkins
> Fix For: 9.1
>
>
> This request appears to be an expansion of TEIID-1701 to add syntax like the below as an alias for transactional commands. This would be in line to make commands portable from other vendor DBs such as PostgreSQL/SQL Server/DB2/MySQL.
> BEGIN WORK
> ROLLBACK WORK
> COMMIT WORK
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
- 1
- 0
[JBoss JIRA] (TEIID-4298) Support in Odata4 for the Partner NavigationProperty attribute
by Mirco Marchitiello (JIRA)
[ https://issues.jboss.org/browse/TEIID-4298?page=com.atlassian.jira.plugin... ]
Mirco Marchitiello updated TEIID-4298:
--------------------------------------
Description:
in Teiid 9.0 it would be useful to create a bidirectional link between tables, like in odata2
for example:
<EntityType Name="Product">
<Key>
<PropertyRef Name="ProductID"/>
</Key>
<Property Name="ProductID" Type="Edm.Int32" Nullable="false" p5:StoreGeneratedPattern="Identity"/>
<Property Name="ProductName" Type="Edm.String" Nullable="false" MaxLength="40"/>
<Property Name="SupplierID" Type="Edm.Int32"/>
<Property Name="CategoryID" Type="Edm.Int32"/>
<Property Name="QuantityPerUnit" Type="Edm.String" MaxLength="20"/>
<Property Name="UnitPrice" Type="Edm.Decimal" Precision="19" Scale="4"/>
<Property Name="UnitsInStock" Type="Edm.Int16"/>
<Property Name="UnitsOnOrder" Type="Edm.Int16"/><Property Name="ReorderLevel" Type="Edm.Int16"/>
<Property Name="Discontinued" Type="Edm.Boolean" Nullable="false"/>
<NavigationProperty Name="Category" Type="NorthwindModel.Category" Partner="Products">
<ReferentialConstraint Property="CategoryID" ReferencedProperty="CategoryID"/>
</NavigationProperty>
<NavigationProperty Name="Order_Details" Type="Collection(NorthwindModel.Order_Detail)" Partner="Product"/>
<NavigationProperty Name="Supplier" Type="NorthwindModel.Supplier" Partner="Products">
<ReferentialConstraint Property="SupplierID" ReferencedProperty="SupplierID"/>
</NavigationProperty>
</EntityType>
<EntityType Name="Category">
<Key>
<PropertyRef Name="CategoryID"/>
</Key>
<Property Name="CategoryID" Type="Edm.Int32" Nullable="false" p5:StoreGeneratedPattern="Identity"/>
<Property Name="CategoryName" Type="Edm.String" Nullable="false" MaxLength="15"/>
<Property Name="Description" Type="Edm.String" MaxLength="max"/>
<Property Name="Picture" Type="Edm.Binary" MaxLength="max"/>
<NavigationProperty Name="Products" Type="Collection(NorthwindModel.Product)" Partner="Category"/>
</EntityType>
It seems that the two tables are related through NavigationProperty and Partner
In fact I can see all the Categories of a certain Product
http://services.odata.org/V4/Northwind/Northwind.svc/Products(10)/Category
or viceversa the products of a certain Category
http://services.odata.org/V4/Northwind/Northwind.svc/Categories(8)/Products
While in Teiid using odata2 this works just by creating a FK from one table to the other one, with odata4 this does not happen
was:
in Teiid 9.0 it would be useful to create a bidirectional link between tables, like in odata2
for example:
<EntityType Name="Product">
<Key>
<PropertyRef Name="ProductID"/>
</Key>
<Property Name="ProductID" Type="Edm.Int32" Nullable="false" p5:StoreGeneratedPattern="Identity"/>
<Property Name="ProductName" Type="Edm.String" Nullable="false" MaxLength="40"/>
<Property Name="SupplierID" Type="Edm.Int32"/>
<Property Name="CategoryID" Type="Edm.Int32"/>
<Property Name="QuantityPerUnit" Type="Edm.String" MaxLength="20"/>
<Property Name="UnitPrice" Type="Edm.Decimal" Precision="19" Scale="4"/>
<Property Name="UnitsInStock" Type="Edm.Int16"/>
<Property Name="UnitsOnOrder" Type="Edm.Int16"/><Property Name="ReorderLevel" Type="Edm.Int16"/>
<Property Name="Discontinued" Type="Edm.Boolean" Nullable="false"/>
<NavigationProperty Name="Category" Type="NorthwindModel.Category" Partner="Products">
<ReferentialConstraint Property="CategoryID" ReferencedProperty="CategoryID"/>
</NavigationProperty>
<NavigationProperty Name="Order_Details" Type="Collection(NorthwindModel.Order_Detail)" Partner="Product"/>
<NavigationProperty Name="Supplier" Type="NorthwindModel.Supplier" Partner="Products">
<ReferentialConstraint Property="SupplierID" ReferencedProperty="SupplierID"/>
</NavigationProperty>
</EntityType>
<EntityType Name="Category">
<Key>
<PropertyRef Name="CategoryID"/>
</Key>
<Property Name="CategoryID" Type="Edm.Int32" Nullable="false" p5:StoreGeneratedPattern="Identity"/>
<Property Name="CategoryName" Type="Edm.String" Nullable="false" MaxLength="15"/>
<Property Name="Description" Type="Edm.String" MaxLength="max"/>
<Property Name="Picture" Type="Edm.Binary" MaxLength="max"/>
<NavigationProperty Name="Products" Type="Collection(NorthwindModel.Product)" Partner="Category"/>
</EntityType>
It seems that the two tables are related through NavigationProperty and Partner
In fact I can see all the Categories of a certain Product
http://services.odata.org/V4/Northwind/Northwind.svc/Products(10)/Category
or viceversa the products of a certain Category
http://services.odata.org/V4/Northwind/Northwind.svc/Categories(8)/Products
> Support in Odata4 for the Partner NavigationProperty attribute
> --------------------------------------------------------------
>
> Key: TEIID-4298
> URL: https://issues.jboss.org/browse/TEIID-4298
> Project: Teiid
> Issue Type: Enhancement
> Components: OData
> Affects Versions: 9.0
> Reporter: Mirco Marchitiello
> Assignee: Steven Hawkins
>
> in Teiid 9.0 it would be useful to create a bidirectional link between tables, like in odata2
> for example:
> <EntityType Name="Product">
> <Key>
> <PropertyRef Name="ProductID"/>
> </Key>
> <Property Name="ProductID" Type="Edm.Int32" Nullable="false" p5:StoreGeneratedPattern="Identity"/>
> <Property Name="ProductName" Type="Edm.String" Nullable="false" MaxLength="40"/>
> <Property Name="SupplierID" Type="Edm.Int32"/>
> <Property Name="CategoryID" Type="Edm.Int32"/>
> <Property Name="QuantityPerUnit" Type="Edm.String" MaxLength="20"/>
> <Property Name="UnitPrice" Type="Edm.Decimal" Precision="19" Scale="4"/>
> <Property Name="UnitsInStock" Type="Edm.Int16"/>
> <Property Name="UnitsOnOrder" Type="Edm.Int16"/><Property Name="ReorderLevel" Type="Edm.Int16"/>
> <Property Name="Discontinued" Type="Edm.Boolean" Nullable="false"/>
> <NavigationProperty Name="Category" Type="NorthwindModel.Category" Partner="Products">
> <ReferentialConstraint Property="CategoryID" ReferencedProperty="CategoryID"/>
> </NavigationProperty>
> <NavigationProperty Name="Order_Details" Type="Collection(NorthwindModel.Order_Detail)" Partner="Product"/>
> <NavigationProperty Name="Supplier" Type="NorthwindModel.Supplier" Partner="Products">
> <ReferentialConstraint Property="SupplierID" ReferencedProperty="SupplierID"/>
> </NavigationProperty>
> </EntityType>
> <EntityType Name="Category">
> <Key>
> <PropertyRef Name="CategoryID"/>
> </Key>
> <Property Name="CategoryID" Type="Edm.Int32" Nullable="false" p5:StoreGeneratedPattern="Identity"/>
> <Property Name="CategoryName" Type="Edm.String" Nullable="false" MaxLength="15"/>
> <Property Name="Description" Type="Edm.String" MaxLength="max"/>
> <Property Name="Picture" Type="Edm.Binary" MaxLength="max"/>
> <NavigationProperty Name="Products" Type="Collection(NorthwindModel.Product)" Partner="Category"/>
> </EntityType>
> It seems that the two tables are related through NavigationProperty and Partner
> In fact I can see all the Categories of a certain Product
> http://services.odata.org/V4/Northwind/Northwind.svc/Products(10)/Category
> or viceversa the products of a certain Category
> http://services.odata.org/V4/Northwind/Northwind.svc/Categories(8)/Products
> While in Teiid using odata2 this works just by creating a FK from one table to the other one, with odata4 this does not happen
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
- 1
- 0