January 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Updated: (TEIID-1427) Class not found in Teiid JON agent

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIID-1427?page=com.atlassian.jira.plugin... ] Ted Jones updated TEIID-1427: ----------------------------- Fix Version/s: 7.1.1 7.3 > Class not found in Teiid JON agent > ---------------------------------- > > Key: TEIID-1427 > URL: https://issues.jboss.org/browse/TEIID-1427 > Project: Teiid > Issue Type: Bug > Components: Jopr Plugin > Affects Versions: 7.1.1 > Reporter: Paul Nittel > Assignee: Ted Jones > Priority: Blocker > Fix For: 7.1.1, 7.3 > > Attachments: agent.log.zip > > > While trying to delete a VDB form my server, it was noticed the agent's log showed a missing class. > 2011-01-07 10:26:54,366 WARN [MeasurementManager.collector-1] (rhq.core.pc.measurement.MeasurementCollectorRunner)- Failure to collect measurement data for Resource[id=10301, type=Data Services, key=RuntimeEngineDeployer, name=Data Services, parent=sllxqm27:1099 production, version=7.1.1] - cause: java.lang.Exception:java.lang.NoClassDefFoundError: Could not initialize class org.teiid.adminapi.impl.SessionMetadataMapper -> java.lang.NoClassDefFoundError:Could not initialize class org.teiid.adminapi.impl.SessionMetadataMapper > Attaching the whole log file for further analysis. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 2 months

1
0
0 / 0

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

by Van Halbert (JIRA)

ODBC connection fails if the TeiidDriver is not registered. ----------------------------------------------------------- Key: TEIID-1429 URL: https://issues.jboss.org/browse/TEIID-1429 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

15 years, 2 months

1
0
0 / 0

[JBoss JIRA] Created: (TEIID-1148) Require the use of CXF

by Steve Hawkins (JIRA)

Require the use of CXF ---------------------- Key: TEIID-1148 URL: https://jira.jboss.org/browse/TEIID-1148 Project: Teiid Issue Type: Sub-task Components: XML Connector Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.1 Given the current direction of the JBoss WS project and that the other SOA projects do not have a specific implementation target, we can require the use of CXF. There are some additional installation steps needed that will be added to the admin guide / release notes. -- 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

15 years, 2 months

3
11
0 / 0

[JBoss JIRA] Created: (TEIID-1249) VDB scoped cached results not checked for access

by Steven Hawkins (JIRA)

VDB scoped cached results not checked for access ------------------------------------------------ Key: TEIID-1249 URL: https://jira.jboss.org/browse/TEIID-1249 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 7.1.1 VDB scoped cached result for user queries are not being validated against applicable roles. -- 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

15 years, 2 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1215) Add a performance tuning chapter to the admin guide

by Steve Hawkins (JIRA)

Add a performance tuning chapter to the admin guide --------------------------------------------------- Key: TEIID-1215 URL: https://jira.jboss.org/browse/TEIID-1215 Project: Teiid Issue Type: Feature Request Components: Documentation Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.1.1 The admin guide should have a performance chapter especially to cover buffer manager configuration. -- 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

15 years, 2 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1368) "Each" should be a parser keyword

by Steven Hawkins (JIRA)

"Each" should be a parser keyword --------------------------------- Key: TEIID-1368 URL: https://jira.jboss.org/browse/TEIID-1368 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.3 Each should be a reserved word in the parser. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 2 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1250) Allow usage of select expressions in order by, even with group by/distinct.

by Steven Hawkins (JIRA)

Allow usage of select expressions in order by, even with group by/distinct. --------------------------------------------------------------------------- Key: TEIID-1250 URL: https://jira.jboss.org/browse/TEIID-1250 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 7.2 We currently do not allow order by keys to reference anything other select aliases if a simple query uses distinct or group by. We could allow for the projected expressions to resolve as well. For example: select x as y from t group by x order by x instead of order by y Mondrian generates queries of this form, although I'm not sure if that's something that could be customized through Mondrian. -- 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

15 years, 2 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1409) NPE when trying to sum up from OUTER JOIN elements

by Wanja Pernath (JIRA)

