October 2015 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2684) SalesForce importer issue

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2684?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2684: ----------------------------------- Fix Version/s: 9.3 > SalesForce importer issue > ------------------------- > > Key: TEIIDDES-2684 > URL: https://issues.jboss.org/browse/TEIIDDES-2684 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.0.4 > Environment: MAC OS > Reporter: Matus Makovy > Assignee: Mark Drilling > Fix For: 9.3 > > > According to conversation in TEIID-3112 this is a Designer issue. If I understood correctly, it has been fixed in Teiid and now the changes have to be made in TD SF importer. > I have a VDB with Source model that is created via SalesForce importer and I am getting this error: > {quote} > Didn't understand relationship 'Opportunitys' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names > {quote} > when trying to submit this query: > {quote} > select distinct YEAR("Opportunity"."CloseDate") as "Opportunity_CloseDate1" from "SalesForceSource".Campaign AS "Campaign" LEFT OUTER JOIN "SalesForceSource".Opportunity AS "Opportunity" ON Campaign."Id" = Opportunity."CampaignId" order by YEAR("Opportunity"."CloseDate") ASC LIMIT 0 , 32 > {quote} > It works without problems with dynamic VDB. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2688) Dynamic VDB Generation - Problem with DDL generated for procedure

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2688?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2688: ---------------------------------------- master: https://github.com/Teiid-Designer/teiid-designer/commit/de1769e492e4a743e... > Dynamic VDB Generation - Problem with DDL generated for procedure > ----------------------------------------------------------------- > > Key: TEIIDDES-2688 > URL: https://issues.jboss.org/browse/TEIIDDES-2688 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.4 > Reporter: Matus Makovy > Assignee: Barry LaFond > Fix For: 9.2 > > > I have a VDB that was created for consumption of REST Web Service. > There is a procedure named getProgrammes(). DDL generated for dynamic VDB is: > {quote} > CREATE VIRTUAL PROCEDURE getProgrammes () > AS > CREATE VIRTUAL PROCEDURE > BEGIN > DECLARE STRING VARIABLES.qp = ''; > SELECT > A.pid AS pid, A."start" AS "start", A."end" AS "end", A.title AS title > FROM > (EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE')) AS f, XMLTABLE('/schedule' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS pid string PATH 'day/broadcasts/broadcast/pid/text()', "start" string PATH 'day/broadcasts/broadcast/start/text()', "end" string PATH 'day/broadcasts/broadcast/end/text()', title string PATH 'day/broadcasts/broadcast/programme/title/text()') AS A; > END; > {quote} > Obviously, there is one extra "CREATE VIRTUAL PROCEDURE". > Even after fixing this issue there is another error: > {quote} > VDB: REST State: INACTIVE ERROR: TEIID31080 ViewModel.getProgrammes validation error: TEIID31118 Element "f.result" is not defined by any relevant group. ERROR: TEIID31080 ViewModel.getProgrammes1 validation error: TEIID31118 Element "f.result" is not defined by any relevant group. Models: SourceModel ViewModel > {quote} > "f" should be a refrence to "EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE'))" as descibed in the SQL -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2688) Dynamic VDB Generation - Problem with DDL generated for procedure

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2688?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2688. ------------------------------------ Resolution: Done > Dynamic VDB Generation - Problem with DDL generated for procedure > ----------------------------------------------------------------- > > Key: TEIIDDES-2688 > URL: https://issues.jboss.org/browse/TEIIDDES-2688 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.4 > Reporter: Matus Makovy > Assignee: Barry LaFond > Fix For: 9.2 > > > I have a VDB that was created for consumption of REST Web Service. > There is a procedure named getProgrammes(). DDL generated for dynamic VDB is: > {quote} > CREATE VIRTUAL PROCEDURE getProgrammes () > AS > CREATE VIRTUAL PROCEDURE > BEGIN > DECLARE STRING VARIABLES.qp = ''; > SELECT > A.pid AS pid, A."start" AS "start", A."end" AS "end", A.title AS title > FROM > (EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE')) AS f, XMLTABLE('/schedule' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS pid string PATH 'day/broadcasts/broadcast/pid/text()', "start" string PATH 'day/broadcasts/broadcast/start/text()', "end" string PATH 'day/broadcasts/broadcast/end/text()', title string PATH 'day/broadcasts/broadcast/programme/title/text()') AS A; > END; > {quote} > Obviously, there is one extra "CREATE VIRTUAL PROCEDURE". > Even after fixing this issue there is another error: > {quote} > VDB: REST State: INACTIVE ERROR: TEIID31080 ViewModel.getProgrammes validation error: TEIID31118 Element "f.result" is not defined by any relevant group. ERROR: TEIID31080 ViewModel.getProgrammes1 validation error: TEIID31118 Element "f.result" is not defined by any relevant group. Models: SourceModel ViewModel > {quote} > "f" should be a refrence to "EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE'))" as descibed in the SQL -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2688) Dynamic VDB Generation - Problem with DDL generated for procedure

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2688?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2688: ----------------------------------- Fix Version/s: 9.2 > Dynamic VDB Generation - Problem with DDL generated for procedure > ----------------------------------------------------------------- > > Key: TEIIDDES-2688 > URL: https://issues.jboss.org/browse/TEIIDDES-2688 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.4 > Reporter: Matus Makovy > Assignee: Barry LaFond > Fix For: 9.2 > > > I have a VDB that was created for consumption of REST Web Service. > There is a procedure named getProgrammes(). DDL generated for dynamic VDB is: > {quote} > CREATE VIRTUAL PROCEDURE getProgrammes () > AS > CREATE VIRTUAL PROCEDURE > BEGIN > DECLARE STRING VARIABLES.qp = ''; > SELECT > A.pid AS pid, A."start" AS "start", A."end" AS "end", A.title AS title > FROM > (EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE')) AS f, XMLTABLE('/schedule' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS pid string PATH 'day/broadcasts/broadcast/pid/text()', "start" string PATH 'day/broadcasts/broadcast/start/text()', "end" string PATH 'day/broadcasts/broadcast/end/text()', title string PATH 'day/broadcasts/broadcast/programme/title/text()') AS A; > END; > {quote} > Obviously, there is one extra "CREATE VIRTUAL PROCEDURE". > Even after fixing this issue there is another error: > {quote} > VDB: REST State: INACTIVE ERROR: TEIID31080 ViewModel.getProgrammes validation error: TEIID31118 Element "f.result" is not defined by any relevant group. ERROR: TEIID31080 ViewModel.getProgrammes1 validation error: TEIID31118 Element "f.result" is not defined by any relevant group. Models: SourceModel ViewModel > {quote} > "f" should be a refrence to "EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE'))" as descibed in the SQL -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2688) Dynamic VDB Generation - Problem with DDL generated for procedure

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2688?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2688: -------------------------------------- Assignee: Barry LaFond > Dynamic VDB Generation - Problem with DDL generated for procedure > ----------------------------------------------------------------- > > Key: TEIIDDES-2688 > URL: https://issues.jboss.org/browse/TEIIDDES-2688 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.4 > Reporter: Matus Makovy > Assignee: Barry LaFond > > I have a VDB that was created for consumption of REST Web Service. > There is a procedure named getProgrammes(). DDL generated for dynamic VDB is: > {quote} > CREATE VIRTUAL PROCEDURE getProgrammes () > AS > CREATE VIRTUAL PROCEDURE > BEGIN > DECLARE STRING VARIABLES.qp = ''; > SELECT > A.pid AS pid, A."start" AS "start", A."end" AS "end", A.title AS title > FROM > (EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE')) AS f, XMLTABLE('/schedule' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS pid string PATH 'day/broadcasts/broadcast/pid/text()', "start" string PATH 'day/broadcasts/broadcast/start/text()', "end" string PATH 'day/broadcasts/broadcast/end/text()', title string PATH 'day/broadcasts/broadcast/programme/title/text()') AS A; > END; > {quote} > Obviously, there is one extra "CREATE VIRTUAL PROCEDURE". > Even after fixing this issue there is another error: > {quote} > VDB: REST State: INACTIVE ERROR: TEIID31080 ViewModel.getProgrammes validation error: TEIID31118 Element "f.result" is not defined by any relevant group. ERROR: TEIID31080 ViewModel.getProgrammes1 validation error: TEIID31118 Element "f.result" is not defined by any relevant group. Models: SourceModel ViewModel > {quote} > "f" should be a refrence to "EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE'))" as descibed in the SQL -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2688) Dynamic VDB Generation - Problem with DDL generated for procedure

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2688?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2688: ---------------------------------------- [~mmakovy] Can you verify if the view model in the VDB is *old*? if the procedure in the VDB contains SQL that starts with CREATE VIRTUAL PROCEDURE, then the issue you logged will probably occur. Any NEW procedure will NOT have the CREATE VIRTUAL PROCEDURE in the SQL.. just a simple statement or one wrapped in BEGIN...END > Dynamic VDB Generation - Problem with DDL generated for procedure > ----------------------------------------------------------------- > > Key: TEIIDDES-2688 > URL: https://issues.jboss.org/browse/TEIIDDES-2688 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.4 > Reporter: Matus Makovy > > I have a VDB that was created for consumption of REST Web Service. > There is a procedure named getProgrammes(). DDL generated for dynamic VDB is: > {quote} > CREATE VIRTUAL PROCEDURE getProgrammes () > AS > CREATE VIRTUAL PROCEDURE > BEGIN > DECLARE STRING VARIABLES.qp = ''; > SELECT > A.pid AS pid, A."start" AS "start", A."end" AS "end", A.title AS title > FROM > (EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE')) AS f, XMLTABLE('/schedule' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS pid string PATH 'day/broadcasts/broadcast/pid/text()', "start" string PATH 'day/broadcasts/broadcast/start/text()', "end" string PATH 'day/broadcasts/broadcast/end/text()', title string PATH 'day/broadcasts/broadcast/programme/title/text()') AS A; > END; > {quote} > Obviously, there is one extra "CREATE VIRTUAL PROCEDURE". > Even after fixing this issue there is another error: > {quote} > VDB: REST State: INACTIVE ERROR: TEIID31080 ViewModel.getProgrammes validation error: TEIID31118 Element "f.result" is not defined by any relevant group. ERROR: TEIID31080 ViewModel.getProgrammes1 validation error: TEIID31118 Element "f.result" is not defined by any relevant group. Models: SourceModel ViewModel > {quote} > "f" should be a refrence to "EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE'))" as descibed in the SQL -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2689) LDAP dialogue too slow - loads a lot of data?

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2689?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2689: -------------------------------------- Assignee: Paul Richardson > LDAP dialogue too slow - loads a lot of data? > --------------------------------------------- > > Key: TEIIDDES-2689 > URL: https://issues.jboss.org/browse/TEIIDDES-2689 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.4 > Environment: MAC OS > Reporter: Matus Makovy > Assignee: Paul Richardson > Priority: Critical > Fix For: 9.0.5, 9.3 > > Attachments: Screen Shot 2015-10-14 at 14.17.46.png > > > I came across this when trying to verify TEIIDDES-2478. > When you have a LDAP instance with big amount of entries (in the screenshot you can see that are 931 entries) in some part, it takes long to load all attributes. After clicking Next> on the page shown in screenshot (see attachment) JBDS freezes and doesn't respond for about 3 minutes. At least we should have some message that says, that TD is loading data from LDAP. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2689) LDAP dialogue too slow - loads a lot of data?

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2689?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2689: ----------------------------------- Fix Version/s: 9.0.5 9.3 > LDAP dialogue too slow - loads a lot of data? > --------------------------------------------- > > Key: TEIIDDES-2689 > URL: https://issues.jboss.org/browse/TEIIDDES-2689 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.4 > Environment: MAC OS > Reporter: Matus Makovy > Assignee: Paul Richardson > Priority: Critical > Fix For: 9.0.5, 9.3 > > Attachments: Screen Shot 2015-10-14 at 14.17.46.png > > > I came across this when trying to verify TEIIDDES-2478. > When you have a LDAP instance with big amount of entries (in the screenshot you can see that are 931 entries) in some part, it takes long to load all attributes. After clicking Next> on the page shown in screenshot (see attachment) JBDS freezes and doesn't respond for about 3 minutes. At least we should have some message that says, that TD is loading data from LDAP. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2691) Teiid Connection Import does not set translator when importing from Sybase

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2691?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2691. ------------------------------------ Resolution: Done > Teiid Connection Import does not set translator when importing from Sybase > -------------------------------------------------------------------------- > > Key: TEIIDDES-2691 > URL: https://issues.jboss.org/browse/TEIIDDES-2691 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Priority: Minor > Fix For: 9.2 > > Attachments: Screenshot from 2015-10-14 15-53-23.png > > > When using Teiid Connection to import from Sybase, the translator is set to jdbc-ansi, not sybase. For other relational databases, it is set to the correct translator automatically. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2691) Teiid Connection Import does not set translator when importing from Sybase

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2691?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2691: ---------------------------------------- master: https://github.com/Teiid-Designer/teiid-designer/commit/da52c069c790c2570... > Teiid Connection Import does not set translator when importing from Sybase > -------------------------------------------------------------------------- > > Key: TEIIDDES-2691 > URL: https://issues.jboss.org/browse/TEIIDDES-2691 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Priority: Minor > Fix For: 9.2 > > Attachments: Screenshot from 2015-10-14 15-53-23.png > > > When using Teiid Connection to import from Sybase, the translator is set to jdbc-ansi, not sybase. For other relational databases, it is set to the correct translator automatically. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues October 2015