November 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3179) To support AS 7.4.0 requires changes to jboss-integration

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3179?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3179: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1153703|https://bugzilla.redhat.com/show_bug.cgi?id=1153703] from MODIFIED to ON_QA > To support AS 7.4.0 requires changes to jboss-integration > --------------------------------------------------------- > > Key: TEIID-3179 > URL: https://issues.jboss.org/browse/TEIID-3179 > Project: Teiid > Issue Type: Enhancement > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Blocker > Fix For: 8.7.1 > > > When upgrading to use the BOM version 13, from 10, the jboss-integration breaks due to changes in the jboss as controller. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3165) TeiidDataSource ignores jassName

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3165?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3165: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1151034|https://bugzilla.redhat.com/show_bug.cgi?id=1151034] from MODIFIED to ON_QA > TeiidDataSource ignores jassName > -------------------------------- > > Key: TEIID-3165 > URL: https://issues.jboss.org/browse/TEIID-3165 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: fedora 20 > arch: x86_64 > java: sun 1.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > I am trying to connect to VDB through Kerberos authentication using TeiidDataSource: > TeiidDataSource tds = new TeiidDataSource(); > tds.setServerName("localhost"); > tds.setPortNumber(31000); > tds.setDatabaseName(<vdb>); > tds.setJaasName(<jassName>); > tds.setKerberosServicePrincipleName(<principalName>); > but tds.getConnection(); ends with: > TEIID20005 Client URL connection property missing "jaasName". Please add the property to connection URL > Connection through TeiidDriver works fine: > url: jdbc:teiid:<vdb>@mm://<host>:31000;jaasName=<jassName>;kerberosServicePrincipleName=<principalName> -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3169) Update infinispan-cache translator to use DSLQuery in library mode

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3169?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3169: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1151584|https://bugzilla.redhat.com/show_bug.cgi?id=1151584] from MODIFIED to ON_QA > Update infinispan-cache translator to use DSLQuery in library mode > ------------------------------------------------------------------ > > Key: TEIID-3169 > URL: https://issues.jboss.org/browse/TEIID-3169 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > > The curent lucene query logic needs to be upgraded to use the DSL query logic to perform searches on the cache when in library mode. This logic is currently being used in the infinispan-cache-dsl translator. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3189) Defined materialization in the dynamic VDB fails to deploy

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3189?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3189: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1157263|https://bugzilla.redhat.com/show_bug.cgi?id=1157263] from MODIFIED to ON_QA > Defined materialization in the dynamic VDB fails to deploy > ---------------------------------------------------------- > > Key: TEIID-3189 > URL: https://issues.jboss.org/browse/TEIID-3189 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > Attachments: customer-schema.sql, portfolio-vdb.xml > > > The attached dynamic VDB that's in the dynamicvdb-data-federation quick start, fails to deploy based on the defined materialization (remove it and the VDB deploys fine): > 15:33:39,870 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue12) TEIID30020 Processing exception for request Za7hE/1FAkqH.0 'TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE (updateStmt || ' AND loadNumber = DVARS.loadNumber') USING loadNumber = VARIABLES.loadNumber, vdbName = VARIABLES.vdbName, vdbVersion = VARIABLES.vdbVersion, schemaName = schemaName, viewName = viewName, updated = now(), LoadState = 'FAILED_LOAD', valid = (VARIABLES.valid) AND (NOT (invalidate)), cardinality = -1" with the SQL statement "(updateStmt || ' AND loadNumber = DVARS.loadNumber')" due to: TEIID30082 Cannot set symbol 'LoadNumber' with expected type integer to expression 'DVARS.LoadNumber''. Originally QueryProcessingException 'TEIID30082 Expected value of type 'integer' but 'DVARS.LoadNumber' is of type 'long' and no implicit conversion is available.' ResolverUtil.java:217. Enable more detailed logging to see the entire stacktrace. > 15:33:39,872 WARN [org.teiid.PROCESSOR.MATVIEWS] (teiid-async-threads - 3) TEIID50100 Trigger execution result: org.jboss.as.controller.OperationFailedException [ "TEIID30168 org.teiid.api.exception.query.QueryProcessingException: TEIID30168 Couldn't execute the dynamic SQL command \"EXECUTE IMMEDIATE (updateStmt || ' AND loadNumber = DVARS.loadNumber') USING loadNumber = VARIABLES.loadNumber, vdbName = VARIABLES.vdbName, vdbVersion = VARIABLES.vdbVersion, schemaName = schemaName, viewName = viewName, updated = now(), LoadState = 'FAILED_LOAD', valid = (VARIABLES.valid) AND (NOT (invalidate)), cardinality = -1\" with the SQL statement \"(updateStmt || ' AND loadNumber = DVARS.loadNumber')\" due to: TEIID30082 Cannot set symbol 'LoadNumber' with expected type integer to expression 'DVARS.LoadNumber'" ]: org.teiid.jdbc.TeiidSQLException: TEIID50100 Trigger execution result: org.jboss.as.controller.OperationFailedException [ "TEIID30168 org.teiid.api.exception.query.QueryProcessingException: TEIID30168 Couldn't execute the dynamic SQL command \"EXECUTE IMMEDIATE (updateStmt || ' AND loadNumber = DVARS.loadNumber') USING loadNumber = VARIABLES.loadNumber, vdbName = VARIABLES.vdbName, vdbVersion = VARIABLES.vdbVersion, schemaName = schemaName, viewName = viewName, updated = now(), LoadState = 'FAILED_LOAD', valid = (VARIABLES.valid) AND (NOT (invalidate)), cardinality = -1\" with the SQL statement \"(updateStmt || ' AND loadNumber = DVARS.loadNumber')\" due to: TEIID30082 Cannot set symbol 'LoadNumber' with expected type integer to expression 'DVARS.LoadNumber'" ] > at org.teiid.jboss.MaterializationManagementService$1.executeQuery(MaterializationManagementService.java:104) [teiid-jboss-integration-8.7.1.redhat-4.jar:8.7.1.redhat-4] > at org.teiid.runtime.MaterializationManager$QueryJob$1.run(MaterializationManager.java:267) [teiid-runtime-8.7.1.redhat-4.jar:8.7.1.redhat-4] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_55] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_55] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_55] > at org.jboss.threads.JBossThread.run(JBossThread.java:122) -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3059) Support consuming SOAP based service that is secured by Kerberos authentication

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3059?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3059: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1155299|https://bugzilla.redhat.com/show_bug.cgi?id=1155299] from MODIFIED to ON_QA > Support consuming SOAP based service that is secured by Kerberos authentication > ------------------------------------------------------------------------------- > > Key: TEIID-3059 > URL: https://issues.jboss.org/browse/TEIID-3059 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Labels: CR2, ER4 > Fix For: 8.7.1, 8.9 > > > CXF supports Kerberos based authentication in issuing a SOAP based web service call. This needs to be verified authentication scenario and further enhance code to support delegation of kerberos token. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2976) Using new database logging extension, getting error that indicates column isn't long enough

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2976?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2976: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1154655|https://bugzilla.redhat.com/show_bug.cgi?id=1154655] from MODIFIED to ON_QA > Using new database logging extension, getting error that indicates column isn't long enough > ------------------------------------------------------------------------------------------- > > Key: TEIID-2976 > URL: https://issues.jboss.org/browse/TEIID-2976 > Project: Teiid > Issue Type: Bug > Components: Server > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Fix For: 8.7.1 > > > Getting the following sporadically: > 11:57:57,538 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (pool-2-thread-1) Value too long for column "TRANSACTIONID VARCHAR(50)": "'TransactionImple < ac, BasicAction: 0:ffffc0a80102:307704ce:5388aa39:169 status: ActionStatus.RUNNING >' (103)"; SQL statement: > insert into commandlog (id, applicationname, executionid, modelname, plan, principal, requestid, rowcount, sessionid, sourcecommand, sourcerequestid, sqlcmd, eventtype, logtime, transactionid, translatorname, vdbname, vdbversion) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-168] -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3232) Embedded dist zip for 8.9.0 is missing from repo

