November 2010 - teiid-designer-issues

[JBoss JIRA] Commented: (TEIIDDES-386) Add validation rule for missing names in source for physical tables

by Paul Nittel (JIRA)

[ https://jira.jboss.org/browse/TEIIDDES-386?page=com.atlassian.jira.plugin... ] Paul Nittel commented on TEIIDDES-386: -------------------------------------- I have attached a model project set and accompanying -ds.xml file. > Add validation rule for missing names in source for physical tables > ------------------------------------------------------------------- > > Key: TEIIDDES-386 > URL: https://jira.jboss.org/browse/TEIIDDES-386 > Project: Teiid Designer > Issue Type: Task > Components: Modeling > Environment: All > Reporter: Paul Nittel > Assignee: Barry LaFond > Fix For: 7.2 > > Attachments: PartsByHand-ds.xml, PartsNIS_MPS.zip, wtf_parts_porsche.png > > > I created a physical model and added names in source for the columns, forgetting the table. It validates OK. I wired it to a connector binding and tried to preview the data. This failed with a rather verbose, ugly Oracle error. See attached screenshot. > Should/Can we add a new rule to validate the presence of all names in source for source models. > (Once I defined the tables NIS, it worked fine.) -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

1
0
0 / 0

[JBoss JIRA] Updated: (TEIIDDES-386) Add validation rule for missing names in source for physical tables

by Barry LaFond (JIRA)

[ https://jira.jboss.org/browse/TEIIDDES-386?page=com.atlassian.jira.plugin... ] Barry LaFond updated TEIIDDES-386: ---------------------------------- Fix Version/s: 7.2 > Add validation rule for missing names in source for physical tables > ------------------------------------------------------------------- > > Key: TEIIDDES-386 > URL: https://jira.jboss.org/browse/TEIIDDES-386 > Project: Teiid Designer > Issue Type: Task > Components: Modeling > Environment: All > Reporter: Paul Nittel > Assignee: Barry LaFond > Fix For: 7.2 > > Attachments: wtf_parts_porsche.png > > > I created a physical model and added names in source for the columns, forgetting the table. It validates OK. I wired it to a connector binding and tried to preview the data. This failed with a rather verbose, ugly Oracle error. See attached screenshot. > Should/Can we add a new rule to validate the presence of all names in source for source models. > (Once I defined the tables NIS, it worked fine.) -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

1
0
0 / 0

[JBoss JIRA] Assigned: (TEIIDDES-386) Add validation rule for missing names in source for physical tables

by Paul Nittel (JIRA)

[ https://jira.jboss.org/browse/TEIIDDES-386?page=com.atlassian.jira.plugin... ] Paul Nittel reassigned TEIIDDES-386: ------------------------------------ Assignee: Barry LaFond (was: Paul Nittel) Back to ya! > Add validation rule for missing names in source for physical tables > ------------------------------------------------------------------- > > Key: TEIIDDES-386 > URL: https://jira.jboss.org/browse/TEIIDDES-386 > Project: Teiid Designer > Issue Type: Task > Components: Modeling > Environment: All > Reporter: Paul Nittel > Assignee: Barry LaFond > Attachments: wtf_parts_porsche.png > > > I created a physical model and added names in source for the columns, forgetting the table. It validates OK. I wired it to a connector binding and tried to preview the data. This failed with a rather verbose, ugly Oracle error. See attached screenshot. > Should/Can we add a new rule to validate the presence of all names in source for source models. > (Once I defined the tables NIS, it worked fine.) -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

1
0
0 / 0

[JBoss JIRA] Commented: (TEIIDDES-386) Add validation rule for missing names in source for physical tables

by Paul Nittel (JIRA)

[ https://jira.jboss.org/browse/TEIIDDES-386?page=com.atlassian.jira.plugin... ] Paul Nittel commented on TEIIDDES-386: -------------------------------------- I retried the experiment and created the model without the table having a NIS. Queried and it failed. Added the NIS and it succeeded. Here's the error I received: Error Code:942 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:942 Message:Error Code:942 Message:'ORA-00942: table or view does not exist ' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.PART_ID, g_0.PART_NAME, g_0.PART_COLOR, g_0.PART_WEIGHT FROM Gizmos g_0] > Add validation rule for missing names in source for physical tables > ------------------------------------------------------------------- > > Key: TEIIDDES-386 > URL: https://jira.jboss.org/browse/TEIIDDES-386 > Project: Teiid Designer > Issue Type: Task > Components: Modeling > Environment: All > Reporter: Paul Nittel > Assignee: Paul Nittel > Attachments: wtf_parts_porsche.png > > > I created a physical model and added names in source for the columns, forgetting the table. It validates OK. I wired it to a connector binding and tried to preview the data. This failed with a rather verbose, ugly Oracle error. See attached screenshot. > Should/Can we add a new rule to validate the presence of all names in source for source models. > (Once I defined the tables NIS, it worked fine.) -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

1
0
0 / 0

[JBoss JIRA] Created: (TEIIDDES-670) Pasting DELETE transformation SQL always (AFAICT) requires two attempts

by Paul Nittel (JIRA)

Pasting DELETE transformation SQL always (AFAICT) requires two attempts ----------------------------------------------------------------------- Key: TEIIDDES-670 URL: https://jira.jboss.org/browse/TEIIDDES-670 Project: Teiid Designer Issue Type: Bug Components: Editors Affects Versions: 7.1.1 Environment: JBDS 4.0.0 Beta 1 Reporter: Paul Nittel Priority: Minor Fix For: 7.1.1 Creating the DELETE procedure for an updatable virtual table, pasting in the SQL fails the first time. It leaves the transformation editor empty. The second attempt always seems to succeed. This only happens with the DELETE procedure, not SELECT, INSERT, or UPDATE. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

3
4
0 / 0

[JBoss JIRA] Created: (TEIIDDES-510) Remove old Designer Preferences Import & Export buttons and underlying functions

by Paul Nittel (JIRA)

Remove old Designer Preferences Import & Export buttons and underlying functions -------------------------------------------------------------------------------- Key: TEIIDDES-510 URL: https://jira.jboss.org/browse/TEIIDDES-510 Project: Teiid Designer Issue Type: Task Affects Versions: 7.0 Environment: All Reporter: Paul Nittel I noticed the Preferences Designer Import and Export functions both use the Import file chooser. Barry pointed out the correct methods are to use File > Import (or Export) > General > Preferences. Please remove all references to the older, obsolete, and, now incorrect, version. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

2
2
0 / 0

[JBoss JIRA] Assigned: (TEIIDDES-386) Add validation rule for missing names in source for physical tables

by Barry LaFond (JIRA)

[ https://jira.jboss.org/browse/TEIIDDES-386?page=com.atlassian.jira.plugin... ] Barry LaFond reassigned TEIIDDES-386: ------------------------------------- Assignee: Paul Nittel (was: Barry LaFond) > Add validation rule for missing names in source for physical tables > ------------------------------------------------------------------- > > Key: TEIIDDES-386 > URL: https://jira.jboss.org/browse/TEIIDDES-386 > Project: Teiid Designer > Issue Type: Task > Components: Modeling > Environment: All > Reporter: Paul Nittel > Assignee: Paul Nittel > Attachments: wtf_parts_porsche.png > > > I created a physical model and added names in source for the columns, forgetting the table. It validates OK. I wired it to a connector binding and tried to preview the data. This failed with a rather verbose, ugly Oracle error. See attached screenshot. > Should/Can we add a new rule to validate the presence of all names in source for source models. > (Once I defined the tables NIS, it worked fine.) -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

1
0
0 / 0

[JBoss JIRA] Commented: (TEIIDDES-386) Add validation rule for missing names in source for physical tables

by Barry LaFond (JIRA)

[ https://jira.jboss.org/browse/TEIIDDES-386?page=com.atlassian.jira.plugin... ] Barry LaFond commented on TEIIDDES-386: --------------------------------------- Basically previewed with a SHIP_VIA table WITH name in source. Then set it to NULL, saved and tried again. Teiid didn't seem to care, so is this a non-issue? > Add validation rule for missing names in source for physical tables > ------------------------------------------------------------------- > > Key: TEIIDDES-386 > URL: https://jira.jboss.org/browse/TEIIDDES-386 > Project: Teiid Designer > Issue Type: Task > Components: Modeling > Environment: All > Reporter: Paul Nittel > Assignee: Barry LaFond > Attachments: wtf_parts_porsche.png > > > I created a physical model and added names in source for the columns, forgetting the table. It validates OK. I wired it to a connector binding and tried to preview the data. This failed with a rather verbose, ugly Oracle error. See attached screenshot. > Should/Can we add a new rule to validate the presence of all names in source for source models. > (Once I defined the tables NIS, it worked fine.) -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

1
0
0 / 0

[JBoss JIRA] Created: (TEIIDDES-519) Delete project - Unhandled event loop exception and project not deleted

by Warren Gibson (JIRA)

Delete project - Unhandled event loop exception and project not deleted ----------------------------------------------------------------------- Key: TEIIDDES-519 URL: https://jira.jboss.org/browse/TEIIDDES-519 Project: Teiid Designer Issue Type: Bug Components: Housekeeping Affects Versions: 7.0 Reporter: Warren Gibson Running Teiid Designer in JBoss Developer Studio Imported BQT_ORCL9 project attached. Did some editing Decided to delete the project. Selected the project in the Model Expl tree with right mouse. Selected delete. Got a dialog wanting me to confirm the delete. Selected Yes for the delete. Project was not get deleted from tree. Refreshed the tree and project still exists. Notice an Unhandled event loop exception: org.eclipse.swt.SWTException: Widget is disposed at org.eclipse.swt.SWT.error(SWT.java:3884) at org.eclipse.swt.SWT.error(SWT.java:3799) at org.eclipse.swt.SWT.error(SWT.java:3770) at org.eclipse.swt.widgets.Widget.error(Widget.java:450) at org.eclipse.swt.widgets.Widget.getDisplay(Widget.java:532) at org.eclipse.ltk.ui.refactoring.RefactoringWizardOpenOperation.run(RefactoringWizardOpenOperation.java:155) at org.eclipse.ltk.internal.ui.refactoring.actions.DeleteResourcesHandler.execute(DeleteResourcesHandler.java:40) at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:294) 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.executeCommandInContext(HandlerService.java:270) at org.eclipse.ui.internal.ide.actions.LTKLauncher.runCommand(LTKLauncher.java:95) at org.eclipse.ui.internal.ide.actions.LTKLauncher.openDeleteWizard(LTKLauncher.java:47) at org.eclipse.ui.actions.DeleteResourceAction.run(DeleteResourceAction.java:481) at com.metamatrix.modeler.internal.ui.actions.DeleteResourceAction.doRun(DeleteResourceAction.java:386) at com.metamatrix.ui.actions.AbstractAction$1.run(AbstractAction.java:537) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) at com.metamatrix.ui.actions.AbstractAction.run(AbstractAction.java:540) at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) 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:1176) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3493) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3112) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221) at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194) 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:368) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514) at org.eclipse.equinox.launcher.Main.run(Main.java:1311) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

2
1
0 / 0

[JBoss JIRA] Created: (TEIIDDES-657) Transformation validation incorretly requires an updatable model element in an INSERT transformation.

by John Doyle (JIRA)

Transformation validation incorretly requires an updatable model element in an INSERT transformation. ------------------------------------------------------------------------------------------------------ Key: TEIIDDES-657 URL: https://jira.jboss.org/browse/TEIIDDES-657 Project: Teiid Designer Issue Type: Bug Components: Validation Affects Versions: 7.1 Reporter: John Doyle See: http://community.jboss.org/message/566009#566009 Update and Insert transformations could be implemented in many ways, not all require an updatable model element. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

3
5
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues November 2010