April 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-1935) TransformationMetadata.getXMLSchemas relative paths fail on windows

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-1935: ------------------------------------- Summary: TransformationMetadata.getXMLSchemas relative paths fail on windows Key: TEIID-1935 URL: https://issues.jboss.org/browse/TEIID-1935 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.6 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.7 The use of File logic makes getting the parent path dependent on the platform. The logic is only currently correct for filesystems that use the / separator. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

1
2
0 / 0

[JBoss JIRA] (TEIID-1972) Non-stagable cardinality dependent aggregate should prevent the creation of a staged grouping

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-1972: ------------------------------------- Summary: Non-stagable cardinality dependent aggregate should prevent the creation of a staged grouping Key: TEIID-1972 URL: https://issues.jboss.org/browse/TEIID-1972 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.7.1 The use of a stagable and non-stagable cardinality dependent aggregate (e.g. count(x) and array_agg) over a join will still result in a staged grouping being created that can change the results. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

1
2
0 / 0

[JBoss JIRA] (TEIID-1969) Missing message for key JDBCQueryExecution.Error_executing_query__1

by Mark Drilling (JIRA)

Mark Drilling created TEIID-1969: ------------------------------------ Summary: Missing message for key JDBCQueryExecution.Error_executing_query__1 Key: TEIID-1969 URL: https://issues.jboss.org/browse/TEIID-1969 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.0 Reporter: Mark Drilling Assignee: Steven Hawkins Priority: Minor Ran into the following missing message when testing Teiid 8.0 Beta1 Code:1146 Message:TEIID11008:<Missing message for key "JDBCQueryExecution.Error_executing_query__1" in: org.teiid.translator.jdbc.i18n> 1 [MySQLSyntaxErrorException]Table 'test12Mar.ACCOUNT' doesn't exist at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:90) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:235) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:355) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:144) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:141) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1751) Scalar function reference issues

by Steven Hawkins (JIRA)

Scalar function reference issues -------------------------------- Key: TEIID-1751 URL: https://issues.jboss.org/browse/TEIID-1751 Project: Teiid Issue Type: Bug Components: Documentation Affects Versions: 7.4.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4.1, 7.6 Generic issue for on-going corrections/improvements to scalar function docs. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

2
3
0 / 0

[JBoss JIRA] (TEIID-1976) Metadata TYPE_NAME value is null for String Columns

by Mark Drilling (JIRA)

Mark Drilling created TEIID-1976: ------------------------------------ Summary: Metadata TYPE_NAME value is null for String Columns Key: TEIID-1976 URL: https://issues.jboss.org/browse/TEIID-1976 Project: Teiid Issue Type: Bug Components: Common Affects Versions: 8.0 Reporter: Mark Drilling Assignee: Ramesh Reddy The metadata TYPE_NAME value for string datatypes is apparently returning null. I am running against a JBoss AS7.1Final server with Teiid 8.0Beta2. My application (openshift web client) establishes connection from a DataSource, eg connection = dataSource.getConnection(), then resultSet = connection.getMetaData().getColumns(); when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null for string types. Other types seem to return a correct value. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

3
13
0 / 0

[JBoss JIRA] (TEIID-1978) SalesForce getDeleted function does not return deleted objects list

by Paul Nittel (JIRA)

Paul Nittel created TEIID-1978: ---------------------------------- Summary: SalesForce getDeleted function does not return deleted objects list Key: TEIID-1978 URL: https://issues.jboss.org/browse/TEIID-1978 Project: Teiid Issue Type: Bug Components: Salesforce Connector Reporter: Paul Nittel Assignee: Steven Hawkins While testing the SalesForce connector, I noticed the getDeleted function was not returning any results, when there should be. See Steps to Reproduce. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

2
5
0 / 0

[JBoss JIRA] (TEIID-1944) After changing model to replace primary key with a unique key, the deployment of the vdb errors saying PrimaryKey does not exist

by Van Halbert (JIRA)

Van Halbert created TEIID-1944: ---------------------------------- Summary: After changing model to replace primary key with a unique key, the deployment of the vdb errors saying PrimaryKey does not exist Key: TEIID-1944 URL: https://issues.jboss.org/browse/TEIID-1944 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.4.1 Reporter: Van Halbert Assignee: Steven Hawkins Attachments: dummy-ds.xml, server.log, Trade.vdb In designer, I removed a primary key and replaced it with a unique key, and changed the foreign key to now reference the unique key, and all built with no errors. When deploying vdb to server, you see this exception (partial, see attachment for full log): Caused by: mmuuid:15f67b60-e387-4092-bbc5-0b7726585f52 PrimaryKey does not exist. at org.teiid.metadata.index.IndexMetadataFactory.getPrimaryKey(IndexMetadataFactory.java:353) at org.teiid.metadata.index.IndexMetadataFactory.getTables(IndexMetadataFactory.java:295) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

