1 Reply Latest reply on Jun 15, 2017 2:47 PM by rareddy

Empty model;There are no tables, procedures or functions defined in this model modelName

kulbhushanc Jun 15, 2017 9:30 AM

Hi,

i am using admin-api, teiid 9.1.3 and wildfly 10.0.0.

I am facing issue while connection to ORACLE database.

I have created two user on ORACLE database . One is Admin and Other one is Non admin.

Using admin user i am able fetch schema but using non admin user i am not able to fetch schema.

For non admin user while fetching schema i am getting error as below:

ERROR:

Empty model;There are no tables, procedures or functions defined in this model TESTDSORACLE20170615101132422.

he metadata for the VDB SvcSourceVdb_TESTDSORACLE20170615101132422.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.

2017-06-15 10:11:32,979 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-1) WFLYJCA0001: Bound data source [java:/TESTDSORACLE20170615101132422]

2017-06-15 10:11:33,265 INFO [org.jboss.as.repository] (management-handler-thread - 123) WFLYDR0001: Content added at location /teiid-9.1.3/standalone/data/content/d2/9be062d750591e472acef006b300d732a5db93/content

2017-06-15 10:11:33,270 INFO [org.jboss.as.server.deployment] (MSC service thread 1-6) WFLYSRV0027: Starting deployment of "SvcSourceVdb_TESTDSORACLE20170615101132422-vdb.xml" (runtime-name: "SvcSourceVdb_TESTDSORACLE20170615101132422-vdb.xml")

2017-06-15 10:11:33,287 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-5) TEIID40118 VDB SvcSourceVdb_TESTDSORACLE20170615101132422.1 added to the repository

2017-06-15 10:11:33,287 INFO [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50029 VDB SvcSourceVdb_TESTDSORACLE20170615101132422.1 model "TESTDSORACLE20170615101132422" metadata is currently being loaded. Start Time: 6/15/17 10:11 AM

2017-06-15 10:11:33,287 INFO [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50029 VDB SvcSourceVdb_TESTDSORACLE20170615101132422.1 model "TESTDSORACLE20170615101132422Native" metadata is currently being loaded. Start Time: 6/15/17 10:11 AM

2017-06-15 10:11:33,298 INFO [org.jboss.as.server] (management-handler-thread - 123) WFLYSRV0010: Deployed "SvcSourceVdb_TESTDSORACLE20170615101132422-vdb.xml" (runtime-name : "SvcSourceVdb_TESTDSORACLE20170615101132422-vdb.xml")

2017-06-15 10:11:33,512 INFO [org.teiid.CONNECTOR] (Worker27_async-teiid-threads44) OracleExecutionFactory Commit=true;DatabaseProductName=Oracle;DatabaseProductVersion=Oracle Database 11g Release 11.2.0.1.0 - Production;DriverMajorVersion=11;DriverMajorVersion=1;DriverName=Oracle JDBC driver;DriverVersion=11.1.0.7.0-Production;IsolationLevel=2

2017-06-15 10:11:33,544 INFO [org.teiid.CONNECTOR] (Worker26_async-teiid-threads43) OracleExecutionFactory Commit=true;DatabaseProductName=Oracle;DatabaseProductVersion=Oracle Database 11g Release 11.2.0.1.0 - Production;DriverMajorVersion=11;DriverMajorVersion=1;DriverName=Oracle JDBC driver;DriverVersion=11.1.0.7.0-Production;IsolationLevel=2

2017-06-15 10:11:33,630 INFO [org.teiid.RUNTIME] (Worker27_async-teiid-threads44) TEIID50030 VDB SvcSourceVdb_TESTDSORACLE20170615101132422.1 model "TESTDSORACLE20170615101132422Native" metadata loaded. End Time: 6/15/17 10:11 AM

2017-06-15 10:11:33,638 INFO [org.teiid.RUNTIME] (Worker26_async-teiid-threads43) TEIID50030 VDB SvcSourceVdb_TESTDSORACLE20170615101132422.1 model "TESTDSORACLE20170615101132422" metadata loaded. End Time: 6/15/17 10:11 AM

2017-06-15 10:11:33,640 WARN [org.teiid.PLANNER.RESOLVER] (Worker26_async-teiid-threads43) TEIID31070 Empty model;There are no tables, procedures or functions defined in this model TESTDSORACLE20170615101132422

2017-06-15 10:11:33,640 INFO [org.teiid.RUNTIME] (Worker26_async-teiid-threads43) TEIID40073 The metadata for the VDB SvcSourceVdb_TESTDSORACLE20170615101132422.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.

2017-06-15 10:11:33,640 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (Worker26_async-teiid-threads43) TEIID40003 VDB SvcSourceVdb_TESTDSORACLE20170615101132422.1 is set to FAILED

2017-06-15 10:11:33,641 WARN [org.teiid.PROCESSOR.MATVIEWS] (Worker26_async-teiid-threads43) org.teiid.core.TeiidProcessingException: TEIID31099 VDB SvcSourceVdb_TESTDSORACLE20170615101132422.1[TESTDSORACLE20170615101132422{TESTDSORACLE20170615101132422=TESTDSORACLE20170615101132422, oracle, java:/TESTDSORACLE20170615101132422}, TESTDSORACLE20170615101132422Native{TESTDSORACLE20170615101132422Native=TESTDSORACLE20170615101132422Native, oracle-native, java:/TESTDSORACLE20170615101132422}] 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_TESTDSORACLE20170615101132422.1[TESTDSORACLE20170615101132422{TESTDSORACLE20170615101132422=TESTDSORACLE20170615101132422, oracle, java:/TESTDSORACLE20170615101132422}, TESTDSORACLE20170615101132422Native{TESTDSORACLE20170615101132422Native=TESTDSORACLE20170615101132422Native, oracle-native, java:/TESTDSORACLE20170615101132422}] 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(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745)

Caused by: org.teiid.core.TeiidProcessingException: TEIID31099 VDB SvcSourceVdb_TESTDSORACLE20170615101132422.1[TESTDSORACLE20170615101132422{TESTDSORACLE20170615101132422=TESTDSORACLE20170615101132422, oracle, java:/TESTDSORACLE20170615101132422}, TESTDSORACLE20170615101132422Native{TESTDSORACLE20170615101132422Native=TESTDSORACLE20170615101132422Native, oracle-native, java:/TESTDSORACLE20170615101132422}] 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(FutureTask.java:266)

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