June 2016 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2865) JDBC importer imports MSSQL Server datatype numeric(9, [0-9]) as bigdecimal with zero precision

by Debbie Steigner (JIRA)

Debbie Steigner created TEIIDDES-2865: ----------------------------------------- Summary: JDBC importer imports MSSQL Server datatype numeric(9,[0-9]) as bigdecimal with zero precision Key: TEIIDDES-2865 URL: https://issues.jboss.org/browse/TEIIDDES-2865 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 9.0.7, 9.0.6, 9.0.5, 10.0 Reporter: Debbie Steigner Assignee: Barry LaFond Fix For: 10.0.2 JDBC importer imports MSSQL Server datatype numeric(9,[0-9]) as bigdecimal with zero precision and should be 9. I believe this https://issues.jboss.org/browse/TEIIDDES-2746 may have changed the behavior, in version 9.0.3 it imports correctly. You can use jdbc:sqlserver://ENGNTDBS14.mw.lab.eng.bos.redhat.com:1433;databaseName=mss_eds user - mss_eds password - mss_eds table - debtest2, both columns are numeric(9,2) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2788) Access Pattern not generated when exporting dynamic VDB

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2788?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2788: ---------------------------------------- [~mkralik] the export DDL and export dynamic VDB use the same DDL generation logic. Targeted to 10.0.2 > Access Pattern not generated when exporting dynamic VDB > ------------------------------------------------------- > > Key: TEIIDDES-2788 > URL: https://issues.jboss.org/browse/TEIIDDES-2788 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Fix For: 10.0.2 > > Attachments: APproj.zip > > > When exporting a dynamic VDB, access pattern constrains on model tables are not exported. > Actual DDL: > {code:sql} > CREATE FOREIGN TABLE s1 ( > newColumn_1 string(4000), > newColumn_2 string(4000) > ) > {code} > Expected DDL: > {code:sql} > CREATE FOREIGN TABLE s1 ( > newColumn_1 string(4000), > newColumn_2 string(4000), > CONSTRAINT NewAccessPattern ACCESSPATTERN (newColumn_1) > ) > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2788) Access Pattern not generated when exporting dynamic VDB

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2788?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2788: ----------------------------------- Fix Version/s: 10.0.2 > Access Pattern not generated when exporting dynamic VDB > ------------------------------------------------------- > > Key: TEIIDDES-2788 > URL: https://issues.jboss.org/browse/TEIIDDES-2788 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Fix For: 10.0.2 > > Attachments: APproj.zip > > > When exporting a dynamic VDB, access pattern constrains on model tables are not exported. > Actual DDL: > {code:sql} > CREATE FOREIGN TABLE s1 ( > newColumn_1 string(4000), > newColumn_2 string(4000) > ) > {code} > Expected DDL: > {code:sql} > CREATE FOREIGN TABLE s1 ( > newColumn_1 string(4000), > newColumn_2 string(4000), > CONSTRAINT NewAccessPattern ACCESSPATTERN (newColumn_1) > ) > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2788) Access Pattern not generated when exporting dynamic VDB

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2788?page=com.atlassian.jira.plu... ] Matej Kralik commented on TEIIDDES-2788: ---------------------------------------- A similar situation is when I want to export a model which contains a table with access pattern to the teiid DDL. Generated DDL doesn't contain access pattern. Import teiid DDL which contains access pattern (for example CONSTRAINT NewAccessPattern ACCESSPATTERN (newColumn_1) ) works fine. The designer generates the valid model with the access pattern. > Access Pattern not generated when exporting dynamic VDB > ------------------------------------------------------- > > Key: TEIIDDES-2788 > URL: https://issues.jboss.org/browse/TEIIDDES-2788 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Attachments: APproj.zip > > > When exporting a dynamic VDB, access pattern constrains on model tables are not exported. > Actual DDL: > {code:sql} > CREATE FOREIGN TABLE s1 ( > newColumn_1 string(4000), > newColumn_2 string(4000) > ) > {code} > Expected DDL: > {code:sql} > CREATE FOREIGN TABLE s1 ( > newColumn_1 string(4000), > newColumn_2 string(4000), > CONSTRAINT NewAccessPattern ACCESSPATTERN (newColumn_1) > ) > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2864) NPE's when trying to perform JDBC import from a postgres database

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2864?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2864. ------------------------------------ Release Notes Text: fixed in 10.0.1 via TEIIDDES-2835 Resolution: Duplicate > NPE's when trying to perform JDBC import from a postgres database > ----------------------------------------------------------------- > > Key: TEIIDDES-2864 > URL: https://issues.jboss.org/browse/TEIIDDES-2864 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 10.0 > Reporter: Van Halbert > Assignee: Barry LaFond > Attachments: log(2) > > > Seeing 2 NPE's, the first one is seen a lot: > java.lang.NullPointerException > at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionPanel(JdbcImportOptionsPage.java:444) > at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionTab(JdbcImportOptionsPage.java:245) > at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createControl(JdbcImportOptionsPage.java:228) > at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1216) > at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1208) > at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1197) > at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) > at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1194) > java.lang.NullPointerException > at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.refresh(JdbcImportObjectsPage.java:539) > at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.setVisible(JdbcImportObjectsPage.java:454) > at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1229) > at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1208) > at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1197) > at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) > at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1194) > at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:885) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2864) NPE's when trying to perform JDBC import from a postgres database

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2864?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-2864: --------------------------------------- This works in 8.1 JBDS and 9.0.7.Final Designer. > NPE's when trying to perform JDBC import from a postgres database > ----------------------------------------------------------------- > > Key: TEIIDDES-2864 > URL: https://issues.jboss.org/browse/TEIIDDES-2864 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 10.0 > Reporter: Van Halbert > Assignee: Barry LaFond > Attachments: log(2) > > > Seeing 2 NPE's, the first one is seen a lot: > java.lang.NullPointerException > at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionPanel(JdbcImportOptionsPage.java:444) > at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionTab(JdbcImportOptionsPage.java:245) > at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createControl(JdbcImportOptionsPage.java:228) > at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1216) > at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1208) > at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1197) > at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) > at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1194) > java.lang.NullPointerException > at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.refresh(JdbcImportObjectsPage.java:539) > at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.setVisible(JdbcImportObjectsPage.java:454) > at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1229) > at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1208) > at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1197) > at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) > at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1194) > at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:885) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2864) NPE's when trying to perform JDBC import from a postgres database

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2864?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-2864: --------------------------------------- Tried database development perspective and confirmed was able to connect and see tables/columns and data. So this appears to be a designer issue. > NPE's when trying to perform JDBC import from a postgres database > ----------------------------------------------------------------- > > Key: TEIIDDES-2864 > URL: https://issues.jboss.org/browse/TEIIDDES-2864 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 10.0 > Reporter: Van Halbert > Assignee: Barry LaFond > Attachments: log(2) > > > Seeing 2 NPE's, the first one is seen a lot: > java.lang.NullPointerException > at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionPanel(JdbcImportOptionsPage.java:444) > at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionTab(JdbcImportOptionsPage.java:245) > at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createControl(JdbcImportOptionsPage.java:228) > at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1216) > at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1208) > at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1197) > at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) > at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1194) > java.lang.NullPointerException > at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.refresh(JdbcImportObjectsPage.java:539) > at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.setVisible(JdbcImportObjectsPage.java:454) > at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1229) > at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1208) > at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1197) > at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) > at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1194) > at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:885) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2864) NPE's when trying to perform JDBC import from a postgres database

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2864?page=com.atlassian.jira.plu... ] Van Halbert updated TEIIDDES-2864: ---------------------------------- Attachment: log(2) log(2) is from a restart of designer, and then not selecting anything on the import panel. > NPE's when trying to perform JDBC import from a postgres database > ----------------------------------------------------------------- > > Key: TEIIDDES-2864 > URL: https://issues.jboss.org/browse/TEIIDDES-2864 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 10.0 > Reporter: Van Halbert > Assignee: Barry LaFond > Attachments: log(2) > > > Seeing 2 NPE's, the first one is seen a lot: > java.lang.NullPointerException > at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionPanel(JdbcImportOptionsPage.java:444) > at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionTab(JdbcImportOptionsPage.java:245) > at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createControl(JdbcImportOptionsPage.java:228) > at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1216) > at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1208) > at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1197) > at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) > at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1194) > java.lang.NullPointerException > at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.refresh(JdbcImportObjectsPage.java:539) > at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.setVisible(JdbcImportObjectsPage.java:454) > at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1229) > at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1208) > at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1197) > at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) > at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1194) > at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:885) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2864) NPE's when trying to perform JDBC import from a postgres database

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2864?page=com.atlassian.jira.plu... ] Van Halbert reassigned TEIIDDES-2864: ------------------------------------- Assignee: Barry LaFond (was: Van Halbert) > NPE's when trying to perform JDBC import from a postgres database > ----------------------------------------------------------------- > > Key: TEIIDDES-2864 > URL: https://issues.jboss.org/browse/TEIIDDES-2864 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 10.0 > Reporter: Van Halbert > Assignee: Barry LaFond > > Seeing 2 NPE's, the first one is seen a lot: > java.lang.NullPointerException > at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionPanel(JdbcImportOptionsPage.java:444) > at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionTab(JdbcImportOptionsPage.java:245) > at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createControl(JdbcImportOptionsPage.java:228) > at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1216) > at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1208) > at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1197) > at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) > at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1194) > java.lang.NullPointerException > at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.refresh(JdbcImportObjectsPage.java:539) > at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.setVisible(JdbcImportObjectsPage.java:454) > at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1229) > at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1208) > at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1197) > at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) > at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1194) > at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:885) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2864) NPE's when trying to perform JDBC import from a postgres database

by Van Halbert (JIRA)

Van Halbert created TEIIDDES-2864: ------------------------------------- Summary: NPE's when trying to perform JDBC import from a postgres database Key: TEIIDDES-2864 URL: https://issues.jboss.org/browse/TEIIDDES-2864 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 10.0 Reporter: Van Halbert Seeing 2 NPE's, the first one is seen a lot: java.lang.NullPointerException at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionPanel(JdbcImportOptionsPage.java:444) at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionTab(JdbcImportOptionsPage.java:245) at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createControl(JdbcImportOptionsPage.java:228) at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1216) at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1208) at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1197) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1194) java.lang.NullPointerException at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.refresh(JdbcImportObjectsPage.java:539) at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.setVisible(JdbcImportObjectsPage.java:454) at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1229) at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1208) at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1197) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1194) at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:885) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 8 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 June 2016