2
6
0 / 0

[JBoss JIRA] (TEIID-1959) Add a way to exclude tables/procedures from JDBC import

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-1959: ------------------------------------- Summary: Add a way to exclude tables/procedures from JDBC import Key: TEIID-1959 URL: https://issues.jboss.org/browse/TEIID-1959 Project: Teiid Issue Type: Enhancement Components: JDBC Connector Affects Versions: 7.7 Reporter: Steven Hawkins Assignee: Steven Hawkins The JDBC importer provides a simplistic pass-through for table/procedure inclusion, but that can make it cumbersome to exclude a small subset of tables/procedures. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

1
3
0 / 0

[JBoss JIRA] (TEIID-1961) A translator override that is not used by a physical model will cause an exception on the server when the vdb is deployed

by Van Halbert (JIRA)

Van Halbert created TEIID-1961: ---------------------------------- Summary: A translator override that is not used by a physical model will cause an exception on the server when the vdb is deployed Key: TEIID-1961 URL: https://issues.jboss.org/browse/TEIID-1961 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.4.1 Reporter: Van Halbert Assignee: Steven Hawkins A previously created translator override was not associated with any physical model during the vdb development process. However, the following error occurred on the server when the vdb was deployed: org.jboss.deployers.spi.DeploymentException: The parent translator defined not found in configuration "vfszip:/Users/vhalbert/RedHat/platforms/soa/5.3/jboss-soa-p-5-object/jboss-as/server/default/deploy/Trade.vdb/" at org.teiid.deployers.VDBDeployer.deploy(VDBDeployer.java:102) at org.teiid.deployers.VDBDeployer.deploy(VDBDeployer.java:60) >From a usability standpoint, the user shouldn't need to remove translator overrides that are not currently used because they represent a what-if scenario the user is trying and may contain override info they are not done with. The server should just ignore those that are not used. Also, it would be good if the error message indicated the name of the translator/override it was having issues with. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

2
7
0 / 0

[JBoss JIRA] (TEIID-1893) TeiidException when executing SELECT subquery with more than 2 UNIONs

by Andriy Rokhmanov (Created) (JIRA)

TeiidException when executing SELECT subquery with more than 2 UNIONs --------------------------------------------------------------------- Key: TEIID-1893 URL: https://issues.jboss.org/browse/TEIID-1893 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.6 Environment: Windows 7, JBoss 5.1.0.GA, java version "1.6.0_22" 64 bit Reporter: Andriy Rokhmanov Assignee: Steven Hawkins Exception: org.teiid.core.TeiidException happens after executing select statement #1, but works fine on #2 and #3. The execution plan for problematic statement attached. 1. Problematic SQL Statement: SELECT T.ROLE_NAME as ROLE_NAME, T.SCHEMA_NAME as SCHEMA_NAME, T.INSTALL_STATUS as INSTALL_STATUS FROM ( SELECT ROLE_NAME, 'demodata_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from vantage_chorus_metadata.chorus_role ) AS T, chorus_license.RL_LICENSE as L WHERE T.ROLE_NAME = L.ROLE_NAME AND T.install_status = true; 2. This SQL statement works fine (the difference between #1 and #2 is in final 'AND...' clause): SELECT T.ROLE_NAME as ROLE_NAME, T.SCHEMA_NAME as SCHEMA_NAME, T.INSTALL_STATUS as INSTALL_STATUS FROM ( SELECT ROLE_NAME, 'demodata_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from vantage_chorus_metadata.chorus_role ) AS T, chorus_license.RL_LICENSE as L WHERE T.ROLE_NAME = L.ROLE_NAME; 3. This SQL statement also works fine (the difference between #1 and #3 is only two UNIONs included out of three, does not matter which ones) SELECT T.ROLE_NAME as ROLE_NAME, T.SCHEMA_NAME as SCHEMA_NAME, T.INSTALL_STATUS as INSTALL_STATUS FROM ( SELECT ROLE_NAME, 'security_cia_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' as SCHEMA_NAME, INSTALL_STATUS from vantage_chorus_metadata.chorus_role ) AS T, chorus_license.RL_LICENSE as L WHERE T.ROLE_NAME = L.ROLE_NAME AND T.install_status = true; -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 9 months

5
4
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2012