February 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1482) Prevent unnecessary rebuffering of sorted results

by Steven Hawkins (JIRA)

Prevent unnecessary rebuffering of sorted results ------------------------------------------------- Key: TEIID-1482 URL: https://issues.jboss.org/browse/TEIID-1482 Project: Teiid Issue Type: Enhancement Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 A plan that has a final (non-unrelated sort) sort will have the results rebuffered by the RequestWorkItem even though they are should already be available in a buffer. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1082) simple vdbless editor

by Mauricio Chicalski (JIRA)

simple vdbless editor --------------------- Key: TEIID-1082 URL: https://jira.jboss.org/jira/browse/TEIID-1082 Project: Teiid Issue Type: Feature Request Components: AdminApi Affects Versions: 7.0 Reporter: Mauricio Chicalski Assignee: Steven Hawkins Priority: Optional helper classes (vdbless beans?) and methods to create/manipulate vdbless files within the admin api c.setUrl("jdbc:...."); model.setName model.setConnector(c); vdb.setConnector(c); admin.createVDB(vdb); -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

3
4
0 / 0

[JBoss JIRA] Created: (TEIID-1480) Teiid's ODBC interaction with PostgreSQL-ODBC fails when column lengths exceed 64K as PostgreSQL stores these values as a short

by Paul Nittel (JIRA)

Teiid's ODBC interaction with PostgreSQL-ODBC fails when column lengths exceed 64K as PostgreSQL stores these values as a short ------------------------------------------------------------------------------------------------------------------------------- Key: TEIID-1480 URL: https://issues.jboss.org/browse/TEIID-1480 Project: Teiid Issue Type: Bug Reporter: Paul Nittel Assignee: Steven Hawkins I imported the AdventureWorks2000 database from SQL Server. I had a simple VDB which contained this model. In Excel I was able to see the basic metadata (names of tables), but trying to do anything with a column caused an error. The server.log reported: 2011-02-23 10:15:50,330 ERROR [org.teiid.PROCESSOR.MATVIEWS] (Worker6_QueryProcessorQueue146) Failed to load materialized view table #MAT_PG_CATALOG.PG_ATTRIBUTE. [ExpressionEvaluationException] ERR.015.001.0003: Error Code:ERR.015.001.0003 Message:Unable to evaluate convert(t1__1.Length, short): Error Code:ERR.015.001.0003 Message:Error while evaluating function convert 1 [FunctionExecutionException] ERR.015.001.0003: Error Code:ERR.015.001.0003 Message:Error while evaluating function convert 2 [FunctionExecutionException] ERR.015.001.0033: Error Code:ERR.015.001.0033 Message:Error converting [2,147,483,647] of type integer to type short 3 [TransformationException]The Integer value '2,147,483,647' is outside the of range for Short at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:605) at org.teiid.query.processor.relational.ProjectNode.updateTuple(ProjectNode.java:218) at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:181) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:107) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:150) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105) at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:71) at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:205) at org.teiid.query.tempdata.TempTable.insert(TempTable.java:446) at org.teiid.query.tempdata.TempTableDataManager.loadGlobalTable(TempTableDataManager.java:516) at org.teiid.query.tempdata.TempTableDataManager.registerQuery(TempTableDataManager.java:410) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:182) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:170) at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:197) at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:118) at org.teiid.query.processor.relational.JoinStrategy.openRight(JoinStrategy.java:102) at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:141) at org.teiid.query.processor.relational.JoinStrategy.openLeft(JoinStrategy.java:92) at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:138) at org.teiid.query.processor.relational.JoinStrategy.openLeft(JoinStrategy.java:92) at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:138) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.JoinStrategy.openLeft(JoinStrategy.java:92) at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:138) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:98) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:134) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:184) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:636) The pg_attribute field was modeled as a short to conform to PostgreSQL. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

3
2
0 / 0

[JBoss JIRA] Created: (TEIID-1061) Add a specific translator for SAP Business Warehouse

by Steven Hawkins (JIRA)

