November 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4430) Update the Olingo library to 4.3

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4430?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4430: ------------------------------------------------ Debi Rieden <drieden(a)redhat.com> changed the Status of [bug 1506570|https://bugzilla.redhat.com/show_bug.cgi?id=1506570] from NEW to CLOSED > Update the Olingo library to 4.3 > -------------------------------- > > Key: TEIID-4430 > URL: https://issues.jboss.org/browse/TEIID-4430 > Project: Teiid > Issue Type: Task > Components: OData > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Labels: CR1 > Fix For: 9.1, 8.12.x-6.4 > > > Upgrade the Olingo to 4.3 version. This is currently in beta but will be in final by the time 9.1 releases. Also this is required for $expand and future data aggregation capabilities. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5139) Reached maximum thread count "10" for worker pool "async-teiid-threads"

by Pedro Inácio (JIRA)

Pedro Inácio created TEIID-5139: ----------------------------------- Summary: Reached maximum thread count "10" for worker pool "async-teiid-threads" Key: TEIID-5139 URL: https://issues.jboss.org/browse/TEIID-5139 Project: Teiid Issue Type: Bug Affects Versions: 10.0 Environment: Teiid 10.0.0 Wildfly 11 RHEL 7.2 Reporter: Pedro Inácio Assignee: Steven Hawkins Cannot configure system to remove the following warning: *TEIID30009 Reached maximum thread count "10" for worker pool "async-teiid-threads" with a queue size high of "44". Queued work waited 500 ms prior to executing. To avoid queuing of work you may consider increasing "max-threads" or decreasing the "max-active-plans" in the "standalone-teiid.xml" file.* Already tried what is explained [here|https://developer.jboss.org/thread/275761] but applied for the standalone mode without any success. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5137) SystemAdmin.usage column dependency issue

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5137?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5137. ----------------------------------- Fix Version/s: 10.0.1 9.3.5 10.1 Resolution: Done Corrected the schema and name columns for column entries. > SystemAdmin.usage column dependency issue > ----------------------------------------- > > Key: TEIID-5137 > URL: https://issues.jboss.org/browse/TEIID-5137 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 10.0.1, 9.3.5, 10.1 > > > For "object_type" == "Column", the field "Name" should be the name of the table. > Here it is the same value of "ElementName" fields (ie column name). > {code} > { > "VDBName" => "Financials", > "UID" => "tid:252cb13c7440-0c0428eb-0000000d", > "object_type" => "Column", > "SchemaName" => "ACCOUNTHOLDINGS", > "Name" => "PRODUCTID", > "ElementName" => "PRODUCTID", > "Uses_UID" => "tid:694b1432214b-cbf6d637-0000000d", > "Uses_object_type" => "Column", > "Uses_SchemaName" => "EU_Customers_EDL", > "Uses_Name" => "ACCOUNTHOLDINGS", > "Uses_ElementName" => "PRODUCTID" > } > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5137) SystemAdmin.usage column dependency issue

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5137?page=com.atlassian.jira.plugin... ] Work on TEIID-5137 started by Steven Hawkins. --------------------------------------------- > SystemAdmin.usage column dependency issue > ----------------------------------------- > > Key: TEIID-5137 > URL: https://issues.jboss.org/browse/TEIID-5137 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Steven Hawkins > > For "object_type" == "Column", the field "Name" should be the name of the table. > Here it is the same value of "ElementName" fields (ie column name). > {code} > { > "VDBName" => "Financials", > "UID" => "tid:252cb13c7440-0c0428eb-0000000d", > "object_type" => "Column", > "SchemaName" => "ACCOUNTHOLDINGS", > "Name" => "PRODUCTID", > "ElementName" => "PRODUCTID", > "Uses_UID" => "tid:694b1432214b-cbf6d637-0000000d", > "Uses_object_type" => "Column", > "Uses_SchemaName" => "EU_Customers_EDL", > "Uses_Name" => "ACCOUNTHOLDINGS", > "Uses_ElementName" => "PRODUCTID" > } > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5138) JGroups Channel creation in domain mode is invalid

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-5138: ----------------------------------- Summary: JGroups Channel creation in domain mode is invalid Key: TEIID-5138 URL: https://issues.jboss.org/browse/TEIID-5138 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 10.0 Reporter: Ramesh Reddy Assignee: Steven Hawkins Priority: Critical In domain mode configuration where the JGroups channel is configured, it is configured to be used as a separate channel where it would require separate protocol stack, which is also discouraged form. The suggested configuration is to create a forked channel as {code} <channel name="ee" stack="udp" cluster="ejb"> <fork name="teiid-cluster"/> </channel> {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5137) SystemAdmin.usage column dependency issue

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-5137?page=com.atlassian.jira.plugin... ] Van Halbert edited comment on TEIID-5137 at 11/6/17 7:46 AM: ------------------------------------------------------------- Using the portfolio quickstart: - SchemaName should be: OtherHoldings (model name) - name should be: PersonalHoldings (table name) {code} { "VDBName" => "Portfolio", "object_type" => "Column", "SchemaName" => "PersonalHoldings", "Name" => "SSN", "ElementName" => "SSN", "Uses_object_type" => "Column", "Uses_SchemaName" => "Accounts", "Uses_Name" => "ACCOUNT", "Uses_ElementName" => "SSN" } {code} was (Author: van.halbert): Using the portfolio quickstart: {code} { "VDBName" => "Portfolio", "object_type" => "Column", "SchemaName" => "PersonalHoldings", "Name" => "SSN", "ElementName" => "SSN", "Uses_object_type" => "Column", "Uses_SchemaName" => "Accounts", "Uses_Name" => "ACCOUNT", "Uses_ElementName" => "SSN" } {code} > SystemAdmin.usage column dependency issue > ----------------------------------------- > > Key: TEIID-5137 > URL: https://issues.jboss.org/browse/TEIID-5137 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Steven Hawkins > > For "object_type" == "Column", the field "Name" should be the name of the table. > Here it is the same value of "ElementName" fields (ie column name). > {code} > { > "VDBName" => "Financials", > "UID" => "tid:252cb13c7440-0c0428eb-0000000d", > "object_type" => "Column", > "SchemaName" => "ACCOUNTHOLDINGS", > "Name" => "PRODUCTID", > "ElementName" => "PRODUCTID", > "Uses_UID" => "tid:694b1432214b-cbf6d637-0000000d", > "Uses_object_type" => "Column", > "Uses_SchemaName" => "EU_Customers_EDL", > "Uses_Name" => "ACCOUNTHOLDINGS", > "Uses_ElementName" => "PRODUCTID" > } > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5137) SystemAdmin.usage column dependency issue

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-5137?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-5137: ------------------------------------ Using the portfolio quickstart: {code} { "VDBName" => "Portfolio", "object_type" => "Column", "SchemaName" => "PersonalHoldings", "Name" => "SSN", "ElementName" => "SSN", "Uses_object_type" => "Column", "Uses_SchemaName" => "Accounts", "Uses_Name" => "ACCOUNT", "Uses_ElementName" => "SSN" } {code} > SystemAdmin.usage column dependency issue > ----------------------------------------- > > Key: TEIID-5137 > URL: https://issues.jboss.org/browse/TEIID-5137 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Steven Hawkins > > For "object_type" == "Column", the field "Name" should be the name of the table. > Here it is the same value of "ElementName" fields (ie column name). > {code} > { > "VDBName" => "Financials", > "UID" => "tid:252cb13c7440-0c0428eb-0000000d", > "object_type" => "Column", > "SchemaName" => "ACCOUNTHOLDINGS", > "Name" => "PRODUCTID", > "ElementName" => "PRODUCTID", > "Uses_UID" => "tid:694b1432214b-cbf6d637-0000000d", > "Uses_object_type" => "Column", > "Uses_SchemaName" => "EU_Customers_EDL", > "Uses_Name" => "ACCOUNTHOLDINGS", > "Uses_ElementName" => "PRODUCTID" > } > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5137) SystemAdmin.usage column dependency issue

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-5137?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-5137: ------------------------------- Description: For "object_type" == "Column", the field "Name" should be the name of the table. Here it is the same value of "ElementName" fields (ie column name). {code} { "VDBName" => "Financials", "UID" => "tid:252cb13c7440-0c0428eb-0000000d", "object_type" => "Column", "SchemaName" => "ACCOUNTHOLDINGS", "Name" => "PRODUCTID", "ElementName" => "PRODUCTID", "Uses_UID" => "tid:694b1432214b-cbf6d637-0000000d", "Uses_object_type" => "Column", "Uses_SchemaName" => "EU_Customers_EDL", "Uses_Name" => "ACCOUNTHOLDINGS", "Uses_ElementName" => "PRODUCTID" } {code} was: For "object_type" == "Column", the field "Name" should be the name of the table. Here it is the same value of "ElementName" fields (ie column name). { "VDBName" => "Financials", "UID" => "tid:252cb13c7440-0c0428eb-0000000d", "object_type" => "Column", "SchemaName" => "ACCOUNTHOLDINGS", "Name" => "PRODUCTID", "ElementName" => "PRODUCTID", "Uses_UID" => "tid:694b1432214b-cbf6d637-0000000d", "Uses_object_type" => "Column", "Uses_SchemaName" => "EU_Customers_EDL", "Uses_Name" => "ACCOUNTHOLDINGS", "Uses_ElementName" => "PRODUCTID" } > SystemAdmin.usage column dependency issue > ----------------------------------------- > > Key: TEIID-5137 > URL: https://issues.jboss.org/browse/TEIID-5137 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Steven Hawkins > > For "object_type" == "Column", the field "Name" should be the name of the table. > Here it is the same value of "ElementName" fields (ie column name). > {code} > { > "VDBName" => "Financials", > "UID" => "tid:252cb13c7440-0c0428eb-0000000d", > "object_type" => "Column", > "SchemaName" => "ACCOUNTHOLDINGS", > "Name" => "PRODUCTID", > "ElementName" => "PRODUCTID", > "Uses_UID" => "tid:694b1432214b-cbf6d637-0000000d", > "Uses_object_type" => "Column", > "Uses_SchemaName" => "EU_Customers_EDL", > "Uses_Name" => "ACCOUNTHOLDINGS", > "Uses_ElementName" => "PRODUCTID" > } > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5137) SystemAdmin.usage column dependency issue

