June 2020 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIIDSB-213) We have strange behavior with aliases

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-213?page=com.atlassian.jira.plug... ] Steven Hawkins commented on TEIIDSB-213: ---------------------------------------- I don't quite follow what is happening here. Is the query with aliases the Teiid query you are issuing? What is the source SOQL query that you are seeing as a result? What is the nature of the problem with the salesforce response to that? What version of Teiid Spring Boot is this? If I for example on Teiid/Teiid Spring Boot master issue the Teiid query: "SELECT a.id FROM Opportunity as a where a.amount > 100000000 LIMIT 5" The SOQL issued is actually: "SELECT Opportunity.Id FROM Opportunity WHERE Opportunity.Amount > 100000000 LIMIT 5" -- the user query alias does not appear. > We have strange behavior with aliases > ------------------------------------- > > Key: TEIIDSB-213 > URL: https://issues.redhat.com/browse/TEIIDSB-213 > Project: Teiid Spring Boot > Issue Type: Bug > Components: datasource > Reporter: Renat Eskenin > Priority: Major > > We have two SOQL > SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5 > > SELECT a.ArticleNumber,a.Id,a.KnowledgeArticleId,a.Language FROM Regular_Articles__kav a WHERE a.Language = 'it' LIMIT 5 > This SOQL requests get different responses from SF because in second request we have alias for table. > It is mystics from SF (we made bug in sf) > How we can call > SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5 > in Teiid without aliases? -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-213) We have strange behavior with aliases

by Renat Eskenin (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-213?page=com.atlassian.jira.plug... ] Renat Eskenin updated TEIIDSB-213: ---------------------------------- Description: We have two SOQL SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5 SELECT a.ArticleNumber,a.Id,a.KnowledgeArticleId,a.Language FROM Regular_Articles__kav a WHERE a.Language = 'it' LIMIT 5 This SOQL requests get different responses from SF because in second request we have alias for table. It is mystics from SF (we made bug in sf) How we can call SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5 in Teiid without aliases? was: We have two SOQL SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5 SELECT a.ArticleNumber,a.Id,a.KnowledgeArticleId,a.Language FROM Regular_Articles__kav a WHERE a.Language = 'it' LIMIT 5 This SOQL requests get different responses from SF because in second request we have alias for table. It is mystics from SF How we can call SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5 in Teiid without aliases? > We have strange behavior with aliases > ------------------------------------- > > Key: TEIIDSB-213 > URL: https://issues.redhat.com/browse/TEIIDSB-213 > Project: Teiid Spring Boot > Issue Type: Bug > Components: datasource > Reporter: Renat Eskenin > Priority: Major > > We have two SOQL > SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5 > > SELECT a.ArticleNumber,a.Id,a.KnowledgeArticleId,a.Language FROM Regular_Articles__kav a WHERE a.Language = 'it' LIMIT 5 > This SOQL requests get different responses from SF because in second request we have alias for table. > It is mystics from SF (we made bug in sf) > How we can call > SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5 > in Teiid without aliases? -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-213) We have strange behavior with aliases

by Renat Eskenin (Jira)

Renat Eskenin created TEIIDSB-213: ------------------------------------- Summary: We have strange behavior with aliases Key: TEIIDSB-213 URL: https://issues.redhat.com/browse/TEIIDSB-213 Project: Teiid Spring Boot Issue Type: Bug Components: datasource Reporter: Renat Eskenin We have two SOQL SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5 SELECT a.ArticleNumber,a.Id,a.KnowledgeArticleId,a.Language FROM Regular_Articles__kav a WHERE a.Language = 'it' LIMIT 5 This SOQL requests get different responses from SF because in second request we have alias for table. It is mystics from SF How we can call SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE Language = 'it' LIMIT 5 in Teiid without aliases? -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5974) Can't Use Console to Change Logging Configuration

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5974?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5974: ---------------------------------- Fix Version/s: 15.0 > Can't Use Console to Change Logging Configuration > ------------------------------------------------- > > Key: TEIID-5974 > URL: https://issues.redhat.com/browse/TEIID-5974 > Project: Teiid > Issue Type: Bug > Affects Versions: 12.2 > Reporter: Mike Higgins > Assignee: Steven Hawkins > Priority: Minor > Fix For: 15.0 > > > Could be a problem on my end, but Installing this version with Wildfly does not let me access the configuration->logging web console page. It comes up blank. I use this to change the command logging level on a running server. > Seems to happen in version 13, also. > I tried using the checkboxes in subsystem>teiid>configure>logging but they did not seem to change the level. > > Please let me know if this if reproducible for you. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5962) Teiid locks many threads when Salesforce is disconnected

by Renat Eskenin (Jira)

