[teiid-issues] [JBoss JIRA] Moved: (TEIID-1200) Non-parsable SQL in transformation provides no help to user - NPE in stack trace
Steve Hawkins (JIRA)
jira-events at lists.jboss.org
Wed Aug 11 15:03:49 EDT 2010
[ https://jira.jboss.org/browse/TEIID-1200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steve Hawkins moved TEIIDDES-489 to TEIID-1200:
-----------------------------------------------
Project: Teiid (was: Teiid Designer)
Key: TEIID-1200 (was: TEIIDDES-489)
Affects Version/s: 7.0
(was: 7.0)
Component/s: Query Engine
(was: Transformations)
> Non-parsable SQL in transformation provides no help to user - NPE in stack trace
> --------------------------------------------------------------------------------
>
> Key: TEIID-1200
> URL: https://jira.jboss.org/browse/TEIID-1200
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> 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)
--
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
More information about the teiid-issues
mailing list