August 2016 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2858) DDL Importer does drops quotes from quoted column names

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2858?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2858: ----------------------------------- Summary: DDL Importer does drops quotes from quoted column names (was: Column whose have specific name are not correctly parsed in the DDL) > DDL Importer does drops quotes from quoted column names > ------------------------------------------------------- > > Key: TEIIDDES-2858 > URL: https://issues.jboss.org/browse/TEIIDDES-2858 > Project: Teiid Designer > Issue Type: Bug > Components: Data Preview, Dynamic VDBs > Affects Versions: 10.0.1 > Environment: Fedora 23 > Reporter: Matej Kralik > Assignee: Barry LaFond > Fix For: 10.0.2 > > Attachments: remoteXML.zip, screenshot1.png, screenshot2.png > > > When I wanted preview date from the table which contains column with specific name, server shows me this error: > TEIID31100 Parsing error: Encountered "'FALSE'), [*]YEAR[*] string(" at line 8, column 9. > Was expecting: "constraint" | "foreign" | "primary" | "unique" | id > I looked on the DDL which designer generated (screenshot1) and I think that column TIME should be between quotation marks. > "YEAR" string(4000) OPTIONS(NAMEINSOURCE '"YEAR"', UPDATABLE 'FALSE') > When I change column name from TIME to "TIME", the preview passed and showed me data. (screenshot2) > A similar situation is when I generated dynamic VDB. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2858) DDL Importer does drops quotes from quoted column names

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2858?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2858: ---------------------------------------- It appears the basic Teiid DDL Sequencer strips double-quotes off of identifiers. The StandardDdlParser in Modeshape does the same thing. So not sure how to fix this except to look for reserved words in the Parser and keep the double-quotes in the AstNode OR we perform the reserved word check whenever we export from MS or import as DDL via Modeshape. > DDL Importer does drops quotes from quoted column names > ------------------------------------------------------- > > Key: TEIIDDES-2858 > URL: https://issues.jboss.org/browse/TEIIDDES-2858 > Project: Teiid Designer > Issue Type: Bug > Components: Data Preview, Dynamic VDBs > Affects Versions: 10.0.1 > Environment: Fedora 23 > Reporter: Matej Kralik > Assignee: Barry LaFond > Fix For: 10.0.2 > > Attachments: remoteXML.zip, screenshot1.png, screenshot2.png > > > When I wanted preview date from the table which contains column with specific name, server shows me this error: > TEIID31100 Parsing error: Encountered "'FALSE'), [*]YEAR[*] string(" at line 8, column 9. > Was expecting: "constraint" | "foreign" | "primary" | "unique" | id > I looked on the DDL which designer generated (screenshot1) and I think that column TIME should be between quotation marks. > "YEAR" string(4000) OPTIONS(NAMEINSOURCE '"YEAR"', UPDATABLE 'FALSE') > When I change column name from TIME to "TIME", the preview passed and showed me data. (screenshot2) > A similar situation is when I generated dynamic VDB. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2858) Column whose have specific name are not correctly parsed in the DDL

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2858?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2858: -------------------------------------- Assignee: Barry LaFond > Column whose have specific name are not correctly parsed in the DDL > ------------------------------------------------------------------- > > Key: TEIIDDES-2858 > URL: https://issues.jboss.org/browse/TEIIDDES-2858 > Project: Teiid Designer > Issue Type: Bug > Components: Data Preview, Dynamic VDBs > Affects Versions: 10.0.1 > Environment: Fedora 23 > Reporter: Matej Kralik > Assignee: Barry LaFond > Fix For: 10.0.2 > > Attachments: remoteXML.zip, screenshot1.png, screenshot2.png > > > When I wanted preview date from the table which contains column with specific name, server shows me this error: > TEIID31100 Parsing error: Encountered "'FALSE'), [*]YEAR[*] string(" at line 8, column 9. > Was expecting: "constraint" | "foreign" | "primary" | "unique" | id > I looked on the DDL which designer generated (screenshot1) and I think that column TIME should be between quotation marks. > "YEAR" string(4000) OPTIONS(NAMEINSOURCE '"YEAR"', UPDATABLE 'FALSE') > When I change column name from TIME to "TIME", the preview passed and showed me data. (screenshot2) > A similar situation is when I generated dynamic VDB. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2871) Data roles editor problem

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2871?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2871: -------------------------------------- Assignee: Barry LaFond > Data roles editor problem > ------------------------- > > Key: TEIIDDES-2871 > URL: https://issues.jboss.org/browse/TEIIDDES-2871 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.1 > Environment: MAC > Reporter: Matus Makovy > Assignee: Barry LaFond > Fix For: 10.0.2 > > > Changes in data roles are not always acknowledged by TD. > See steps to reproduce and attached video. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2351) Merge applicable 8.6.Final changes into 8.6.x luna and kepler branches

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2351?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2351. ---------------------------------- > Merge applicable 8.6.Final changes into 8.6.x luna and kepler branches > ---------------------------------------------------------------------- > > Key: TEIIDDES-2351 > URL: https://issues.jboss.org/browse/TEIIDDES-2351 > Project: Teiid Designer > Issue Type: Task > Components: Patch Release > Affects Versions: 8.6.1 > Reporter: Barry LaFond > Assignee: Paul Richardson > Priority: Blocker > Fix For: 8.6.1 > > > 8.6.x luna and kepler were branched prior to 8.6.Final. > Need to cherry-pick merge applicable commits. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2481) Add support for recursive common table expressions

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2481?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2481. ------------------------------------ Assignee: Barry LaFond (was: Paul Richardson) Resolution: Done https://github.com/Teiid-Designer/teiid-designer/commit/8b372b8384212a35b... Fixed the internal group resolving issue. Done > Add support for recursive common table expressions > -------------------------------------------------- > > Key: TEIIDDES-2481 > URL: https://issues.jboss.org/browse/TEIIDDES-2481 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling, Patch Release, Teiid Integration > Reporter: Steven Hawkins > Assignee: Barry LaFond > Fix For: 10.0.1, 10.0.2 > > Attachments: RCTE1-vdb.xml > > > Teiid 8.10 added support for recursive common table expressions. There is no new syntax, but more logic around resolving a special form of a common table expression. If the query expression is written as a union then the right hand side of the union is allowed to reference the common table group. See https://docs.jboss.org/author/display/TEIID/WITH+Clause -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2508) Import From an LDAP Server Failed to Model Table

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2508?page=com.atlassian.jira.plu... ] Matus Makovy commented on TEIIDDES-2508: ---------------------------------------- I lowered the priority, I don't think it is a blocker. [~kylin] is this still an issue in TD 10.0.1. I was not able to reproduce this, because I wasn't able to connect to this LDAP service. > Import From an LDAP Server Failed to Model Table > ------------------------------------------------ > > Key: TEIIDDES-2508 > URL: https://issues.jboss.org/browse/TEIIDDES-2508 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.0 > Reporter: Kylin Soong > Priority: Critical > Attachments: ldap-ds-1.png, ldap-ds-2.png, ldap-ds-3.png, ldap-ds-4.png, ldap-ds-5.png > > > In OpenLDAP Server have a Group 'HR' and with 3 Users named hr1, hr2, hr3 correspondingly, more details refer to blog [1]. > As attached 5 pics we import LDAP Service to Source Model: > * In ldap-ds-3.png directory tree on the left, each time if click one of items the others are gone as ldap-ds-4.png, also in sometimes directory tree can not form correctly. > * In ldap-ds-5.png validation failed cause can not further process the wizard. > [1] http://ksoong.org/ldap-java/ -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2508) Import From an LDAP Server Failed to Model Table

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2508?page=com.atlassian.jira.plu... ] Matus Makovy edited comment on TEIIDDES-2508 at 8/19/16 10:11 AM: ------------------------------------------------------------------ I lowered the priority, I don't think it is a blocker. [~kylin] is this still an issue in TD 10.0.1. ? I was not able to reproduce this, because I wasn't able to connect to this LDAP service. was (Author: mmakovy): I lowered the priority, I don't think it is a blocker. [~kylin] is this still an issue in TD 10.0.1. I was not able to reproduce this, because I wasn't able to connect to this LDAP service. > Import From an LDAP Server Failed to Model Table > ------------------------------------------------ > > Key: TEIIDDES-2508 > URL: https://issues.jboss.org/browse/TEIIDDES-2508 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.0 > Reporter: Kylin Soong > Priority: Critical > Attachments: ldap-ds-1.png, ldap-ds-2.png, ldap-ds-3.png, ldap-ds-4.png, ldap-ds-5.png > > > In OpenLDAP Server have a Group 'HR' and with 3 Users named hr1, hr2, hr3 correspondingly, more details refer to blog [1]. > As attached 5 pics we import LDAP Service to Source Model: > * In ldap-ds-3.png directory tree on the left, each time if click one of items the others are gone as ldap-ds-4.png, also in sometimes directory tree can not form correctly. > * In ldap-ds-5.png validation failed cause can not further process the wizard. > [1] http://ksoong.org/ldap-java/ -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2508) Import From an LDAP Server Failed to Model Table

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2508?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2508: ----------------------------------- Priority: Critical (was: Blocker) > Import From an LDAP Server Failed to Model Table > ------------------------------------------------ > > Key: TEIIDDES-2508 > URL: https://issues.jboss.org/browse/TEIIDDES-2508 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.0 > Reporter: Kylin Soong > Priority: Critical > Attachments: ldap-ds-1.png, ldap-ds-2.png, ldap-ds-3.png, ldap-ds-4.png, ldap-ds-5.png > > > In OpenLDAP Server have a Group 'HR' and with 3 Users named hr1, hr2, hr3 correspondingly, more details refer to blog [1]. > As attached 5 pics we import LDAP Service to Source Model: > * In ldap-ds-3.png directory tree on the left, each time if click one of items the others are gone as ldap-ds-4.png, also in sometimes directory tree can not form correctly. > * In ldap-ds-5.png validation failed cause can not further process the wizard. > [1] http://ksoong.org/ldap-java/ -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1542) Powerhub driver not working with Teiid

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1542?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-1542. ---------------------------------- Resolution: Won't Do > Powerhub driver not working with Teiid > -------------------------------------- > > Key: TEIIDDES-1542 > URL: https://issues.jboss.org/browse/TEIIDDES-1542 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 7.7 > Environment: Windows Vista 64 bit > Reporter: Tanmoy Palit > Assignee: Barry LaFond > Priority: Blocker > Attachments: Includes.java, JdbcCatalogImpl.java, JdbcImportMetadataPage.java, JdbcSchemaImpl.java, JdbcTableImpl.java, org.teiid.designer.jdbc.patch, org.teiid.designer.jdbc.ui.patch > > > Powerhub drvier which is com.lgc.dam.phs.client.jdbc.PhsJDBCDriver, is a custom JDBC driver from Landmark. > Connection string looks like the following: > jdbc:scwapi:<server_name>;<powerhub_user>;<passwd>;<database_instance><database_name;<username>;<dbpasswd> > Getting the following error when Teiid Designer is used to consume the underlying database: > Error: > Unexpected exception while calling com.lgc.dam.phs.client.jdbc.PhsJDBCDatabaseMetaData.getTableTypes() and processing results on Acceptance PowerExplorer.CDSPROD > Here is the complete stack trace for the error: > java.lang.NullPointerException > at com.metamatrix.modeler.internal.jdbc.ui.wizards.JdbcImportMetadataPage.initializeInTransaction(JdbcImportMetadataPage.java:313) > at com.metamatrix.modeler.internal.jdbc.ui.wizards.JdbcImportMetadataPage.setVisible(JdbcImportMetadataPage.java:238) > at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1260) > at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1239) > at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1228) > at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) > at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1226) > at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:915) > at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:428) > at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:624) > at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:240) > at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053) > at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165) > at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754) > at org.eclipse.jface.window.Window.runEventLoop(Window.java:825) > at org.eclipse.jface.window.Window.open(Window.java:801) > at org.eclipse.ui.internal.handlers.WizardHandler$Import.executeHandler(WizardHandler.java:150) > at org.eclipse.ui.internal.handlers.WizardHandler.execute(WizardHandler.java:277) > at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:293) > at org.eclipse.core.commands.Command.executeWithChecks(Command.java:476) > at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508) > at org.eclipse.ui.internal.handlers.HandlerService.executeCommand(HandlerService.java:169) > at org.eclipse.ui.internal.handlers.SlaveHandlerService.executeCommand(SlaveHandlerService.java:241) > at org.eclipse.ui.internal.actions.CommandAction.runWithEvent(CommandAction.java:157) > at org.eclipse.ui.internal.actions.CommandAction.run(CommandAction.java:171) > at org.eclipse.ui.actions.ImportResourcesAction.run(ImportResourcesAction.java:97) > at org.eclipse.ui.actions.BaseSelectionListenerAction.runWithEvent(BaseSelectionListenerAction.java:168) > at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584) > at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501) > at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411) > at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053) > at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165) > at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754) > at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2701) > at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2665) > at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499) > at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679) > at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) > at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:668) > at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) > at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:123) > at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196) > at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110) > at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79) > at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344) > at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622) > at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577) > at org.eclipse.equinox.launcher.Main.run(Main.java:1410) > at org.eclipse.equinox.launcher.Main.main(Main.java:1386) > Squrriel SQL Client successfully connects to metadata and executes queries to this Powerhub data source using same PhsJDBC driver -- 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