File source xml importer - TeiidException: java.lang.ClassNotFoundException: com.sun.ws.rs.ext.RuntimeDelegateImpl from

[lightsailpro]

I am testing importing a xml "http://www.w3schools.com/xml/plant_catalog.xml" using the importer tool. I got the following error when doing preview. I have teiid 8.7 with designer 8.5 apha2 on Windows. Does anyone know what is missing here? Thanks

select * from "SampleXml"."SampleXml"

org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: java.lang.ClassNotFoundException: com.sun.ws.rs.ext.RuntimeDelegateImpl from [Module "javax.ws.rs.api:main" from local module loader @6d667cff (finder: local module finder @63988175 (roots: C:\Teiid87\jboss-eap-6.1\modules,C:\Teiid87\jboss-eap-6.1\modules\system\layers\base))]

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

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

(EXEC SampleXmlSource.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

[shawkins]

Is this still the same issue as Teiid 8.6 flat file remote url error?

It seems somewhat related to CXF.  Does the same error occur with Teiid 8.6?  Are you running with the EAP 6.1 Alpha?

[lightsailpro]

Basically similar issue as in 8.6, but it is better. The local XML file works fine. But remote xml file always gives me the above "ClassNotFoundException" exception. I have Windows 7 x64, jdk 1.6.37, Teiid 8.7, designer 8.5 alpha 2 with latest nightly build, EAP6.1 alpha, JBDS 7.1.1. From what I tested, I have not been able to find a remote file working combination on Windows platform. Does the CXF comes with EAP 6.1 alpha, or do I need install separately. Thanks a lot.

[lightsailpro]

I do have two failed service when stating Teiid 8.7 on windows 7. I am not if it is related to the remote file exception.

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

08:36:18,326 ERROR [org.apache.catalina.core] (ServerService Thread Pool -- 53)  JBWEB001103: Error detected during cont
ext /odata start, will stop it
08:36:18,342 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 53)  MSC00001: Failed to start service jbo
ss.web.deployment.default-host./odata: org.jboss.msc.service.StartException in service jboss.web.deployment.default-host
./odata: org.jboss.msc.service.StartException in anonymous service: JBAS018040: Failed to start context
        at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:96)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) [rt.jar:1.6.0_37]
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_37]
        at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_37]
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_37]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_37]
        at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_37]
        at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: org.jboss.msc.service.StartException in anonymous service: JBAS018040: Failed to start context
        at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:161)
        at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60)
        at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93)
        ... 7 more

08:36:18,358 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1)  TEIID40003 VDB SalesforceVDB.1 is set to ACTIVE
08:36:18,592 INFO  [org.jboss.as.server] (Controller Boot Thread)  JBAS018559: Deployed "OverdriveVDB.vdb" (runtime-name
: "OverdriveVDB.vdb")
08:36:18,592 INFO  [org.jboss.as.server] (Controller Boot Thread)  JBAS018559: Deployed "SalesforceVDB.vdb" (runtime-nam
e : "SalesforceVDB.vdb")
08:36:18,592 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 44)  JBAS018559: Deployed "teiid-odata-8.7.0.Fina
l.war" (runtime-name : "teiid-odata-8.7.0.Final.war")
08:36:18,592 INFO  [org.jboss.as.controller] (Controller Boot Thread)  JBAS014774: Service status report
JBAS014777:   Services which failed to start:      service jboss.web.deployment.default-host./odata: org.jboss.msc.servi
ce.StartException in service jboss.web.deployment.default-host./odata: org.jboss.msc.service.StartException in anonymous
service: JBAS018040: Failed to start context

08:36:18,654 INFO  [org.jboss.as] (Controller Boot Thread)  JBAS015961: Http management interface listening on http://12
7.0.0.1:9990/management
08:36:18,654 INFO  [org.jboss.as] (Controller Boot Thread)  JBAS015951: Admin console listening on http://127.0.0.1:9990

08:36:18,654 ERROR [org.jboss.as] (Controller Boot Thread)  JBAS015875: JBoss Teiid + Teiid 8.4 (AS 7.2.0.Alpha1-redhat-
4) started (with errors) in 11293ms - Started 420 of 507 services (2 services failed or missing dependencies, 82 service
s are passive or on-demand)
08:36:18,794 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 3)  TEIID40003 VDB OverdriveVDB.1 is set to ACTIVE

[shawkins]

I believe those are indicative of the rest easy patch not being applied.  You can follow the rest easy patch instructions from the download page - Downloads · Teiid

[lightsailpro]

The rest easy patch actually fixed the both startup errors and remote file exceptions. Thanks a lot!

[shawkins]

That's great news.  It seems odd that it has that far reaching of an affect.  We may need to change the download page to indicate that it should be installed even when not using odata.