1 Reply Latest reply on May 5, 2014 7:41 AM by Steven Hawkins

    ClassCastException while Execute VDB for XML RESTful services

    Pramod Nair Novice

      I have a RESTful XML data source. I am able to Import and Preview 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. Help please?

       

      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]

       

      Screenshot below the COnnection works.

      i22.png

       

      When trying to retrieve Sample Data I get

      i11.png