April 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3480) External Materialization status

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3480?page=com.atlassian.jira.plugin... ] Kylin Soong resolved TEIID-3480. -------------------------------- Resolution: Done Change the UI made this resolved. > External Materialization status > ------------------------------- > > Key: TEIID-3480 > URL: https://issues.jboss.org/browse/TEIID-3480 > Project: Teiid > Issue Type: Enhancement > Components: Server > Affects Versions: 8.4 > Reporter: Ramesh Reddy > Assignee: Kylin Soong > Fix For: 9.0 > > > When external materialization is configured with "STATUS" table, then Teiid should expose those stats over CLI and in the web-console. Currently the internal materialization does show status, need to expand to the external matviews. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4146) Using JDG Library Mode, unable to perform insert (

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4146?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4146: --------------------------------------- Van did you want me to work this? > Using JDG Library Mode, unable to perform insert ( > -------------------------------------------------- > > Key: TEIID-4146 > URL: https://issues.jboss.org/browse/TEIID-4146 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Critical > > Trying to run the JDG local cache quickstart, get the following error when trying to perform an insert: > 15:09:34,027 WARN [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue12) TEIID30020 Processing exception for request O25SlCY41bD5.6 'TEIID30492 Element StockCache.Stock.StockObject of StockCache.Stock is neither nullable nor has a default value. A value must be specified in the insert.'. Originally QueryValidatorException Request.java:330. Enable more detailed logging to see the entire stacktrace. > The issue is because the StockObject column is set to be NullType.unknown, instead of NullType.Nullable. This is because the metadata processor in the translator-object is setting it incorrectly. > Workaround: > - Using Teiid Designer to import the source model and change the null type. > - use dynamic vdb and define the DDL metadata to set the null type. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4146) Using JDG Library Mode, unable to perform insert (

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4146?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4146: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1327752 Bugzilla Update: Perform > Using JDG Library Mode, unable to perform insert ( > -------------------------------------------------- > > Key: TEIID-4146 > URL: https://issues.jboss.org/browse/TEIID-4146 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Critical > > Trying to run the JDG local cache quickstart, get the following error when trying to perform an insert: > 15:09:34,027 WARN [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue12) TEIID30020 Processing exception for request O25SlCY41bD5.6 'TEIID30492 Element StockCache.Stock.StockObject of StockCache.Stock is neither nullable nor has a default value. A value must be specified in the insert.'. Originally QueryValidatorException Request.java:330. Enable more detailed logging to see the entire stacktrace. > The issue is because the StockObject column is set to be NullType.unknown, instead of NullType.Nullable. This is because the metadata processor in the translator-object is setting it incorrectly. > Workaround: > - Using Teiid Designer to import the source model and change the null type. > - use dynamic vdb and define the DDL metadata to set the null type. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4146) Using JDG Library Mode, unable to perform insert (

by Van Halbert (JIRA)

Van Halbert created TEIID-4146: ---------------------------------- Summary: Using JDG Library Mode, unable to perform insert ( Key: TEIID-4146 URL: https://issues.jboss.org/browse/TEIID-4146 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.5 Reporter: Van Halbert Assignee: Steven Hawkins Priority: Critical Trying to run the JDG local cache quickstart, get the following error when trying to perform an insert: 15:09:34,027 WARN [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue12) TEIID30020 Processing exception for request O25SlCY41bD5.6 'TEIID30492 Element StockCache.Stock.StockObject of StockCache.Stock is neither nullable nor has a default value. A value must be specified in the insert.'. Originally QueryValidatorException Request.java:330. Enable more detailed logging to see the entire stacktrace. The issue is because the StockObject column is set to be NullType.unknown, instead of NullType.Nullable. This is because the metadata processor in the translator-object is setting it incorrectly. Workaround: - Using Teiid Designer to import the source model and change the null type. - use dynamic vdb and define the DDL metadata to set the null type. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4130) Prevent blocked exceptions from being thrown in AccessNode open

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4130?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4130: ------------------------------------------------ jolee(a)redhat.com changed the Status of [bug 1326832|https://bugzilla.redhat.com/show_bug.cgi?id=1326832] from NEW to MODIFIED > Prevent blocked exceptions from being thrown in AccessNode open > --------------------------------------------------------------- > > Key: TEIID-4130 > URL: https://issues.jboss.org/browse/TEIID-4130 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.13.4 > > > Having the access node block in open can lead to unintended consequences in parent nodes. For example with tuplesource caching it can create additional tuplesource instances such the cached source is closed prematurely (as it thinks that all readers have been satisfied). This results in exceptions similar to: > TEIID30019 Unexpected exception for request 2TLgULsEBZvO.8: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null > ... > at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:286) \[teiid-engine-8.7.5.6_2-redhat-1.jar:8.7.5.6_2-redhat-1] > at org.teiid.dqp.internal.process.TupleSourceCache$CopyOnReadTupleSource.nextTuple(TupleSourceCache.java:103) \[teiid-engine-8.7.5.6_2-redhat-1.jar:8.7.5.6_2-redhat-1] > ... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4145) JDG Local Cache Quickstart deployed configuration file name doesn't match the resource-adapter

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4145?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4145: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1327748 Bugzilla Update: Perform > JDG Local Cache Quickstart deployed configuration file name doesn't match the resource-adapter > ----------------------------------------------------------------------------------------------- > > Key: TEIID-4145 > URL: https://issues.jboss.org/browse/TEIID-4145 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > > The jdg local cache resource-adapter fails to start due to a missing file. > In the jdg-local-cache quickstart, the configuration file (infinispan_persistent_config.xml) that's deployed does not match the name of the "ConfigurationFilenamForLocalCache" property that's set in the example resource-adapter (docs/teiid/datasources/infinispan/infinispan-ds.xml). > Either, the property name in the resource-adapter can be changed or rename the config file. > I plan on renaming the file in the quickstart to be infinispan.xml. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4145) JDG Local Cache Quickstart deployed configuration file name doesn't match the resource-adapter

by Van Halbert (JIRA)

Van Halbert created TEIID-4145: ---------------------------------- Summary: JDG Local Cache Quickstart deployed configuration file name doesn't match the resource-adapter Key: TEIID-4145 URL: https://issues.jboss.org/browse/TEIID-4145 Project: Teiid Issue Type: Bug Components: Quick Starts Reporter: Van Halbert Assignee: Van Halbert Priority: Minor The jdg local cache resource-adapter fails to start due to a missing file. In the jdg-local-cache quickstart, the configuration file (infinispan_persistent_config.xml) that's deployed does not match the name of the "ConfigurationFilenamForLocalCache" property that's set in the example resource-adapter (docs/teiid/datasources/infinispan/infinispan-ds.xml). Either, the property name in the resource-adapter can be changed or rename the config file. I plan on renaming the file in the quickstart to be infinispan.xml. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4134) Oracle requires column alias list when using recursive CTE

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4134?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4134. ----------------------------------- Fix Version/s: 9.0 8.12.5 Resolution: Done Applied Andrej's pull request with minor changes. If we need to we can go back and refine the support version to earlier than 11.2.0.4 > Oracle requires column alias list when using recursive CTE > ---------------------------------------------------------- > > Key: TEIID-4134 > URL: https://issues.jboss.org/browse/TEIID-4134 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.12.x > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5 > > > Running a recursive common table expression query against an Oracle source removes the columns alias list, which causes {noformat}ORA-32039: recursive WITH clause must have column alias list{noformat} > Note that there might be an issue with some specific versions of Oracle 11g, the columns alias list is required 11.2.0.4, but might not be in 11.2.0.2. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4119) ODBC reports tables as views ('relkind' column in pg_catalog.pg_class) when it should report as table type

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4119?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4119. ----------------------------------- Resolution: Incomplete Description Marking as incomplete description until we get more information. > ODBC reports tables as views ('relkind' column in pg_catalog.pg_class) when it should report as table type > ----------------------------------------------------------------------------------------------------------- > > Key: TEIID-4119 > URL: https://issues.jboss.org/browse/TEIID-4119 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 7.7 > Reporter: Marc Shirley > Assignee: Steven Hawkins > > Virtual tables are reported as a view with value "v" in 'relkind' column in pg_catalog.pg_class. This should be reported as a table in some cases, so we need to be able to toggle the metadata to report as the type the user needs. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4129) Wrong results with cross model join on 2 varchar fields

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4129?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4129: --------------------------------------- For future reference, it would best just to provide a vdb.xml or vdb zip and the ddl for the h2 sources. And a query plan would also be helpful. Providing low level artifacts would be best accompanied by a java class that demonstrates the reproduction using embedded. In this case what I can infer here is that the order bys are being pushed to the source and the sort order is based upon the case insensitive ordering and not the expected default utf-8 ordering. The workarounds are to either disable order by pushdown for h2, or you can set the system property org.teiid.requireTeiidCollation=true and set the translator property CollationLocale to any value that doesn't match org.teiid.collationLocale. The latter is more targeted as only string orderings will not be pushed. There is currently not a mechanism to do this on a per table basis. > Wrong results with cross model join on 2 varchar fields > ------------------------------------------------------- > > Key: TEIID-4129 > URL: https://issues.jboss.org/browse/TEIID-4129 > Project: Teiid > Issue Type: Bug > Reporter: Mark Tawk > Assignee: Steven Hawkins > Attachments: H2 DBs.zip, MetaDataStores.zip > > > I'm using Teiid 8.11.3 with H2 translator. > I'm joining 2 h2 tables from 2 different teiid models linked on varchar fields. > the query result is retuning empty values from the joined table even though the joined values are identical. > You find attached a zip file containing 2 h2 DBs for a simplified example > Here is the query used: > _select "Customer"."City" as "Customer_City","Customer"."CustomerID" as "Customer_CustomerID","City"."City" as "City_City","City"."CityID" as "City_CityID" > from "db2"."Customer" "Customer" > LEFT JOIN "db1"."City" "City" ON "Customer"."City" = "City"."City"_ > Note that if the 2 tables are in the same model, the query return correct results. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 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 April 2016