December 2015 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2622) DDL importer does not properly set Materialized table options

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2622?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2622: -------------------------------------- Assignee: Barry LaFond (was: Mark Drilling) > DDL importer does not properly set Materialized table options > ------------------------------------------------------------- > > Key: TEIIDDES-2622 > URL: https://issues.jboss.org/browse/TEIIDDES-2622 > Project: Teiid Designer > Issue Type: Bug > Components: Extension Framework, Import/Export, Patch Release > Affects Versions: 9.0.1, 9.1 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 9.2.1 > > > Importing a DDL similar to the one [here|https://docs.jboss.org/author/display/teiid810final/External+Materia...], the Materialized property of the view table is set, but the Materialized Table property is not. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[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 commented on TEIIDDES-2684: ---------------------------------------- master: https://github.com/Teiid-Designer/teiid-designer/commit/45a83cff2d2249c49... > SalesForce importer issue > ------------------------- > > Key: TEIIDDES-2684 > URL: https://issues.jboss.org/browse/TEIIDDES-2684 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 9.0.4 > Environment: MAC OS > Reporter: Matus Makovy > Assignee: Mark Drilling > Fix For: 9.2.1 > > Attachments: salesdynamic-vdb.xml > > > 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)

9 years

1
0
0 / 0

[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 resolved TEIIDDES-2684. ------------------------------------ Resolution: Done > SalesForce importer issue > ------------------------- > > Key: TEIIDDES-2684 > URL: https://issues.jboss.org/browse/TEIIDDES-2684 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 9.0.4 > Environment: MAC OS > Reporter: Matus Makovy > Assignee: Mark Drilling > Fix For: 9.2.1 > > Attachments: salesdynamic-vdb.xml > > > 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)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2700) DDL Export logic does not add non-relational extension properties to the DDL OPTIONS() clause

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2700?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2700. ------------------------------------ Resolution: Done master: https://github.com/Teiid-Designer/teiid-designer/commit/45a83cff2d2249c49... > DDL Export logic does not add non-relational extension properties to the DDL OPTIONS() clause > --------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2700 > URL: https://issues.jboss.org/browse/TEIIDDES-2700 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs, Import/Export, Patch Release > Reporter: Barry LaFond > Assignee: Barry LaFond > Priority: Blocker > Fix For: 9.2.1 > > > Trying to Export the attached salesforce XMI model, the salesforce extension properties are not included in the OPTIONS() clause. > TeiidModelToDdlGenerator.getTableOptions() method is only adding standard relational properties and not looking via the extension assistant framework. > May need to add a method on the assistant API like *protected Properties getTeiidDdlOptions(BaseTable table)* which would make it clear what the methed returned -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2232) Cannot create JDBC/Oracle connection profile using ServiceName syntax

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2232?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2232: --------------------------------------------------- Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1272599|https://bugzilla.redhat.com/show_bug.cgi?id=1272599] from NEW to CLOSED > Cannot create JDBC/Oracle connection profile using ServiceName syntax > --------------------------------------------------------------------- > > Key: TEIIDDES-2232 > URL: https://issues.jboss.org/browse/TEIIDDES-2232 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Affects Versions: 8.4 > Reporter: Tom Johnston > Assignee: Barry LaFond > > Cannot successfully create a jdbc url like: > "jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename" > which is found here: > http://docs.oracle.com/cd/B14117_01/java.101/b10979/urls.htm > Note the "../myservicename" -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2199) Designer deletes materialization setting in transformation Editor

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2199?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2199: -------------------------------------- Assignee: Paul Richardson > Designer deletes materialization setting in transformation Editor > ----------------------------------------------------------------- > > Key: TEIIDDES-2199 > URL: https://issues.jboss.org/browse/TEIIDDES-2199 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 8.3.2 > Environment: fedora 19, Red Hat Data Virtualization 6, JBDS 7.1.1.GA > Reporter: Jason Marley > Assignee: Paul Richardson > Fix For: 9.2.1 > > > In transformation editor and add caching comment /*+ cache(ttl:300000) */, if there is a space before + and the beginning of comment, upon save designer deletes the line. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2199) Designer deletes materialization setting in transformation Editor

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2199?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2199: ----------------------------------- Component/s: Patch Release Transformations > Designer deletes materialization setting in transformation Editor > ----------------------------------------------------------------- > > Key: TEIIDDES-2199 > URL: https://issues.jboss.org/browse/TEIIDDES-2199 > Project: Teiid Designer > Issue Type: Bug > Components: Patch Release, Transformations > Affects Versions: 8.3.2 > Environment: fedora 19, Red Hat Data Virtualization 6, JBDS 7.1.1.GA > Reporter: Jason Marley > Assignee: Paul Richardson > Fix For: 9.2.1 > > > In transformation editor and add caching comment /*+ cache(ttl:300000) */, if there is a space before + and the beginning of comment, upon save designer deletes the line. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2199) Designer deletes materialization setting in transformation Editor

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2199?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2199: ----------------------------------- Fix Version/s: 9.2.1 > Designer deletes materialization setting in transformation Editor > ----------------------------------------------------------------- > > Key: TEIIDDES-2199 > URL: https://issues.jboss.org/browse/TEIIDDES-2199 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 8.3.2 > Environment: fedora 19, Red Hat Data Virtualization 6, JBDS 7.1.1.GA > Reporter: Jason Marley > Fix For: 9.2.1 > > > In transformation editor and add caching comment /*+ cache(ttl:300000) */, if there is a space before + and the beginning of comment, upon save designer deletes the line. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2745) Extension properties not imported from dynamic VDB

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2745?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2745: -------------------------------------- Assignee: Barry LaFond > Extension properties not imported from dynamic VDB > -------------------------------------------------- > > Key: TEIIDDES-2745 > URL: https://issues.jboss.org/browse/TEIIDDES-2745 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 9.2.1 > > > When importing a dynamic VDB containing models with extension properties, the properties are not imported. > {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; > > CREATE VIEW internal_long_ttl ( > customer_id integer PRIMARY KEY, > total_amount integer > ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE') > AS /*+ cache(ttl:1000 updatable)*/ 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; > > CREATE VIEW external_long_ttl ( > customer_id integer NOT NULL, > total_amount integer > ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE', > MATERIALIZED_TABLE 'Source.DB.PUBLIC.MAT_VIEW', > "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', > "teiid_rel:MATVIEW_STATUS_TABLE" 'Source.DB.PUBLIC.STATUS', > "teiid_rel:ON_VDB_START_SCRIPT" 'exec Source.native(''MERGE INTO check_table(id,vdb_create) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT vdb_create from check_table WHERE id=''''external_long_ttl''''),0)+1)'');', > "teiid_rel:ON_VDB_DROP_SCRIPT" 'exec Source.native(''MERGE INTO check_table(id,vdb_drop) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT vdb_drop from check_table WHERE id=''''external_long_ttl''''),0)+1)'');', > "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO mat_view_stage(customer_id,total_amount) SELECT c.id AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;', > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute Source.native(''truncate table mat_view_stage'');exec Source.native(''MERGE INTO check_table(id,before_load) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT before_load from check_table WHERE id=''''external_long_ttl''''),0)+1)'');', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'exec Source.native(''ALTER TABLE mat_view_stage RENAME TO mat_view_temp'');exec Source.native(''ALTER TABLE mat_view RENAME TO mat_view_stage'');exec Source.native(''ALTER TABLE mat_view_temp RENAME TO mat_view'');exec Source.native(''MERGE INTO check_table(id,after_load) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT after_load from check_table WHERE id=''''external_long_ttl''''),0)+1)'');', > "teiid_rel:MATVIEW_ONERROR_ACTION" 'THROW_EXCEPTION', > "teiid_rel:MATVIEW_TTL" 2000) > AS 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

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2745) Extension properties not imported from dynamic VDB

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2745?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2745: ----------------------------------- Fix Version/s: 9.2.1 > Extension properties not imported from dynamic VDB > -------------------------------------------------- > > Key: TEIIDDES-2745 > URL: https://issues.jboss.org/browse/TEIIDDES-2745 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 9.2.1 > > > When importing a dynamic VDB containing models with extension properties, the properties are not imported. > {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; > > CREATE VIEW internal_long_ttl ( > customer_id integer PRIMARY KEY, > total_amount integer > ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE') > AS /*+ cache(ttl:1000 updatable)*/ 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; > > CREATE VIEW external_long_ttl ( > customer_id integer NOT NULL, > total_amount integer > ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE', > MATERIALIZED_TABLE 'Source.DB.PUBLIC.MAT_VIEW', > "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', > "teiid_rel:MATVIEW_STATUS_TABLE" 'Source.DB.PUBLIC.STATUS', > "teiid_rel:ON_VDB_START_SCRIPT" 'exec Source.native(''MERGE INTO check_table(id,vdb_create) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT vdb_create from check_table WHERE id=''''external_long_ttl''''),0)+1)'');', > "teiid_rel:ON_VDB_DROP_SCRIPT" 'exec Source.native(''MERGE INTO check_table(id,vdb_drop) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT vdb_drop from check_table WHERE id=''''external_long_ttl''''),0)+1)'');', > "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO mat_view_stage(customer_id,total_amount) SELECT c.id AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;', > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute Source.native(''truncate table mat_view_stage'');exec Source.native(''MERGE INTO check_table(id,before_load) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT before_load from check_table WHERE id=''''external_long_ttl''''),0)+1)'');', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'exec Source.native(''ALTER TABLE mat_view_stage RENAME TO mat_view_temp'');exec Source.native(''ALTER TABLE mat_view RENAME TO mat_view_stage'');exec Source.native(''ALTER TABLE mat_view_temp RENAME TO mat_view'');exec Source.native(''MERGE INTO check_table(id,after_load) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT after_load from check_table WHERE id=''''external_long_ttl''''),0)+1)'');', > "teiid_rel:MATVIEW_ONERROR_ACTION" 'THROW_EXCEPTION', > "teiid_rel:MATVIEW_TTL" 2000) > AS 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

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues December 2015