Teiid designer giving String index out of range

[jayeshgarg]

Hi,

I am using Teiid Designer version 9.1.0 along with Teiid Beta version teiid-8.11.0.Beta3. I just opened an example project PartsProject.zip(attached) and it starts giving me the below error. I am not sure what is wrong here. Can you please guide?

java.lang.StringIndexOutOfBoundsException: String index out of range: 1

  at java.lang.String.charAt(String.java:658)

  at java.util.regex.Matcher.appendReplacement(Matcher.java:762)

  at java.util.regex.Matcher.replaceAll(Matcher.java:906)

  at java.lang.String.replaceAll(String.java:2162)

  at org.teiid.query.metadata.SystemMetadata.<init>(SystemMetadata.java:90)

  at org.teiid.query.metadata.SystemMetadata.getInstance(SystemMetadata.java:66)

  at org.teiid.query.function.metadata.FunctionMetadataValidator.validateFunctionMethods(FunctionMetadataValidator.java:72)

  at org.teiid.query.function.SystemFunctionManager.getSystemFunctions(SystemFunctionManager.java:77)

  at org.teiid.runtime.client.query.QueryService.createFunctionLibrary(QueryService.java:137)

  at org.teiid.designer.udf.UdfManager.getSystemFunctionLibrary(UdfManager.java:372)

  at org.teiid.query.ui.sqleditor.sql.SqlSyntax.init(SqlSyntax.java:93)

  at org.teiid.query.ui.sqleditor.sql.SqlSyntax.<init>(SqlSyntax.java:61)

  at org.teiid.query.ui.sqleditor.sql.SqlCompletionProcessor.<init>(SqlCompletionProcessor.java:39)

  at org.teiid.designer.transformation.ui.editors.sqleditor.SqlSourceViewerConfiguration.getContentAssistant(SqlSourceViewerConfiguration.java:64)

  at org.teiid.designer.transformation.ui.editors.sqleditor.SqlTextViewer.<init>(SqlTextViewer.java:84)

  at org.teiid.designer.transformation.ui.editors.sqleditor.SqlDisplayPanel.init(SqlDisplayPanel.java:75)

  at org.teiid.designer.transformation.ui.editors.sqleditor.SqlDisplayPanel.<init>(SqlDisplayPanel.java:60)

  at org.teiid.designer.transformation.ui.builder.AbstractLanguageObjectBuilder.createDialogArea(AbstractLanguageObjectBuilder.java:257)

  at org.eclipse.jface.dialogs.Dialog.createContents(Dialog.java:768)

  at org.eclipse.jface.window.Window.create(Window.java:435)

  at org.eclipse.jface.dialogs.Dialog.create(Dialog.java:1101)

  at org.teiid.designer.ui.common.widget.Dialog.create(Dialog.java:109)

  at org.teiid.designer.transformation.ui.builder.AbstractLanguageObjectBuilder.create(AbstractLanguageObjectBuilder.java:114)

  at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.getExpressionBuilder(SqlEditorPanel.java:1149)

  at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.showExpressionBuilder(SqlEditorPanel.java:1196)

  at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanelWrapper.showExpressionBuilder(SqlEditorPanelWrapper.java:123)

  at org.teiid.designer.transformation.ui.editors.sqleditor.actions.LaunchExpressionBuilder.doRun(LaunchExpressionBuilder.java:50)

  at org.teiid.designer.ui.common.actions.AbstractAction$1.run(AbstractAction.java:544)

  at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator$2$1.run(UiBusyIndicator.java:206)

  at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)

  at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:136)

  at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4147)

  at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3764)

  at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.executeRunnable(UiBusyIndicator.java:227)

  at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.showWhileInternal(UiBusyIndicator.java:159)

  at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.showWhile(UiBusyIndicator.java:116)

  at org.teiid.designer.ui.common.actions.AbstractAction.run(AbstractAction.java:547)

  at org.eclipse.jface.action.Action.runWithEvent(Action.java:519)

  at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:595)

  at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:511)

  at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:462)

  at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

  at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4353)

  at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1061)

  at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4172)

  at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3761)

  at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151)

  at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

  at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032)

  at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148)

  at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636)

  at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

  at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579)

  at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)

  at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:135)

  at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

  at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

  at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

  at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)

  at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)

  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:606)

  at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)

  at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)

  at org.eclipse.equinox.launcher.Main.run(Main.java:1465)

[rareddy]

When you see this error, I opened attached project did not see error

[jayeshgarg]

Problem is not with the project. I created another project and for that also I am getting the same error. Also none of my system functions are coming. My Expression Builder is not opening and its not showing any error as well. I even tried with another colleague's system and there also  Expression Builder is not coming. Pretty much lost on what is missing  in my setup..

[rareddy]

Ok, I tried with 9.1 version did not see, however I am running on Fedora 21. Are you running on Windows? Also when do you actually see the error, when executing something or just as working with view? I need to re-create the issue before I can help.

Also, can you give JBoss Developer Studio a try, also this is much more easier to install from here JBoss Developer Studio - Overview, note to install Teiid Designer, under welcome window, there is tab to install additional software.

[jayeshgarg]

Yes, I am on Windows. When I open any project, I am seeing this error. I'll try JBDS.

Thanks,

Jayesh

[jayeshgarg]

I tried with JBDS as well. Still the same error. I am attaching my jbds log file as well if that can help.

[rareddy]

I installed Designer 9.1 on Windows 7 machine and finally able to recreate the issue. This is happening when I click "ExpressionBuilder" tool bar button in the transformation panel when creating a view. Yes, this is bug and seems to be a regression. The workaround is manually typing in your WHERE clause in the transformation window and not use ExpressionBuilder.

I am not sure if there is way to install JBDS with older version of Data Virtualization, but that would be next step I suggest. By Designer team knows ways for it.

Can you also open JIRA here on this issue Teiid Designer - JBoss Issue Tracker

Thanks.

Ramesh..

[jayeshgarg]

Hi Ramesh,

Thanks for checking. This is not limited to clicking on the Expression Builder. I am constantly getting this error since I open the project. Its a sample project so I have not made any changes there.

Thanks,

Jayesh

[rareddy]

Jayesh,

Can you open JIRA for this, without it it pretty much looks like Designer 9.1 is useless.

Ramesh..

[jayeshgarg]

Hi Ramesh,

I have opened a JIRA Ticket https://issues.jboss.org/browse/TEIIDDES-2585 for the same.

Thanks,

Jayesh