August 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4110) Odata - date functions does't accept date string as a parameter

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4110?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4110: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1322536|https://bugzilla.redhat.com/show_bug.cgi?id=1322536] from VERIFIED to CLOSED > Odata - date functions does't accept date string as a parameter > --------------------------------------------------------------- > > Key: TEIID-4110 > URL: https://issues.jboss.org/browse/TEIID-4110 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > Date functions year, month, day, hour, minute and second doesn't accept date string(DateTimeOffset) as a parameter. > Reference service which supports OData V4: > *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=m... eq EmployeeID > *Result:* Employee with ID 1 > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable/?$filter... eq intkey > *Result:* {"error": {"code": null, "message": "TEIID30069 The function 'MONTH(?)' has more than one possible signature." }} > *Expected result:* Entity with intkey 1 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3562) Teradata15 - teiid shifts date/time/timestamp values according to timezone.

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3562?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3562: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1240565|https://bugzilla.redhat.com/show_bug.cgi?id=1240565] from VERIFIED to CLOSED > Teradata15 - teiid shifts date/time/timestamp values according to timezone. > --------------------------------------------------------------------------- > > Key: TEIID-3562 > URL: https://issues.jboss.org/browse/TEIID-3562 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: teradata version - 15.00.01.01 > teradata driver version - 15.10.00.05 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12 > > Attachments: Main.java, out_GMT+0500, out_GMT_not_set > > > Teiid shifts date/time/timestamp values returned from teradata according to user.timezone value [1], [2]. However, when I execute source-specific command, teradata returns correct values [3]. > [1] > *Query:* SELECT * FROM smalla ORDER BY IntKey > *-Duser.timezone:* GMT+5 > *Result:* > || IntKey || DateValue || TimeValue || TimeStampValue || > |0 | 1999-12-31 | 19:00:00 | 1999-12-31 19:00:00.0| > |1 | 2000-01-01 | 20:00:00 | 1999-12-31 19:00:01.0| > |2 | 2000-01-02 | 21:00:00 | 1999-12-31 19:00:02.0| > |3 | 2000-01-03 | 22:00:00 | 1999-12-31 19:00:03.0| > |...|...|...|...| > [2] > *Query:* SELECT * FROM smalla ORDER BY IntKey > *-Duser.timezone:* GMT+1 > *Result:* > || IntKey || DateValue || TimeValue || TimeStampValue || > |0 | 1999-12-31 | 23:00:00 | 1999-12-31 23:00:00.0| > |1 | 2000-01-01 | 00:00:00 | 1999-12-31 23:00:01.0| > |2 | 2000-01-02 | 01:00:00 | 1999-12-31 23:00:02.0| > |3 | 2000-01-03 | 02:00:00 | 1999-12-31 23:00:03.0| > |...|...|...|...| > [3] > *Query:* SELECT g_0.IntKey AS c_0, g_0.DateValue AS c_1, g_0.TimeValue AS c_2, g_0.TimestampValue AS c_3 FROM smalla AS g_0 ORDER BY 1 > *local timezone:* GMT+1/GMT+5 > *Result:* > || c_0 || c_1 || c_2 || c_3 || > |0 | 2000-01-01 | 00:00:00 | 2000-01-01 00:00:00.0| > |1 | 2000-01-02 | 01:00:00 | 2000-01-01 00:00:01.0| > |2 | 2000-01-03 | 02:00:00 | 2000-01-01 00:00:02.0| > |3 | 2000-01-04 | 03:00:00 | 2000-01-01 00:00:03.0| > |...|...|...|...| -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4058) OData - Request entity which does not exist return 204 instead of 404

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4058?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4058: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1316500|https://bugzilla.redhat.com/show_bug.cgi?id=1316500] from VERIFIED to CLOSED > OData - Request entity which does not exist return 204 instead of 404 > --------------------------------------------------------------------- > > Key: TEIID-4058 > URL: https://issues.jboss.org/browse/TEIID-4058 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5 > > > If entity with requested ID does not exist, OData service should return 404 but Teiid returns 204. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView(-2) > Moreover, if users define also property in the URL, Teiid returns 404, but body is neither in XML nor in JSON format (seems like generic EAP error page). > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView(-2)/intkey > 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)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3528) Solr translator - batched update with more than one query gets stack

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3528?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3528: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1231769|https://bugzilla.redhat.com/show_bug.cgi?id=1231769] from VERIFIED to CLOSED > Solr translator - batched update with more than one query gets stack > -------------------------------------------------------------------- > > Key: TEIID-3528 > URL: https://issues.jboss.org/browse/TEIID-3528 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.3 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.11 > > Attachments: server.log > > > PreparedStatement.executeBatch() with more than one query gets stack (but data are stored in Solr). For more details see server.log. > However batch of size 1 and Statement.executeBatch() run without problems. > The issue is not present in 6.1.1 version. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3958) NPE Executing Against Web Service Source using invokeHttp() procedure without stream parameter

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3958?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3958: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1305902|https://bugzilla.redhat.com/show_bug.cgi?id=1305902] from VERIFIED to CLOSED > NPE Executing Against Web Service Source using invokeHttp() procedure without stream parameter > ---------------------------------------------------------------------------------------------- > > Key: TEIID-3958 > URL: https://issues.jboss.org/browse/TEIID-3958 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1, 8.7.1.6_2 > Environment: Migrated web services model from EDS 5.3.1 that does not include 'stream' parameter in the invokeHttp() procedure > DV 6.1 - translator-ws-8.7.1.redhat-8.jar > DV 6.2 - translator-ws-8.7.1.6_2-redhat-6.jar > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.7.3.6_2 > > Attachments: testStream.vdb > > > Appears to still be an issue similar to TEIID 2537. Executing against the invokeHttp() procedure generated by JBDS 5 for Teiid Designer 7.7.3 without a stream parameter results in a slightly different stack trace, but appears to be the same issue. > 2016-01-21 12:53:50,297 ERROR \[org.teiid.PROCESSOR\] (Worker22_QueryProcessorQueue117472) TEIID30019 Unexpected exception for request FzkQneotrSUs.5: java.lang.NullPointerException > at org.teiid.translator.ws.BinaryWSProcedureExecution.getOutputParameterValues(BinaryWSProcedureExecution.java:174) > at org.teiid.dqp.internal.datamgr.ProcedureBatchHandler.getParameterRow(ProcedureBatchHandler.java:86) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:435) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:207) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_65] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_65] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_65] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_65] -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4056) OData - PUT cannot parse entity

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4056?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4056: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1316497|https://bugzilla.redhat.com/show_bug.cgi?id=1316497] from VERIFIED to CLOSED > OData - PUT cannot parse entity > ------------------------------- > > Key: TEIID-4056 > URL: https://issues.jboss.org/browse/TEIID-4056 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5 > > > If user want to update entity using HTTP PUT method, OData service returns error that JSON document is not valid. Even if entity is in XML format. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/PutTable(1) or http://localhost:8080/odata4/olingo_basic/Source/PutTable(2) > *Method:* PUT > *Request reader:* Content-type: application/json or Content-type: application/xml > *Error:* The syntax of the JSON document is not valid. > *Entity JSON:* > {code:plain} > {"intnum(a)odata.type":"Int32","intnum":5,"stringval(a)odata.type":"String","stringval":"5","timestampval(a)odata.type":"DateTimeOffset","timestampval":"2005-01-01T00:00:05Z","clobval(a)odata.type":"Binary","clobval":"Y2xvYl92YWx1ZV8wMDAwNQ=="} > {code} > *Entity XML:* > {code:xml} > <?xml version='1.0' encoding='UTF-8'?><entry xmlns="http://www.w3.org/2005/Atom" xmlns:xml="http://www.w3.org/XML/1998/namespace" xmlns:m="http://docs.oasis-open.org/odata/ns/metadata" xmlns:d="http://docs.oasis-open.org/odata/ns/data" xmlns:gml="http://www.opengis.net/gml" xmlns:georss="http://www.georss.org/georss"><category scheme="http://docs.oasis-open.org/odata/ns/scheme"/><content type="application/xml"><m:properties><d:intnum m:type="Int32">4</d:intnum><d:stringval>4</d:stringval><d:timestampval m:type="DateTimeOffset">2004-01-01T00:00:04Z</d:timestampval><d:clobval m:type="Binary">Y2xvYl92YWx1ZV8wMDAwNA==</d:clobval></m:properties></content></entry> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3974) MIN and MAX on boolean not supported in Vertica

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3974?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3974: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1306991|https://bugzilla.redhat.com/show_bug.cgi?id=1306991] from VERIFIED to CLOSED > MIN and MAX on boolean not supported in Vertica > ----------------------------------------------- > > Key: TEIID-3974 > URL: https://issues.jboss.org/browse/TEIID-3974 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.12.3 > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5 > > > Vertica does not support calling MIN and MAX aggregate functions on boolean values, attempting that fails with > {noformat} > Remote com.vertica.support.exceptions.SyntaxErrorException: [Vertica][VJDBC](3457) ERROR: Function MIN(boolean) does not exist, or permission is denied for MIN(boolean) > {noformat} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3978) Remove AddressWrapper

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3978?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3978: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1308959|https://bugzilla.redhat.com/show_bug.cgi?id=1308959] from VERIFIED to CLOSED > Remove AddressWrapper > --------------------- > > Key: TEIID-3978 > URL: https://issues.jboss.org/browse/TEIID-3978 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 9.0, 8.12.5, 8.13.2, 8.7.5.6_2 > > > AddressWrapper was introduced to handle an earlier jgroups version where address objects were not directly serializable. However the deserialization code is using the thread context class loader which is not guaranteed to have the JGroups classes in the classpath. The resulting exception (where the original exception is simply swallowed) looks like: > {code} > 2016-02-16 08:45:30,140 ERROR [Incoming-1,shared=tcp-teiid-1] org.teiid.replication.jgroups.JGroupsObjectReplicator$ReplicatorRpcDispatcher - exception marshalling object > java.lang.IllegalStateException: unread block data > at java.io.ObjectInputStream$BlockDataInputStream.setBlockDataMode(ObjectInputStream.java:2421) > at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1382) > at java.io.ObjectInputStream.readArray(ObjectInputStream.java:1706) > at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1344) > at java.io.ObjectInputStream.readObject(ObjectInputStream.java:370) > at org.jgroups.blocks.MethodCall.readExternal(MethodCall.java:430) > at java.io.ObjectInputStream.readExternalData(ObjectInputStream.java:1837) > at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1796) > at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1350) > at java.io.ObjectInputStream.readObject(ObjectInputStream.java:370) > at org.teiid.replication.jgroups.JGroupsObjectReplicator$ContextAwareMarshaller.objectFromBuffer(JGroupsObjectReplicator.java:611) > at org.teiid.replication.jgroups.JGroupsObjectReplicator$ReplicatorRpcDispatcher.handle(JGroupsObjectReplicator.java:106) > at org.jgroups.blocks.RequestCorrelator.handleRequest(RequestCorrelator.java:484) > at org.jgroups.blocks.RequestCorrelator.receiveMessage(RequestCorrelator.java:391) > at org.jgroups.blocks.RequestCorrelator.receive(RequestCorrelator.java:249) > at org.jgroups.blocks.MessageDispatcher$ProtocolAdapter.up(MessageDispatcher.java:600) > at org.jgroups.JChannel.up(JChannel.java:707) > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

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

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4059?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4059: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1316501|https://bugzilla.redhat.com/show_bug.cgi?id=1316501] from VERIFIED to CLOSED > 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 (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4150) Infinispan dsl resource-adapter has not valid module.xml

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4150?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4150: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1328436|https://bugzilla.redhat.com/show_bug.cgi?id=1328436] from VERIFIED to CLOSED > Infinispan dsl resource-adapter has not valid module.xml > -------------------------------------------------------- > > Key: TEIID-4150 > URL: https://issues.jboss.org/browse/TEIID-4150 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Jan Stastny > Assignee: Van Halbert > Fix For: 9.0, 8.12.5 > > > There is a problem in mentioned module when server attempts to load it: > {code:plain} > [standalone@localhost:9999 /] /subsystem=resource-adapters/resource-adapter=infinispandsl:add(module=org.jboss.teiid.resource-adapter.infinispan.dsl) > { > "outcome" => "failed", > "failure-description" => "JBAS010473: Failed to load module for RA [org.jboss.teiid.resource-adapter.infinispan.dsl]", > "rolled-back" => true > } > {code} > It is not valid module according to the 'urn:jboss:module:1.1' schema. > Problematic fragment: > {code:xml} > <dependencies> > ... > <module name="org.infinispan.query" slot="jdg-6.6" optional="true" export="true" services="true" /> > ... > </dependencies> > {code} > According to the mentioned schema the attribute 'services' can have only values: > * none > * import > * export > This issue prevents a user from using the adapter. > Furthermore I am not sure that name 'org.infinispan.query' of the dependency module is correct. I haven't found such module in jdg client libs, there are two possible candidates though: > * org.infinispan.query.dsl > * org.infinispan.query.remote.client -- This message was sent by Atlassian JIRA (v6.4.11#64026)

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