January 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1265) Document the replacement approach for credentail maps

by Steven Hawkins (JIRA)

Document the replacement approach for credentail maps ----------------------------------------------------- Key: TEIID-1265 URL: https://jira.jboss.org/browse/TEIID-1265 Project: Teiid Issue Type: Quality Risk Components: Misc. Connectors Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.1.1 The client based credential map feature was removed from the project. There should be a replacement approach documented for JBossAS where source connections can have more than 1 set of static credentials with appropriate pooling. -- 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-1370) Error Code:107 Message:'The column prefix 'custsale' does not match with a table name or alias name used in the query - But query is valid

by Paul Nittel (JIRA)

Error Code:107 Message:'The column prefix 'custsale' does not match with a table name or alias name used in the query - But query is valid ------------------------------------------------------------------------------------------------------------------------------------------ Key: TEIID-1370 URL: https://jira.jboss.org/browse/TEIID-1370 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1.1 Environment: Fedora 12, OpenJDK Server VM (build 14.0-b16), SOA-P 5.1 ER4 Reporter: Paul Nittel Assignee: Steven Hawkins I ran into this executing the E2E TPCR Text Metadata Test Script and it can be reproduced by focusing on query #22. A model project set and other necessary artifacts will be attached. The whole error, from SQuirreL, is: Error: Error Code:107 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:107 Message:Error Code:107 Message:'The column prefix 'custsale' does not match with a table name or alias name used in the query.' error executing statement(s): [Prepared Values: ['13', '17', '18', '23', '29', '30', '31', 0E-15, '13', '17', '18', '23', '29', '30', '31'] SQL: SELECT TOP 100 v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM CUSTOMER g_0 WHERE left(g_0.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?) AND g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM CUSTOMER g_1 WHERE g_1.C_ACCTBAL > ? AND left(g_1.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?)) AND NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM ORDERS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY))) v_0 GROUP BY v_0.c_0 ORDER BY custsale.c_0] The executed query is: select * from vTpcr.Q22 ORDER BY cntrycode -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 2 months

2
5
0 / 0

[JBoss JIRA] Created: (TEIID-1254) Detect session scoped temp tables in setting determism

by Steven Hawkins (JIRA)

Detect session scoped temp tables in setting determism ------------------------------------------------------ Key: TEIID-1254 URL: https://jira.jboss.org/browse/TEIID-1254 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.1.1 The usage of session scoped temp tables should be detected to determine the determinism level of a command/results. -- 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-1104) Teiid engine will be clusterable.

by Van Halbert (JIRA)

Teiid engine will be clusterable. --------------------------------- Key: TEIID-1104 URL: https://jira.jboss.org/browse/TEIID-1104 Project: Teiid Issue Type: Feature Request Components: Server Reporter: Van Halbert Assignee: Steve Hawkins The Teiid engine must support the ability to be clustered. -- 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

4
10
0 / 0

[JBoss JIRA] Resolved: (TEIID-967) Asynchronous messaging API

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-967?page=com.atlassian.jira.plugin.... ] Steven Hawkins resolved TEIID-967. ---------------------------------- Resolution: Incomplete Description There isn't enough detail here and simple integration of teiid as a source is already covered by the ESB project under jdbc. Any ESB as a source integration docs will be added as part of TEIID-403. > Asynchronous messaging API > -------------------------- > > Key: TEIID-967 > URL: https://issues.jboss.org/browse/TEIID-967 > Project: Teiid > Issue Type: Feature Request > Components: Documentation > Reporter: Marc Shirley > Assignee: Jerry Helbling > Priority: Minor > -- 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] Resolved: (TEIID-1439) Adminshell/API - sequence of datasource creation/VDB deployment and queries results in deployment error

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-1439?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-1439. --------------------------------- Resolution: Done The Materialization and Result Set caches both defined as resultset cache type, however in the JBoss cache, cache type was being used also as cache location, thus they shared same cache location. However, one defined as Expiration cache and another as LRU, thus when the cache location accessed as LRU the above issue re-surfaced, since the expiration key still exists in keyset. To correct the issue, the cache type, location are decoupled such location can be configured independent of the type. > Adminshell/API - sequence of datasource creation/VDB deployment and queries results in deployment error > ------------------------------------------------------------------------------------------------------- > > Key: TEIID-1439 > URL: https://issues.jboss.org/browse/TEIID-1439 > Project: Teiid > Issue Type: Bug > Components: AdminApi, Server > Affects Versions: 7.1.1 > Reporter: Len DiMaggio > Assignee: Ramesh Reddy > Priority: Blocker > Fix For: 7.1.1, 7.3 > > Attachments: DeployTest.groovy, server.log_DEBUG_deploy, server.log_TRACE_deploy, weather-ds.xml, weather-vdb.xml > > > See attached standalone adminshell/adminAPI test - this is a new problem in ER7. > A sequence of 2 iterations of: datasource creation/VDB deployment and queries results in this error: > DEPLOYMENTS IN ERROR: > Deployment "vfsfile:/jboss/local/51_ER7/jboss-soa-p-5/jboss-as/server/production/deploy/weather-vdb.xml" is in error due to the following reason(s): java.lang.ClassCastException: java.lang.String cannot be cast to org.teiid.dqp.internal.process.SessionAwareCache$CacheID -- 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-1457) Processing errors after the first batch has been returned may not be reported

