February 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3117) NullPointerException while creating source model from Excel table

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3117?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3117: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1138697|https://bugzilla.redhat.com/show_bug.cgi?id=1138697] from VERIFIED to CLOSED > NullPointerException while creating source model from Excel table > ----------------------------------------------------------------- > > Key: TEIID-3117 > URL: https://issues.jboss.org/browse/TEIID-3117 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7 > Environment: Fedora 20, data virtualization 6.1.0.ER1 > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Labels: Beta1 > Fix For: 8.7.1, 8.9 > > Attachments: ExcelDynamic-vdb.xml, Server.log, smalla.xlsx, smalla_raw.xlsx > > > I am trying to create source model from Excel file (.xlsx). When I set property "Header Row Number" to 1 (using Teiid Designer), creating ends with NullPointerException. Setting "Header Row Number" to 0 executes with no problems. > Same problem (and same exception) with dynamic VDB (only with <property name="importer.headerRowNumber" value="1"/>). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3556) BufferManager reserve memory variable is decremented twice

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3556?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3556: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1234839|https://bugzilla.redhat.com/show_bug.cgi?id=1234839] from VERIFIED to CLOSED > BufferManager reserve memory variable is decremented twice > ---------------------------------------------------------- > > Key: TEIID-3556 > URL: https://issues.jboss.org/browse/TEIID-3556 > Project: Teiid > Issue Type: Bug > Components: Server > Reporter: Van Halbert > Assignee: Ramesh Reddy > Fix For: 8.7.1.6_2, 8.12, 8.11.1 > > > Web admin console shows negative value for Memory Used By Active Plans(KB) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2983) MongoDB: Function "count()" returns sum instead of number of rows

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2983?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2983: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1104614|https://bugzilla.redhat.com/show_bug.cgi?id=1104614] from VERIFIED to CLOSED > MongoDB: Function "count()" returns sum instead of number of rows > ----------------------------------------------------------------- > > Key: TEIID-2983 > URL: https://issues.jboss.org/browse/TEIID-2983 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Labels: Beta1 > Fix For: 8.8, 8.7.1 > > > Function "count()" returns sum of rows instead of number of rows > Query [1] returns sum of values of all rows of IntKey column. > Query [2] correctly returns number of rows > > [1] SELECT COUNT(IntKey) FROM BQT1.SmallA > [2] SELECT COUNT(*) FROM BQT1.SmallA -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3438) Null value returned from BlobImpl getBytes

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3438?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3438: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1212852|https://bugzilla.redhat.com/show_bug.cgi?id=1212852] from VERIFIED to CLOSED > Null value returned from BlobImpl getBytes > ------------------------------------------ > > Key: TEIID-3438 > URL: https://issues.jboss.org/browse/TEIID-3438 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Kylin Soong > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.10.1, 8.11 > > Attachments: TEIID-3438.zip > > > If translator retrieveValue return a empty Blob, the engine will throw NPE as below > Caused by: java.lang.NullPointerException > at javax.sql.rowset.serial.SerialBlob.<init>(SerialBlob.java:100) > at org.teiid.common.buffer.LobManager.persistLob(LobManager.java:226) > at org.teiid.common.buffer.LobManager.updateReferences(LobManager.java:141) > at org.teiid.common.buffer.TupleBuffer.addTupleBatch(TupleBuffer.java:203) > at org.teiid.query.processor.BatchCollector.flushBatchDirect(BatchCollector.java:229) > at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:653) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3623) HBase translator - boolean and biginteger values are not translated correctly

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3623?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3623: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1252385|https://bugzilla.redhat.com/show_bug.cgi?id=1252385] from VERIFIED to CLOSED > HBase translator - boolean and biginteger values are not translated correctly > ----------------------------------------------------------------------------- > > Key: TEIID-3623 > URL: https://issues.jboss.org/browse/TEIID-3623 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Hbase: 1.1.1 > Phoenix: 4.5.0-HBase-1.1 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.12 > > Attachments: insert_biginteger.log, inser_boolean.log > > > *1. Boolean values:* The Teiid translates the value true/false as 1/0, but HBase does not support integer representation of boolean values [1]. > *2. BigInteger values ( <= -2):* Teiid's bigInteger data type is wider than HBase's bigint (as wide as long) type, so it make sense to define column in HBase as e.g. _decimal(30,0)_ and map it to Teiid's biginteger type. > From Teiid's point of view: There is no problem if inserted value is greater than or equal to -1. But if the value is less than -1, then a ClassCastException is thrown [2]. Phoenix driver require something like "UPSERT INTO smalla (intkey, bigintegervalue) VALUES (1, -10 *.0*)" > [1] > *Query:* insert into hbase.smalla (intkey, booleanvalue) values (55, true) > *Column definition:* > - source: booleanvalue boolean > - VDB: BooleanValue boolean OPTIONS (nameinsource 'booleanvalue', NATIVE_TYPE 'boolean') > *Stack trace:* > insert_boolean.log > [2] > *Query:* insert into hbase.smalla (intkey, bigintegervalue) values (55, -10) > *Column definition:* > - source: bigintegervalue decimal(20,0) > - VDB: BigIntegerValue biginteger OPTIONS (nameinsource 'bigintegervalue', NATIVE_TYPE 'decimal') > *Stack trace:* > insert_biginteger.log -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3404) Teiid DatabaseAppender JPA perisist Command log consume high CPU

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3404?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3404: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1206143|https://bugzilla.redhat.com/show_bug.cgi?id=1206143] from VERIFIED to CLOSED > Teiid DatabaseAppender JPA perisist Command log consume high CPU > ---------------------------------------------------------------- > > Key: TEIID-3404 > URL: https://issues.jboss.org/browse/TEIID-3404 > Project: Teiid > Issue Type: Bug > Components: Tools > Affects Versions: 8.7.1 > Environment: * DV 6.1 > * dynamicvdb-datafederation quickstart > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 8.7.2 > > > I have 4 - 5 concurrent client query to Portfolio VDB, this cause log DatabaseAppender JPA perisist Command log thread consume high CPU. In my test, one log threads always swallow high CPU, if the concurrent client query more than 10, it swallow 100% cpu. > [1] have detailed reproduce steps, including thread dumps. > [1] https://github.com/kylinsoong/teiid-samples/tree/master/command-logging-h... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3100) SOLR: Connector ignores CoreName property

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3100?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3100: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1133848|https://bugzilla.redhat.com/show_bug.cgi?id=1133848] from VERIFIED to CLOSED > SOLR: Connector ignores CoreName property > ----------------------------------------- > > Key: TEIID-3100 > URL: https://issues.jboss.org/browse/TEIID-3100 > Project: Teiid > Issue Type: Bug > Components: Connector API > Affects Versions: 8.7 > Reporter: Filip Elias > Assignee: Ramesh Reddy > Labels: Beta1 > Fix For: 8.7.1, 8.9 > > > SOLR connector ignores CoreName property. It uses first or active core (by default "collection1"). CoreName should be appended to the Solr Server's baseUrl. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2988) MongoDB: Function substring - starting index and number of arguments

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2988?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2988: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1105101|https://bugzilla.redhat.com/show_bug.cgi?id=1105101] from VERIFIED to CLOSED > MongoDB: Function substring - starting index and number of arguments > -------------------------------------------------------------------- > > Key: TEIID-2988 > URL: https://issues.jboss.org/browse/TEIID-2988 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4.1 > Reporter: Filip Elias > Assignee: Ramesh Reddy > Labels: Beta1 > Fix For: 8.8, 8.7.1, 8.10 > > > Two minor bugs in function substring() > Mongo's function $substr takes only 3 arguments so this query fails: > {code} > SELECT intkey, SUBSTRING(BQT1.SmallA.stringkey, 1) FROM BQT1.SmallA ORDER BY intkey > {code} > {code} > Exception:13:18:48,220 ERROR [org.teiid.CONNECTOR] (Worker38_QueryProcessorQueue345) Connector worker process failed for atomic-request=omsmHP0o16Sa.40.0.86: com.mongodb.CommandFailureException: { "serverUsed" : "localhost/127.0.0.1:27017" , "errmsg" : "exception: the $substr operator requires 3 operand(s)" , "code" : 16020 , "ok" : 0.0} > at com.mongodb.CommandResult.getException(CommandResult.java:71) > at com.mongodb.CommandResult.throwOnError(CommandResult.java:110) > at com.mongodb.DBCollection.aggregate(DBCollection.java:1308) > {code} > Generated mongo command: > {code} > { aggregate: "smalla", pipeline: [ { $project: { c_0: "$INTKEY", c_1: { $substr: [ "$STRINGKEY", 1 ] } } }, { $sort: { c_0: 1 } } ] } > {code} > Mongo's $substr function second argument represents number of bytes to skip, not the starting index. The function substring(StringKey,1,1) returns the second letter, but it should return the first letter. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3358) Issues with entity set names

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3358?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3358: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1208515|https://bugzilla.redhat.com/show_bug.cgi?id=1208515] from VERIFIED to CLOSED > Issues with entity set names > ---------------------------- > > Key: TEIID-3358 > URL: https://issues.jboss.org/browse/TEIID-3358 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Labels: Alpha1 > Fix For: 8.7.1.6_2, 8.11, 8.7.3 > > > The entity set name used for sql generation should be the fully qualified name. If there is for example two table with the same names in schemas visible to odata, but one of the tables does not have a key, then an ambiguous name exception will be thrown if an odata url is used with only the base table name. > It also appears that the URI link in the results metadata uses the non-qualified table name, which will have issues in the scenario above. > We may also need to document or add an additional check for ambiguity as the OData4j findEdmEntitySet logic will return the first matching entity, which is generally against our approach to resolving. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3324) Boolean fields with null are evaluated to false

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3324?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3324: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1206576|https://bugzilla.redhat.com/show_bug.cgi?id=1206576] from VERIFIED to CLOSED > Boolean fields with null are evaluated to false > ----------------------------------------------- > > Key: TEIID-3324 > URL: https://issues.jboss.org/browse/TEIID-3324 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 7.1 > Reporter: Salvatore R > Assignee: Steven Hawkins > Fix For: 8.10, 8.7.2, 8.7.1.6_2 > > > I have a source table defined as follows (e.g. in PostgreSQL): > {code:sql} > CREATE TABLE public.test > ( > id integer, > iscustomer boolean > ) > {code} > and the table contains these rows: > {code:sql} > insert into public.test values(1, null); > insert into public.test values(2, true); > insert into public.test values(3, false); > {code} > > When I try to get data from this table in Teiid, the "null" value is evaluated as false: > ||id||iscustomer|| > |1|false| > |2|true| > |3|false| -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2016