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

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

    Kulbhushan Chaskar Master

      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

       

       

      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.