November 2017 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-3024) Import/Export ddl problem with Indexes

by Mario Majernik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3024?page=com.atlassian.jira.plu... ] Mario Majernik closed TEIIDDES-3024. ------------------------------------ > Import/Export ddl problem with Indexes > --------------------------------------- > > Key: TEIIDDES-3024 > URL: https://issues.jboss.org/browse/TEIIDDES-3024 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 11.0.1 > Reporter: Mario Majernik > Assignee: Barry LaFond > Labels: release_notes > Fix For: 11.1 > > Attachments: verification.zip > > > According this : [DDL metadata|https://docs.jboss.org/author/display/TEIID/DDL+Metadata] > Index should look like this: > CONSTRAINT EXAMPLE_INDEX INDEX (name, amount) > but in our ddl look: > newColumn_1 string(4000) INDEX > Problem is that when we export and import source model new model have two indexes with the same default name INDEX(colision/error) and also there are missing atributes Name In Source and description. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2683) Importing Excel file using Teiid Connection does not import extension properties

by Michael Echevarria (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2683?page=com.atlassian.jira.plu... ] Michael Echevarria updated TEIIDDES-2683: ----------------------------------------- Attachment: excel-import-problem.mkv > Importing Excel file using Teiid Connection does not import extension properties > -------------------------------------------------------------------------------- > > Key: TEIIDDES-2683 > URL: https://issues.jboss.org/browse/TEIIDDES-2683 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 11.1 > > Attachments: excel-import-problem.mkv > > > When importing an excel file using Teiid Connection, the extension properties are silently discarded. This results in invalid model, which, when deployed and queried, causes the following error in the server log: > bq. Connector worker process failed for atomic-request=AVU37BnZoOUS.0.0.0: org.teiid.translator.TranslatorException: TEIID23007 OPTIONS property CELL_NUMBER is required and it not defined on column ROW_ID > The DDL obtained from the server is > {code:sql} > SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel; > CREATE FOREIGN TABLE Sheet1 ( > ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'), > StringNum string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'), > CharValue string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'), > DoubleNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'), > BigIntegerValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '4'), > ShortValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '5'), > FloatNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '6'), > ObjectValue string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '7'), > IntNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '8'), > BigDecimalValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '9'), > LongNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '10'), > BooleanValue boolean OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '11'), > TimestampValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '12'), > ByteNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '13'), > IntKey double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '14'), > StringKey string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '15'), > TimeValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '16'), > DateValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '17'), > CONSTRAINT PK0 PRIMARY KEY(ROW_ID) > ) OPTIONS ("teiid_excel:FILE" 'smalla.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2'); > {code} > When trying to import the same DDL using the DDL import wizard, a warning dialog is shown stating that the extension properties could not be processed and the Model Extension Definition should be registered -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3147) Import a REST service source and view model crashes

by Michael Echevarria (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3147?page=com.atlassian.jira.plu... ] Michael Echevarria updated TEIIDDES-3147: ----------------------------------------- Attachment: rest-import-crash.mkv > Import a REST service source and view model crashes > --------------------------------------------------- > > Key: TEIIDDES-3147 > URL: https://issues.jboss.org/browse/TEIIDDES-3147 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Usability > Affects Versions: 11.1 > Environment: JBoss Developer Studio 11, Teiid Designer 11.1 > Reporter: Michael Echevarria > Assignee: Barry LaFond > Priority: Critical > Attachments: rest-import-crash.mkv > > > When generating the source and view model on importing a web service, the designer will occasionally throw and error and fail the import -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3147) Import a REST service source and view model crashes

by Michael Echevarria (JIRA)

Michael Echevarria created TEIIDDES-3147: -------------------------------------------- Summary: Import a REST service source and view model crashes Key: TEIIDDES-3147 URL: https://issues.jboss.org/browse/TEIIDDES-3147 Project: Teiid Designer Issue Type: Bug Components: Import/Export, Usability Affects Versions: 11.1 Environment: JBoss Developer Studio 11, Teiid Designer 11.1 Reporter: Michael Echevarria Assignee: Barry LaFond Priority: Critical When generating the source and view model on importing a web service, the designer will occasionally throw and error and fail the import -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3146) Teiid Execution plan locks up Teiid Designer

