[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2262) Lexical error in viewmodel but cannot edit it

Lexical error in viewmodel but cannot edit it --------------------------------------------- Key: TEIIDDES-2262 URL: https://issues.jboss.org/browse/TEIIDDES-2262 Project: Teiid Designer Issue Type: Bug Security Level: Public(Everyone can see) Components: Teiid Integration Affects Versions: 8.5 Reporter: Tom Johnston Somehow I've gotten a lexical error in my transformation. however, I cannot edit it. I double click on the transformation or the error in the log and can never get to the ability to 'edit' the transformation. This is JBoss DV 7.1.1 ga and Teiid Designer8.5.0.Final Nor sure what else you may need but here's the event details: org.teiid.query.parser.v8.TokenMgrError: Lexical error at line 2, column 39. Encountered: "\'" (39), after : "|" at org.teiid.query.parser.v8.Teiid8ParserTokenManager.getNextToken(Teiid8ParserTokenManager.java:3314) at org.teiid.query.parser.v8.Teiid8Parser.jj_ntk(Teiid8Parser.java:18993) at org.teiid.query.parser.v8.Teiid8Parser.valueExpressionPrimary(Teiid8Parser.java:9238) at org.teiid.query.parser.v8.Teiid8Parser.timesExpression(Teiid8Parser.java:9180) at org.teiid.query.parser.v8.Teiid8Parser.plusExpression(Teiid8Parser.java:9124) at org.teiid.query.parser.v8.Teiid8Parser.commonValueExpression(Teiid8Parser.java:9105) at org.teiid.query.parser.v8.Teiid8Parser.booleanPrimary(Teiid8Parser.java:7490) at org.teiid.query.parser.v8.Teiid8Parser.notCrit(Teiid8Parser.java:7327) at org.teiid.query.parser.v8.Teiid8Parser.compoundCritAnd(Teiid8Parser.java:7255) at org.teiid.query.parser.v8.Teiid8Parser.compoundCritOr(Teiid8Parser.java:7212) at org.teiid.query.parser.v8.Teiid8Parser.criteria(Teiid8Parser.java:7178) at org.teiid.query.parser.v8.Teiid8Parser.expression(Teiid8Parser.java:9077) at org.teiid.query.parser.v8.Teiid8Parser.selectExpression(Teiid8Parser.java:4961) at org.teiid.query.parser.v8.Teiid8Parser.selectSymbol(Teiid8Parser.java:4938) at org.teiid.query.parser.v8.Teiid8Parser.select(Teiid8Parser.java:4758) at org.teiid.query.parser.v8.Teiid8Parser.query(Teiid8Parser.java:4471) at org.teiid.query.parser.v8.Teiid8Parser.queryPrimary(Teiid8Parser.java:4382) at org.teiid.query.parser.v8.Teiid8Parser.queryTerm(Teiid8Parser.java:4307) at org.teiid.query.parser.v8.Teiid8Parser.queryExpressionBody(Teiid8Parser.java:4220) at org.teiid.query.parser.v8.Teiid8Parser.queryExpression(Teiid8Parser.java:4143) at org.teiid.query.parser.v8.Teiid8Parser.userCommand(Teiid8Parser.java:1081) at org.teiid.query.parser.v8.Teiid8Parser.designerCommand(Teiid8Parser.java:611) at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:204) at org.teiid.query.parser.QueryParser.parseDesignerCommand(QueryParser.java:193) at org.teiid.query.parser.QueryParser.parseDesignerCommand(QueryParser.java:1) at org.teiid.designer.transformation.validation.TransformationValidator.parseSQL(TransformationValidator.java:398) at org.teiid.designer.transformation.validation.TransformationValidator.validateSql(TransformationValidator.java:351) at org.teiid.designer.transformation.util.SqlMappingRootCache.createStatus(SqlMappingRootCache.java:752) at org.teiid.designer.transformation.util.SqlMappingRootCache.getStatus(SqlMappingRootCache.java:833) at org.teiid.designer.transformation.util.SqlMappingRootCache.getStatus(SqlMappingRootCache.java:794) at org.teiid.designer.transformation.util.SqlMappingRootCache.getSqlString(SqlMappingRootCache.java:688) at org.teiid.designer.transformation.util.TransformationHelper.getSqlString(TransformationHelper.java:405) at org.teiid.designer.transformation.ui.actions.RevalidateModelTransformationsAction.resetTransformation(RevalidateModelTransformationsAction.java:212) at org.teiid.designer.transformation.ui.actions.RevalidateModelTransformationsAction.revalidate(RevalidateModelTransformationsAction.java:167) at org.teiid.designer.transformation.ui.actions.RevalidateModelTransformationsAction$1.execute(RevalidateModelTransformationsAction.java:111) at org.eclipse.ui.actions.WorkspaceModifyOperation$1.run(WorkspaceModifyOperation.java:106) at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2345) at org.eclipse.ui.actions.WorkspaceModifyOperation.run(WorkspaceModifyOperation.java:118) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121) I also get this stack sometimes: org.teiid.query.parser.v8.TokenMgrError: Lexical error at line 2, column 39. Encountered: "\'" (39), after : "|" at org.teiid.query.parser.v8.Teiid8ParserTokenManager.getNextToken(Teiid8ParserTokenManager.java:3314) at org.teiid.query.parser.v8.Teiid8Parser.jj_ntk(Teiid8Parser.java:18993) at org.teiid.query.parser.v8.Teiid8Parser.valueExpressionPrimary(Teiid8Parser.java:9238) at org.teiid.query.parser.v8.Teiid8Parser.timesExpression(Teiid8Parser.java:9180) at org.teiid.query.parser.v8.Teiid8Parser.plusExpression(Teiid8Parser.java:9124) at org.teiid.query.parser.v8.Teiid8Parser.commonValueExpression(Teiid8Parser.java:9105) at org.teiid.query.parser.v8.Teiid8Parser.booleanPrimary(Teiid8Parser.java:7490) at org.teiid.query.parser.v8.Teiid8Parser.notCrit(Teiid8Parser.java:7327) at org.teiid.query.parser.v8.Teiid8Parser.compoundCritAnd(Teiid8Parser.java:7255) at org.teiid.query.parser.v8.Teiid8Parser.compoundCritOr(Teiid8Parser.java:7212) at org.teiid.query.parser.v8.Teiid8Parser.criteria(Teiid8Parser.java:7178) at org.teiid.query.parser.v8.Teiid8Parser.expression(Teiid8Parser.java:9077) at org.teiid.query.parser.v8.Teiid8Parser.selectExpression(Teiid8Parser.java:4961) at org.teiid.query.parser.v8.Teiid8Parser.selectSymbol(Teiid8Parser.java:4938) at org.teiid.query.parser.v8.Teiid8Parser.select(Teiid8Parser.java:4758) at org.teiid.query.parser.v8.Teiid8Parser.query(Teiid8Parser.java:4471) at org.teiid.query.parser.v8.Teiid8Parser.queryPrimary(Teiid8Parser.java:4382) at org.teiid.query.parser.v8.Teiid8Parser.queryTerm(Teiid8Parser.java:4307) at org.teiid.query.parser.v8.Teiid8Parser.queryExpressionBody(Teiid8Parser.java:4220) at org.teiid.query.parser.v8.Teiid8Parser.queryExpression(Teiid8Parser.java:4143) at org.teiid.query.parser.v8.Teiid8Parser.userCommand(Teiid8Parser.java:1081) at org.teiid.query.parser.v8.Teiid8Parser.designerCommand(Teiid8Parser.java:611) at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:204) at org.teiid.query.parser.QueryParser.parseDesignerCommand(QueryParser.java:193) at org.teiid.query.parser.QueryParser.parseDesignerCommand(QueryParser.java:1) at org.teiid.designer.transformation.validation.TransformationValidator.parseSQL(TransformationValidator.java:398) at org.teiid.designer.transformation.validation.TransformationValidator.validateSql(TransformationValidator.java:351) at org.teiid.designer.transformation.util.SqlMappingRootCache.createStatus(SqlMappingRootCache.java:752) at org.teiid.designer.transformation.util.SqlMappingRootCache.getStatus(SqlMappingRootCache.java:833) at org.teiid.designer.transformation.util.SqlMappingRootCache.getStatus(SqlMappingRootCache.java:794) at org.teiid.designer.transformation.util.SqlMappingRootCache.getSqlString(SqlMappingRootCache.java:688) at org.teiid.designer.transformation.util.TransformationHelper.getSqlString(TransformationHelper.java:405) at org.teiid.designer.transformation.util.TransformationHelper.getSelectSqlString(TransformationHelper.java:381) at org.teiid.designer.transformation.util.TransformationHelper.isEmptySelect(TransformationHelper.java:3130) at org.teiid.designer.transformation.ui.actions.TransformationSourceManager.canAddUnionSource(TransformationSourceManager.java:159) at org.teiid.designer.transformation.ui.actions.AddUnionSourceAction.shouldEnable(AddUnionSourceAction.java:256) at org.teiid.designer.transformation.ui.actions.AddUnionSourceAction.selectionChanged(AddUnionSourceAction.java:116) at org.eclipse.ui.internal.e4.compatibility.SelectionService.notifyListeners(SelectionService.java:154) at org.eclipse.ui.internal.e4.compatibility.SelectionService.access$3(SelectionService.java:151) at org.eclipse.ui.internal.e4.compatibility.SelectionService$1.selectionChanged(SelectionService.java:74) at org.eclipse.e4.ui.internal.workbench.SelectionAggregator$2.run(SelectionAggregator.java:119) at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42) at org.eclipse.e4.ui.internal.workbench.SelectionAggregator.notifyListeners(SelectionAggregator.java:117) at org.eclipse.e4.ui.internal.workbench.SelectionAggregator.access$5(SelectionAggregator.java:114) at org.eclipse.e4.ui.internal.workbench.SelectionAggregator$7$1.run(SelectionAggregator.java:216) at org.eclipse.e4.core.contexts.RunAndTrack.runExternalCode(RunAndTrack.java:56) at org.eclipse.e4.ui.internal.workbench.SelectionAggregator$7.changed(SelectionAggregator.java:214) at org.eclipse.e4.core.internal.contexts.TrackableComputationExt.update(TrackableComputationExt.java:110) at org.eclipse.e4.core.internal.contexts.EclipseContext.processScheduled(EclipseContext.java:334) at org.eclipse.e4.core.internal.contexts.EclipseContext.set(EclipseContext.java:348) at org.eclipse.e4.ui.internal.workbench.SelectionServiceImpl.setSelection(SelectionServiceImpl.java:30) at org.eclipse.ui.internal.e4.compatibility.CompatibilityPart.selectionChanged(CompatibilityPart.java:437) at org.eclipse.jface.viewers.Viewer$2.run(Viewer.java:164) at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42) at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:49) at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175) at org.eclipse.jface.viewers.Viewer.fireSelectionChanged(Viewer.java:162) at org.eclipse.jface.viewers.StructuredViewer.updateSelection(StructuredViewer.java:2188) at org.eclipse.jface.viewers.StructuredViewer.handleSelect(StructuredViewer.java:1211) at org.eclipse.jface.viewers.StructuredViewer$4.widgetSelected(StructuredViewer.java:1241) at org.eclipse.jface.util.OpenStrategy.fireSelectionEvent(OpenStrategy.java:239) at org.eclipse.jface.util.OpenStrategy.access$4(OpenStrategy.java:233) at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:403) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4170) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3759) at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997) at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:140) at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:611) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124) 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:354) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181) 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:636) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591) at org.eclipse.equinox.launcher.Main.run(Main.java:1450) at org.eclipse.equinox.launcher.Main.main(Main.java:1426)