December 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3836) Create a quick start to demonstrate OData

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3836?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3836. --------------------------------- > Create a quick start to demonstrate OData > ----------------------------------------- > > Key: TEIID-3836 > URL: https://issues.jboss.org/browse/TEIID-3836 > Project: Teiid > Issue Type: Task > Components: Quick Starts > Affects Versions: 9.x > Reporter: Kylin Soong > Assignee: Van Halbert > > Add a quick start to demonstrate OData api may helpful for users. > After deploy portfolio-vdb.xml successful, I test with(http://localhost:8080/odata/Portfolio.1/Stocks.StockPrices) return a error: > {code} > TEIID16011 EntitySet "Stocks.StockPrices" is not found; Check the spelling, use modelName.tableName; The table that representing the Entity type must either have a PRIMARY KEY or UNIQUE key(s) > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5087) Infinispan Hotrod error for date/time/timestamp literal in where criteria

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5087?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-5087. --------------------------------- > Infinispan Hotrod error for date/time/timestamp literal in where criteria > ------------------------------------------------------------------------- > > Key: TEIID-5087 > URL: https://issues.jboss.org/browse/TEIID-5087 > Project: Teiid > Issue Type: Bug > Components: JDG Connector, Misc. Connectors > Affects Versions: 8.12.x-6.4 > Reporter: Jan Stastny > Assignee: Ramesh Reddy > Priority: Critical > > For a vdb with following source DDL metadata: > {code:sql|title="Source"} > CREATE FOREIGN TABLE SmallA ( > IntKey integer, > IntNum integer, > DoubleNum double, > ObjectValue object, > BigDecimalValue bigdecimal, > BigIntegerValue biginteger, > CharValue char, > StringNum string, > StringKey string PRIMARY KEY, > FloatNum float, > LongNum long, > TimeValue time, > ShortValue short, > ByteNum byte, > TimeStampValue timestamp, > BooleanValue boolean, > DateValue date > ) OPTIONS(UPDATABLE true, "teiid_ispn:cache" '${jdg.cache.name}'); > {code} > and a view: > {code:sql|title="CRUD"} > CREATE VIEW SmallA( > IntKey integer, > IntNum integer, > DoubleNum double, > ObjectValue object, > BigDecimalValue bigdecimal, > BigIntegerValue biginteger, > CharValue char, > StringNum string, > StringKey string PRIMARY KEY, > FloatNum float, > LongNum long, > TimeValue time, > ShortValue short, > ByteNum byte, > TimestampValue timestamp, > BooleanValue boolean, > DateValue date > ) OPTIONS (UPDATABLE true) AS > SELECT > source.IntKey AS IntKey, > source.IntNum as IntNum, > source.DoubleNum AS DoubleNum, > source.ObjectValue AS ObjectValue, > source.BigDecimalValue AS BigDecimalValue, > source.BigIntegerValue AS BigIntegerValue, > source.CharValue AS CharValue, > source.StringNum AS StringNum, > source.StringKey AS StringKey, > source.FloatNum AS FloatNum, > source.LongNum AS LongNum, > source.TimeValue AS TimeValue, > source.ShortValue AS ShortValue, > source.ByteNum AS ByteNum, > source.TimeStampValue AS TimestampValue, > source.BooleanValue AS BooleanValue, > source.DateValue AS DateValue > FROM Source.SmallA as source; > {code} > Following query fails: > {code:sql} > SELECT TimeValue FROM CRUD.SmallA WHERE TimeValue = {t '02:52:21'} > {code} > and the same applies to date/timestamp alternatives. > {code:title=error} > 16:58:10,318 WARN [org.infinispan.client.hotrod.impl.protocol.Codec21] (Worker3_QueryProcessorQueue21) ISPN004005: Error received from the server: org.infinispan.objectfilter.ParsingException: ISPN028526: Invalid query: SELECT g_0.TimeValue FROM Source.SmallA g_0 WHERE g_0.TimeValue = {t '02:52:21'} ; Parser error messages: [[statement, selectStatement, querySpec, whereClause, logicalExpression, expression, logicalOrExpression, logicalAndExpression, negatedExpression, equalityExpression, relationalExpression, additiveExpression]: line 1:66 state 0 (decision=42) no viable alt; token=[@22,66:66='{',<74>,1:66], [statement]: line 1:67 mismatched token: [@23,67:67='t',<59>,1:67]; expecting type EOF]. > 16:58:10,319 ERROR [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue21) Connector worker process failed for atomic-request=7H/tbl4yNCGQ.7.0.36: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for messageId=97 returned server error (status=0x85): org.infinispan.objectfilter.ParsingException: ISPN028526: Invalid query: SELECT g_0.TimeValue FROM Source.SmallA g_0 WHERE g_0.TimeValue = {t '02:52:21'} ; Parser error messages: [[statement, selectStatement, querySpec, whereClause, logicalExpression, expression, logicalOrExpression, logicalAndExpression, negatedExpression, equalityExpression, relationalExpression, additiveExpression]: line 1:66 state 0 (decision=42) no viable alt; token=[@22,66:66='{',<74>,1:66], [statement]: line 1:67 mismatched token: [@23,67:67='t',<59>,1:67]; expecting type EOF]. > at org.infinispan.client.hotrod.impl.protocol.Codec20.checkForErrorsInResponseStatus(Codec20.java:363) [infinispan-client-hotrod.jar:8.4.1.ER1-redhat-1] > at org.infinispan.client.hotrod.impl.protocol.Codec20.readPartialHeader(Codec20.java:152) [infinispan-client-hotrod.jar:8.4.1.ER1-redhat-1] > at org.infinispan.client.hotrod.impl.protocol.Codec20.readHeader(Codec20.java:138) [infinispan-client-hotrod.jar:8.4.1.ER1-redhat-1] > at org.infinispan.client.hotrod.impl.operations.HotRodOperation.readHeaderAndValidate(HotRodOperation.java:60) [infinispan-client-hotrod.jar:8.4.1.ER1-redhat-1] > at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:68) [infinispan-client-hotrod.jar:8.4.1.ER1-redhat-1] > at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:30) [infinispan-client-hotrod.jar:8.4.1.ER1-redhat-1] > at org.infinispan.client.hotrod.impl.operations.RetryOnFailureOperation.execute(RetryOnFailureOperation.java:57) [infinispan-client-hotrod.jar:8.4.1.ER1-redhat-1] > at org.infinispan.client.hotrod.impl.query.RemoteQuery.executeQuery(RemoteQuery.java:68) [infinispan-client-hotrod.jar:8.4.1.ER1-redhat-1] > at org.infinispan.client.hotrod.impl.query.RemoteQuery.list(RemoteQuery.java:53) [infinispan-client-hotrod.jar:8.4.1.ER1-redhat-1] > at org.teiid.translator.infinispan.hotrod.InfinispanResponse.fetchNextBatch(InfinispanResponse.java:76) [translator-infinispan-hotrod-8.12.11.6_4.jar:8.12.11.6_4] > at org.teiid.translator.infinispan.hotrod.InfinispanResponse.getNextRow(InfinispanResponse.java:92) [translator-infinispan-hotrod-8.12.11.6_4.jar:8.12.11.6_4] > at org.teiid.translator.infinispan.hotrod.InfinispanQueryExecution.next(InfinispanQueryExecution.java:138) [translator-infinispan-hotrod-8.12.11.6_4.jar:8.12.11.6_4] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:433) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:236) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6] > at sun.reflect.GeneratedMethodAccessor162.invoke(Unknown Source) [:1.8.0_121] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_121] > at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_121] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6] > at com.sun.proxy.$Proxy79.more(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_121] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_121] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_121] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_121] > 16:58:10,322 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue22) TEIID30020 Processing exception for request 7H/tbl4yNCGQ.7 'TEIID30504 jdg7-source: org.infinispan.objectfilter.ParsingException: ISPN028526: Invalid query: SELECT g_0.TimeValue FROM Source.SmallA g_0 WHERE g_0.TimeValue = {t '02:52:21'} ; Parser error messages: [[statement, selectStatement, querySpec, whereClause, logicalExpression, expression, logicalOrExpression, logicalAndExpression, negatedExpression, equalityExpression, relationalExpression, additiveExpression]: line 1:66 state 0 (decision=42) no viable alt; token=[@22,66:66='{',<74>,1:66], [statement]: line 1:67 mismatched token: [@23,67:67='t',<59>,1:67]; expecting type EOF].'. Originally TeiidProcessingException Codec20.java:363. Enable more detailed logging to see the entire stacktrace. > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4053) Provide Kerberos authentication on OData service

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4053?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4053. --------------------------------- > Provide Kerberos authentication on OData service > ------------------------------------------------ > > Key: TEIID-4053 > URL: https://issues.jboss.org/browse/TEIID-4053 > Project: Teiid > Issue Type: Task > Components: OData > Affects Versions: 8.12.4 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.12.5 > > > Provide template to generate OData web service that can participate in a Kerberos based authentication, similar to that of the template of OData. Provide documentation for the same. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4025) Web admin console typo when setting time-slice-in-milliseconds attribute

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4025?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4025. --------------------------------- > Web admin console typo when setting time-slice-in-milliseconds attribute > ------------------------------------------------------------------------ > > Key: TEIID-4025 > URL: https://issues.jboss.org/browse/TEIID-4025 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Affects Versions: 8.12.5 > Reporter: Filip Elias > Assignee: Van Halbert > Fix For: 9.0, 8.12.5 > > > Admin console prints error when editing Threading attributes. > Typo in attribute name: time-slice-in-millseconds > {code} > Unknown error > Unexpected HTTP response: 500 > Request > { > "operation" => "composite", > "address" => [], > "steps" => [{ > "address" => [("subsystem" => "teiid")], > "operation" => "write-attribute", > "name" => "time-slice-in-millseconds", > "value" => 10000 > }] > } > Response > Internal Server Error > { > "outcome" => "failed", > "result" => {"step-1" => { > "outcome" => "failed", > "failure-description" => "JBAS014792: Unknown attribute time-slice-in-millseconds", > "rolled-back" => true > }}, > "failure-description" => {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-1" => "JBAS014792: Unknown attribute time-slice-in-millseconds"}}, > "rolled-back" => true, > "response-headers" => {"process-state" => "reload-required"} > } > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4656) parseTimestamp issue with Oracle

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4656?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4656. --------------------------------- > parseTimestamp issue with Oracle > -------------------------------- > > Key: TEIID-4656 > URL: https://issues.jboss.org/browse/TEIID-4656 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector, Query Engine > Affects Versions: 8.12 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.2, 8.12.9.6_3, 8.7.11.6_2 > > > parseTimestamp is pushed as to_timestamp. However TO_TIMESTAMP is not generally valid unless the format string covers the entire string input value otherwise there is an exception about the picture ending. > This means in general that we cannot pushdown the parseDate/Time/Timestamp operations to oracle as that is behavioral different with the java format routines, which will process just to the end of the format string. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4583) cannot create simpledb translator/datasource

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4583?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4583. --------------------------------- > cannot create simpledb translator/datasource > -------------------------------------------- > > Key: TEIID-4583 > URL: https://issues.jboss.org/browse/TEIID-4583 > Project: Teiid > Issue Type: Bug > Environment: RHEL 7.x, JBoss 6.4, JDV 6.3, > JBDS 9.1.0.GA, GA-v20160414-0124-B497 > Same on Fedora 23 as well > Reporter: Glen Wilcox > Assignee: Steven Hawkins > > I was trying to set up the simpledb example: > https://developer.jboss.org/wiki/IntegrateAmazonSimpleDBWithTeiid > You go through all the steps and it errors out before creating the Data Source > When I create the DataSource to AWS I get the following error:07:19:29,048 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (teiid-async-threads - 1) IJ000604: Throwable while attempting to get a new connection: null: java.lang.NoClassDefFoundError: com/amazonaws/AmazonServiceException > at org.teiid.resource.adapter.simpledb.SimpleDBManagedConnectionFactory$1.getConnection(SimpleDBManagedConnectionFactory.java:46) > at org.teiid.resource.adapter.simpledb.SimpleDBManagedConnectionFactory$1.getConnection(SimpleDBManagedConnectionFactory.java:41) > at org.teiid.resource.spi.BasicManagedConnectionFactory.createManagedConnection(BasicManagedConnectionFactory.java:71) [teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:834) > at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:379) > at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:453) > at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:425) > at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:354) -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4040) Representation of OData error does not contain error code.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4040?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4040. --------------------------------- > Representation of OData error does not contain error code. > ---------------------------------------------------------- > > Key: TEIID-4040 > URL: https://issues.jboss.org/browse/TEIID-4040 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > JSON: > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* \{"error":\{"code":null,"message":"TEIID30492 Non-comparable expression of type object cannot be used in comparison: g4.clobval = ?."\}\} > *Expected result:* "code":30492 > XML (in this case OData returns HTTP status code instead of error code): > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Result:* > {code:xml} > <error> > <code>500</code> > <message>TEIID30492 Non-comparable expression of type object cannot be used in comparison: g1.clobval = ?.</message> > </error> > {code} > *Expected result:* > {code:xml}<code>:30492</code>{code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3801) Upgrade Infinispan translator to support 6.4.x version (JDG 6.6)

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3801?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3801. --------------------------------- > Upgrade Infinispan translator to support 6.4.x version (JDG 6.6) > ---------------------------------------------------------------- > > Key: TEIID-3801 > URL: https://issues.jboss.org/browse/TEIID-3801 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.12.x, 9.x > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.1, 8.12.5 > > > Upgrade Infinispan translator to support version 6.4 (JDG 6.6). -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4413) With DISTINCT an aggregate order by is required to reference the aggregate arguments

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4413?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4413. --------------------------------- > With DISTINCT an aggregate order by is required to reference the aggregate arguments > ------------------------------------------------------------------------------------ > > Key: TEIID-4413 > URL: https://issues.jboss.org/browse/TEIID-4413 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.0.2 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > > Hi, > I'm using the function STRING_AGG(distinct FORMATTIMESTAMP(somedate,'dd-MM-yyyy'),',' ORDER BY somedate) in a script that was made using 8.11.3. This used to work. > In 9.0.2 I get an error with the following message: With DISTINCT an aggregate order by is required to reference the aggregate arguments -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4059) OData - $ref after $expand does not work

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4059?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4059. --------------------------------- > OData - $ref after $expand does not work > ---------------------------------------- > > Key: TEIID-4059 > URL: https://issues.jboss.org/browse/TEIID-4059 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Labels: Beta1 > Fix For: 9.0, 8.12.5 > > > If user declares $ref after $expand, OData service should return inline references to 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:inline> > <a:feed> > <m:ref id="http://localhost:8080/odata4/olingo_basic/Source/Orders(1)"/> > ... > {code} > See http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 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 December 2017