9 Replies Latest reply on Mar 25, 2014 9:28 AM by Steven Hawkins

    Error querying a view model using multi-source source models

    skethire Newbie

      I am using Teiid 8.4

      I have two multi-source source models

      I created a view model with one table that does a join across the tables in the source models.

      When I run a query against the View table, I get the following error: 

      If I change my source models to single source, then there is a no problem.

       

      Is it not possible to build a federated view that uses multi-source source models? 

       

      Thanks in advance

      Srini

       

      18:16:44,065 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue68) TEIID30019 Unexpected exception for request 18LSw7tJq5dy.13: org.teiid.core.TeiidComponentException: TEIID30554 A single source is not assigned to model OW5000 in VDB name EDMOWMultiFederated.1
        at org.teiid.dqp.internal.process.DataTierManagerImpl.createRequest(DataTierManagerImpl.java:924) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.dqp.internal.process.DataTierManagerImpl.registerRequest(DataTierManagerImpl.java:647) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:175) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:412) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:195) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:140) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:230) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:136) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:112) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_27]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_27]
        at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_27]