July 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1608) TeiidComponentException from generated web service

by Scott Dawson (JIRA)

TeiidComponentException from generated web service -------------------------------------------------- Key: TEIID-1608 URL: https://issues.jboss.org/browse/TEIID-1608 Project: Teiid Issue Type: Bug Components: SOAP Services Affects Versions: 7.3 Environment: Runtime environment: JBoss AS 5.1, Teiid 7.3, JBossWS-CXF 3.2.1, MySQL 5, mysql-connector-java-5.1.10-bin.jar Development environment: Teiid Designer 7.3 installed into Eclipse Helios 3.6.2; SoapUI 2.5 as a test client Reporter: Scott Dawson Assignee: Steven Hawkins I'm using the 'Generate JBossWS-CXF War' feature of Teiid Designer to expose a MySQL table as a web service. Everything deploys normally and about half the time the web service works correctly, however, I often get the exception shown below when I call the service. It seems to be fairly random as to whether or not it works or throws the exception. Everything is running on one laptop including the client and the database. I'm attaching my Eclipse project, warfile and a more complete stack trace. See 'Steps to Reproduce' below for my development process and a description of the DB table. 17:46:20,833 SEVERE [org.teiid.soap] Exception in executeDataservice: {0} java.lang.Throwable: java.sql.SQLException: Unable to read data from the stream: [TeiidComponentException]Wrong type of data found or no data found; expecting streamable object from the buffer manager. at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:194) at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) at org.teiid.soap.provider.MySQL_local_user.invoke(MySQL_local_user.java:22) at org.teiid.soap.provider.MySQL_local_user.invoke(MySQL_local_user.java:15) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:166) at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:82) at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:55) at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:68) at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58) -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

3
6
0 / 0

[JBoss JIRA] Created: (TEIID-1637) In the Reference guide - Query Timeouts section - add a reference to the Client Developers guide

by Van Halbert (JIRA)

In the Reference guide - Query Timeouts section - add a reference to the Client Developers guide ------------------------------------------------------------------------------------------------ Key: TEIID-1637 URL: https://issues.jboss.org/browse/TEIID-1637 Project: Teiid Issue Type: Enhancement Components: Documentation Affects Versions: 7.4 Reporter: Van Halbert Assignee: Steven Hawkins Priority: Minor In the Reference guide - Query Timeouts section - add a reference to the Client Developers guide section of the URL Connection properties that talks about setting the QueryTimeOut. It talks about it, but just doesn't point you to where/how to do it. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1618) Designer (JBDS 4.1 CR1) not able to preview: NPE

by Paul Nittel (JIRA)

Designer (JBDS 4.1 CR1) not able to preview: NPE ------------------------------------------------ Key: TEIID-1618 URL: https://issues.jboss.org/browse/TEIID-1618 Project: Teiid Issue Type: Bug Components: Query Engine Environment: Fedora 14 x86_64, JBDS 4.1 CR1, Teiid 7.4 Final Reporter: Paul Nittel Assignee: Steven Hawkins I created a project and imported PartsSupplier from Oracle. I selected the PARTS table in the Model Explorer tree and clicked the Preview button. In return, I received exceptions: [AdminComponentException]Remote org.teiid.adminapi.AdminComponentException: Failed to process template. 1 [AdminComponentException]Remote org.teiid.adminapi.AdminComponentException: Failed to process template. 2 [AdminComponentException]Remote org.teiid.adminapi.AdminComponentException: Failed to process template. 3 [RuntimeException]Remote java.lang.RuntimeException: Failed to process template. 4 [RuntimeException]Remote java.lang.RuntimeException: org.jboss.deployers.client.spi.IncompleteDeploymentException: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS): *** DEPLOYMENTS IN ERROR: Name -> Error ... and ... org.teiid.jdbc.TeiidSQLException: Remote org.teiid.client.security.LogonException: VDB "PREVIEW_f74d4e6a-9fdb-4b99-8539-27819cf6130d_SeaAreWon_project" version "latest" does not exist. at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69) at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:56) at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107) The whole Designer and server logs are attached. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

3
19
0 / 0

[JBoss JIRA] Created: (TEIID-1634) For file connector-based queries, please provide a DEBUG warning if no files are found

by Paul Nittel (JIRA)

For file connector-based queries, please provide a DEBUG warning if no files are found -------------------------------------------------------------------------------------- Key: TEIID-1634 URL: https://issues.jboss.org/browse/TEIID-1634 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Paul Nittel Assignee: Steven Hawkins I am writing a query against an XML file. I have a file connector referenced by a dynamic VDB. As luck would have it, I used an incorrect directory when the data source was defined. When the query is executed, it appears as though I have no results. (I actually have no data!) After fiddling with the XML for a while, I realized the error, corrected it, and went merrily on my way. Had there been some kind of notification that there were no files to process, I could have saved a half-hour. So, if a DEBUG message were put in the log file, it may help someone else (or me again) down the road. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

4
10
0 / 0

[JBoss JIRA] Created: (TEIID-1689) Load internal mateirlized view cached contents when node joins the cluster

by Ramesh Reddy (JIRA)

