April 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4501) Salesforce 34 resource adapter should default to the 34 api

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4501?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4501: ---------------------------------- Fix Version/s: 9.1 (was: 9.2) > Salesforce 34 resource adapter should default to the 34 api > ----------------------------------------------------------- > > Key: TEIID-4501 > URL: https://issues.jboss.org/browse/TEIID-4501 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > The salesforce-34 resource adapter ra.xml still points to the 22 api url by default. It should point to 34. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4501) Salesforce 34 resource adapter should default to the 34 api

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4501?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-4501: ----------------------------------- > Salesforce 34 resource adapter should default to the 34 api > ----------------------------------------------------------- > > Key: TEIID-4501 > URL: https://issues.jboss.org/browse/TEIID-4501 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > The salesforce-34 resource adapter ra.xml still points to the 22 api url by default. It should point to 34. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4848) Google translator does not support ALL in DELETE

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4848?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4848. ----------------------------------- Resolution: Rejected By default there is no concept of a primary or unique key with a spreadsheet. If the user alters the metadata to have a key, then this style of delete can proceed. > Google translator does not support ALL in DELETE > ------------------------------------------------ > > Key: TEIID-4848 > URL: https://issues.jboss.org/browse/TEIID-4848 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.10.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > > Query DELETE FROM SmallA WHERE IntKey > ALL (values(20)) throws exception (debug mode): > 08:05:50,812 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) TEIID30020 Processing exception for request 2md+OVeJxlHo.0 'TEIID30253 Source UPDATE or DELETE command "DELETE FROM Source.smalla WHERE intkey > ALL (SELECT 20)" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. '. Originally QueryPlannerException RelationalPlanner.java:1187.: org.teiid.api.exception.query.QueryPlannerException: TEIID30253 Source UPDATE or DELETE command "DELETE FROM Source.smalla WHERE intkey > ALL (SELECT 20)" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. > at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:205) [teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2] > at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:159) [teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2] > at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:442) [teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2] > ... -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4849) Google translator behaves unexpectedly with Double in WHERE clause of SELECT

by Lucie Fabrikova (JIRA)

Lucie Fabrikova created TEIID-4849: -------------------------------------- Summary: Google translator behaves unexpectedly with Double in WHERE clause of SELECT Key: TEIID-4849 URL: https://issues.jboss.org/browse/TEIID-4849 Project: Teiid Issue Type: Bug Affects Versions: 8.12.10.6_3 Reporter: Lucie Fabrikova Assignee: Steven Hawkins Query like "SELECT DoubleNum FROM SmallA WHERE DoubleNum > 5.0" gives unexpected results for following values in DoubleNum column: * value like '15.1' is probably by google spreadsheet interpreted as date (in function row in sheet appears 15.1.2017), SELECT query returns no results * value like '150.1': SELECT returns null -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4848) Google translator does not support ALL in DELETE

by Lucie Fabrikova (JIRA)

Lucie Fabrikova created TEIID-4848: -------------------------------------- Summary: Google translator does not support ALL in DELETE Key: TEIID-4848 URL: https://issues.jboss.org/browse/TEIID-4848 Project: Teiid Issue Type: Bug Affects Versions: 8.12.10.6_3 Reporter: Lucie Fabrikova Assignee: Steven Hawkins Query DELETE FROM SmallA WHERE IntKey > ALL (values(20)) throws exception (debug mode): 08:05:50,812 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) TEIID30020 Processing exception for request 2md+OVeJxlHo.0 'TEIID30253 Source UPDATE or DELETE command "DELETE FROM Source.smalla WHERE intkey > ALL (SELECT 20)" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. '. Originally QueryPlannerException RelationalPlanner.java:1187.: org.teiid.api.exception.query.QueryPlannerException: TEIID30253 Source UPDATE or DELETE command "DELETE FROM Source.smalla WHERE intkey > ALL (SELECT 20)" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:205) [teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2] at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:159) [teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:442) [teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2] ... -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4847) Google translator ClientLogin not supported

by Lucie Fabrikova (JIRA)

Lucie Fabrikova created TEIID-4847: -------------------------------------- Summary: Google translator ClientLogin not supported Key: TEIID-4847 URL: https://issues.jboss.org/browse/TEIID-4847 Project: Teiid Issue Type: Bug Components: Documentation Affects Versions: 9.2 Reporter: Lucie Fabrikova Assignee: Steven Hawkins Documentation for both DV 6.3 [1] and teiid 9 [2] says "Authentication to your google account may be done in two ways. ClientLogin (requires login and password) or OAuth...", however only OAuth is supported already - SpreadsheetConnectionImpl.java throws exception for method other than OAuth with message "provide_auth=Only OAuth2 is allowed for the AuthMethod." [1] https://access.redhat.com/documentation/en-us/red_hat_jboss_data_virtuali... [2] https://teiid.gitbooks.io/documents/content/admin/Google_Spreadsheet_Data... -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4846) Can't use TEIID 9.1.1 with Websphere 8.5.5 + JAVA 8

