March 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4039) Resolving of entityid with $expand or $select fails

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4039?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4039: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1316469 Bugzilla Update: Perform > Resolving of entityid with $expand or $select fails > --------------------------------------------------- > > Key: TEIID-4039 > URL: https://issues.jboss.org/browse/TEIID-4039 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/$entity/?$id=Customers(1... > *Returned status code:* 404 > *URL:* http://localhost:8080/odata4/olingo_basic/Source/$entity/?$id=Customers(1... > *Returned status code:* 500 > In this case response does not contain mandatory OData-version header and server throws exception: > {code:plain} > 12:20:40,911 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/odata4].[odata4]] (http-/127.0.0.1:8080-1) JBWEB000236: Servlet.service() for servlet odata4 threw exception: java.util.EmptyStackException > at java.util.Stack.peek(Stack.java:102) [rt.jar:1.8.0-internal] > at org.apache.olingo.server.core.uri.parser.UriParseTreeVisitor.visitSelectSegment(UriParseTreeVisitor.java:2195) > at org.apache.olingo.server.core.uri.antlr.UriParserParser$SelectSegmentContext.accept(UriParserParser.java:3611) > at org.apache.olingo.server.core.uri.parser.UriParseTreeVisitor.visitSelectItem(UriParseTreeVisitor.java:2168) > at org.apache.olingo.server.core.uri.antlr.UriParserParser$SelectItemContext.accept(UriParserParser.java:3541) > at org.apache.olingo.server.core.uri.parser.UriParseTreeVisitor.visitSelectEOF(UriParseTreeVisitor.java:2153) > at org.apache.olingo.server.core.uri.parser.Parser.parseUri(Parser.java:228) > at org.apache.olingo.server.core.ErrorHandler.handleServerError(ErrorHandler.java:93) > at org.apache.olingo.server.core.ErrorHandler.handleException(ErrorHandler.java:85) > at org.apache.olingo.server.core.OData4HttpHandler.process(OData4HttpHandler.java:70) > at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:50) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] > at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-2.jar:1.0.2.Final-redhat-2] > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:194) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.4.Final-redhat-4.jar:7.5.4.Final-redhat-4] > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal] > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4038) OData returns bad number of entities with $count and $expand

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4038?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4038: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1316468 Bugzilla Update: Perform > OData returns bad number of entities with $count and $expand > ------------------------------------------------------------ > > Key: TEIID-4038 > URL: https://issues.jboss.org/browse/TEIID-4038 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$count=true&$... > *Expected count:* 4 > *Actual count:* 9 > Similar behavior with $filter - http://localhost:8080/odata4/olingo_basic/Source/Customers/?$count=true&$... > OData should return only count of Customer entities. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4038) OData returns bad number of entities with $count and $expand

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4038?page=com.atlassian.jira.plugin... ] Juraj Duráni updated TEIID-4038: -------------------------------- Description: *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$count=true&$... *Expected count:* 4 *Actual count:* 9 Similar behavior with $filter - http://localhost:8080/odata4/olingo_basic/Source/Customers/?$count=true&$... OData should return only count of Customer entities. was: *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$count=true&$... *Expected count: * 4 *Actual count:* 9 Similar behavior with $filter - http://localhost:8080/odata4/olingo_basic/Source/Customers/?$count=true&$... OData should return only count of Customer entities. > OData returns bad number of entities with $count and $expand > ------------------------------------------------------------ > > Key: TEIID-4038 > URL: https://issues.jboss.org/browse/TEIID-4038 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$count=true&$... > *Expected count:* 4 > *Actual count:* 9 > Similar behavior with $filter - http://localhost:8080/odata4/olingo_basic/Source/Customers/?$count=true&$... > OData should return only count of Customer entities. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4037) Bad metadata of returned entity

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4037?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4037: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1316467 Bugzilla Update: Perform > Bad metadata of returned entity > ------------------------------- > > Key: TEIID-4037 > URL: https://issues.jboss.org/browse/TEIID-4037 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > Odata response contains bad metadata seee \[1\]: > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers(1)/Orders_FK0(1) > *Actual metadata:* $metadata#Orders/$entity > *Expected metadata:* $metadata#Customer(1)/Orders/$entity > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers(1)/Orders_FK0 > *Actual metadata:* $metadata#Orders/$entity > *Expected metadata:* $metadata#Customer(1)/Orders > \[1\] http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4035) Parameter alias without value returns http status code 500

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4035?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4035: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1316466 Bugzilla Update: Perform > Parameter alias without value returns http status code 500 > ---------------------------------------------------------- > > Key: TEIID-4035 > URL: https://issues.jboss.org/browse/TEIID-4035 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Result:* OData Library: An exception without message text was thrown. > See http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4064) OData - missing non-nullable property

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-4064: ----------------------------------- Summary: OData - missing non-nullable property Key: TEIID-4064 URL: https://issues.jboss.org/browse/TEIID-4064 Project: Teiid Issue Type: Sub-task Components: OData Reporter: Juraj Duráni Assignee: Ramesh Reddy Change DDL for tables Customer and Orders in VDB as follows: {code:sql} CREATE FOREIGN TABLE Customers ( id integer PRIMARY KEY OPTIONS (NAMEINSOURCE 'id'), name varchar(10)) OPTIONS (NAMEINSOURCE 'DB.PUBLIC.CUSTOMERS'); CREATE FOREIGN TABLE Orders ( id integer PRIMARY KEY OPTIONS (NAMEINSOURCE 'id'), customerid integer, place varchar(10), FOREIGN KEY (customerid) REFERENCES Customers(id)) OPTIONS (NAMEINSOURCE 'DB.PUBLIC.ORDERS'); {code} Note, that both tables have same name of primary key named "id". Invoke GET method to URL http://localhost:8080/odata4/olingo_basic/Source/Customers/?$count=true&$... *Result:* The non-nullable property 'id' is missing. Here are selected part of Teiid's log: *Query:* {code:sql} SELECT g10.id, g10.name, g11.id, g11.customerid, g11.place FROM Source.Customers AS g10 LEFT OUTER JOIN Source.Orders AS g11 ON g10.id = g11.customerid ORDER BY g10.id {code} *Result:* |id|name|id|customerid|place| |1|customer1|1|1|town| |1|customer1|2|1|state| |1|customer1|3|1|country| |1|customer1|4|1|abroad| |2|customer2|5|2|state| |2|customer2|6|2|country| |3|customer3|7|3|town| |3|customer3|8|3|town| |4|customer4|<null>|<null>|<null>| -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4063) OData - $all returns 500 without message (generic error page of EAP)

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-4063: ----------------------------------- Summary: OData - $all returns 500 without message (generic error page of EAP) Key: TEIID-4063 URL: https://issues.jboss.org/browse/TEIID-4063 Project: Teiid Issue Type: Sub-task Components: OData Reporter: Juraj Duráni Assignee: Ramesh Reddy *URL:* http://localhost:8080/odata4/olingo_basic/Source/$all *Result:* OData returns status code 500 without message. There is no error in the console log of Teiid server. *Expected result:* if $all is not implemented then OData should return 501 otherwise correct result should be returned. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4062) OData - $corssjoin fails due to missing class

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-4062: ----------------------------------- Summary: OData - $corssjoin fails due to missing class Key: TEIID-4062 URL: https://issues.jboss.org/browse/TEIID-4062 Project: Teiid Issue Type: Sub-task Components: OData Reporter: Juraj Duráni Assignee: Ramesh Reddy *URL:* http://localhost:8080/odata4/olingo_basic/Source/$crossjoin(PutTable,Dele... *Missing dependency:* com.fasterxml.jackson *Error:* {code:plain} 11:04:51,047 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/odata4].[odata4]] (http-/127.0.0.1:8080-2) JBWEB000236: Servlet.service() for servlet odata4 threw exception: java.lang.ClassNotFoundException: com.fasterxml.jackson.core.JsonFactory from [Module "org.jboss.teiid.olingo:main" from local module loader @7c53a9eb (finder: local module finder @ed17bee (roots: /home/jdurani/redhat/tests/functional_testing/workdir_olingo/modules,/home/jdurani/redhat/tests/functional_testing/workdir_olingo/modules/system/layers/dv,/home/jdurani/redhat/tests/functional_testing/workdir_olingo/modules/system/layers/base))] at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213) [jboss-modules.jar:1.3.7.Final-redhat-1] at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459) [jboss-modules.jar:1.3.7.Final-redhat-1] at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408) [jboss-modules.jar:1.3.7.Final-redhat-1] at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389) [jboss-modules.jar:1.3.7.Final-redhat-1] at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134) [jboss-modules.jar:1.3.7.Final-redhat-1] at org.teiid.olingo.TeiidODataJsonSerializer.complexCollection(TeiidODataJsonSerializer.java:53) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] at org.teiid.olingo.EdmComplexResponse.writeComplexType(EdmComplexResponse.java:73) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] at org.teiid.olingo.service.TeiidServiceHandler.sendResults(TeiidServiceHandler.java:317) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] at org.teiid.olingo.service.TeiidServiceHandler.crossJoin(TeiidServiceHandler.java:834) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] at org.apache.olingo.server.core.requests.DataRequest$CrossJoinRequest.execute(DataRequest.java:692) at org.apache.olingo.server.core.requests.DataRequest.execute(DataRequest.java:245) at org.apache.olingo.server.core.ServiceDispatcher.execute(ServiceDispatcher.java:117) at org.apache.olingo.server.core.OData4HttpHandler.process(OData4HttpHandler.java:65) at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:50) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-2.jar:1.0.2.Final-redhat-2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:194) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.4.Final-redhat-4.jar:7.5.4.Final-redhat-4] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal] {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4061) OData - request is not traslated to valid SQL

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-4061: ----------------------------------- Summary: OData - request is not traslated to valid SQL Key: TEIID-4061 URL: https://issues.jboss.org/browse/TEIID-4061 Project: Teiid Issue Type: Sub-task Components: OData Reporter: Juraj Duráni Assignee: Ramesh Reddy *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$filter=Order... *Result:* TEIID31118 Element "g30.customerid" is not defined by any relevant group. *SQL:* {code:sql} SELECT g30.idcust, g30.name FROM Source.Customers AS g30 WHERE (SELECT COUNT(*) FROM Source.Orders AS g31 WHERE g30.customerid = g31.idcust) < ? ORDER BY g30.idcust {code} *Correct SQL:* {code:sql} SELECT g30.idcust, g30.name FROM Source.Customers AS g30 WHERE (SELECT COUNT(*) FROM Source.Orders AS g31 WHERE g30.idcust = g31.customerid) < ? ORDER BY g30.idcust {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4060) OData - $count after $expand does not work

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-4060: ----------------------------------- Summary: OData - $count after $expand does not work Key: TEIID-4060 URL: https://issues.jboss.org/browse/TEIID-4060 Project: Teiid Issue Type: Sub-task Components: OData Reporter: Juraj Duráni Assignee: Ramesh Reddy If user declares $count after $expand, OData service should return count if referenced entities instead of whole entities. *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$expand=Order... *Result:* {code:xml} ... <a:link rel="http://docs.oasis-open.org/odata/ns/related/Orders_FK0" title="Orders_FK0" href="http://localhost:8080/odata4/olingo_basic/Source/Customers(1)/Orders_FK0"> <m:inline> <a:feed> <a:entry> ... {code} *Expected result:* {code:xml} <a:link rel="http://docs.oasis-open.org/odata/ns/related/Orders_FK0" title="Orders_FK0" href="http://localhost:8080/odata4/olingo_basic/Source/Customers(1)/Orders_FK0">  <m:count>4</m:count> ... {code} See http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2016