1 2 Previous Next 20 Replies Latest reply on May 8, 2014 6:12 PM by Mark Drilling

    XML Data Source - Preview Data / VDB Fails

    Pramod Nair Novice

      I followed the steps for XML Data Source --> Model Remote XML File Data Source - Teiid Examples - Project Documentation Editor

       

      When I ry Preview Data in the last step I am not getting any DL Results. No errors. Any help. I am using JBoss EAP 6.1, Teiid Runtime 8.6 and Teiid Designer 8.4

        • 1. Re: XML Data Source - Preview Data / VDB Fails
          Ramesh Reddy Master

          Pramod,

           

          Either "Root Path" is an issue in the transformation where you rooted to read the data from or if you got namespaces in the document they were not correctly defined.

           

          Ramesh..

          • 2. Re: XML Data Source - Preview Data / VDB Fails
            Pramod Nair Novice

            Thanks Ramesh. as I am new to this teiid can you please direct me to the part of the documentation where there is guide to define root path etc.

            • 3. Re: XML Data Source - Preview Data / VDB Fails
              Pramod Nair Novice

              This is the xml I am using --> http://www.w3schools.com/xml/plant_catalog.xml

              I have the source and view screenshot below:

              i1.png

              • 4. Re: XML Data Source - Preview Data / VDB Fails
                Pramod Nair Novice

                THis is the COnsole entry for Preview Data :

                06:19:14,534 INFO  [org.jboss.as.repository] (management-handler-thread - 4)  JBAS014900: Content added at location C:\Pramod\COE\Downloads\jboss\jboss-eap-6.1\standalone\data\content\b7\90990c656f5270f9c172274d08d10242259e2d\content

                06:19:14,545 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2)  JBAS015876: Starting deployment of "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_ViewModel.vdb" (runtime-name: "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_ViewModel.vdb")

                06:19:14,677 INFO  [org.teiid.RUNTIME] (MSC service thread 1-2)  TEIID50029 VDB PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_ViewModel.1 model "ViewModel" metadata is currently being loaded. Start Time: 4/30/14 6:19 AM

                06:19:14,834 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 4)  TEIID50030 VDB PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_ViewModel.1 model "ViewModel" metadata loaded. End Time: 4/30/14 6:19 AM

                06:19:14,965 WARN  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 4)  TEIID31080 View ViewModel.new_table validation error: TEIID30352 SOURCEMODEL.INVOKEHTTP does not exist.

                06:19:14,966 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 4)  TEIID40073 The metadata for the VDB PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_ViewModel.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.

                06:19:14,966 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 4)  TEIID40003 VDB PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_ViewModel.1 is set to ACTIVE

                06:19:14,978 INFO  [org.jboss.as.server] (management-handler-thread - 4)  JBAS018559: Deployed "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_ViewModel.vdb" (runtime-name : "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_ViewModel.vdb")

                06:19:15,849 INFO  [org.jboss.as.repository] (management-handler-thread - 3)  JBAS014900: Content added at location C:\Pramod\COE\Downloads\jboss\jboss-eap-6.1\standalone\data\content\da\57ba0307012f3878a07fcf43a8c5b7e6b8f3cc\content

                06:19:15,867 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2)  JBAS015876: Starting deployment of "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_project.vdb" (runtime-name: "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_project.vdb")

                06:19:15,960 INFO  [org.teiid.RUNTIME] (MSC service thread 1-2)  TEIID40003 VDB PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_project.1 is set to ACTIVE

                06:19:16,023 INFO  [org.jboss.as.server] (management-handler-thread - 3)  JBAS018559: Deployed "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_project.vdb" (runtime-name : "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_project.vdb")

                06:19:18,900 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4)  IJ020001: Required license terms for file:/C:/Pramod/COE/Downloads/jboss/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/webservice/main/./

                06:19:19,330 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2)  IJ020001: Required license terms for file:/C:/Pramod/COE/Downloads/jboss/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/webservice/main/./

                06:19:19,341 INFO  [org.jboss.as.connector.deployment] (MSC service thread 1-2)  JBAS010406: Registered connection factory java:/PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_SourceModel

                06:19:19,342 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2)  IJ020002: Deployed: file:/C:/Pramod/COE/Downloads/jboss/jboss-eap-6.1/modules/system/layers/base/org/jboss/teiid/resource-adapter/webservice/main/./

                06:19:19,344 INFO  [org.jboss.as.connector.deployment] (MSC service thread 1-1)  JBAS010401: Bound JCA ConnectionFactory [java:/PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_SourceModel]

                06:19:19,517 INFO  [org.jboss.as.repository] (management-handler-thread - 2)  JBAS014900: Content added at location C:\Pramod\COE\Downloads\jboss\jboss-eap-6.1\standalone\data\content\58\ea059a7e8408f3806745a9e2e48e6d8c6417f1\content

                06:19:19,522 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3)  JBAS015876: Starting deployment of "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_SourceModel.vdb" (runtime-name: "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_SourceModel.vdb")

                06:19:19,751 INFO  [org.teiid.RUNTIME] (MSC service thread 1-4)  TEIID50029 VDB PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_SourceModel.1 model "SourceModel" metadata is currently being loaded. Start Time: 4/30/14 6:19 AM

                06:19:19,859 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 2)  TEIID50030 VDB PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_SourceModel.1 model "SourceModel" metadata loaded. End Time: 4/30/14 6:19 AM

                06:19:19,877 INFO  [org.jboss.as.server] (management-handler-thread - 2)  JBAS018559: Deployed "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_SourceModel.vdb" (runtime-name : "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_SourceModel.vdb")

                06:19:19,901 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 2)  TEIID40003 VDB PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_sources_SourceModel.1 is set to ACTIVE

                06:19:20,603 INFO  [org.teiid.RUNTIME] (MSC service thread 1-1)  TEIID50026 VDB "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_project.1[]" undeployed.

                06:19:20,661 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4)  JBAS015877: Stopped deployment PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_project.vdb (runtime-name: PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_project.vdb) in 78ms

                06:19:20,918 INFO  [org.jboss.as.repository] (management-handler-thread - 3)  JBAS014901: Content removed from location C:\Pramod\COE\Downloads\jboss\jboss-eap-6.1\standalone\data\content\da\57ba0307012f3878a07fcf43a8c5b7e6b8f3cc\content

                06:19:20,919 INFO  [org.jboss.as.server] (management-handler-thread - 3)  JBAS018558: Undeployed "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_project.vdb" (runtime-name: "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_project.vdb")

                06:19:21,172 INFO  [org.jboss.as.repository] (management-handler-thread - 4)  JBAS014900: Content added at location C:\Pramod\COE\Downloads\jboss\jboss-eap-6.1\standalone\data\content\16\70923a7fdbd0cca15d8d0e7a38994b758b3d83\content

                06:19:21,188 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4)  JBAS015876: Starting deployment of "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_project.vdb" (runtime-name: "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_project.vdb")

                06:19:21,482 INFO  [org.teiid.RUNTIME] (MSC service thread 1-3)  TEIID40003 VDB PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_project.1 is set to ACTIVE

                06:19:21,602 INFO  [org.jboss.as.server] (management-handler-thread - 4)  JBAS018559: Deployed "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_project.vdb" (runtime-name : "PREVIEW_a9eb296e-7f6d-48c2-9e6d-95d734b16ced_test_project.vdb")

                 

                 

                Console error log is attachedi1.png

                 

                Model Explorerr:

                i1.png

                • 5. Re: Re: XML Data Source - Preview Data / VDB Fails
                  Ramesh Reddy Master

                  Pamod,

                   

                   

                  What you need to fist check is the transformation of the view. If you double click on it, it should show SQL like this.

                   

                  SELECT
                    A.COMMON AS COMMON, A.BOTANICAL AS BOTANICAL, A.ZONE AS ZONE, A.LIGHT AS LIGHT, A.PRICE AS PRICE, A.AVAILABILITY AS AVAILABILITY
                    FROM
                    (EXEC SourceModel.invokeHttp('GET', null, 'http://www.w3schools.com/xml/plant_catalog.xml', 'TRUE')) AS f,
                  XMLTABLE('/CATALOG' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS COMMON string PATH 'PLANT/COMMON/text()',
                  BOTANICAL string PATH 'PLANT/BOTANICAL/text()', ZONE string PATH 'PLANT/ZONE/text()', LIGHT string PATH 'PLANT/LIGHT/text()',
                  PRICE string PATH 'PLANT/PRICE/text()', AVAILABILITY string PATH 'PLANT/AVAILABILITY/text()') AS A
                  

                   

                  for your reference I am attaching the whole eclipse project set.

                   

                  Ramesh..

                  • 6. Re: Re: XML Data Source - Preview Data / VDB Fails
                    Pramod Nair Novice

                    Ramesh Appreciate your time. I tried your project within my JBoss Developer Studio and Preview fails. Do you think this is something to do with my envt. I have

                    JBoss EAP 6.1;

                    Teiid 8.6

                    JBoss Dev Studio --> 7.1.1 GA

                    Teiid Designer --> 8.4

                    Attached the screenshots:

                    i1.png

                    i2.png

                    • 7. Re: Re: XML Data Source - Preview Data / VDB Fails
                      Mark Drilling Novice

                      Pramod,

                      Can you check the JBDS/Designer log - located at /workspace/.metadata/.log .  Please attach any exceptions at the bottom of the log

                      Thanks

                      Mark

                      • 8. Re: Re: XML Data Source - Preview Data / VDB Fails
                        Pramod Nair Novice

                        /workspace/.metadata/.log attached below:


                        !SESSION 2014-04-29 22:57:47.656 -----------------------------------------------

                        eclipse.buildId=unknown

                        java.version=1.6.0_26

                        java.vendor=Sun Microsystems Inc.

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

                        Framework arguments:  -application org.eclipse.ui.ide.workbench -product com.jboss.jbds.product.product

                        Command-line arguments:  -os win32 -ws win32 -arch x86 -application org.eclipse.ui.ide.workbench -product com.jboss.jbds.product.product

                         

                         

                        !ENTRY org.teiid.designer.dqp.ui 4 0 2014-04-30 06:19:24.105

                        !MESSAGE

                         

                         

                        !ENTRY org.teiid.designer.dqp.ui 4 0 2014-04-30 11:36:24.262

                        !MESSAGE

                        • 9. Re: XML Data Source - Preview Data / VDB Fails
                          Mark Drilling Novice

                          based on the Error Log tab on your screenshots, there is an error - but no corresponding log trace.  You can try double-click on the error log entry - to see if there is a stack trace.  Otherwise, can you export your Model Project Set and attach it?  I will see if I can reproduce.  Click on the project, the File > Export > Teiid Designer > Model Project Set.

                          Thanks

                          Mark

                          • 10. Re: Re: XML Data Source - Preview Data / VDB Fails
                            Pramod Nair Novice

                            No stacktrace available. Model Project set attached.mdrillin

                            • 11. Re: XML Data Source - Preview Data / VDB Fails
                              Mark Drilling Novice

                              In the import wizard, see the instructions for the "XML Data File Import Options" page.  Make sure you expand the document, select the "PLANT" node then rt-click > set as root path.  The root path should look like the screencap.  When I run preview on your table I get the error below because your root path was /CATALOG, not /CATALOG/PLANT

                               

                              org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30171 Unexpected multi-valued result was returned for XMLTable column "COMMON".  Path expressions for non-XML type columns should return at most a single result.

                               

                              I'm not sure why you're not getting any error message - I will keep looking into that.

                              • 12. Re: Re: XML Data Source - Preview Data / VDB Fails
                                Pramod Nair Novice

                                Tried it. Ran into trouble. Sorry for disturbing you and really appreciate your help:Attached the Model project.

                                 

                                The XML file I am using is ==================> http://www.w3schools.com/xml/plant_catalog.xml

                                 

                                Transformation Query:

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

                                SELECT

                                  A.COMMON AS COMMON, A.BOTANICAL AS BOTANICAL, A.ZONE AS ZONE, A.LIGHT AS LIGHT, A.PRICE AS PRICE, A.AVAILABILITY AS AVAILABILITY

                                  FROM

                                  (EXEC SourceModel.invokeHttp('GET', null, 'http://www.w3schools.com/xml/plant_catalog.xml', 'TRUE')) AS f, XMLTABLE('/CATALOG/PLANT' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS COMMON string PATH 'COMMON/text()', BOTANICAL string PATH 'BOTANICAL/text()', ZONE string PATH 'ZONE/text()', LIGHT string PATH 'LIGHT/text()', PRICE string PATH 'PRICE/text()', AVAILABILITY string PATH 'AVAILABILITY/text()') AS A

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

                                 

                                Log Entry:

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

                                !SESSION 2014-04-29 22:57:47.656 -----------------------------------------------

                                eclipse.buildId=unknown

                                java.version=1.6.0_26

                                java.vendor=Sun Microsystems Inc.

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

                                Framework arguments:  -application org.eclipse.ui.ide.workbench -product com.jboss.jbds.product.product

                                Command-line arguments:  -os win32 -ws win32 -arch x86 -application org.eclipse.ui.ide.workbench -product com.jboss.jbds.product.product

                                 

                                 

                                !ENTRY org.teiid.designer.dqp.ui 4 0 2014-04-30 06:19:24.105

                                !MESSAGE

                                 

                                 

                                !ENTRY org.teiid.designer.dqp.ui 4 0 2014-04-30 11:36:24.262

                                !MESSAGE

                                 

                                 

                                !ENTRY org.teiid.designer.dqp.ui 4 0 2014-04-30 13:25:22.566

                                !MESSAGE

                                 

                                 

                                !ENTRY org.eclipse.datatools.connectivity 4 10001 2014-04-30 16:26:13.679

                                !MESSAGE Error loading connection profile data.

                                !STACK 1

                                org.eclipse.core.runtime.CoreException: Error loading connection profile data.

                                  at org.eclipse.datatools.connectivity.internal.ConnectionProfileMgmt.loadCPs(ConnectionProfileMgmt.java:950)

                                  at org.eclipse.datatools.connectivity.internal.ConnectionProfileMgmt.loadCPsUsingFileExtension(ConnectionProfileMgmt.java:529)

                                  at org.eclipse.datatools.connectivity.internal.ConnectionProfileMgmt.loadCPs(ConnectionProfileMgmt.java:503)

                                  at org.eclipse.datatools.connectivity.internal.InternalProfileManager.loadProfiles(InternalProfileManager.java:1088)

                                  at org.eclipse.datatools.connectivity.internal.InternalProfileManager.getProfiles(InternalProfileManager.java:150)

                                  at org.eclipse.datatools.connectivity.internal.InternalProfileManager.getProfilesByCategory(InternalProfileManager.java:200)

                                  at org.eclipse.datatools.connectivity.ProfileManager.getProfilesByCategory(ProfileManager.java:88)

                                  at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlImportSourcePage.refreshConnectionProfiles(TeiidXmlImportSourcePage.java:1044)

                                  at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlImportSourcePage.setVisible(TeiidXmlImportSourcePage.java:1513)

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

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

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

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

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

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

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

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

                                Caused by: org.xml.sax.SAXParseException: Premature end of file.

                                  at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)

                                  at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)

                                  at org.eclipse.datatools.connectivity.internal.ConnectionProfileMgmt.loadCPs(ConnectionProfileMgmt.java:939)

                                  ... 73 more

                                !SUBENTRY 1 org.eclipse.datatools.connectivity 4 -1 2014-04-30 16:26:13.735

                                !MESSAGE Error loading connection profile data.

                                !STACK 0

                                org.xml.sax.SAXParseException: Premature end of file.

                                  at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)

                                  at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)

                                  at org.eclipse.datatools.connectivity.internal.ConnectionProfileMgmt.loadCPs(ConnectionProfileMgmt.java:939)

                                  at org.eclipse.datatools.connectivity.internal.ConnectionProfileMgmt.loadCPsUsingFileExtension(ConnectionProfileMgmt.java:529)

                                  at org.eclipse.datatools.connectivity.internal.ConnectionProfileMgmt.loadCPs(ConnectionProfileMgmt.java:503)

                                  at org.eclipse.datatools.connectivity.internal.InternalProfileManager.loadProfiles(InternalProfileManager.java:1088)

                                  at org.eclipse.datatools.connectivity.internal.InternalProfileManager.getProfiles(InternalProfileManager.java:150)

                                  at org.eclipse.datatools.connectivity.internal.InternalProfileManager.getProfilesByCategory(InternalProfileManager.java:200)

                                  at org.eclipse.datatools.connectivity.ProfileManager.getProfilesByCategory(ProfileManager.java:88)

                                  at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlImportSourcePage.refreshConnectionProfiles(TeiidXmlImportSourcePage.java:1044)

                                  at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlImportSourcePage.setVisible(TeiidXmlImportSourcePage.java:1513)

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

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

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

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

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

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

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

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

                                 

                                 

                                !ENTRY org.teiid.designer.dqp.ui 4 0 2014-04-30 16:30:41.012

                                !MESSAGE

                                • 13. Re: Re: XML Data Source - Preview Data / VDB Fails
                                  Mark Drilling Novice

                                  No problem - we appreciate your feedback.  I've done some more testing, and apparently we have issues with the Designer 8.4 installation (on windows os).  I'd recommend that you move to the latest Designer 8.5 build. 

                                  Follow the install instructions for 8.5 Alpha at Download & Install - JBoss Community .  You already have 8.4 installed, so you can just update that if you wish (or keep it and do a separate clean install for 8.5).  On step 3, use the Designer nightly build update site - http://download.jboss.org/jbosstools/builds/staging/jbosstools-teiid-designer_trunk/all/repo/  - instead of the one given in the instructions.  Normally we'd recommend the alpha build - but there is a bug with the type of import you're doing - that's fixed in the nightly.  I just tested the nightly and ran through the import and preview against a teiid 8.6 server with no problem.

                                  Thanks,

                                  Mark

                                  • 14. Re: XML Data Source - Preview Data / VDB Fails
                                    Pramod Nair Novice

                                    Thanks again. I made it to work with Designer 8.3. When I tried the nightly update it forced me to downgrade from 8.4 to 8.3. After that the test started working. Thanks a lot. Major road bloc removed. Moving on to deal with mainframe data now with REST services.

                                    1 2 Previous Next