by David Hladky (JIRA)

[ https://issues.jboss.org/browse/TEIID-3232?page=com.atlassian.jira.plugin... ] David Hladky commented on TEIID-3232: ------------------------------------- Hi guys, the problem is described in my blog here https://developer.jboss.org/community/website/blog/2014/11/07/missing-che... . The artifacts available for the builds can be checked here https://origin-repository.jboss.org/nexus/content/repositories/releases/o... . The fact they are not visible on repository.jboss.org does not mean they are not available for Maven Builds. > Embedded dist zip for 8.9.0 is missing from repo > ------------------------------------------------ > > Key: TEIID-3232 > URL: https://issues.jboss.org/browse/TEIID-3232 > Project: Teiid > Issue Type: Bug > Components: Build/Kits, Embedded > Affects Versions: 8.9 > Environment: Java version: 1.7.0_71, vendor: Oracle Corporation > Java home: C:\Program Files\Java\jdk1.7.0_71\jre > Default locale: en_US, platform encoding: Cp1252 > OS name: "windows 7", version: "6.1", arch: "amd64", family: "windows" > Ant 1.9.4 > Ivy 2.3.0 > Reporter: Gary Gregory > Assignee: Steven Hawkins > Priority: Blocker > > For version 8.8.1, our build uses > https://repository.jboss.org/org/jboss/teiid/teiid/8.8.1/teiid-8.8.1-embe... > There is no such zip for 8.9.0. > In fact there are no useful files in https://repository.jboss.org/org/jboss/teiid/teiid/8.9.0.Final > Help! -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 10 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 ASSIGNED to MODIFIED > 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.8#6338)

9 years, 10 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 ASSIGNED to MODIFIED > 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.8#6338)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3227) Add support for sub-expression pushing of must pushdown functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3227?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3227: ---------------------------------- Issue Type: Enhancement (was: Feature Request) Fix Version/s: 8.10 We'll also check about generalizing to other nodes beyond grouping - select and join ideally. > Add support for sub-expression pushing of must pushdown functions > ----------------------------------------------------------------- > > Key: TEIID-3227 > URL: https://issues.jboss.org/browse/TEIID-3227 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 8.9 > Reporter: Michał Warecki > Assignee: Steven Hawkins > Priority: Minor > Fix For: 8.10 > > > As a user I'd like to have a possibility to push down sub-expressions of must pushdown functions. > Example: > Input query with not supported group by: > SELECT AAA, SUM(custom_function(BBB)) AS BBB_ALIAS FROM some_table WHERE some_table.CCC = 'VAL' GROUP BY AAA ORDER BY AAA > > Output query (processed by teiid): > SELECT AAA, BBB AS BBB_ALIAS FROM some_table.CCC = 'VAL' > > What I think it should looks like: > SELECT AAA, custom_function(BBB) AS BBB_ALIAS FROM some_table.CCC = 'VAL' > https://developer.jboss.org/message/910926#910926 -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 10 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2014