Add a specific translator for SAP Business Warehouse ---------------------------------------------------- Key: TEIID-1061 URL: https://jira.jboss.org/jira/browse/TEIID-1061 Project: Teiid Issue Type: Feature Request Components: JDBC Connector Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.1 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

4
7
0 / 0

[JBoss JIRA] Created: (TEIID-1383) Partial Results processing fails too easily when a source is unavailable

by Paul Nittel (JIRA)

Partial Results processing fails too easily when a source is unavailable ------------------------------------------------------------------------ Key: TEIID-1383 URL: https://jira.jboss.org/browse/TEIID-1383 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1.1 Environment: Fedora 12, SOA-P ER4 Reporter: Paul Nittel Assignee: Steven Hawkins I'm updating the MMx partial results test to work with Teiid and ran into this problem while testing that. To mimic an unavailable data source, I munged the server name in the data source definition (-ds) file. Using SQuirreL, I first "set partialResultsMode true" and then query a unioned table: SELECT * FROM PartialVM.MyUnionTable order by INTKEY. I'm getting back an exception about the bad connection, but no apparent attempt to continue the query without that source is made. Steve Hawkins suspects, "it's testing partial results at too low of a level". Artifacts will be attached. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1395) XMLPARSE error message references XMLSERIALIZE

by Steven Hawkins (JIRA)

XMLPARSE error message references XMLSERIALIZE ---------------------------------------------- Key: TEIID-1395 URL: https://issues.jboss.org/browse/TEIID-1395 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.3 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 7.3 The XMLPARSE validation error message references XMLSERIALIZE. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1346) Rewrite is wrong with translate criteria and no user criteria

by Steven Hawkins (JIRA)

Rewrite is wrong with translate criteria and no user criteria ------------------------------------------------------------- Key: TEIID-1346 URL: https://jira.jboss.org/browse/TEIID-1346 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 7.1.1 In a scenario with a user query of: update foo set (...) and a procedure of ... update foo1 set (...) where translate criteria ... the update will fail to happen since the criteria will be translated as FALSE. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

1
5
0 / 0

[JBoss JIRA] Created: (TEIID-1428) ODBC connection fails if the TeiidDriver is not registered.

by Ramesh Reddy (JIRA)

ODBC connection fails if the TeiidDriver is not registered. ----------------------------------------------------------- Key: TEIID-1428 URL: https://issues.jboss.org/browse/TEIID-1428 Project: Teiid Issue Type: Bug Components: ODBC Affects Versions: 7.2 Reporter: Ramesh Reddy Assignee: Ramesh Reddy When the ODBC connection is made to the Teiid Server, it uses the JDBC connection using "local" mode. To make this connection it uses the DriverManager. However, if the Teiid Driver is not already registered with the VM, then the ODBC client will see the below error. $iodbctest DSN=test iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0709.0909 1: SQLDriverConnect = ERROR: No suitable driver found for jdbc:teiid:TransactionsRevisited;ApplicationName=ODBC org.teiid.jdbc.TeiidSQLException: No suitable driver found for jdbc:teiid:TransactionsRevisited;ApplicationName=ODBC (210) SQLSTATE=08001 -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

2
5
0 / 0

[JBoss JIRA] Created: (TEIID-1418) Metadata loaded incorrectly

by Steven Hawkins (JIRA)

Metadata loaded incorrectly --------------------------- Key: TEIID-1418 URL: https://issues.jboss.org/browse/TEIID-1418 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.1.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 7.1.1, 7.3 The index metadata load uses a match filter of type|*name.*|* to load tables for a given schema name. The leading * causes all schemas that have the same suffix to add their tables. In the case shown on the forum link, views were injected into a physical model which caused a recursive query and a stack overflow. The fix is simply to change the match pattern to type|name.*|* -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1410) MALFORMED Query when trying to execute a query with OUTER JOINs which only contains elements from JOINed source

by Wanja Pernath (JIRA)