by Michael Echevarria (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3146?page=com.atlassian.jira.plu... ] Michael Echevarria updated TEIIDDES-3146: ----------------------------------------- Attachment: lockup.mkv > Teiid Execution plan locks up Teiid Designer > -------------------------------------------- > > Key: TEIIDDES-3146 > URL: https://issues.jboss.org/browse/TEIIDDES-3146 > Project: Teiid Designer > Issue Type: Bug > Components: Data Preview > Affects Versions: 11.1 > Environment: JBoss Developer Studio 11 with Teiid Designer 11.1 > Reporter: Michael Echevarria > Assignee: Barry LaFond > Priority: Critical > Attachments: lockup.mkv > > > Previewing data on any datasource that is not relational (file, excel, REST, etc) will produce a delay as the Teiid Execution Plan is calculated. During calculation, the entire Teiid Designer workspace is locked. When calculating execution plans on more than one datasource this delay can take several minutes. The designer is completely unusable while calculating -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2683) Importing Excel file using Teiid Connection does not import extension properties

by Michael Echevarria (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2683?page=com.atlassian.jira.plu... ] Michael Echevarria commented on TEIIDDES-2683: ---------------------------------------------- The workaround I discovered was to save the DDL that is generated during the wizard process, close and exit the designer and restart the server. Then import that DDL as the source model. Sometimes I still get a prompt saying the capabilites are not registered and I need to restart the designer a second time. > Importing Excel file using Teiid Connection does not import extension properties > -------------------------------------------------------------------------------- > > Key: TEIIDDES-2683 > URL: https://issues.jboss.org/browse/TEIIDDES-2683 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 11.1 > > > When importing an excel file using Teiid Connection, the extension properties are silently discarded. This results in invalid model, which, when deployed and queried, causes the following error in the server log: > bq. Connector worker process failed for atomic-request=AVU37BnZoOUS.0.0.0: org.teiid.translator.TranslatorException: TEIID23007 OPTIONS property CELL_NUMBER is required and it not defined on column ROW_ID > The DDL obtained from the server is > {code:sql} > SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel; > CREATE FOREIGN TABLE Sheet1 ( > ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'), > StringNum string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'), > CharValue string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'), > DoubleNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'), > BigIntegerValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '4'), > ShortValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '5'), > FloatNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '6'), > ObjectValue string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '7'), > IntNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '8'), > BigDecimalValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '9'), > LongNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '10'), > BooleanValue boolean OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '11'), > TimestampValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '12'), > ByteNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '13'), > IntKey double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '14'), > StringKey string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '15'), > TimeValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '16'), > DateValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '17'), > CONSTRAINT PK0 PRIMARY KEY(ROW_ID) > ) OPTIONS ("teiid_excel:FILE" 'smalla.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2'); > {code} > When trying to import the same DDL using the DDL import wizard, a warning dialog is shown stating that the extension properties could not be processed and the Model Extension Definition should be registered -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3146) Teiid Execution plan locks up Teiid Designer

by Michael Echevarria (JIRA)