by Van Halbert (JIRA)

Van Halbert created TEIID-5137: ---------------------------------- Summary: SystemAdmin.usage column dependency issue Key: TEIID-5137 URL: https://issues.jboss.org/browse/TEIID-5137 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 8.12.x-6.4 Reporter: Van Halbert Assignee: Steven Hawkins For "object_type" == "Column", the field "Name" should be the name of the table. Here it is the same value of "ElementName" fields (ie column name). { "VDBName" => "Financials", "UID" => "tid:252cb13c7440-0c0428eb-0000000d", "object_type" => "Column", "SchemaName" => "ACCOUNTHOLDINGS", "Name" => "PRODUCTID", "ElementName" => "PRODUCTID", "Uses_UID" => "tid:694b1432214b-cbf6d637-0000000d", "Uses_object_type" => "Column", "Uses_SchemaName" => "EU_Customers_EDL", "Uses_Name" => "ACCOUNTHOLDINGS", "Uses_ElementName" => "PRODUCTID" } -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5136) Osisoft translator - NPE when running query with LATERAL JOIN

by Andrej Šmigala (JIRA)

Andrej Šmigala created TEIID-5136: ------------------------------------- Summary: Osisoft translator - NPE when running query with LATERAL JOIN Key: TEIID-5136 URL: https://issues.jboss.org/browse/TEIID-5136 Project: Teiid Issue Type: Bug Components: JDBC Connector Reporter: Andrej Šmigala Assignee: Steven Hawkins Running the following query: {code:sql} SELECT bqt2.smalla.intkey, g2.intkey, bqt2.smalla.bytenum FROM bqt2.smalla LEFT JOIN LATERAL (SELECT intkey FROM bqt2.mediuma WHERE bqt2.smalla.bytenum = bqt2.mediuma.bytenum) AS g2 ON true {code} results in a NPE in teiid (before sending source src command). Stacktrace: {noformat} Connector worker process failed for atomic-request=vEbs99yd+srV.1.0.1: java.lang.NullPointerException at org.teiid.translator.jdbc.pi.PIExecutionFactory.translate(PIExecutionFactory.java:273) [translator-jdbc-8.12.11.6_4.jar:8.12.11.6_4] at org.teiid.translator.jdbc.SQLConversionVisitor.append(SQLConversionVisitor.java:111) [translator-jdbc-8.12.11.6_4.jar:8.12.11.6_4] at org.teiid.language.visitor.SQLStringVisitor.append(SQLStringVisitor.java:106) [teiid-api-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7] at org.teiid.language.visitor.SQLStringVisitor.visit(SQLStringVisitor.java:767) [teiid-api-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7] at org.teiid.language.Select.acceptVisitor(Select.java:110) [teiid-api-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7] at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7] at org.teiid.language.visitor.SQLStringVisitor.append(SQLStringVisitor.java:91) [teiid-api-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7] at org.teiid.translator.jdbc.SQLConversionVisitor.append(SQLConversionVisitor.java:130) [translator-jdbc-8.12.11.6_4.jar:8.12.11.6_4] at org.teiid.translator.jdbc.TranslatedCommand.translateCommand(TranslatedCommand.java:76) [translator-jdbc-8.12.11.6_4.jar:8.12.11.6_4] at org.teiid.translator.jdbc.JDBCBaseExecution.translateCommand(JDBCBaseExecution.java:120) [translator-jdbc-8.12.11.6_4.jar:8.12.11.6_4] at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:114) [translator-jdbc-8.12.11.6_4.jar:8.12.11.6_4] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:363) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_141] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_141] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_141] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_141] at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) at com.sun.proxy.$Proxy79.execute(Unknown Source) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_141] at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_141] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_141] at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_141] {noformat} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2017