[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)
8 years, 4 months
[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)
8 years, 4 months
[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)
8 years, 4 months
[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)
8 years, 4 months
[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)
8 years, 4 months
[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)
8 years, 4 months
[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)
8 years, 4 months