[teiid-designer-issues] [JBoss JIRA] Updated: (TEIIDDES-489) Non-parsable SQL in transformation provides no help to user - NPE in stack trace

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 Attachments: E2eUpdateVirtualGroupsTestScript.odt, UpdatesProject.zip 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)