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

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

kulbhushanc Jul 6, 2017 3:06 PM

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.