-
1. Re: XML Data Source - Preview Data / VDB Fails
rareddy Apr 29, 2014 11:10 PM (in response to pramod_bs)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_bs Apr 30, 2014 5:45 AM (in response to rareddy)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_bs Apr 30, 2014 6:00 AM (in response to pramod_bs)This is the xml I am using --> http://www.w3schools.com/xml/plant_catalog.xml
I have the source and view screenshot below:
-
4. Re: XML Data Source - Preview Data / VDB Fails
pramod_bs Apr 30, 2014 9:14 AM (in response to pramod_bs)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")
Model Explorerr:
-
5. Re: Re: XML Data Source - Preview Data / VDB Fails
rareddy Apr 30, 2014 9:35 AM (in response to pramod_bs)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..
-
plant.zip 21.5 KB
-
-
6. Re: Re: XML Data Source - Preview Data / VDB Fails
pramod_bs Apr 30, 2014 11:42 AM (in response to rareddy) -
7. Re: Re: XML Data Source - Preview Data / VDB Fails
mdrillin Apr 30, 2014 11:53 AM (in response to pramod_bs)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_bs Apr 30, 2014 12:50 PM (in response to mdrillin)/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
mdrillin Apr 30, 2014 2:29 PM (in response to pramod_bs)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_bs Apr 30, 2014 3:11 PM (in response to mdrillin)No stacktrace available. Model Project set attached.mdrillin
-
Plant.zip 21.5 KB
-
-
11. Re: XML Data Source - Preview Data / VDB Fails
mdrillin Apr 30, 2014 3:55 PM (in response to pramod_bs)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_bs Apr 30, 2014 4:36 PM (in response to mdrillin)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
-
Plant2.zip 23.5 KB
-
-
13. Re: Re: XML Data Source - Preview Data / VDB Fails
mdrillin Apr 30, 2014 7:02 PM (in response to pramod_bs)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_bs Apr 30, 2014 11:09 PM (in response to mdrillin)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.