NPE when trying to sum up from OUTER JOIN elements -------------------------------------------------- Key: TEIID-1409 URL: https://issues.jboss.org/browse/TEIID-1409 Project: Teiid Issue Type: Bug Components: Salesforce Connector Affects Versions: 7.1, 7.1.1 Environment: EAP 5.1 with CXF Reporter: Wanja Pernath Assignee: Steven Hawkins Following query results in a NPE: select PrimaryBusinessUnit, sum(SYBAmount), accountId 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, accountId note that SYBAmount is a calculated value. Also please note that a query like this: select PrimaryBusinessUnit, sum(oli.TotalPrice), accountId 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, accountId works as expected. LOGs: 2010-12-30 02:26:03,896 DEBUG [org.teiid.CONNECTOR] (Worker80_QueryProcessorQueue1859) 3tWvUX8+cunn.0.6.151 Create State 2010-12-30 02:26:03,897 DEBUG [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1860) 3tWvUX8+cunn.0.6.151 Processing NEW request: SELECT sfdc.salesforce.OpportunityLineItem.PricebookEntryId, sfdc.salesforce.Opportunity.AccountId, sfdc.salesforce.OpportunityLineItem.Year1Amount__c 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:26:03,897 DEBUG [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1860) 3tWvUX8+cunn.0.6.151 Obtained execution 2010-12-30 02:26:03,897 DEBUG [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1860) sfdc.3tWvUX8+cunn.3tWvUX8+cunn.0.6: Incoming Query: SELECT OpportunityLineItem.PricebookEntryId, Opportunity.AccountId, OpportunityLineItem.Year1Amount__c 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:26:03,898 DEBUG [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1860) sfdc.3tWvUX8+cunn.3tWvUX8+cunn.0.6: Executing Query: SELECT Opportunity.AccountId, (SELECT OpportunityLineItem.PricebookEntryId, OpportunityLineItem.Year1Amount__c 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:26:05,112 DEBUG [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1860) 3tWvUX8+cunn.0.6.151 Executed command 2010-12-30 02:26:05,112 DEBUG [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1860) 3tWvUX8+cunn.0.6.151 Sending results from connector 2010-12-30 02:26:05,112 DEBUG [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1860) SalesForce Object Name = Opportunity 2010-12-30 02:26:05,112 DEBUG [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1860) FieldCount = 2 2010-12-30 02:26:05,112 DEBUG [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1860) Field # 0 is AccountId 2010-12-30 02:26:05,112 DEBUG [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1860) Field # 1 is OpportunityLineItems 2010-12-30 02:26:05,112 ERROR [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1860) Connector worker process failed for atomic-request=3tWvUX8+cunn.0.6.151 java.lang.NullPointerException at org.teiid.translator.salesforce.execution.QueryExecutionImpl.setElementValueInColumn(QueryExecutionImpl.java:323) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.extractValuesFromElement(QueryExecutionImpl.java:276) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.extactJoinResults(QueryExecutionImpl.java:234) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.getObjectData(QueryExecutionImpl.java:216) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:199) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.getRow(QueryExecutionImpl.java:174) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:166) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:281) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:266) 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) 2010-12-30 02:26:05,115 ERROR [org.teiid.PROCESSOR] (Worker80_QueryProcessorQueue1861) Unexpected exception for request 3tWvUX8+cunn.0 java.lang.NullPointerException at org.teiid.translator.salesforce.execution.QueryExecutionImpl.setElementValueInColumn(QueryExecutionImpl.java:323) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.extractValuesFromElement(QueryExecutionImpl.java:276) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.extactJoinResults(QueryExecutionImpl.java:234) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.getObjectData(QueryExecutionImpl.java:216) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.loadBatch(QueryExecutionImpl.java:199) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.getRow(QueryExecutionImpl.java:174) at org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:166) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:281) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:266) 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) 2010-12-30 02:26:05,115 DEBUG [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1862) 3tWvUX8+cunn.0.6.151 Processing Close : SELECT sfdc.salesforce.OpportunityLineItem.PricebookEntryId, sfdc.salesforce.Opportunity.AccountId, sfdc.salesforce.OpportunityLineItem.Year1Amount__c 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:26:05,115 DEBUG [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1862) SynchQueryExecution.close() called 2010-12-30 02:26:05,115 DEBUG [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1862) 3tWvUX8+cunn.0.6.151 Closed execution 2010-12-30 02:26:05,115 DEBUG [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1862) 3tWvUX8+cunn.0.6.151 Remove State 2010-12-30 02:26:05,115 DEBUG [org.teiid.CONNECTOR] (Worker81_QueryProcessorQueue1862) 3tWvUX8+cunn.0.6.151 Closed connection -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 2 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1247) Passthrough Authentication on JDBC Connection not switching identities

by Brenton Camac (JIRA)

Passthrough Authentication on JDBC Connection not switching identities ---------------------------------------------------------------------- Key: TEIID-1247 URL: https://jira.jboss.org/browse/TEIID-1247 Project: Teiid Issue Type: Bug Components: Embedded Affects Versions: 7.1 Environment: Teiid: 7.1 JBoss: EAP 501 Java: 1.6.0_20 HotSpot 64-Bit Server VM 16.3-b01-279 (Apple Inc). Teiid Datasources deployed as Embedded XA Datasource. Reporter: Brenton Camac Assignee: Steven Hawkins When the Teiid datasource property 'PassthroughAuthentication' is enabled Teiid does not switch the identity on that connection when the caller's identity is changed. Such is typically the case when an existing connection is retrieved from the connection pool (datasource.getConnection() ) by a different caller identity. Teiid should switch the identity on that connection to the new caller's identity. This is described in the Client Developer's Guide (http://docs.jboss.org/teiid/7.1.0.Final/client-developers-guide/en-US/htm...) Section 1.2 - Datasource Connection in Table 1.2 / PassthroughAuthentication: "... Teiid also verifies that the same user is using this connection during the life of the connection. if it finds a different security context on the calling thread, it switches the identity on the connection, if the new user is also eligible to log in to Teiid otherwise connection fails to execute." When the identity isn't switched as it should be one caller can initiate a connection and another caller with a different identity will be presented to Teiid's authorization facility as the other caller, resulting in incorrect authorization decisions. -- 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

15 years, 2 months

3
5
0 / 0

[JBoss JIRA] Created: (TEIID-1103) Add ability to disable hostname verification on the server side for SSL connections

by Marc Shirley (JIRA)

Add ability to disable hostname verification on the server side for SSL connections ----------------------------------------------------------------------------------- Key: TEIID-1103 URL: https://jira.jboss.org/browse/TEIID-1103 Project: Teiid Issue Type: Feature Request Reporter: Marc Shirley Assignee: Steve Hawkins Should include the ability to disable hostname verification for SSL connections. -- 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

15 years, 2 months

3
11
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2011