1 2 Previous Next 16 Replies Latest reply on Mar 26, 2015 12:04 PM by Ted Jones

    Optimal setup for Teiid/JBoss/Teiid Designer Tools

    Evangelos Pertsinis Newbie

      Hi,

       

      We're trying to setup a server environment with Teiid/JBoss Community versions. So far we've run into some issues especially with Teiid Designer Tools and Teiid Runtime. If you have an optimal setup could you please share it.

       

      We need to know:

       

      • JBoss server community version (we used EAP 6.3)
      • Teiid Runtime (we used 8.9.1)
      • Teiid Designer Tools for Eclipse (we used 9.0 Final)
      • JDK (we tried both 1.8 and 1.7 just in case) 

       

      Regards,

       

      Evangelos

        • 1. Re: Optimal setup for Teiid/JBoss/Teiid Designer Tools
          Tomaz Cerar Master

          Moved to proper forum.

          As of jboss server community version goes, that would be WildFly, with current stable version being 8.2 which you can get at http://wildfly.org/downloads/

           

          JBoss EAP 6.x commercially supported version that is accessible to developers under $0 developer subscription about which you can read at http://www.jboss.org/faq/ but for running in production you need to obtain subscription from Red Hat.

          • 2. Re: Optimal setup for Teiid/JBoss/Teiid Designer Tools
            Ramesh Reddy Master

            You mean what versions work together?

             

            1) Latest Teiid runtime is 8.10.0.Final, you can also use Teiid 8.9.1

            2) Java 1.7, you can also use Java 1.8

            3) MUST use EAP 6.3.Alpha (Not GA, with community version)

            4) Teiid Designer 9.0 may be supported with 8.9.1, but this version is only tested with Teiid 8.7. There is no version compatible to work with 8.10 yet.

             

            Ramesh..

            • 3. Re: Optimal setup for Teiid/JBoss/Teiid Designer Tools
              Evangelos Pertsinis Newbie

              Yes I meant what versions work together. We installed:

               

              - EAP 6.3 Alpha

              - Java 1.8

              - Teiid 8.9.1

              - Teiid Designer 9.0

               

              The server starts fine but when I try to connect to our REST API I get back:

               

              java.io.IOException: Server returned HTTP response code: 500 for URL: http://*******/public/site.version

                at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source)

                at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)

                at org.teiid.designer.core.util.URLHelper.resolveUrl(URLHelper.java:286)

                at org.teiid.designer.datatools.profiles.ws.WSWizardUtils.testURLConnection(WSWizardUtils.java:90)

                at org.teiid.designer.datatools.profiles.ws.WSProfileDetailsWizardPage$URLPingJob.testXmlUrlConnection(WSProfileDetailsWizardPage.java:580)

                at org.teiid.designer.datatools.profiles.ws.WSProfileDetailsWizardPage$URLPingJob.run(WSProfileDetailsWizardPage.java:570)

                at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

               

              Does that mean Teiid Designer tools won't work with 8.9.1? I also tried Teiid runtime 8.8 but then the server doesn't even start.

               

              Any ideas?

               

              Cheers

               

              Evangelos

              • 4. Re: Optimal setup for Teiid/JBoss/Teiid Designer Tools
                Steven Hawkins Master

                > Does that mean Teiid Designer tools won't work with 8.9.1?

                 

                No, at first glance that doesn't appear related to the runtime.

                 

                > I also tried Teiid runtime 8.8 but then the server doesn't even start.

                 

                8.8 would be EAP 6.1 Alpha1 - see Downloads · Teiid it also required an additional rest easy patch.  However EAP 6.1 had issues with Java 1.8 I believe that were addressed for EAP 6.3.

                • 5. Re: Optimal setup for Teiid/JBoss/Teiid Designer Tools
                  Evangelos Pertsinis Newbie

                  What do you think is the issue then? When I hit the REST API from either the browser or Postman I get data back. Within Teiid Designer Tools I cant seem to be able to ping it.

                   

                  Vagos

                  • 6. Re: Optimal setup for Teiid/JBoss/Teiid Designer Tools
                    Ramesh Reddy Master

                    From your positing above it does not show any error that indicates to the Designer error. BTW, when does this error happen?

                    • 7. Re: Optimal setup for Teiid/JBoss/Teiid Designer Tools
                      Evangelos Pertsinis Newbie

                      The error happens when I try to test the REST API URL during import[1]. If I then click Finish I can see the API response file but I get a markup error (something about the response has to bee well formatted).

                       

                      If I discard that error as well and click Next so I can finish importing the API source the server produces an error [2].

                      [1]

                      teiidErrorPingURL.png

                      [2]

                       

                      eclipse.buildId=4.4.2.M20150204-1700

                      java.version=1.8.0_40

                      java.vendor=Oracle Corporation

                      BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US

                      Framework arguments:  -product org.eclipse.epp.package.java.product

                      Command-line arguments:  -os win32 -ws win32 -arch x86_64 -product org.eclipse.epp.package.java.product

                       

                       

                      org.eclipse.ui

                      Error

                      Thu Mar 26 10:55:33 UTC 2015

                      Unhandled event loop exception

                       

                       

                      org.eclipse.core.runtime.AssertionFailedException: null argument:

                        at org.eclipse.core.runtime.Assert.isNotNull(Assert.java:85)

                        at org.eclipse.core.runtime.Assert.isNotNull(Assert.java:73)

                        at org.eclipse.jface.viewers.StructuredViewer.assertElementsNotNull(StructuredViewer.java:584)

                        at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:1000)

                        at org.eclipse.jface.viewers.ColumnViewer.getRawChildren(ColumnViewer.java:699)

                        at org.eclipse.jface.viewers.AbstractTreeViewer.getRawChildren(AbstractTreeViewer.java:1349)

                        at org.eclipse.jface.viewers.TreeViewer.getRawChildren(TreeViewer.java:353)

                        at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:905)

                        at org.eclipse.jface.viewers.AbstractTreeViewer.getSortedChildren(AbstractTreeViewer.java:617)

                        at org.eclipse.jface.viewers.AbstractTreeViewer$1.run(AbstractTreeViewer.java:815)

                        at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)

                        at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:791)

                        at org.eclipse.jface.viewers.TreeViewer.createChildren(TreeViewer.java:611)

                        at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:762)

                        at org.eclipse.jface.viewers.AbstractTreeViewer.internalInitializeTree(AbstractTreeViewer.java:1543)

                        at org.eclipse.jface.viewers.TreeViewer.internalInitializeTree(TreeViewer.java:790)

                        at org.eclipse.jface.viewers.AbstractTreeViewer$5.run(AbstractTreeViewer.java:1527)

                        at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1436)

                        at org.eclipse.jface.viewers.TreeViewer.preservingSelection(TreeViewer.java:366)

                        at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1397)

                        at org.eclipse.jface.viewers.AbstractTreeViewer.inputChanged(AbstractTreeViewer.java:1519)

                        at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:292)

                        at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1675)

                        at org.teiid.designer.transformation.ui.wizards.xmlfile.panels.XmlFileContentsGroup.loadFileContentsViewer(XmlFileContentsGroup.java:64)

                        at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlImportXmlConfigurationPage.loadFileContentsViewer(TeiidXmlImportXmlConfigurationPage.java:214)

                        at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlImportXmlConfigurationPage.setVisible(TeiidXmlImportXmlConfigurationPage.java:142)

                        at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1289)

                        at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1268)

                        at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1257)

                        at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)

                        at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1254)

                        at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:942)

                        at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:434)

                        at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:619)

                        at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)

                        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.jface.window.Window.runEventLoop(Window.java:832)

                        at org.eclipse.jface.window.Window.open(Window.java:808)

                        at org.eclipse.ui.internal.handlers.WizardHandler$Import.executeHandler(WizardHandler.java:158)

                        at org.eclipse.ui.internal.handlers.WizardHandler.execute(WizardHandler.java:290)

                        at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:294)

                        at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90)

                        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.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:55)

                        at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:247)

                        at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:229)

                        at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132)

                        at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:149)

                        at org.eclipse.core.commands.Command.executeWithChecks(Command.java:499)

                        at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)

                        at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:210)

                        at org.eclipse.ui.internal.handlers.LegacyHandlerService.executeCommand(LegacyHandlerService.java:343)

                        at org.eclipse.ui.internal.actions.CommandAction.runWithEvent(CommandAction.java:159)

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

                        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(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:648)

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

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

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

                      • 8. Re: Optimal setup for Teiid/JBoss/Teiid Designer Tools
                        Steven Hawkins Master

                        We'll have the Teiid Designer guys take a look.  Hopefully it's a known issue with a workaround.

                        • 9. Re: Optimal setup for Teiid/JBoss/Teiid Designer Tools
                          Ted Jones Master

                          Hi Vagos,

                           

                          Can you please have a look at the EAP console or log and get the full stack trace? My guess is you will need add an optional header parameter, but I need the full stack trace from the server to be sure. Also, please upgrade to 9.0.1.Final as some improvements were made in the REST importer. Here is the update site: Index of /jbosstools/updates/release/luna/integration-stack/teiiddesigner/9.0.1.Final

                           

                          Thanks,

                          Ted

                          • 10. Re: Optimal setup for Teiid/JBoss/Teiid Designer Tools
                            Evangelos Pertsinis Newbie

                            Hi Ted,

                             

                            Teiid 9.0.1 seems to fixed the error I was getting when testing the connection. Now though I'm getting

                             

                            "The return type for the connection profile is JSON. An invalid response was returned."

                             

                            This is the server response:

                             

                            {"successMessage":"V107.1-2015-03-26_10-54-24-EXCEL","data":"V107.1"}

                             

                            Why would that be invalid? Mind you, in Teiid 8.7 it works fine.

                             

                            Cheers

                             

                            Vagos

                            • 11. Re: Optimal setup for Teiid/JBoss/Teiid Designer Tools
                              Ted Jones Master

                              Hi Vagos,

                               

                              Can you please share your expected response? Also, please check the EAP console and/or log for more info.

                               

                              Thanks,

                              Ted

                              • 12. Re: Optimal setup for Teiid/JBoss/Teiid Designer Tools
                                Evangelos Pertsinis Newbie

                                Sorry, I was bit unclear. The REST API response is:

                                 

                                {"successMessage":"V107.1-2015-03-26_10-54-24-EXCEL","data":"V107.1"}


                                This a GET request.


                                Teiid comes back with:


                                teiidErrorInvalidResponse.png

                                 

                                The server log and console have no messages.

                                Vagos

                                • 13. Re: Optimal setup for Teiid/JBoss/Teiid Designer Tools
                                  Steven Hawkins Master

                                  That is not coming from Teiid.  I believe the Teiid Designer team has been working on their error reporting with that dialog.  You should hit the server directly to see what the response looks like.

                                  • 14. Re: Optimal setup for Teiid/JBoss/Teiid Designer Tools
                                    Ted Jones Master

                                    Hi Vargos,

                                     

                                    Using TD 9.0.1 I was able to import that JSON without issue. Can you please check your Designer log under .metadata of your workspace?

                                     

                                    Thanks,

                                    Ted

                                    1 2 Previous Next