-
15. Re: XML Data Source - Preview Data / VDB Fails
pramod_bs May 4, 2014 11:10 PM (in response to pramod_bs)I have another issue which I am not sure if I should start another thread?
I have a RESTful XML data source. I am able to Import and View the data using "running man". But when I deploy and execute the VDB and try to get the data I get the following error. Any help?
23:07:28,252 ERROR [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue53) y0Wird73mETL Connector worker process failed for atomic-request=y0Wird73mETL.18.5.4: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.WSConnection
at org.teiid.translator.ws.WSExecutionFactory.createProcedureExecution(WSExecutionFactory.java:51)
at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:308) [teiid-api-8.6.0.Final.jar:8.6.0.Final]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:308) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_51]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:273) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]
at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
23:07:28,256 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue54) y0Wird73mETL TEIID30019 Unexpected exception for request y0Wird73mETL.18: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.WSConnection
at org.teiid.translator.ws.WSExecutionFactory.createProcedureExecution(WSExecutionFactory.java:51)
at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:308) [teiid-api-8.6.0.Final.jar:8.6.0.Final]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:308) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_51]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:273) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]
at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
-
16. Re: XML Data Source - Preview Data / VDB Fails
shawkins May 5, 2014 7:39 AM (in response to pramod_bs)This is indicating that you have a WS Translator, but are using a File source - so there is a mismatch. From your description it sounds like you need to be using a web services source.
-
17. Re: XML Data Source - Preview Data / VDB Fails
pramod_bs May 5, 2014 8:12 AM (in response to shawkins)Thanks Steve for your response. All I did is after the Preview Data I did a define and execute vdb. I did not change anything else. Can you please advise how to fix the mismatch in translator.
-
18. Re: XML Data Source - Preview Data / VDB Fails
rareddy May 5, 2014 8:33 AM (in response to pramod_bs)Pamod,
I believe, when you are designing your view, you used the file based resource, then at runtime you would like to execute against a web service. So, what Designer did is it created file based source based on your selection. I suggest you redo the import, but this time you select the web-service during the import, then it will work correctly.
Ramesh..
-
19. Re: XML Data Source - Preview Data / VDB Fails
pramod_bs May 5, 2014 9:42 AM (in response to rareddy)Thanks Ramesh. I restarted the Model Project again from the scratch. The Preview Data is working But when I try to Define and Execute VDB I get the error. When I exported Eclispe Teiid Model project and Imported in another machine and recreated VDB it works. Not sure why this is happening.
-
20. Re: XML Data Source - Preview Data / VDB Fails
mdrillin May 8, 2014 6:12 PM (in response to pramod_bs)Just following up to let you know that we've posted updates to Designer 8.4 and 8.5Alpha update sites at - Download & Install - JBoss Community