Empty model;There are no tables, procedures or functions defined in this model modelName
kulbhushanc Jun 15, 2017 9:30 AMHi,
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
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
2017-06-15 10:11:48,430 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-5) TEIID40120 VDB SvcSourceVdb_TESTDSORACLE20170615101132422.1 will be removed from the repository
2017-06-15 10:11:48,430 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-5) TEIID40119 VDB SvcSourceVdb_TESTDSORACLE20170615101132422.1 removed from the repository
2017-06-15 10:11:48,430 INFO [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50026 VDB "SvcSourceVdb_TESTDSORACLE20170615101132422.1[TESTDSORACLE20170615101132422{TESTDSORACLE20170615101132422=TESTDSORACLE20170615101132422, oracle, java:/TESTDSORACLE20170615101132422}, TESTDSORACLE20170615101132422Native{TESTDSORACLE20170615101132422Native=TESTDSORACLE20170615101132422Native, oracle-native, java:/TESTDSORACLE20170615101132422}]" undeployed.
2017-06-15 10:11:48,433 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-6) TEIID40120 VDB SvcSourceVdb_TESTDSORACLE20170615101132422.1 will be removed from the repository
2017-06-15 10:11:48,447 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) WFLYSRV0028: Stopped deployment SvcSourceVdb_TESTDSORACLE20170615101132422-vdb.xml (runtime-name: SvcSourceVdb_TESTDSORACLE20170615101132422-vdb.xml) in 17ms
2017-06-15 10:11:48,458 INFO [org.jboss.as.repository] (management-handler-thread - 123) WFLYDR0002: Content removed from location /teiid-9.1.3/standalone/data/content/d2/9be062d750591e472acef006b300d732a5db93/content
2017-06-15 10:11:48,458 INFO [org.jboss.as.server] (management-handler-thread - 123) WFLYSRV0009: Undeployed "SvcSourceVdb_TESTDSORACLE20170615101132422-vdb.xml" (runtime-name: "SvcSourceVdb_TESTDSORACLE20170615101132422-vdb.xml")
Thanks,
Kulbhushan Chaskar.