[ https://issues.redhat.com/browse/TEIID-5962?page=com.atlassian.jira.plugi... ] Renat Eskenin commented on TEIID-5962: -------------------------------------- Ok, I will try > Teiid locks many threads when Salesforce is disconnected > -------------------------------------------------------- > > Key: TEIID-5962 > URL: https://issues.redhat.com/browse/TEIID-5962 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 12.3.1 > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Attachments: Снимок экрана от 2020-05-31 11-09-10.png > > Original Estimate: 1 hour > Time Spent: 45 minutes > Remaining Estimate: 15 minutes > > We had two incidents in our experimental service with teiid spring boot app. When Salesforce is down to 20min and service with teiid trying to call SQL from Salesforce we have many threads in tomcat server (in spring boot app). Then when 200 threads is activated service do not reply to requests because is "max threads" in tomcat of service. > Why teiid do not send response as "Salesforce is down - error" or connection timeout? > Micro schema: > HTTP Requests to REST api -> Teiid spring boot app -> {broken 20min}Salesforce -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5962) Teiid locks many threads when Salesforce is disconnected

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5962?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIID-5962: --------------------------------------- In general fork and then clone the git repository, then add your changes locally, push them and open a pull request. > Teiid locks many threads when Salesforce is disconnected > -------------------------------------------------------- > > Key: TEIID-5962 > URL: https://issues.redhat.com/browse/TEIID-5962 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 12.3.1 > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Attachments: Снимок экрана от 2020-05-31 11-09-10.png > > Original Estimate: 1 hour > Time Spent: 45 minutes > Remaining Estimate: 15 minutes > > We had two incidents in our experimental service with teiid spring boot app. When Salesforce is down to 20min and service with teiid trying to call SQL from Salesforce we have many threads in tomcat server (in spring boot app). Then when 200 threads is activated service do not reply to requests because is "max threads" in tomcat of service. > Why teiid do not send response as "Salesforce is down - error" or connection timeout? > Micro schema: > HTTP Requests to REST api -> Teiid spring boot app -> {broken 20min}Salesforce -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5962) Teiid locks many threads when Salesforce is disconnected

by Renat Eskenin (Jira)

[ https://issues.redhat.com/browse/TEIID-5962?page=com.atlassian.jira.plugi... ] Renat Eskenin commented on TEIID-5962: -------------------------------------- Hi! How to contribute to teiid spring boot? I have some modifications in salesforce connection and connection fabric. > Teiid locks many threads when Salesforce is disconnected > -------------------------------------------------------- > > Key: TEIID-5962 > URL: https://issues.redhat.com/browse/TEIID-5962 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 12.3.1 > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Attachments: Снимок экрана от 2020-05-31 11-09-10.png > > Original Estimate: 1 hour > Time Spent: 45 minutes > Remaining Estimate: 15 minutes > > We had two incidents in our experimental service with teiid spring boot app. When Salesforce is down to 20min and service with teiid trying to call SQL from Salesforce we have many threads in tomcat server (in spring boot app). Then when 200 threads is activated service do not reply to requests because is "max threads" in tomcat of service. > Why teiid do not send response as "Salesforce is down - error" or connection timeout? > Micro schema: > HTTP Requests to REST api -> Teiid spring boot app -> {broken 20min}Salesforce -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5950) Create an athena translator

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5950?focusedWorklogId=12451587&pag... ] Steven Hawkins logged work on TEIID-5950: ----------------------------------------- Author: Steven Hawkins Created on: 25/Jun/20 2:14 PM Start Date: 25/Jun/20 2:14 PM Worklog Time Spent: 2 hours Issue Time Tracking ------------------- Remaining Estimate: 2 hours (was: 4 hours) Time Spent: 2 hours Worklog Id: (was: 12451587) > Create an athena translator > --------------------------- > > Key: TEIID-5950 > URL: https://issues.redhat.com/browse/TEIID-5950 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 15.0 > > Original Estimate: 4 hours > Time Spent: 2 hours > Remaining Estimate: 2 hours > > There have been several issues seen with athena using the jdbc ansi translator - subquery support and bind variables specifically. There should be a specific translator so that we can account for those better. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5950) Create an athena translator

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5950?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-5950. ----------------------------------- Resolution: Done Added a simply extension of the prestodb translator to account for ENTESB-13704 and ENTESB-13703. There will likely be more issues to address with broader usage. Also things my further bifurcate when we account for the presto db / sql split. > Create an athena translator > --------------------------- > > Key: TEIID-5950 > URL: https://issues.redhat.com/browse/TEIID-5950 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 15.0 > > Original Estimate: 4 hours > Remaining Estimate: 4 hours > > There have been several issues seen with athena using the jdbc ansi translator - subquery support and bind variables specifically. There should be a specific translator so that we can account for those better. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-205) Missing dependencies from the dependencyManagement section

by Van Halbert (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-205?page=com.atlassian.jira.plug... ] Van Halbert resolved TEIIDSB-205. --------------------------------- Resolution: Done > Missing dependencies from the dependencyManagement section > ---------------------------------------------------------- > > Key: TEIIDSB-205 > URL: https://issues.redhat.com/browse/TEIIDSB-205 > Project: Teiid Spring Boot > Issue Type: Quality Risk > Components: core > Affects Versions: 1.5.0 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Major > Fix For: 1.5.0 > > > Missing the following dependencies from the dependencyManagement section: > - jakarta.xml.bind:jakarta.xml.bind-api:2.3.3 > - jakarta.persistence:jakarta.persistence-api:2.2.3 -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 9 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 June 2020