1 Reply Latest reply on Jul 15, 2013 8:48 AM by Steven Hawkins

    VDB Chaining in Teiid 8.1

    Madhu Garimilla Newbie

      I have 3 vdbs(vdb1,vdb2 and vdb3) in my application. vdb1 imports vdb2 which inturn imports vdb3. Are all the views which are exposed by vdb3 should be visible in vdb1 and vdb2. Is this correct?

       

      VDB1

      {code:xml}<?xml version="1.0" encoding="UTF-8"?>

          <vdb name="vdb1" version="1">

          <import-vdb name="vdb2" version="1" import-data-policies="false"/>

              -- defined some views here--

          </vdb>{code}

       

      VDB2

      {code:xml}

          <?xml version="1.0" encoding="UTF-8"?>

          <vdb name="vdb2" version="1">

          <import-vdb name="vdb3" version="1" import-data-policies="false"/>

              -- defined some views here--

          </vdb>{code}

       

      VDB3

      {code:xml}

        <?xml version="1.0" encoding="UTF-8"?>

          <vdb name="vdb3" version="1">

              -- defined some views here--

          </vdb>{code}

       

       

      Here i am trying to connect to vdb1 and access the view/data available in vdb3. when i do a select * query against a view in vdb3, it is throwing below exception in jboss console. where as the same query works when i connect to vdb2 or vdb3. What is going wrong here? Is this way of importing vdbs correct? I am using jboss 7.1.1 and teiid 8.1

       

      Exception stacktrace:

      12:30:13,791 ERROR [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue76) TEIID30019 Unexpected exception for request tJYymmzYdTcd.0: java.lang.NullPoi

      nterException

              at org.teiid.dqp.internal.process.DataTierManagerImpl.registerRequest(DataTierManagerImpl.java:203) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

       

              at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:142) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:377) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:164) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:255) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.query.processor.relational.JoinStrategy.openLeft(JoinStrategy.java:95) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.query.processor.relational.NestedTableJoinStrategy.openLeft(NestedTableJoinStrategy.java:74) [teiid-engine-8.1.0.Final.jar:8.1.0.

      Final]

              at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:142) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:255) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:139) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:200) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:130) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:109) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:382) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:291) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) [teiid-engine-8.1.0.Final.jar:8.1.0.Fi

      nal]

              at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) [teiid-engine-8.1.0.Final.jar:8.1.0.Final]

              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_03]

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_03]

              at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_03]