[JBoss JIRA] Created: (TEIIDDES-234) WSDL Relational Importer creates tables that could be collapsed out of the model.
by John Doyle (JIRA)
WSDL Relational Importer creates tables that could be collapsed out of the model.
---------------------------------------------------------------------------------
Key: TEIIDDES-234
URL: https://jira.jboss.org/jira/browse/TEIIDDES-234
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 6.0.0
Reporter: John Doyle
Assignee: John Doyle
Priority: Minor
Fix For: Future
The attached WSDL and XSD's create a model with a Request Table, Response Table, an intermediate table that has only mmid's, and finally a table (Order) containing all of the data. (it is invalid because of JBEDSP-514, but that's not material). While this model valid and will work once the table name conflict from 514 is addressed, it's not optimal. The intermediate table is not required in the model because there is no multiplicity above the Order table. The intermediate table can be removed and the Order table linked directly to the response and the simplicity of the model will be improved with no loss of capability. The importer could be enhanced to recognize this possibility.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 9 months
[JBoss JIRA] Created: (TEIIDDES-489) Non-parsable SQL in transformation provides no help to user - NPE in stack trace
by Paul Nittel (JIRA)
Non-parsable SQL in transformation provides no help to user - NPE in stack trace
--------------------------------------------------------------------------------
Key: TEIIDDES-489
URL: https://jira.jboss.org/browse/TEIIDDES-489
Project: Teiid Designer
Issue Type: Bug
Components: Transformations
Affects Versions: 7.0
Environment: Fedora 12, OpenJDK, Designer 6/28
Reporter: Paul Nittel
Neither the error nor the stack trace provides the user with any assistance in correcting their SQL error. (BTW, in MMx 554, this parsed.)
While attempting the Update Virtual Groups modeling, I ran into this problem defining the Update procedure for UpdateProduct. After pasting in the SQL text, I validated the SQL and received:
The query is not parsable.
Error encountered while validating the transformation.
The message log shows:
Error 2010-06-30 11:32:04.784 Error encountered while validating the transformation.
Please check the Message log for exceptions
java.lang.NullPointerException
at org.teiid.query.validator.ValidationVisitor.validateTranslateCriteria(ValidationVisitor.java:536)
at org.teiid.query.validator.ValidationVisitor.visit(ValidationVisitor.java:479)
at org.teiid.query.sql.proc.TranslateCriteria.acceptVisitor(TranslateCriteria.java:134)
at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:53)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.preVisitVisitor(PreOrPostOrderNavigator.java:125)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:461)
at org.teiid.query.sql.proc.TranslateCriteria.acceptVisitor(TranslateCriteria.java:134)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:475)
at org.teiid.query.sql.lang.Update.acceptVisitor(Update.java:157)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:158)
at org.teiid.query.sql.proc.AssignmentStatement.acceptVisitor(AssignmentStatement.java:133)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:73)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:175)
at org.teiid.query.sql.proc.Block.acceptVisitor(Block.java:88)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:289)
at org.teiid.query.sql.proc.IfStatement.acceptVisitor(IfStatement.java:147)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:73)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:175)
at org.teiid.query.sql.proc.Block.acceptVisitor(Block.java:88)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
at org.teiid.query.validator.Validator$1.visitNode(Validator.java:88)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:218)
at org.teiid.query.sql.proc.CreateUpdateProcedureCommand.acceptVisitor(CreateUpdateProcedureCommand.java:144)
at org.teiid.query.validator.Validator.executeValidation(Validator.java:93)
at org.teiid.query.validator.Validator.validate(Validator.java:55)
at org.teiid.query.validator.Validator.validate(Validator.java:41)
at com.metamatrix.modeler.transformation.validation.TransformationValidator.validateCommand(TransformationValidator.java:389)
at com.metamatrix.modeler.transformation.validation.TransformationValidator.validateSql(TransformationValidator.java:297)
at com.metamatrix.query.internal.ui.sqleditor.component.QueryDisplayComponent.validateSql(QueryDisplayComponent.java:263)
at com.metamatrix.query.internal.ui.sqleditor.component.QueryDisplayComponent.setText(QueryDisplayComponent.java:178)
at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.setTextInTransaction(SqlEditorPanel.java:421)
at com.metamatrix.query.ui.sqleditor.SqlEditorPanel$4.run(SqlEditorPanel.java:464)
at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:464)
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:372)
at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:507)
at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.setText(SqlEditorPanel.java:470)
at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.setText(SqlEditorPanel.java:495)
at com.metamatrix.query.ui.sqleditor.SqlEditorPanel.validate(SqlEditorPanel.java:526)
at com.metamatrix.query.ui.sqleditor.SqlEditorPanelWrapper.validate(SqlEditorPanelWrapper.java:138)
at com.metamatrix.query.internal.ui.sqleditor.actions.Validate.doRun(Validate.java:52)
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$6.handleEvent(ActionContributionItem.java:452)
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
15 years, 10 months