MALFORMED Query when trying to execute a query with OUTER JOINs which only contains elements from JOINed source --------------------------------------------------------------------------------------------------------------- Key: TEIID-1410 URL: https://issues.jboss.org/browse/TEIID-1410 Project: Teiid Issue Type: Bug Components: Salesforce Connector Affects Versions: 7.1.1 Environment: EAP 5.1 with CXF and Teiid 7.1.1 Reporter: Wanja Pernath Assignee: Steven Hawkins If you're executing a query like this: select PrimaryBusinessUnit, sum(oli.totalPrice) from general.salesforce.Opportunity o left outer join general.salesforce.OpportunityLineItem oli ON oli.OpportunityId = o.id, general.salesforce.PricebookEntry pbe, general.salesforce.Product2 p where (PricebookEntryId = pbe.Id) AND (p.Id = Product2Id) and isClosed=true and isWon = true and CloseDate > '2008-03-01' and accountId = '00130000009SwiLAAS' group by PrimaryBusinessUnit you end up with a MALFORMED_QUERY exception. 2010-12-30 02:32:07,946 DEBUG [org.teiid.CONNECTOR] (Worker82_QueryProcessorQueue1867) iQQ1QVCn8ndT.0.6.153 Create State 2010-12-30 02:32:07,946 DEBUG [org.teiid.CONNECTOR] (Worker84_QueryProcessorQueue1868) iQQ1QVCn8ndT.0.6.153 Processing NEW request: SELECT sfdc.salesforce.OpportunityLineItem.PricebookEntryId, sfdc.salesforce.OpportunityLineItem.TotalPrice FROM sfdc.salesforce.Opportunity LEFT OUTER JOIN sfdc.salesforce.OpportunityLineItem ON sfdc.salesforce.OpportunityLineItem.OpportunityId = sfdc.salesforce.Opportunity.Id WHERE (sfdc.salesforce.Opportunity.StageName <> 'Closed Lost') AND (sfdc.salesforce.Opportunity.ForecastCategory <> 'Omitted') AND (sfdc.salesforce.Opportunity.OpportunityType__c <> 'REBOOK') AND (sfdc.salesforce.Opportunity.IsClosed = TRUE) AND (sfdc.salesforce.Opportunity.IsWon = TRUE) AND (sfdc.salesforce.Opportunity.CloseDate > {d'2008-03-01'}) AND (sfdc.salesforce.Opportunity.AccountId = '00130000009SwiLAAS') 2010-12-30 02:32:07,946 DEBUG [org.teiid.CONNECTOR] (Worker84_QueryProcessorQueue1868) iQQ1QVCn8ndT.0.6.153 Obtained execution 2010-12-30 02:32:07,946 DEBUG [org.teiid.CONNECTOR] (Worker84_QueryProcessorQueue1868) sfdc.iQQ1QVCn8ndT.iQQ1QVCn8ndT.0.6: Incoming Query: SELECT OpportunityLineItem.PricebookEntryId, OpportunityLineItem.TotalPrice FROM Opportunity LEFT OUTER JOIN OpportunityLineItem ON OpportunityLineItem.OpportunityId = Opportunity.Id WHERE Opportunity.StageName <> 'Closed Lost' AND Opportunity.ForecastCategory <> 'Omitted' AND Opportunity.OpportunityType__c <> 'REBOOK' AND Opportunity.IsClosed = TRUE AND Opportunity.IsWon = TRUE AND Opportunity.CloseDate > {d '2008-03-01'} AND Opportunity.AccountId = '00130000009SwiLAAS' 2010-12-30 02:32:07,947 DEBUG [org.teiid.CONNECTOR] (Worker84_QueryProcessorQueue1868) sfdc.iQQ1QVCn8ndT.iQQ1QVCn8ndT.0.6: Executing Query: SELECT , (SELECT OpportunityLineItem.PricebookEntryId, OpportunityLineItem.TotalPrice FROM OpportunityLineItems) FROM Opportunity WHERE (Opportunity.StageName != 'Closed Lost') AND ((Opportunity.ForecastCategory != 'Omitted') AND ((Opportunity.OpportunityType__c != 'REBOOK') AND ((Opportunity.IsClosed = true) AND ((Opportunity.IsWon = true) AND ((Opportunity.CloseDate > 2008-03-01) AND (Opportunity.AccountId = '00130000009SwiLAAS')))))) 2010-12-30 02:32:08,434 WARN [org.teiid.CONNECTOR] (Worker84_QueryProcessorQueue1868) Connector worker process failed for atomic-request=iQQ1QVCn8ndT.0.6.153 [TranslatorException]com.sforce.soap.partner.MalformedQueryFault: MALFORMED_QUERY: SELECT , (SELECT OpportunityLineItem.PricebookEntryId ^ ERROR at Row:1:Column:7 unexpected token: ',' 1 [ResourceException]com.sforce.soap.partner.MalformedQueryFault: MALFORMED_QUERY: SELECT , (SELECT OpportunityLineItem.PricebookEntryId ^ ERROR at Row:1:Column:7 unexpected token: ',' 2 [MalformedQueryFault]MALFORMED_QUERY: SELECT , (SELECT OpportunityLineItem.PricebookEntryId ^ ERROR at Row:1:Column:7 unexpected token: ',' at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:149) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:263) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281) at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:274) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: javax.resource.ResourceException: com.sforce.soap.partner.MalformedQueryFault: MALFORMED_QUERY: SELECT , (SELECT OpportunityLineItem.PricebookEntryId ^ ERROR at Row:1:Column:7 unexpected token: ',' at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:176) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:135) ... 12 more Caused by: com.sforce.soap.partner.MalformedQueryFault: MALFORMED_QUERY: SELECT , (SELECT OpportunityLineItem.PricebookEntryId ^ ERROR at Row:1:Column:7 unexpected token: ',' at org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:131) at $Proxy169.query(Unknown Source) at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:171) ... 13 more 2010-12-30 02:32:08,436 DEBUG [org.teiid.CONNECTOR] (Worker84_QueryProcessorQueue1870) iQQ1QVCn8ndT.0.6.153 Processing Close : SELECT sfdc.salesforce.OpportunityLineItem.PricebookEntryId, sfdc.salesforce.OpportunityLineItem.TotalPrice FROM sfdc.salesforce.Opportunity LEFT OUTER JOIN sfdc.salesforce.OpportunityLineItem ON sfdc.salesforce.OpportunityLineItem.OpportunityId = sfdc.salesforce.Opportunity.Id WHERE (sfdc.salesforce.Opportunity.StageName <> 'Closed Lost') AND (sfdc.salesforce.Opportunity.ForecastCategory <> 'Omitted') AND (sfdc.salesforce.Opportunity.OpportunityType__c <> 'REBOOK') AND (sfdc.salesforce.Opportunity.IsClosed = TRUE) AND (sfdc.salesforce.Opportunity.IsWon = TRUE) AND (sfdc.salesforce.Opportunity.CloseDate > {d'2008-03-01'}) AND (sfdc.salesforce.Opportunity.AccountId = '00130000009SwiLAAS') 2010-12-30 02:32:08,436 DEBUG [org.teiid.CONNECTOR] (Worker84_QueryProcessorQueue1870) SynchQueryExecution.close() called 2010-12-30 02:32:08,436 DEBUG [org.teiid.CONNECTOR] (Worker84_QueryProcessorQueue1870) iQQ1QVCn8ndT.0.6.153 Closed execution 2010-12-30 02:32:08,436 WARN [org.teiid.PROCESSOR] (Worker82_QueryProcessorQueue1869) Processing exception 'com.sforce.soap.partner.MalformedQueryFault: MALFORMED_QUERY: SELECT , (SELECT OpportunityLineItem.PricebookEntryId ^ ERROR at Row:1:Column:7 unexpected token: ','' for request iQQ1QVCn8ndT.0. Exception type org.teiid.core.TeiidProcessingException thrown from org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:131). Enable more detailed logging to see the entire stacktrace. 2010-12-30 02:32:08,436 DEBUG [org.teiid.CONNECTOR] (Worker84_QueryProcessorQueue1870) iQQ1QVCn8ndT.0.6.153 Remove State 2010-12-30 02:32:08,437 DEBUG [org.teiid.CONNECTOR] (Worker84_QueryProcessorQueue1870) iQQ1QVCn8ndT.0.6.153 Closed connection -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 8 months

2
2
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2011