6 Replies Latest reply on Apr 23, 2014 4:32 PM by lightsail pro

    Teiid 8.6 flat file remote url error

    lightsail pro Newbie

      I am following the instruction from here to try the flat file data source using remote url:

        https://community.jboss.org/wiki/RemoteFlatFileDataSourceExample

        http://download.jboss.org/teiid/designer/data/employees/file/EMPLOYEEDATA.txt

      I am getting error when preview the sample employee data. My teiid version teiid-8.6.0.Final-jboss-dist with jboss-eap-6.1.0.Alpha running on Windows 7 64bit with JDK jdk1.6.0_37 x64,   Teiid Designer Runtime 8.3.2.Final-v20140328-2123-B54

       

      Could someone help?

       

      ==============================================

      select * from "EMPLOYEE_DATA_VIEWS"."EmployeeData"

      java.lang.ClassNotFoundException: com.sun.ws.rs.ext.RuntimeDelegateImpl from [Module "javax.ws.rs.api:main" from local module loader @2dafae45 (finder: local module finder @68da4b71 (roots: C:\Teiid\jboss-eap-6.1\modules,C:\Teiid\jboss-eap-6.1\modules\system\layers\base))]


      Elapsed Time:  0 hr, 0 min, 0 sec, 73 ms.

       


        • 1. Re: Teiid 8.6 flat file remote url error
          Steven Hawkins Master

          Can you provide the full stacktrace from the server log, and are there any earlier warnings/errors in the server log?

          • 2. Re: Teiid 8.6 flat file remote url error
            Ramesh Reddy Master

            I believe Teiid Designer prescribes 32 bit JDK for the Windows platform. See Download & Install - JBoss Community

            • 3. Re: Teiid 8.6 flat file remote url error
              lightsail pro Newbie

              Just tested the flat file with remote url using Teiid 8.7 and designer 8.5 alpha. Preview button is just greyed out. Could not preview at all. 

              • 4. Re: Teiid 8.6 flat file remote url error
                Mark Drilling Novice

                The Teiid 8.7 - designer 8.5 alpha preview issue is due to this issue - [TEIIDDES-2124] Cannot create Teiid Driver connection - JBoss Issue Tracker   We will be rebuilding the update site and updating the install instructions within the next day or two.  Thanks for your patience.

                • 5. Re: Teiid 8.6 flat file remote url error
                  lightsail pro Newbie

                       The flat file remote url error is not a designer 8.5 specific issue. The jdbc connection related preview issue actually got fixed with today's alpha build. The error exists in all teiid 8.6+ and designer 8.32+ combo (windows and linbux) I tested. The only combo that works is the RedHat DV 6.0 with designer 8.31 on Linux. I tested on 8.5 alpha because I am curious to know if 8.5 fixed issue. The issue can be reproduced easily using the instruction listed here https://community.jboss.org/wiki/RemoteFlatFileDataSourceExample. Thanks

                  • 6. Re: Teiid 8.6 flat file remote url error
                    lightsail pro Newbie

                    Here is the stack trace for the flat file remote url error on teiid 8.7 and designer 8.5.0.Alpha1-v20140423-1406-B2577 on windows 7 64 bit, JBDS 7.1.1, Java 1.6.0_37 x64:


                    Got "x" sign on the data source view at the end of the wizard, preview button is greyed out automatically, then "x" disappear. There is exception in the server log. Here is the exception stack trace:

                    ===========================================

                    eclipse.buildId=unknown
                    java.version=1.6.0_37
                    java.vendor=Sun Microsystems Inc.
                    BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US
                    Framework arguments:  -product com.jboss.jbds.product.product
                    Command-line arguments:  -os win32 -ws win32 -arch x86_64 -product com.jboss.jbds.product.product

                    Error
                    Wed Apr 23 13:02:23 EDT 2014


                    java.lang.NullPointerException
                    at org.teiid.designer.runtime.DqpPlugin.handleNewModelEvent(DqpPlugin.java:274)
                    at org.teiid.designer.runtime.DqpPlugin$1.notifyAdd(DqpPlugin.java:227)
                    at org.teiid.designer.core.workspace.ModelWorkspaceManager.fire(ModelWorkspaceManager.java:631)
                    at org.teiid.designer.core.workspace.DeltaProcessor.fireNotification(DeltaProcessor.java:140)
                    at org.teiid.designer.core.workspace.DeltaProcessor.resourceChanged(DeltaProcessor.java:70)
                    at org.eclipse.core.internal.events.NotificationManager$1.run(NotificationManager.java:291)
                    at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
                    at org.eclipse.core.internal.events.NotificationManager.notify(NotificationManager.java:285)
                    at org.eclipse.core.internal.events.NotificationManager.broadcastChanges(NotificationManager.java:149)
                    at org.eclipse.core.internal.resources.Workspace.broadcastPostChange(Workspace.java:396)
                    at org.eclipse.core.internal.resources.Workspace.endOperation(Workspace.java:1531)
                    at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2354)
                    at org.eclipse.ui.actions.WorkspaceModifyOperation.run(WorkspaceModifyOperation.java:118)
                    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 org.teiid.designer.transformation.ui.wizards.file.TeiidMetadataImportProcessor.execute(TeiidMetadataImportProcessor.java:97)
                    at org.teiid.designer.transformation.ui.wizards.file.TeiidMetadataImportWizard$1.run(TeiidMetadataImportWizard.java:179)
                    at org.teiid.designer.ui.common.util.UiUtil.runInSwtThread(UiUtil.java:492)
                    at org.teiid.designer.transformation.ui.wizards.file.TeiidMetadataImportWizard.finish(TeiidMetadataImportWizard.java:176)
                    at org.teiid.designer.ui.common.wizard.AbstractWizard.performFinish(AbstractWizard.java:356)
                    at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:827)
                    at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:432)
                    at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:628)
                    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.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.jface.window.Window.runEventLoop(Window.java:826)
                    at org.eclipse.jface.window.Window.open(Window.java:802)
                    at org.eclipse.ui.internal.handlers.WizardHandler$Import.executeHandler(WizardHandler.java:152)
                    at org.eclipse.ui.internal.handlers.WizardHandler.execute(WizardHandler.java:279)
                    at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:290)
                    at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90)
                    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                    at java.lang.reflect.Method.invoke(Method.java:597)
                    at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:56)
                    at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:243)
                    at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:224)
                    at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132)
                    at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:167)
                    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:213)
                    at org.eclipse.ui.internal.handlers.LegacyHandlerService.executeCommand(LegacyHandlerService.java:420)
                    at org.eclipse.ui.internal.actions.CommandAction.runWithEvent(CommandAction.java:157)
                    at org.eclipse.ui.internal.actions.CommandAction.run(CommandAction.java:171)
                    at org.eclipse.ui.actions.ImportResourcesAction.run(ImportResourcesAction.java:97)
                    at org.eclipse.ui.actions.BaseSelectionListenerAction.runWithEvent(BaseSelectionListenerAction.java:168)
                    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: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(NativeMethodAccessorImpl.java:39)
                    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                    at java.lang.reflect.Method.invoke(Method.java:597)
                    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)