August 2016 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2270) Add capability to import a project for migrations.

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2270?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2270: ----------------------------------- Fix Version/s: 11.0 (was: 10.0.2) > Add capability to import a project for migrations. > -------------------------------------------------- > > Key: TEIIDDES-2270 > URL: https://issues.jboss.org/browse/TEIIDDES-2270 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export > Affects Versions: 8.5 > Reporter: Hisanobu Okuda > Assignee: Barry LaFond > Fix For: 11.0 > > > This capability would allow a user to easily upgrade their Designer version without losing anything. The workspace export/import would bring along projects, preferences, connector bindings, extension jars, etc. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 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: ----------------------------------- Description: 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} was: 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} > 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)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2529) 1024 x 768 Issue with XML model editor - can not reach red "Staging table arrow" when scrolling

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2529?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2529: ----------------------------------- Fix Version/s: 11.0 (was: 10.0.2) > 1024 x 768 Issue with XML model editor - can not reach red "Staging table arrow" when scrolling > ----------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2529 > URL: https://issues.jboss.org/browse/TEIIDDES-2529 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.2 > Reporter: Matus Makovy > Fix For: 11.0 > > Attachments: bug.mov, Screen Shot 2015-05-18 at 4.30.23 PM.png, Screen Shot 2015-05-18 at 4.30.30 PM.png, Screen Shot 2015-05-18 at 4.30.32 PM.png > > > I am trying to add transformation source. I have to right-click "red arrow" in the model editor and I am not able to reach it. > Screenshots + video attached > Issue occured on OS X -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 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: 10.0.2 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 > 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)

9 years, 2 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 reassigned TEIIDDES-2749: -------------------------------------- Assignee: Barry LaFond > 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)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2695) Deployed dynamic VDB not shown in server views

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2695?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2695: ----------------------------------- Fix Version/s: 10.0.2 11.0 > Deployed dynamic VDB not shown in server views > ---------------------------------------------- > > Key: TEIIDDES-2695 > URL: https://issues.jboss.org/browse/TEIIDDES-2695 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Reporter: Andrej Šmigala > Fix For: 10.0.2, 11.0 > > > When a dynamic VDB (created from a VDB archive) is deployed on the server, it is not shown in the list of VDBs in the Servers view, only after refreshing the server. Suggesting to show it immediately after deploying, like with regular VDBs. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2695) Deployed dynamic VDB not shown in server views

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2695?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2695: -------------------------------------- Assignee: Barry LaFond > Deployed dynamic VDB not shown in server views > ---------------------------------------------- > > Key: TEIIDDES-2695 > URL: https://issues.jboss.org/browse/TEIIDDES-2695 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 10.0.2, 11.0 > > > When a dynamic VDB (created from a VDB archive) is deployed on the server, it is not shown in the list of VDBs in the Servers view, only after refreshing the server. Suggesting to show it immediately after deploying, like with regular VDBs. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-417) Metadata from Text File importer requires use of file Browse button even though file can be entered manually - Finish button is enabled

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-417?page=com.atlassian.jira.plug... ] Matus Makovy reopened TEIIDDES-417: ----------------------------------- > Metadata from Text File importer requires use of file Browse button even though file can be entered manually - Finish button is enabled > --------------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-417 > URL: https://issues.jboss.org/browse/TEIIDDES-417 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 6.3, 8.0 > Environment: Iced Tea, Teiid Designer 6.3 > Reporter: Paul Nittel > Assignee: Mark Drilling > Fix For: 8.2 > > Attachments: IMFTF.jpg > > > I was writing a SWTBot test to create a view model's tables when I ran into this. > Knowing SWTBot can't handle the File Chooser, I was delighted to see I could enter the text file's path and name directly into the importer dialog. It wasn't until some time later that I realized merely typing in the name does nothing; you MUST enter the name using the File Chooser. (Once that's been done, it appears you can use the drop-down to re-select that file, but you need that first time entry.) > What's really bad/confusing is manually entering the file and target location enables the Finish button. Clicking it appears to work, but no tables were added to the model. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1900) Parameter map in generated rest war not thread safe

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1900?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-1900. ---------------------------------- > Parameter map in generated rest war not thread safe > --------------------------------------------------- > > Key: TEIIDDES-1900 > URL: https://issues.jboss.org/browse/TEIIDDES-1900 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 7.8 > Reporter: Steven Hawkins > > The parameter map is held as an instance variable which is not thread safe. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1798) When selecting REST:CHARSET of UTF-8, designer halts

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1798?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-1798. ---------------------------------- I am closing this, since this is a duplicate of TEIIDDES-1578 and that one is already closed. > When selecting REST:CHARSET of UTF-8, designer halts > ---------------------------------------------------- > > Key: TEIIDDES-1798 > URL: https://issues.jboss.org/browse/TEIIDDES-1798 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling > Affects Versions: 8.2 > Reporter: Van Halbert > Assignee: Barry LaFond > Attachments: Sample.vdb > > > When building a rest procedure and selecting REST:CHARSET of UTF-8, designer halts. On the mac, get a continuous spinning wheel. It still has not stopped by the time I've completed writing this jira. > The second time having to kill JBDS. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues August 2016