Error previewing data

[skethire]

I am using Teiid 8.1 aplpha1. I have been able to create a vdb, deploy it and connect to the Teiid Server running on a remote jboss instance.  When I try to preview one of my tables, I get the following error:

org.teiid.jdbc.TeiidSQLException: TEIID20014 The port 'undefined' is a non-numeric value.

at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)

at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)

at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:56)

at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)

at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:1)

at org.teiid.datatools.connectivity.TeiidJDBCConnection.createConnection(TeiidJDBCConnection.java:83)

at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)

at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)

at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73)

at org.teiid.datatools.connectivity.TeiidJDBCConnectionFactory.createConnection(TeiidJDBCConnectionFactory.java:23)

at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)

at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)

at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.getSqlConnection(PreviewDataWorker.java:621)

at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.internalRun(PreviewDataWorker.java:398)

at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:263)

at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:99)

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$5.handleEvent(ActionContributionItem.java:411)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Caused by: org.teiid.net.ConnectionException: TEIID20014 The port 'undefined' is a non-numeric value.

at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:293)

at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54)

... 42 more

Caused by: java.net.MalformedURLException: The port 'undefined' is a non-numeric value.

at org.teiid.net.TeiidURL.validatePort(TeiidURL.java:249)

at org.teiid.net.TeiidURL.parseServerURL(TeiidURL.java:238)

at org.teiid.net.TeiidURL.<init>(TeiidURL.java:129)

at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:291)

... 43 more

When I looked at the default Teiid server port, it is set as 'undefined' (see screenshot below).  This is not an editable field.  And the teiid server itself was automatically picked up when I added my jboss server to eclipse.  What am I missing?  Is there a way to set this port?  (sorry the image is poor, but file is attached)

Thanks

Srini

[rareddy]

Srini,

Yes, that is strange.  I am guessing the server connection was created before you installed the Teiid, so when Teiid got installed it took the existing connection but it's defaults were wrong. Hopefully somebody from Designer can verify that and log an issue.

The work around I suggest is delete the current server connection and create a new one, hopefully this time it will have correct defaults, or you can define the port as 31000 (default) when you are creating the new connection.

Ramesh..

[skethire]

I finally got around to trying this again.  I deleted the server definition and recreated it.  The second time it picked up the correct port.  This is on a different computer.

I am still not sure what the problem is with the first definition.  Perhaps the admin connection info was wrong..

Thanks

srini