Load internal mateirlized view cached contents when node joins the cluster -------------------------------------------------------------------------- Key: TEIID-1689 URL: https://issues.jboss.org/browse/TEIID-1689 Project: Teiid Issue Type: Feature Request Components: Server Affects Versions: 7.4.1 Reporter: Ramesh Reddy Assignee: Ramesh Reddy When IMV loaded at Node 1, and the contents of the that IMV will be loaded at Node 2 only when the query is issued against it. Then user incurs the wait time to load the contents from Node 1. If in the situation if Node 1, went down before the query to Node 2, in that case node 2 has to fetch from the source and cached contents will be lost. This can be avoided by hot loading the all the cached contents at the start of the node from other nodes. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

2
5
0 / 0

[JBoss JIRA] Created: (TEIID-1615) Add features to support relate planning

by Steven Hawkins (JIRA)

Add features to support relate planning --------------------------------------- Key: TEIID-1615 URL: https://issues.jboss.org/browse/TEIID-1615 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4.1 MetaMatrix had an xml relate planner feature that can be reproduced with standard xml processing with additional features. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
7
0 / 0

[JBoss JIRA] Created: (TEIID-1681) Limit not working as expected

by Gaurav Chaudhary (JIRA)

Limit not working as expected ----------------------------- Key: TEIID-1681 URL: https://issues.jboss.org/browse/TEIID-1681 Project: Teiid Issue Type: Bug Components: JDBC Driver Affects Versions: 7.3 Reporter: Gaurav Chaudhary Assignee: Steven Hawkins select CHORUS_B."ID", CHORUS_B."ACCESS_MODE", CHORUS_B."USER_ID", CHORUS_B."CREATED_ON", CHORUS_B."NOTE",'chorusdata.note' as "__objecttype__" from (select * from chorus_notes.RETRIEVE_NOTES where OBJECT_PKEY = xmlserialize(xmlelement("demodata.rule", XMLATTRIBUTES(cast('name 1' as String) as "name",cast('sysid 0' as String) as "system",cast('user 1000' as String) as "user")) as String)) as CHORUS_B LIMIT 50 This query is not returning correct results unless we remove Limit from this. If we include Limit over here, it interchanges the columns and returning incorrect data. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

2
6
0 / 0

[JBoss JIRA] Created: (TEIID-1465) Join between char and varchar

by Claudio Venturini (JIRA)

Join between char and varchar ----------------------------- Key: TEIID-1465 URL: https://issues.jboss.org/browse/TEIID-1465 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.3 Environment: Teiid 7.3 deployed on Jboss AS 5.1.0 GA running on Ubuntu Server 10.04 LTS, MySQL 5.1.51 running on the same machine as JBoss, SQL Server 2000 Standard SP4 running on Windows Server 2003 Reporter: Claudio Venturini Assignee: Steven Hawkins Joins between char and varchar fields fail. Suppose to have a table T1 with a field A, declared as char(10), and a table T2 with a field B, declared as varchar(10). Suppose that the two tables have the following data. *T1*: ||A|| |ML0001| *T2*: ||B|| |ML0001| When performing a INNER JOIN with the condition {{T1.A = T2.B}} the result set is empty, even if the two record match correctly. This happens when the two base tables refer to two different sources, because if they are in the same source Teiid pushes the join to the source, which computes it correctly. I think the problem is in the comparison of the two strings. I have the table T1 in SQL Server 2000, and the table T2 in MySQL 5.1. If one asks SQL Server to convert the string to bytes, the result is {{0x4D4C3030303120202020}}, because the string is filled with (invisible) blanks in order to reach the limit of 10 characters. Note that if one asks for the length of that string, SQL Server states (correctly) that it is 6 characters. The string in MySQL is a VARCHAR(10), so its conversion to binary is {{0x4D4C30303031}}. I think that Teiid compares the two binary strings in their entire length. That comparison fails, and no match is found. The problem remains even if the table T1 is placed in MySQL, and T2 in SQL Server (the opposite situation). I also verified that the problem exists either when querying the source models or view models built over them. *Workaround:* A workaround exists but it is too complex (IMHO). I haven't tested it with many records, but I think it will slow down performances considerably. It consists in casting the string from char to varchar, and then trimming it (with RTRIM() and LTRIM() because SQL Server doesn't support TRIM()). So the join condition is: {noformat} RTRIM(LTRIM(CAST(T1.A AS VARCHAR))) = T2.B {noformat} -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

2
8
0 / 0

[JBoss JIRA] Created: (TEIID-1613) Cannot define an implicit temp table with columns and a query value expression

by Steven Hawkins (JIRA)

Cannot define an implicit temp table with columns and a query value expression ------------------------------------------------------------------------------ Key: TEIID-1613 URL: https://issues.jboss.org/browse/TEIID-1613 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4.1 I believe this may have been a regression from TEIID-1177. "insert into #x select 1 as y" works, but "insert into #x (y) select 1 as y" does not. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1593) Creating a temp table gets error that Cannot create temporary table "dddd". A table with the same name already exists.

by Paul Nittel (JIRA)

Creating a temp table gets error that Cannot create temporary table "dddd". A table with the same name already exists. ---------------------------------------------------------------------------------------------------------------------- Key: TEIID-1593 URL: https://issues.jboss.org/browse/TEIID-1593 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Paul Nittel Assignee: Steven Hawkins Logging into a VDB using SQuirreL, I entered: create local temporary table dddd (id string, name string) What I received was: Cannot create temporary table "dddd". A table with the same name already exists. There appears to be no way to create a temporary table, using this method. SELECT * INTO #temp from ... does work, however. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

2
2
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2011