November 2015 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2731) VDB exported to Dynamic VDB XML, the foreign key relations have erroneous references in the resulting SQL.

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2731?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2731: -------------------------------------- Assignee: Barry LaFond > VDB exported to Dynamic VDB XML, the foreign key relations have erroneous references in the resulting SQL. > ------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2731 > URL: https://issues.jboss.org/browse/TEIIDDES-2731 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs, Import/Export, Patch Release > Affects Versions: 9.2 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 9.2.1 > > Attachments: TestcaseforExport.zip > > > Model: > • Catalog (ID, SecondID, ThirdID). Primary key: (ID). Unique constraint: (SecondID, ThirdID) > • CatalogItem(ID,CatalogID, CatalogSecondID, CatalogThirdID) > Foreign key relation on Unique constraints, spanning two columns: CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) > Expected in metadata DLL for CatalogItem: > CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(SecondID, ThirdID) > Actual: > CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(ID) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2732) Issues with Dynamic VDB to Models - FOREIGN KEY REFERENCING MULTIPLE COLUMNS

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2732?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2732: ----------------------------------- Fix Version/s: 9.2.1 > Issues with Dynamic VDB to Models - FOREIGN KEY REFERENCING MULTIPLE COLUMNS > ----------------------------------------------------------------------------- > > Key: TEIIDDES-2732 > URL: https://issues.jboss.org/browse/TEIIDDES-2732 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.2 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 9.2.1 > > Attachments: TestcaseforImport.zip > > > AFTER IMPORTING FROM XML INTO TEIID: FOREIGN KEY REFERENCING MULTIPLE COLUMNS POINTS TO WRONG COLUMNS IN SOURCE MODEL > Test case : Foreign key relation on Unique constraints, spanning two columns: CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) > XML INPUT fragment for Source model, table CatalogItem: > CONSTRAINT FKI_CATALOG_ID FOREIGN KEY(CatalogID) REFERENCES Catalog(ID), > CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(SecondID, ThirdID) > Expected in Teiid: > CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) > Actual: > CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(ID) > 3. AFTER IMPORTING FROM XML INTO TEIID: FOREIGN KEY REFERENCING MULTIPLE COLUMNS IS MISSING IN VIEW MODEL. > Test case : Foreign key relation on Unique constraints, spanning two columns: CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) > XML INPUT fragment for View model, table CatalogItem: > CONSTRAINT FKI_CATALOG_ID FOREIGN KEY(CatalogID) REFERENCES Catalog(ID), > CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(SecondID, ThirdID) > Expected in Teiid: > CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) > Actual: > Not Foreign key reference at all. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2732) Issues with Dynamic VDB to Models - FOREIGN KEY REFERENCING MULTIPLE COLUMNS

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2732?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2732: ----------------------------------- Component/s: Patch Release > Issues with Dynamic VDB to Models - FOREIGN KEY REFERENCING MULTIPLE COLUMNS > ----------------------------------------------------------------------------- > > Key: TEIIDDES-2732 > URL: https://issues.jboss.org/browse/TEIIDDES-2732 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 9.2 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 9.2.1 > > Attachments: TestcaseforImport.zip > > > AFTER IMPORTING FROM XML INTO TEIID: FOREIGN KEY REFERENCING MULTIPLE COLUMNS POINTS TO WRONG COLUMNS IN SOURCE MODEL > Test case : Foreign key relation on Unique constraints, spanning two columns: CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) > XML INPUT fragment for Source model, table CatalogItem: > CONSTRAINT FKI_CATALOG_ID FOREIGN KEY(CatalogID) REFERENCES Catalog(ID), > CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(SecondID, ThirdID) > Expected in Teiid: > CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) > Actual: > CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(ID) > 3. AFTER IMPORTING FROM XML INTO TEIID: FOREIGN KEY REFERENCING MULTIPLE COLUMNS IS MISSING IN VIEW MODEL. > Test case : Foreign key relation on Unique constraints, spanning two columns: CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) > XML INPUT fragment for View model, table CatalogItem: > CONSTRAINT FKI_CATALOG_ID FOREIGN KEY(CatalogID) REFERENCES Catalog(ID), > CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(SecondID, ThirdID) > Expected in Teiid: > CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) > Actual: > Not Foreign key reference at all. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2732) Issues with Dynamic VDB to Models - FOREIGN KEY REFERENCING MULTIPLE COLUMNS

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2732?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2732: -------------------------------------- Assignee: Barry LaFond > Issues with Dynamic VDB to Models - FOREIGN KEY REFERENCING MULTIPLE COLUMNS > ----------------------------------------------------------------------------- > > Key: TEIIDDES-2732 > URL: https://issues.jboss.org/browse/TEIIDDES-2732 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.2 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Attachments: TestcaseforImport.zip > > > AFTER IMPORTING FROM XML INTO TEIID: FOREIGN KEY REFERENCING MULTIPLE COLUMNS POINTS TO WRONG COLUMNS IN SOURCE MODEL > Test case : Foreign key relation on Unique constraints, spanning two columns: CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) > XML INPUT fragment for Source model, table CatalogItem: > CONSTRAINT FKI_CATALOG_ID FOREIGN KEY(CatalogID) REFERENCES Catalog(ID), > CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(SecondID, ThirdID) > Expected in Teiid: > CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) > Actual: > CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(ID) > 3. AFTER IMPORTING FROM XML INTO TEIID: FOREIGN KEY REFERENCING MULTIPLE COLUMNS IS MISSING IN VIEW MODEL. > Test case : Foreign key relation on Unique constraints, spanning two columns: CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) > XML INPUT fragment for View model, table CatalogItem: > CONSTRAINT FKI_CATALOG_ID FOREIGN KEY(CatalogID) REFERENCES Catalog(ID), > CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(SecondID, ThirdID) > Expected in Teiid: > CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) > Actual: > Not Foreign key reference at all. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2644) Cannot launch the Create View Table Wizard in Create multi-source VDB Cheat Sheets.

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2644?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2644: -------------------------------------- Assignee: Dan Florian > Cannot launch the Create View Table Wizard in Create multi-source VDB Cheat Sheets. > ----------------------------------------------------------------------------------- > > Key: TEIIDDES-2644 > URL: https://issues.jboss.org/browse/TEIIDDES-2644 > Project: Teiid Designer > Issue Type: Bug > Components: Dialogs, Patch Release > Affects Versions: 9.0.3 > Reporter: Matej Kralik > Assignee: Dan Florian > Priority: Minor > Fix For: 9.2.1, 10.1 > > Attachments: Snímka obrazovky z 2015-09-10 13-32-25.png > > > Cannot launch the Create View Table wizard in Create multi-source VDB Cheat Sheets. When I try launch the Create View Table wizard pops up: Unimplemented Action. Action for ID[org.teiid.designer.newObjectViewTable] is not yet implemented. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2473) Support multiple metadata tags

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2473?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2473: -------------------------------------- Assignee: Dan Florian > Support multiple metadata tags > ------------------------------ > > Key: TEIIDDES-2473 > URL: https://issues.jboss.org/browse/TEIIDDES-2473 > Project: Teiid Designer > Issue Type: Feature Request > Components: Patch Release, Teiid Integration > Reporter: Steven Hawkins > Assignee: Dan Florian > Fix For: 9.2.1 > > > With TEIID-3372 we allowed metadata tags under a model, rather than relying on comma separated values. Any Designer side logic dealing with the DMR layer will need to be updated to match the new server side logic - see ModelMetaData getSourceMetadataType and getSourceMetadataText -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2641) Copying Model problem

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2641?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2641: -------------------------------------- Assignee: Paul Richardson > Copying Model problem > --------------------- > > Key: TEIIDDES-2641 > URL: https://issues.jboss.org/browse/TEIIDDES-2641 > Project: Teiid Designer > Issue Type: Bug > Components: Patch Release > Affects Versions: 9.0.3 > Reporter: stanislav kaleta > Assignee: Paul Richardson > Fix For: 9.2.1 > > Attachments: CopyModelImports.png, CopyModelProcedureSQL.png, TestedProject.zip > > > When creating new view model by copying from existing model (see steps to reproduce), two bugs occurs. > First: > In Transformation Diagram of model's procedures, name of model is not updated. > !CopyModelProcedureSQL.png|thumbnail! > In this case "Products_view.PRODUCTDATA.NAME" should be updated to > "<new_model_name>.PRODUCTDATA.NAME", otherwise it produce validation error. > Additionally: > If location of new model is different from existing model (different folder or project), import declarations to source model will be added as following: > * import declaration to source model is added (in this case: /Dataroles/sources/Products_source.xmi) > * concurrently, another import declaration (with name: Model Import) with error (Unable to resolve the imported model ../sources/Products_source.xmi) is added. > !CopyModelImports.png|thumbnail! -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[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 updated TEIIDDES-2622: ----------------------------------- Component/s: Extension Framework > 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 > 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)

10 years, 5 months

1
0
0 / 0

[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: 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: Mark Drilling > 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)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2659) Preview data will have deployed the driver to the server only after first error.

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2659?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2659: -------------------------------------- Assignee: Dan Florian > Preview data will have deployed the driver to the server only after first error. > -------------------------------------------------------------------------------- > > Key: TEIIDDES-2659 > URL: https://issues.jboss.org/browse/TEIIDDES-2659 > Project: Teiid Designer > Issue Type: Bug > Components: Data Preview, Patch Release > Affects Versions: 9.0.3 > Reporter: Matej Kralik > Assignee: Dan Florian > Priority: Minor > Fix For: 9.2.1 > > > I removed a driver from the server,then clicked to refresh teiid instance connection in the Jboss developer studio. (once or more) but preview data doesn't deploy the driver on the server and shows error (TEIID30498 Capabilities for [source model] were not avaialable. The command could not be planned properly.). And from now when I click to refresh teiid instance connection and I click to preview data, data will be show correctly. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 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 November 2015