September 2016 - teiid-designer-issues

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

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2688?page=com.atlassian.jira.plu... ] Matus Makovy commented on TEIIDDES-2688: ---------------------------------------- [~blafond] Tested today with 10.0.2.Alpha2. There is still the problem with "f.result" that is mentioned in the second part of the description. > 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)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2654) Renaming project with VDB in it causes VDB to disappear

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2654?page=com.atlassian.jira.plu... ] Matus Makovy commented on TEIIDDES-2654: ---------------------------------------- [~blafond] You are right, I cannot reproduce this anymore with 10.0.2.Alpha2. But after renaming the project I received this exception: {code:java} java.lang.Exception: java.util.zip.ZipException: zip file is empty at org.teiid.core.designer.util.OperationUtil.perform(OperationUtil.java:54) at org.teiid.designer.vdb.VdbUtil.getVdbManifest(VdbUtil.java:281) at org.teiid.designer.vdb.VdbUtil.validateVdbModelsInWorkspace(VdbUtil.java:627) at org.teiid.designer.vdb.ui.build.VdbBuilder.refreshVdbFileMarkers(VdbBuilder.java:167) at org.teiid.designer.vdb.ui.build.VdbBuilder.buildInternal(VdbBuilder.java:137) at org.teiid.designer.core.builder.AbstractTeiidProjectBuilder.build(AbstractTeiidProjectBuilder.java:76) at org.eclipse.core.internal.events.BuildManager$2.run(BuildManager.java:734) at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42) at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:205) at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:245) at org.eclipse.core.internal.events.BuildManager$1.run(BuildManager.java:300) at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42) at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:303) at org.eclipse.core.internal.events.BuildManager.basicBuildLoop(BuildManager.java:359) at org.eclipse.core.internal.events.BuildManager.build(BuildManager.java:382) at org.eclipse.core.internal.events.AutoBuildJob.doBuild(AutoBuildJob.java:144) at org.eclipse.core.internal.events.AutoBuildJob.run(AutoBuildJob.java:235) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55) Caused by: java.util.zip.ZipException: zip file is empty at java.util.zip.ZipFile.open(Native Method) at java.util.zip.ZipFile.<init>(ZipFile.java:219) at java.util.zip.ZipFile.<init>(ZipFile.java:149) at java.util.zip.ZipFile.<init>(ZipFile.java:120) at org.teiid.designer.vdb.VdbUtil$1.tryToDo(VdbUtil.java:298) at org.teiid.core.designer.util.OperationUtil.perform(OperationUtil.java:41) ... 17 more {code} I don't know how much is renaming project used, I am not using it apart from testing. I am ok with disabling this option. > Renaming project with VDB in it causes VDB to disappear > ------------------------------------------------------- > > Key: TEIIDDES-2654 > URL: https://issues.jboss.org/browse/TEIIDDES-2654 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.4 > Environment: MAC OS X > Reporter: Matus Makovy > Assignee: Barry LaFond > Fix For: 10.0.2 > > Attachments: bug.mov > > -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2654) Renaming project with VDB in it causes VDB to disappear

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2654?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2654: ---------------------------------------- [~mmakovy] I can't reproduce this particular behavior. There are some other odd things that can happen when renaming a project. I would actually vote for disabled the rename action for selected Model Project. > Renaming project with VDB in it causes VDB to disappear > ------------------------------------------------------- > > Key: TEIIDDES-2654 > URL: https://issues.jboss.org/browse/TEIIDDES-2654 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.4 > Environment: MAC OS X > Reporter: Matus Makovy > Assignee: Barry LaFond > Fix For: 10.0.2 > > Attachments: bug.mov > > -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2855) WSDL to Web Service model import doesn't work

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2855?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2855. ------------------------------------ Resolution: Done 10.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/313c57d67c3e443f8... > WSDL to Web Service model import doesn't work > --------------------------------------------- > > Key: TEIIDDES-2855 > URL: https://issues.jboss.org/browse/TEIIDDES-2855 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.1 > Reporter: Matus Makovy > Assignee: Barry LaFond > Priority: Critical > Fix For: 10.0.2 > > Attachments: Hello.wsdl, Screen Shot 2016-06-15 at 10.32.34.png > > > When I hit context menu and then Import -> WSDL File or URL >> Web Service Model, select hello.wsdl (attached) and click next I get an error message saying: "The model descriptor must be supplied" (see screenshot) and I cannot continue. This works with TD 9.0.7. and doesn't work with TD 10.0.1.Beta1. > Is this an issue that is related to Web Service model deprecation ? -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2911) Teiid designer doesn't import comments from DDL.

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2911?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2911. ------------------------------------ Resolution: Duplicate Issue See TEIIDDES-2411 and TEIIDDES-2749 > Teiid designer doesn't import comments from DDL. > ------------------------------------------------ > > Key: TEIIDDES-2911 > URL: https://issues.jboss.org/browse/TEIIDDES-2911 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 10.0.1 > Environment: Fedora 24 > Reporter: Matej Kralik > Assignee: Barry LaFond > Fix For: 10.0.2 > > Attachments: importDDLproject.zip, testComment.ddl > > > When I imported DLL which contains tables which have comments in the transformation SQL, teiid generated view model without this comments in the tables. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2749) Cache hint removed from transformation when importing dynamic VDB

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2749?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2749: ---------------------------------------- This is basically caused by the same teiid-modeshape parsing issue logged in TEIIDTOOLS-31 > Cache hint removed from transformation when importing dynamic VDB > ----------------------------------------------------------------- > > Key: TEIIDDES-2749 > URL: https://issues.jboss.org/browse/TEIIDDES-2749 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 10.0.2 > > > When importing a dynamic VDB, cache hints are removed from the transformation. > {code:xml} > <?xml version="1.0" encoding="UTF-8"?> > <vdb name="MatViewsVdb" version="1"> > <description>For testing of materialized views</description> > <model name="Source"> > <source name="Source" translator-name="h2-override" > connection-jndi-name="java:/mat-views-ds" /> > <metadata type="DDL"><![CDATA[ > > CREATE FOREIGN TABLE customers ( > id integer, > name string(4000), > address string(4000), > CONSTRAINT PK_ID PRIMARY KEY(id) > ) OPTIONS(NAMEINSOURCE 'customer') > > CREATE FOREIGN TABLE orders ( > id integer, > customer_id integer, > amount integer, > CONSTRAINT PK_ID PRIMARY KEY(id), > CONSTRAINT FK_CUST FOREIGN KEY(customer_id) REFERENCES customers(id) > ) OPTIONS(NAMEINSOURCE 'order') > ]]> > </metadata> > </model> > <model name="ViewModel" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW internal_short_ttl ( > customer_id integer NOT NULL, > total_amount integer > ) OPTIONS (MATERIALIZED 'TRUE', > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,before_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE before_load=before_load+1;'');', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,after_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE after_load=after_load+1;'')' > ) > AS /*+ cache(ttl:100)*/SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id; > ]]> > </metadata> > </model> > <translator name="h2-override" type="h2"> > <property name="SupportsDirectQueryProcedure" value="true" /> > </translator> > </vdb> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2749) Cache hint removed from transformation when importing dynamic VDB

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2749?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2749: ----------------------------------- Fix Version/s: (was: 11.0) > Cache hint removed from transformation when importing dynamic VDB > ----------------------------------------------------------------- > > Key: TEIIDDES-2749 > URL: https://issues.jboss.org/browse/TEIIDDES-2749 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 10.0.2 > > > When importing a dynamic VDB, cache hints are removed from the transformation. > {code:xml} > <?xml version="1.0" encoding="UTF-8"?> > <vdb name="MatViewsVdb" version="1"> > <description>For testing of materialized views</description> > <model name="Source"> > <source name="Source" translator-name="h2-override" > connection-jndi-name="java:/mat-views-ds" /> > <metadata type="DDL"><![CDATA[ > > CREATE FOREIGN TABLE customers ( > id integer, > name string(4000), > address string(4000), > CONSTRAINT PK_ID PRIMARY KEY(id) > ) OPTIONS(NAMEINSOURCE 'customer') > > CREATE FOREIGN TABLE orders ( > id integer, > customer_id integer, > amount integer, > CONSTRAINT PK_ID PRIMARY KEY(id), > CONSTRAINT FK_CUST FOREIGN KEY(customer_id) REFERENCES customers(id) > ) OPTIONS(NAMEINSOURCE 'order') > ]]> > </metadata> > </model> > <model name="ViewModel" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW internal_short_ttl ( > customer_id integer NOT NULL, > total_amount integer > ) OPTIONS (MATERIALIZED 'TRUE', > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,before_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE before_load=before_load+1;'');', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,after_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE after_load=after_load+1;'')' > ) > AS /*+ cache(ttl:100)*/SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id; > ]]> > </metadata> > </model> > <translator name="h2-override" type="h2"> > <property name="SupportsDirectQueryProcedure" value="true" /> > </translator> > </vdb> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2749) Cache hint removed from transformation when importing dynamic VDB

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2749?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2749: ---------------------------------------- Underlying issues is with the Teiid Parser throwing away the comments by default > Cache hint removed from transformation when importing dynamic VDB > ----------------------------------------------------------------- > > Key: TEIIDDES-2749 > URL: https://issues.jboss.org/browse/TEIIDDES-2749 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 10.0.2, 11.0 > > > When importing a dynamic VDB, cache hints are removed from the transformation. > {code:xml} > <?xml version="1.0" encoding="UTF-8"?> > <vdb name="MatViewsVdb" version="1"> > <description>For testing of materialized views</description> > <model name="Source"> > <source name="Source" translator-name="h2-override" > connection-jndi-name="java:/mat-views-ds" /> > <metadata type="DDL"><![CDATA[ > > CREATE FOREIGN TABLE customers ( > id integer, > name string(4000), > address string(4000), > CONSTRAINT PK_ID PRIMARY KEY(id) > ) OPTIONS(NAMEINSOURCE 'customer') > > CREATE FOREIGN TABLE orders ( > id integer, > customer_id integer, > amount integer, > CONSTRAINT PK_ID PRIMARY KEY(id), > CONSTRAINT FK_CUST FOREIGN KEY(customer_id) REFERENCES customers(id) > ) OPTIONS(NAMEINSOURCE 'order') > ]]> > </metadata> > </model> > <model name="ViewModel" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW internal_short_ttl ( > customer_id integer NOT NULL, > total_amount integer > ) OPTIONS (MATERIALIZED 'TRUE', > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,before_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE before_load=before_load+1;'');', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,after_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE after_load=after_load+1;'')' > ) > AS /*+ cache(ttl:100)*/SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id; > ]]> > </metadata> > </model> > <translator name="h2-override" type="h2"> > <property name="SupportsDirectQueryProcedure" value="true" /> > </translator> > </vdb> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2650) Changing Fields in several dialogues Causes Designer to Hang

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2650?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-2650 at 9/15/16 3:43 PM: ----------------------------------------------------------------- 10.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/aed1e294e8132df74... * removes all cell editing support to prevent getting into the issue in the first place * cleaned up table-editor buttons enablement to prevent wrong enablements based on selection etc..... 10.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/420b3865417cdf19e... * added edit property action and dialog to VDB user-defined properties table * added double-click edit to general properties table and translator override properties table Note that the *value* table cell editing support is still active for these 2 property tables, so the *Edit* button is an option and workaround if cell editing hangs. was (Author: blafond): 10.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/aed1e294e8132df74... * removes all cell editing support to prevent getting into the issue in the first place * cleaned up table-editor buttons enablement to prevent wrong enablements based on selection etc..... > Changing Fields in several dialogues Causes Designer to Hang > ------------------------------------------------------------ > > Key: TEIIDDES-2650 > URL: https://issues.jboss.org/browse/TEIIDDES-2650 > Project: Teiid Designer > Issue Type: Bug > Components: Patch Release > Affects Versions: 9.0.3 > Environment: MAC OS X > Reporter: Matus Makovy > Assignee: Barry LaFond > Priority: Critical > Fix For: 10.0.2 > > > This issue still occurs in several other dialogues on MAC OS X. > * Create Relational View Table -> Columns > * Create Relational View Procedure -> Result Set (+ I am able to edit values in row, without using "Edit" button) > * Create Relational Table -> Colums > * Create Relational Procedure -> Parameters, Result Set > * Create Relational Source Function -> Parameters > * Create Relational Native Query Procedure -> Parameters, Result Set > * Create Relational View -> Columns > * Changing translator in VDB Editor -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2650) Changing Fields in several dialogues Causes Designer to Hang

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2650?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2650. ------------------------------------ Resolution: Done Done > Changing Fields in several dialogues Causes Designer to Hang > ------------------------------------------------------------ > > Key: TEIIDDES-2650 > URL: https://issues.jboss.org/browse/TEIIDDES-2650 > Project: Teiid Designer > Issue Type: Bug > Components: Patch Release > Affects Versions: 9.0.3 > Environment: MAC OS X > Reporter: Matus Makovy > Assignee: Barry LaFond > Priority: Critical > Fix For: 10.0.2 > > > This issue still occurs in several other dialogues on MAC OS X. > * Create Relational View Table -> Columns > * Create Relational View Procedure -> Result Set (+ I am able to edit values in row, without using "Edit" button) > * Create Relational Table -> Colums > * Create Relational Procedure -> Parameters, Result Set > * Create Relational Source Function -> Parameters > * Create Relational Native Query Procedure -> Parameters, Result Set > * Create Relational View -> Columns > * Changing translator in VDB Editor -- This message was sent by Atlassian JIRA (v6.4.11#64026)

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-designer-issues September 2016