Michael Echevarria created TEIIDDES-3146: -------------------------------------------- Summary: Teiid Execution plan locks up Teiid Designer Key: TEIIDDES-3146 URL: https://issues.jboss.org/browse/TEIIDDES-3146 Project: Teiid Designer Issue Type: Bug Components: Data Preview Affects Versions: 11.1 Environment: JBoss Developer Studio 11 with Teiid Designer 11.1 Reporter: Michael Echevarria Assignee: Barry LaFond Priority: Critical Previewing data on any datasource that is not relational (file, excel, REST, etc) will produce a delay as the Teiid Execution Plan is calculated. During calculation, the entire Teiid Designer workspace is locked. When calculating execution plans on more than one datasource this delay can take several minutes. The designer is completely unusable while calculating -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3145) Warning dialog is shown differently according to platform

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3145?page=com.atlassian.jira.plu... ] Matej Kralik edited comment on TEIIDDES-3145 at 11/20/17 12:40 PM: ------------------------------------------------------------------- [~mmakovy] Can you please verify whether you have the same problem on your mac? If so, I suggest set this issue as a blocker (because user are not able to see whole warning). was (Author: mkralik): [~makovy] Can you please verify whether you have the same problem on your mac? If so, I suggest set this issue as a blocker (because user are not able to see whole warning). > Warning dialog is shown differently according to platform > --------------------------------------------------------- > > Key: TEIIDDES-3145 > URL: https://issues.jboss.org/browse/TEIIDDES-3145 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 11.1.1 > Environment: Fedora 26 > Win 10 17.09 > macOs Sierra 10.12.6 > Reporter: Matej Kralik > Priority: Critical > Attachments: warningLinux.png, warningMac.png, warningWin.png > > > Warning dialog which shows a warning when VDB contains udf shows differently on different platform. On linux it looks fine (warningLinux.png) but > * on Windows, the message is in the one line. (probably issue with line separator on Win) (warningWin.png) > * on Mac, the wizard is not extended and only first line can be seen (warningMac.png). So the user is not able to see whole message on the Mac. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3145) Warning dialog is shown differently according to platform

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3145?page=com.atlassian.jira.plu... ] Matej Kralik commented on TEIIDDES-3145: ---------------------------------------- [~makovy] Can you please verify whether you have the same problem on your mac? If so, I suggest set this issue as a blocker (because user are not able to see whole warning). > Warning dialog is shown differently according to platform > --------------------------------------------------------- > > Key: TEIIDDES-3145 > URL: https://issues.jboss.org/browse/TEIIDDES-3145 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 11.1.1 > Environment: Fedora 26 > Win 10 17.09 > macOs Sierra 10.12.6 > Reporter: Matej Kralik > Priority: Critical > Attachments: warningLinux.png, warningMac.png, warningWin.png > > > Warning dialog which shows a warning when VDB contains udf shows differently on different platform. On linux it looks fine (warningLinux.png) but > * on Windows, the message is in the one line. (probably issue with line separator on Win) (warningWin.png) > * on Mac, the wizard is not extended and only first line can be seen (warningMac.png). So the user is not able to see whole message on the Mac. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3145) Warning dialog is shown differently according to platform

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3145?page=com.atlassian.jira.plu... ] Matej Kralik updated TEIIDDES-3145: ----------------------------------- Description: Warning dialog which shows a warning when VDB contains udf shows differently on different platform. On linux it looks fine (warningLinux.png) but * on Windows, the message is in the one line. (probably issue with line separator on Win) (warningWin.png) * on Mac, the wizard is not extended and only first line can be seen (warningMac.png). So the user is not able to see whole message on the Mac. was: Warning dialog which shows a warning when VDB contains udf shows differently on different platform. On linux it looks fine (warningLinux.png) but * on Windows, the message is in the one line. (probably issue with line separator on Win) (warningWin.png) * on Mac, the wizard is not extended and only first line can be seen (warningMac.png). So the user is not able to see the message on the Mac. > Warning dialog is shown differently according to platform > --------------------------------------------------------- > > Key: TEIIDDES-3145 > URL: https://issues.jboss.org/browse/TEIIDDES-3145 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 11.1.1 > Environment: Fedora 26 > Win 10 17.09 > macOs Sierra 10.12.6 > Reporter: Matej Kralik > Priority: Critical > Attachments: warningLinux.png, warningMac.png, warningWin.png > > > Warning dialog which shows a warning when VDB contains udf shows differently on different platform. On linux it looks fine (warningLinux.png) but > * on Windows, the message is in the one line. (probably issue with line separator on Win) (warningWin.png) > * on Mac, the wizard is not extended and only first line can be seen (warningMac.png). So the user is not able to see whole message on the Mac. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 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 2017