1 Reply Latest reply on Jul 10, 2017 8:59 AM by Ramesh Reddy

    teiid: How to create a connection for the database which doesn't have the schema (table or view)

    Kulbhushan Chaskar Master

      Hi,

      I am using teiid admin api version 9.1.3 and jboss 10.0.0

       

      I am trying to create a connection with the database which doesn't have any table or view but it has some functions, but a teiid server throws an error :

       

      full stack trace:

       

      00:30:44,920 WARN  [org.teiid.PROCESSOR.MATVIEWS] (Worker0_async-teiid-threads0)  org.teiid.core.TeiidProcessingException: TEIID31099 VDB SvcSourceVdb_connTP.1[connTP{connTP=connTP, customtranslator, java:/DSMYSQL20170706234530983}] is not active, but FAILED.  If loading you can resubmit your query after loading has completed or after the errors have been corrected.: java.sql.SQLException: org.teiid.core.TeiidProcessingException: TEIID31099 VDB SvcSourceVdb_connTP.1[connTP{connTP=connTP, customtranslator, java:/DSMYSQL20170706234530983}] is not active, but FAILED.  If loading you can resubmit your query after loading has completed or after the errors have been corrected.

      at org.teiid.runtime.MaterializationManager.executeAsynchQuery(MaterializationManager.java:314)

      at org.teiid.runtime.MaterializationManager$2.process(MaterializationManager.java:147)

      at org.teiid.runtime.MaterializationManager.doMaterializationActions(MaterializationManager.java:195)

      at org.teiid.runtime.MaterializationManager.finishedDeployment(MaterializationManager.java:119)

      at org.teiid.deployers.VDBRepository.notifyFinished(VDBRepository.java:388)

      at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:329)

      at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:244)

      at org.teiid.jboss.VDBService.access$1100(VDBService.java:79)

      at org.teiid.jboss.VDBService$6.run(VDBService.java:381)

      at org.teiid.jboss.VDBService$7.run(VDBService.java:411)

      at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)

      at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)

      at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at java.lang.Thread.run(Unknown Source)

      Caused by: org.teiid.core.TeiidProcessingException: TEIID31099 VDB SvcSourceVdb_connTP.1[connTP{connTP=connTP, customtranslator, java:/DSMYSQL20170706234530983}] is not active, but FAILED.  If loading you can resubmit your query after loading has completed or after the errors have been corrected.

      at org.teiid.dqp.internal.process.DQPCore.checkActive(DQPCore.java:845)

      at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:250)

      at org.teiid.dqp.internal.process.DQPCore$11.call(DQPCore.java:944)

      at org.teiid.dqp.internal.process.DQPCore$11.call(DQPCore.java:938)

      at java.util.concurrent.FutureTask.run(Unknown Source)

      at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)

      at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:266)

      at org.teiid.dqp.internal.process.DQPCore.executeQuery(DQPCore.java:938)

      at org.teiid.runtime.MaterializationManager.executeAsynchQuery(MaterializationManager.java:306)

      ... 15 more

       

       

      00:30:44,921 WARN  [org.teiid.PROCESSOR.MATVIEWS] (Worker0_async-teiid-threads0)  org.teiid.core.TeiidProcessingException: TEIID31099 VDB SvcSourceVdb_connTP.1[connTP{connTP=connTP, customtranslator, java:/DSMYSQL20170706234530983}] is not active, but FAILED.  If loading you can resubmit your query after loading has completed or after the errors have been corrected.: java.sql.SQLException: org.teiid.core.TeiidProcessingException: TEIID31099 VDB SvcSourceVdb_connTP.1[connTP{connTP=connTP, customtranslator, java:/DSMYSQL20170706234530983}] is not active, but FAILED.  If loading you can resubmit your query after loading has completed or after the errors have been corrected.

      at org.teiid.runtime.MaterializationManager.executeAsynchQuery(MaterializationManager.java:314)

      at org.teiid.runtime.MaterializationManager$2.process(MaterializationManager.java:147)

      at org.teiid.runtime.MaterializationManager.doMaterializationActions(MaterializationManager.java:195)

      at org.teiid.runtime.MaterializationManager.finishedDeployment(MaterializationManager.java:119)

      at org.teiid.deployers.VDBRepository.notifyFinished(VDBRepository.java:388)

      at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:329)

      at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:244)

      at org.teiid.jboss.VDBService.access$1100(VDBService.java:79)

      at org.teiid.jboss.VDBService$6.run(VDBService.java:381)

      at org.teiid.jboss.VDBService$7.run(VDBService.java:411)

      at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)

      at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)

      at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at java.lang.Thread.run(Unknown Source)

      Caused by: org.teiid.core.TeiidProcessingException: TEIID31099 VDB SvcSourceVdb_connTP.1[connTP{connTP=connTP, customtranslator, java:/DSMYSQL20170706234530983}] is not active, but FAILED.  If loading you can resubmit your query after loading has completed or after the errors have been corrected.

      at org.teiid.dqp.internal.process.DQPCore.checkActive(DQPCore.java:845)

      at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:250)

      at org.teiid.dqp.internal.process.DQPCore$11.call(DQPCore.java:944)

      at org.teiid.dqp.internal.process.DQPCore$11.call(DQPCore.java:938)

      at java.util.concurrent.FutureTask.run(Unknown Source)

      at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)

      at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:266)

      at org.teiid.dqp.internal.process.DQPCore.executeQuery(DQPCore.java:938)

      at org.teiid.runtime.MaterializationManager.executeAsynchQuery(MaterializationManager.java:306)

      ... 15 more

       

      VDB content:

      <?xml version="1.0" ?><vdb name="SvcSourceVdb_connTP" version="1"><description>VDB for: SvcSourceVdb_connTP, Version: 1</description><connection-type>BY_VERSION</connection-type><model name="connTP" type="PHYSICAL" visible="true"></property><source name="connTP" translator-name="mysql5" connection-jndi-name="java:/DSMYSQL20170706234530983"></source></model></vdb>

       

      Where SvcSourceVdb_connTP deployment name i.e. VDB name and connTP is the model name.

       

      Can I still executes a functions using the VDB?

       

       

       

      Thanks,

      Kulbhushan Chaskar.