by Van Halbert (JIRA)

Processing errors after the first batch has been returned may not be reported ----------------------------------------------------------------------------- Key: TEIID-1457 URL: https://issues.jboss.org/browse/TEIID-1457 Project: Teiid Issue Type: Bug Components: JDBC Driver Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Processing errors after the first batch has been returned may not be reported because the client is not checking for them in requests for more batches. -- 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] Commented: (TEIID-1454) Teiid Web Services: After redeploying VDB, Web services gets "Specified session is invalid" exception - Required restarting server

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIID-1454?page=com.atlassian.jira.plugin... ] Ted Jones commented on TEIID-1454: ---------------------------------- Adding a test query (select 1) to the VDB data source fixes this issue. > Teiid Web Services: After redeploying VDB, Web services gets "Specified session is invalid" exception - Required restarting server > ----------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-1454 > URL: https://issues.jboss.org/browse/TEIID-1454 > Project: Teiid > Issue Type: Bug > Components: SOAP Services > Affects Versions: 7.1.1 > Reporter: Paul Nittel > Assignee: Ted Jones > > I had deployed a VDB and WAR, but there was an error in the transformation, so executing a web service query failed. After correcting the transformation and re-deploying the VDB, the Web service got an error. Checking the server log showed the session was invalid. > Ted and I believe this should have recovered without the exception. > I'll attach the applicable section from the server log. -- 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] Commented: (TEIID-1454) Teiid Web Services: After redeploying VDB, Web services gets "Specified session is invalid" exception - Required restarting server

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-1454?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-1454: ------------------------------------- It looks like the data source backed by the -ds.xml file and does not check the validity of the connections when they are grabbed from the pool. In the mean while user deleted the old vdb and deployed the same version of the vdb in the same container, which invalidated all the sessions that are associated with the deleted VDB. This is expected behaviour. > Teiid Web Services: After redeploying VDB, Web services gets "Specified session is invalid" exception - Required restarting server > ----------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-1454 > URL: https://issues.jboss.org/browse/TEIID-1454 > Project: Teiid > Issue Type: Bug > Components: SOAP Services > Affects Versions: 7.1.1 > Reporter: Paul Nittel > Assignee: Ted Jones > > I had deployed a VDB and WAR, but there was an error in the transformation, so executing a web service query failed. After correcting the transformation and re-deploying the VDB, the Web service got an error. Checking the server log showed the session was invalid. > Ted and I believe this should have recovered without the exception. > I'll attach the applicable section from the server log. -- 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] Commented: (TEIID-1454) Teiid Web Services: After redeploying VDB, Web services gets "Specified session is invalid" exception - Required restarting server

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1454?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1454: --------------------------------------- what type of connection was this using? An embedded datasource with pass through authentication, or something else? > Teiid Web Services: After redeploying VDB, Web services gets "Specified session is invalid" exception - Required restarting server > ----------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-1454 > URL: https://issues.jboss.org/browse/TEIID-1454 > Project: Teiid > Issue Type: Bug > Components: SOAP Services > Affects Versions: 7.1.1 > Reporter: Paul Nittel > Assignee: Ted Jones > > I had deployed a VDB and WAR, but there was an error in the transformation, so executing a web service query failed. After correcting the transformation and re-deploying the VDB, the Web service got an error. Checking the server log showed the session was invalid. > Ted and I believe this should have recovered without the exception. > I'll attach the applicable section from the server log. -- 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

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2011