by Ivan Chan (JIRA)

[ https://issues.jboss.org/browse/TEIID-4846?page=com.atlassian.jira.plugin... ] Ivan Chan closed TEIID-4846. ---------------------------- Fix Version/s: 9.1.1 Resolution: Won't Fix > Can't use TEIID 9.1.1 with Websphere 8.5.5 + JAVA 8 > --------------------------------------------------- > > Key: TEIID-4846 > URL: https://issues.jboss.org/browse/TEIID-4846 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 9.1.1 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Fix For: 9.1.1 > > Attachments: dependencytree.txt > > > After I deploy Teiid 9.1.1 with websphere 8.5.5 + JAVA 8, Teiid embedded server cannot start. It throws the following exception: > Caused by: java.lang.VerifyError: JVMVRFY013 class loading constraint violated; class=org/infinispan/configuration/parsing/XMLExtendedStreamReaderImpl, method=getAttributeName(I)Ljavax/xml/namespace/QName;, pc=0 > at org.infinispan.configuration.parsing.ParserRegistry.parse(ParserRegistry.java:117) > at org.infinispan.configuration.parsing.ParserRegistry.parse(ParserRegistry.java:105) > at org.infinispan.manager.DefaultCacheManager.<init>(DefaultCacheManager.java:275) > at org.infinispan.manager.DefaultCacheManager.<init>(DefaultCacheManager.java:248) > at org.teiid.runtime.EmbeddedConfiguration.getCacheFactory(EmbeddedConfiguration.java:183) > at org.teiid.runtime.EmbeddedServer.start(EmbeddedServer.java:397) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.teiid.TeiidEmbeddedServer.<init>(TeiidEmbeddedServer.java:113) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.startServer(TeiidVirtualDataSourceQueryServiceImpl.java:515) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.init(TeiidVirtualDataSourceQueryServiceImpl.java:510) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.afterPropertiesSet(TeiidVirtualDataSourceQueryServiceImpl.java:755) > at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1573) > at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1511) > ... 89 more -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4846) Can't use TEIID 9.1.1 with Websphere 8.5.5 + JAVA 8

by Ivan Chan (JIRA)

[ https://issues.jboss.org/browse/TEIID-4846?page=com.atlassian.jira.plugin... ] Ivan Chan commented on TEIID-4846: ---------------------------------- I have figured the problem. There was other QName implementation in xml-apis-1.3.04.jar and axis-jaxrpc-1.3.jar which caused problem for Infinspan in Websphere 8 environment. Thanks for helping me to narrow down the problem. > Can't use TEIID 9.1.1 with Websphere 8.5.5 + JAVA 8 > --------------------------------------------------- > > Key: TEIID-4846 > URL: https://issues.jboss.org/browse/TEIID-4846 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 9.1.1 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Attachments: dependencytree.txt > > > After I deploy Teiid 9.1.1 with websphere 8.5.5 + JAVA 8, Teiid embedded server cannot start. It throws the following exception: > Caused by: java.lang.VerifyError: JVMVRFY013 class loading constraint violated; class=org/infinispan/configuration/parsing/XMLExtendedStreamReaderImpl, method=getAttributeName(I)Ljavax/xml/namespace/QName;, pc=0 > at org.infinispan.configuration.parsing.ParserRegistry.parse(ParserRegistry.java:117) > at org.infinispan.configuration.parsing.ParserRegistry.parse(ParserRegistry.java:105) > at org.infinispan.manager.DefaultCacheManager.<init>(DefaultCacheManager.java:275) > at org.infinispan.manager.DefaultCacheManager.<init>(DefaultCacheManager.java:248) > at org.teiid.runtime.EmbeddedConfiguration.getCacheFactory(EmbeddedConfiguration.java:183) > at org.teiid.runtime.EmbeddedServer.start(EmbeddedServer.java:397) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.teiid.TeiidEmbeddedServer.<init>(TeiidEmbeddedServer.java:113) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.startServer(TeiidVirtualDataSourceQueryServiceImpl.java:515) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.init(TeiidVirtualDataSourceQueryServiceImpl.java:510) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.afterPropertiesSet(TeiidVirtualDataSourceQueryServiceImpl.java:755) > at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1573) > at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1511) > ... 89 more -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4846) Can't use TEIID 9.1.1 with Websphere 8.5.5 + JAVA 8

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4846?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4846: --------------------------------------- To confirm, if you were to just minimally install Teiid, then there would be no exception? If that's the case, this in general is a websphere issue with parent last classloading. From your full dependencies, you'll need to see what is packaged with QName class. > Can't use TEIID 9.1.1 with Websphere 8.5.5 + JAVA 8 > --------------------------------------------------- > > Key: TEIID-4846 > URL: https://issues.jboss.org/browse/TEIID-4846 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 9.1.1 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Attachments: dependencytree.txt > > > After I deploy Teiid 9.1.1 with websphere 8.5.5 + JAVA 8, Teiid embedded server cannot start. It throws the following exception: > Caused by: java.lang.VerifyError: JVMVRFY013 class loading constraint violated; class=org/infinispan/configuration/parsing/XMLExtendedStreamReaderImpl, method=getAttributeName(I)Ljavax/xml/namespace/QName;, pc=0 > at org.infinispan.configuration.parsing.ParserRegistry.parse(ParserRegistry.java:117) > at org.infinispan.configuration.parsing.ParserRegistry.parse(ParserRegistry.java:105) > at org.infinispan.manager.DefaultCacheManager.<init>(DefaultCacheManager.java:275) > at org.infinispan.manager.DefaultCacheManager.<init>(DefaultCacheManager.java:248) > at org.teiid.runtime.EmbeddedConfiguration.getCacheFactory(EmbeddedConfiguration.java:183) > at org.teiid.runtime.EmbeddedServer.start(EmbeddedServer.java:397) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.teiid.TeiidEmbeddedServer.<init>(TeiidEmbeddedServer.java:113) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.startServer(TeiidVirtualDataSourceQueryServiceImpl.java:515) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.init(TeiidVirtualDataSourceQueryServiceImpl.java:510) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.afterPropertiesSet(TeiidVirtualDataSourceQueryServiceImpl.java:755) > at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1573) > at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1511) > ... 89 more -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4846) Can't use TEIID 9.1.1 with Websphere 8.5.5 + JAVA 8

by Ivan Chan (JIRA)

[ https://issues.jboss.org/browse/TEIID-4846?page=com.atlassian.jira.plugin... ] Ivan Chan commented on TEIID-4846: ---------------------------------- Last working combination is using Teiid 8.12.3 with Infinispan-core-5.12 on Websphere 8.5.5 I have included the whole dependency tree. [^dependencytree.txt] And I have tried to exclude stax-12.0, staxmapper, xml-apis, xml-apis-ext, and xmlbeans, but still no luck. > Can't use TEIID 9.1.1 with Websphere 8.5.5 + JAVA 8 > --------------------------------------------------- > > Key: TEIID-4846 > URL: https://issues.jboss.org/browse/TEIID-4846 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 9.1.1 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Attachments: dependencytree.txt > > > After I deploy Teiid 9.1.1 with websphere 8.5.5 + JAVA 8, Teiid embedded server cannot start. It throws the following exception: > Caused by: java.lang.VerifyError: JVMVRFY013 class loading constraint violated; class=org/infinispan/configuration/parsing/XMLExtendedStreamReaderImpl, method=getAttributeName(I)Ljavax/xml/namespace/QName;, pc=0 > at org.infinispan.configuration.parsing.ParserRegistry.parse(ParserRegistry.java:117) > at org.infinispan.configuration.parsing.ParserRegistry.parse(ParserRegistry.java:105) > at org.infinispan.manager.DefaultCacheManager.<init>(DefaultCacheManager.java:275) > at org.infinispan.manager.DefaultCacheManager.<init>(DefaultCacheManager.java:248) > at org.teiid.runtime.EmbeddedConfiguration.getCacheFactory(EmbeddedConfiguration.java:183) > at org.teiid.runtime.EmbeddedServer.start(EmbeddedServer.java:397) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.teiid.TeiidEmbeddedServer.<init>(TeiidEmbeddedServer.java:113) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.startServer(TeiidVirtualDataSourceQueryServiceImpl.java:515) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.init(TeiidVirtualDataSourceQueryServiceImpl.java:510) > at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.afterPropertiesSet(TeiidVirtualDataSourceQueryServiceImpl.java:755) > at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1573) > at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1511) > ... 89 more -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2017