December 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3226) Need to upgrade org.springframework to at least version 3.2.12

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3226?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3226: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1166378|https://bugzilla.redhat.com/show_bug.cgi?id=1166378] from MODIFIED to ON_QA > Need to upgrade org.springframework to at least version 3.2.12 > -------------------------------------------------------------- > > Key: TEIID-3226 > URL: https://issues.jboss.org/browse/TEIID-3226 > Project: Teiid > Issue Type: Task > Components: Misc. Connectors > Affects Versions: 8.7.1, 8.10 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Blocker > Fix For: 8.7.1, 8.10 > > > The spring framework version that's packaged with the connector-ws needs to be upgraded from 3.0.7 to 3.1.2. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3228) SOLR: Date and Timestamp parsing is incorrect

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3228?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3228: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1166577|https://bugzilla.redhat.com/show_bug.cgi?id=1166577] from MODIFIED to ON_QA > SOLR: Date and Timestamp parsing is incorrect > --------------------------------------------- > > Key: TEIID-3228 > URL: https://issues.jboss.org/browse/TEIID-3228 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7 > Reporter: Filip Elias > Assignee: Ramesh Reddy > Labels: Alpaha1 > Fix For: 8.7.1, 8.10 > > > SolrSQLHierarchyVisitor uses incorrect Date and Timestamp pattern. > The pattern for Date is yyyy-MM-DD, but it should be yyyy-MM-dd. > DD represents day in year, not day in month > Similar issue occurs for Timestamp. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3223) An issue with time in WHERE clause - SQLServer

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3223?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3223: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1165132|https://bugzilla.redhat.com/show_bug.cgi?id=1165132] from MODIFIED to ON_QA > An issue with time in WHERE clause - SQLServer > ---------------------------------------------- > > Key: TEIID-3223 > URL: https://issues.jboss.org/browse/TEIID-3223 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: fedora20 > arch: x86_64 > java: oracle 1.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.10 > > > Teiid is not able to manage WHERE clause with time value. > translator: sqlserver > base DB: SQL Server 2012/2008/2005 -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3215) External Materialization ON_VDB_START_SCRIPT invocation issues

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3215?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3215: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1163685|https://bugzilla.redhat.com/show_bug.cgi?id=1163685] from MODIFIED to ON_QA > External Materialization ON_VDB_START_SCRIPT invocation issues > -------------------------------------------------------------- > > Key: TEIID-3215 > URL: https://issues.jboss.org/browse/TEIID-3215 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7 > Reporter: Jan Stastny > Assignee: Ramesh Reddy > Labels: Final > Fix For: 8.7.1, 8.9 > > Attachments: mat-views-vdb.xml > > > With materialized view I have set teiid_rel:ON_VDB_START_SCRIPT property for the external matview table. (Simple query to increment a column in table to count invocations.) > Invocation of the script is dependent upon the way the vdb is deployed. The first case (A) doesn't invoke the script, the second (B) does. > A - 1. Copy the vdbname-vdb.xml into deployments folder > 2. Start the server > B - 1. Start the server > 2. Copy the vdbname-vdb.xml into deployments folder > That means that after server stop (maintenance) the script is not invoked on start, which can cause problems when the script is used to initialize running environment (clear table, create temporary table,...) -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3219) Excel Translator Wrong Result From Columns With Interleaved Null Values

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3219?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3219: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1164281|https://bugzilla.redhat.com/show_bug.cgi?id=1164281] from MODIFIED to ON_QA > Excel Translator Wrong Result From Columns With Interleaved Null Values > ----------------------------------------------------------------------- > > Key: TEIID-3219 > URL: https://issues.jboss.org/browse/TEIID-3219 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Jan Stastny > Assignee: Kylin Soong > Fix For: 8.7.1, 8.10 > > Attachments: artifacts.zip > > > When querying a column which has a null value somewhere in it, the result set is missing all the rows under the null value in the xlsx file. When querying more columns, the result set is missing some values only if there is a row, where both columns contains null value. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3170) Change build to include spring framework jar dependencies for WS translator

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3170?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3170: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1151047|https://bugzilla.redhat.com/show_bug.cgi?id=1151047] from MODIFIED to ON_QA > Change build to include spring framework jar dependencies for WS translator > --------------------------------------------------------------------------- > > Key: TEIID-3170 > URL: https://issues.jboss.org/browse/TEIID-3170 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Blocker > Fix For: 8.7.1, 8.9 > > > The "org.springframework.spring" module and dependent jars will be added to the kit. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3133) Impala Time/Date/Timestamp handling

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3133?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3133: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1141685|https://bugzilla.redhat.com/show_bug.cgi?id=1141685] from MODIFIED to ON_QA > Impala Time/Date/Timestamp handling > ----------------------------------- > > Key: TEIID-3133 > URL: https://issues.jboss.org/browse/TEIID-3133 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > Impala supports only TIMESTAMP datatype (see here http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/lates...) > Converted everything into timestamp and now I am trying to get Date and Time parts of the timestamp in Teiid e.g. > SELECT DISTINCT convert(Source.SmallA.TimeValue, time) as TimeValue FROM Source.SmallA ORDER BY TimeValue > But I get TranslatorException: Unexpected exception while translating results: Method not supported > Tried to workaround this but with limited success. For Date it is possible to use to_date function that returns string reprsentation of the date part. For Time I wasn't able to find the solution (have not yet figured out how to use extract function through Teiid). > http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/lates... -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3187) Error Casting TimeStamp to Date using Impala

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3187?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3187: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1141685|https://bugzilla.redhat.com/show_bug.cgi?id=1141685] from MODIFIED to ON_QA > Error Casting TimeStamp to Date using Impala > -------------------------------------------- > > Key: TEIID-3187 > URL: https://issues.jboss.org/browse/TEIID-3187 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.10 > > > With ER3 getting [1] for the conversion of a timestamp to a Date: > convert(Source.smalla.DATEVALUE, date) AS DateValue > [1] > org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT DISTINCT cast(g_0.DATEVALUE AS date) AS c_0 FROM smalla g_0 ORDER BY c_0] > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) > at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:667) > at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:63) > at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:515) > at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) > at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) > at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) > at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:264) > at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:302) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98) > at com.sun.proxy.$Proxy1.read(Unknown Source) > at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:401) > at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:524) > at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:393) > at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:327) > at JDBCClient.execute(JDBCClient.java:80) > at JDBCClient.main(JDBCClient.java:46) > Caused by: org.teiid.core.TeiidProcessingException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT DISTINCT cast(g_0.DATEVALUE AS date) AS c_0 FROM smalla g_0 ORDER BY c_0] > at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:381) > at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:154) > at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) > 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:1145) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.teiid.core.TeiidException: 0 Remote org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT DISTINCT cast(g_0.DATEVALUE AS date) AS c_0 FROM smalla g_0 ORDER BY c_0] > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:325) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) > ... 6 more > Caused by: java.sql.SQLException: Remote java.sql.SQLException: AnalysisException: Invalid type cast of g_0.DATEVALUE from TIMESTAMP to DATE -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3241) Audit/Command Logging handler names do not match web console handler names

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3241?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3241: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1170583|https://bugzilla.redhat.com/show_bug.cgi?id=1170583] from MODIFIED to ON_QA > Audit/Command Logging handler names do not match web console handler names > -------------------------------------------------------------------------- > > Key: TEIID-3241 > URL: https://issues.jboss.org/browse/TEIID-3241 > Project: Teiid > Issue Type: Bug > Components: Tools > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.7.1 > > > When changing configuration of Audit and Command logging via Web Management, an exception is thrown in specific usecase, see the steps to reproduce below. > Then even after server restart logging doesn't work. No changes noticed in standalone.xml during the configuration. > Version-Release number of selected component (if applicable): > DV 6.1.0 ER4 > How reproducible: > Once after installation (further on the logging simply doesn't work) > Steps to Reproduce: > 1.Install DV with audit/command logging enabled > 2.Start DV with bin/standalone.sh, check that logging works > 3.Access http://localhost:9990/console/App.html#teiid-audit and unselect selected options > 4.Apply > 5.Select the previously deselected options again > 6.Apply > 7.See the server log in console > 8.When there is server reload between unselecting and reselecting the options, then the exception is not raised, but the logging doesn't work afterwards. > Actual results: > java.lang.IllegalArgumentException: Handler "TEIID_AUDIT_LOG" is not found > or > java.lang.IllegalArgumentException: Handler "TEIID_COMMAND_LOG" is not found > Expected results: > Logging configured again -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3245) Database Logging: Problems with Microsoft

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3245?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3245: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1118470|https://bugzilla.redhat.com/show_bug.cgi?id=1118470] from MODIFIED to ON_QA > Database Logging: Problems with Microsoft > ------------------------------------------ > > Key: TEIID-3245 > URL: https://issues.jboss.org/browse/TEIID-3245 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Fix For: 8.7.1 > > > Still getting error with mssql driver and sql server 2012. > The error messages look similar, but one: > [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 55) Incorrect syntax near the keyword 'rowcount'. > is present. > While the prior issue > 14:46:56,858 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool – 57) Incorrect syntax near the keyword 'plan'. > was solved. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 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 2014