4 Replies Latest reply on May 23, 2014 3:16 PM by Jhon Kehmeier

    Teiid Designer - Unable to preview data - TEIID30498 Capabilities for OracleConnection were not avaialable.  The command could not be planned properly

    Jhon Kehmeier Newbie

      Hi Folks,

       

      I could use some help.   I'm unable to preview oracle table after successfully creating JDBC connection to back end Oracle source.

       

      Windows 7 - 64 bit

      JDK 1.7.0_51

      JBoss-eap-6.1 (jboss-dv-installer-6.0.0.GA-redhat-4.jar)

      JBoss Developer Studio for Windows (jbdevstudio-product-eap-universal-7.1.1.GA-v20140314-2145-B688.jar)

         -Version: 7.1.1.GA

         -Build id: GA-v20140314-2145-B688

         -Build date: 20140314-2145

      Installed Software

         -Teiid DataTools Connectivity    8.4.1.Final-v20140508-1221-B2598    org.teiid.datatools.connectivity.feature.feature.group    JBoss by Red Hat

         -Teiid Designer    8.4.1.Final-v20140508-1221-B2598    org.teiid.designer.feature.feature.group    JBoss by Red Hat, Inc.

         -Teiid Designer Runtime    8.4.1.Final-v20140508-1221-B2598    org.teiid.designer.runtime.feature.feature.group    JBoss by Red Hat

         -Teiid Runtime Clients    8.4.1.Final-v20140508-1221-B2598    org.teiid.designer.teiid.client.feature.feature.group    JBoss by Red Hat

         -JBoss Developer Studio (Branded Product)    7.1.1.GA-v20140314-2145-B688    com.jboss.jbds.all    null

         -JCR Compact Node Definition (CND) Editor    3.6.0.Final-v20140108-1636-B144    org.jboss.tools.modeshape.jcr.feature.feature.group    JBoss by Red Hat

         -ModeShape Client    3.6.0.Final-v20140108-1636-B144    org.jboss.tools.modeshape.rest.feature.feature.group    JBoss by Red Hat

       

      Steps:

      1.) Install jboss-eap-6.1 data virtualization server

      2.) Install JBoss Developer Studio for windows

      3.) Install Teiid plugins

      4.) Associate JBoss Developer Studio with Teiid server

      5.) Create new Teiid Model Project

      6.) Start Teiid server in Developer Studio

      7.) Create JDBC Oracle Connection.  Provide Oracle connection information so that .xmi element is successfully created.

      8.) Select table object

      9.) Select 'Preview Data' icon

       

      SQL Results tab:

      select * from "OracleConnection"."ACCT_TYPE"

      TEIID30498 Capabilities for OracleConnection were not available.  The command could not be planned properly.

      Elapsed Time:  0 hr, 0 min, 0 sec, 319 ms.

       

      Stack Trace:

      12:19:20,344 WARN  [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) TEIID30020 Processing exception for request sW3xTEP7u4dh.0 'TEIID30498 Capabilities for OracleConnection were not avaialable.  The command could not be planned properly.'. Originally QueryPlannerException PlanToProcessConverter.java:324.: org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for OracleConnection were not avaialable.  The command could not be planned properly.

          at org.teiid.query.optimizer.relational.PlanToProcessConverter.convertNode(PlanToProcessConverter.java:324) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.query.optimizer.relational.PlanToProcessConverter.convertPlan(PlanToProcessConverter.java:150) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.query.optimizer.relational.PlanToProcessConverter.convert(PlanToProcessConverter.java:127) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:247) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:159) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:409) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.Request.processRequest(Request.java:436) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:600) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:309) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]

          at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]

       

      Entire Stack Trace:

      12:18:37,956 INFO  [org.jboss.modules] (main) JBoss Modules version 1.2.2.Final-redhat-1

      12:18:38,149 INFO  [org.jboss.msc] (main) JBoss MSC version 1.0.4.GA-redhat-1

      12:18:38,272 INFO  [org.jboss.as] (MSC service thread 1-8) JBAS015899: JBoss EAP 6.1.1.GA (AS 7.2.1.Final-redhat-10) starting

      12:18:39,606 INFO  [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found teiid-dashboard-builder.war in deployment directory. To trigger deployment create a file called teiid-dashboard-builder.war.dodeploy

      12:18:39,626 INFO  [org.xnio] (MSC service thread 1-2) XNIO Version 3.0.7.GA-redhat-1

      12:18:39,627 INFO  [org.jboss.as.server] (Controller Boot Thread) JBAS015888: Creating http management service using socket-binding (management-http)

      12:18:39,631 INFO  [org.xnio.nio] (MSC service thread 1-2) XNIO NIO Implementation Version 3.0.7.GA-redhat-1

      12:18:39,639 INFO  [org.jboss.remoting] (MSC service thread 1-2) JBoss Remoting version 3.2.16.GA-redhat-1

      12:18:39,735 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 31) JBAS010280: Activating Infinispan subsystem.

      12:18:39,740 INFO  [org.jboss.as.naming] (ServerService Thread Pool -- 39) JBAS011800: Activating Naming Subsystem

      12:18:39,747 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)

      12:18:39,750 INFO  [org.jboss.as.jsf] (ServerService Thread Pool -- 37) JBAS012605: Activated the following JSF Implementations: [main, 1.2]

      12:18:39,764 INFO  [org.jboss.as.security] (ServerService Thread Pool -- 44) JBAS013171: Activating Security Subsystem

      12:18:39,770 INFO  [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activating WebServices Extension

      12:18:39,774 INFO  [org.jboss.as.naming] (MSC service thread 1-4) JBAS011802: Starting Naming Service

      12:18:39,886 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-2) JBAS015400: Bound mail session [java:jboss/mail/Default]

      12:18:39,899 INFO  [org.jboss.as.security] (MSC service thread 1-7) JBAS013170: Current PicketBox version=4.0.17.SP2-redhat-2

      12:18:39,926 INFO  [org.jboss.as.connector.logging] (MSC service thread 1-2) JBAS010408: Starting JCA Subsystem (IronJacamar 1.0.19.Final-redhat-2)

      12:18:39,930 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010404: Deploying non-JDBC-compliant driver class org.teiid.jdbc.TeiidDriver (version 8.4)

      12:18:39,931 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010404: Deploying non-JDBC-compliant driver class org.teiid.jdbc.TeiidDriver (version 8.4)

      12:18:40,027 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010404: Deploying non-JDBC-compliant driver class org.modeshape.jdbc.LocalJcrDriver (version 3.3)

      12:18:40,035 INFO  [org.jboss.ws.common.management] (MSC service thread 1-1) JBWS022052: Starting JBoss Web Services - Stack CXF Server 4.1.4.Final-redhat-7

      12:18:40,468 INFO  [org.apache.coyote.http11] (MSC service thread 1-3) JBWEB003001: Coyote HTTP/1.1 initializing on : http-/0.0.0.0:8080

      12:18:40,542 INFO  [org.apache.coyote.http11] (MSC service thread 1-3) JBWEB003000: Coyote HTTP/1.1 starting on: http-/0.0.0.0:8080

      12:18:40,925 INFO  [org.teiid.SECURITY] (ServerService Thread Pool -- 51) TEIID50011 Security enabled for transport "odata" with security-domain set to teiid-security

      12:18:40,928 INFO  [org.teiid.SECURITY] (ServerService Thread Pool -- 51) TEIID50011 Security enabled for transport "jdbc" with security-domain set to teiid-security

      12:18:40,929 INFO  [org.teiid.SECURITY] (ServerService Thread Pool -- 51) TEIID50011 Security enabled for transport "odbc" with security-domain set to teiid-security

      12:18:41,033 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "jdbc-simple" added.

      12:18:41,042 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "jdbc-ansi" added.

      12:18:41,048 INFO  [org.infinispan.factories.GlobalComponentRegistry] (ServerService Thread Pool -- 52) ISPN000128: Infinispan version: Infinispan 'Delirium' 5.2.7.Final

      12:18:41,073 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "access" added.

      12:18:41,092 INFO  [org.infinispan.factories.TransactionManagerFactory] (ServerService Thread Pool -- 54) ISPN000161: Using a batchMode transaction manager

      12:18:41,136 INFO  [org.infinispan.factories.TransactionManagerFactory] (ServerService Thread Pool -- 52) ISPN000161: Using a batchMode transaction manager

      12:18:41,174 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "db2" added.

      12:18:41,238 INFO  [org.infinispan.factories.TransactionManagerFactory] (ServerService Thread Pool -- 53) ISPN000161: Using a batchMode transaction manager

      12:18:41,240 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "derby" added.

      12:18:41,275 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/file/main/./

      12:18:41,288 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-7) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/webservice/main/./

      12:18:41,296 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/file/main/./

      12:18:41,296 INFO  [org.modeshape.jcr.JcrRepository] (MSC service thread 1-3) ModeShape version 3.3.6.GA-redhat-4

      12:18:41,298 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/infinispan/main/./

      12:18:41,308 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/mongodb/main/./

      12:18:41,312 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-8) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/./

      12:18:41,313 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/ldap/main/./

      12:18:41,317 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-5) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/google/main/./

      12:18:41,326 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-6) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/webservice/main/./

      12:18:41,327 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/file/main/./

      12:18:41,329 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/file/main/./

      12:18:41,332 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-8) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/infinispan/main/./

      12:18:41,333 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/ldap/main/./

      12:18:41,334 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-4) JBAS010400: Bound data source [java:/datasources/ModeShapeDS]

      12:18:41,334 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/./

      12:18:41,340 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-5) JBAS010400: Bound data source [java:jboss/datasources/DashboardDS]

      12:18:41,341 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-5) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]

      12:18:41,341 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-5) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/mongodb/main/./

      12:18:41,352 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/file/main/./

      12:18:41,354 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/google/main/./

      12:18:41,356 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/google/main/./

      12:18:41,360 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "h2" added.

      12:18:41,414 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "hsql" added.

      12:18:41,495 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "informix" added.

      12:18:41,512 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-8) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/infinispan/main/./

      12:18:41,514 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/ldap/main/./

      12:18:41,516 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-4) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/./

      12:18:41,514 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-6) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/webservice/main/./

      12:18:41,517 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-5) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/mongodb/main/./

      12:18:41,542 INFO  [org.jboss.as.connector.deployment] (MSC service thread 1-7) JBAS010406: Registered connection factory java:/PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource

      12:18:41,546 INFO  [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020002: Deployed: file:/C:/JBoss/DataVirtualizer/jboss-eap-6.1/modules/system/layers/dv/org/jboss/teiid/resource-adapter/file/main/./

      12:18:41,551 INFO  [org.jboss.as.connector.deployment] (MSC service thread 1-4) JBAS010401: Bound JCA ConnectionFactory [java:/PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource]

      12:18:41,576 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "metamatrix" added.

      12:18:41,630 INFO  [org.infinispan.jmx.CacheJmxRegistration] (ServerService Thread Pool -- 54) ISPN000031: MBeans were successfully registered to the platform MBean server.

      12:18:41,631 INFO  [org.infinispan.jmx.CacheJmxRegistration] (ServerService Thread Pool -- 52) ISPN000031: MBeans were successfully registered to the platform MBean server.

      12:18:41,632 INFO  [org.infinispan.jmx.CacheJmxRegistration] (ServerService Thread Pool -- 53) ISPN000031: MBeans were successfully registered to the platform MBean server.

      12:18:41,634 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 52) JBAS010281: Started preparedplan cache from teiid-cache container

      12:18:41,634 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 54) JBAS010281: Started resultset cache from teiid-cache container

      12:18:41,635 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 53) JBAS010281: Started resultset-repl cache from teiid-cache container

      12:18:41,645 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "mysql" added.

      12:18:41,710 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "mysql5" added.

      12:18:41,769 INFO  [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50001 Teiid Engine 8.4.1-redhat-7 Started = Wed May 21 12:18:41 MDT 2014

      12:18:41,776 INFO  [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50038 Teiid Embedded transport enabled. Bound to: teiid/queryengine/odata

      12:18:41,776 INFO  [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50038 Teiid Embedded transport enabled. Bound to: teiid/queryengine/embedded

      12:18:41,777 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "oracle" added.

      12:18:41,862 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "postgresql" added.

      12:18:41,864 INFO  [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50012 Teiid JDBC - Name = jdbc, Host = 0.0.0.0,  Port = 31000, SSL = OFF, security-domains = [teiid-security]

      12:18:41,864 INFO  [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50037 Teiid ODBC - Name = odbc, Host = 0.0.0.0,  Port = 35432, SSL = OFF, security-domains = [teiid-security]

      12:18:42,018 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "sqlserver" added.

      12:18:42,052 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "sybase" added.

      12:18:42,087 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "teiid" added.

      12:18:42,136 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "teradata" added.

      12:18:42,149 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "modeshape" added.

      12:18:42,159 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "ingres" added.

      12:18:42,176 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "ingres93" added.

      12:18:42,189 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "intersystems-cache" added.

      12:18:42,208 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "netezza" added.

      12:18:42,214 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "file" added.

      12:18:42,219 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "ldap" added.

      12:18:42,225 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "loopback" added.

      12:18:42,232 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "olap" added.

      12:18:42,240 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "ws" added.

      12:18:42,246 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "salesforce" added.

      12:18:42,252 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "hive" added.

      12:18:42,255 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "infinispan-cache" added.

      12:18:42,259 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "map-cache" added.

      12:18:42,265 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "google-spreadsheet" added.

      12:18:42,278 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "odata" added.

      12:18:42,285 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "sap-nw-gateway" added.

      12:18:42,292 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 51) TEIID50006 Teiid translator "mongodb" added.

      12:18:42,328 INFO  [org.jboss.as.remoting] (MSC service thread 1-3) JBAS017100: Listening on 0.0.0.0:4447

      12:18:42,329 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "ojdbc14.jar" (runtime-name: "ojdbc14.jar")

      12:18:42,330 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_customerList_View.vdb" (runtime-name: "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_customerList_View.vdb")

      12:18:42,331 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015876: Starting deployment of "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_project.vdb" (runtime-name: "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_project.vdb")

      12:18:42,332 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "ModeShape.vdb" (runtime-name: "ModeShape.vdb")

      12:18:42,332 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "teiid-dashboard-builder.war" (runtime-name: "teiid-dashboard-builder.war")

      12:18:42,334 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "modeshape-webdav.war" (runtime-name: "modeshape-webdav.war")

      12:18:42,329 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "teiid-odata-8.4.1-redhat-7.war" (runtime-name: "teiid-odata-8.4.1-redhat-7.war")

      12:18:42,335 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "modeshape-rest.war" (runtime-name: "modeshape-rest.war")

      12:18:42,336 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource.vdb" (runtime-name: "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource.vdb")

      12:18:42,337 INFO  [org.jboss.as.remoting] (MSC service thread 1-4) JBAS017100: Listening on 127.0.0.1:9999

      12:18:42,338 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb")

      12:18:42,338 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4) JBAS015876: Starting deployment of "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

      12:18:42,347 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-5) JBAS015012: Started FileSystemDeploymentService for directory C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments

      12:18:43,908 INFO  [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50029 VDB ModeShape.1 model "ModeShape" metadata is currently being loaded. Start Time: 5/21/14 12:18 PM

      12:18:44,021 INFO  [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50029 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.1 model "OracleConnection" metadata is currently being loaded. Start Time: 5/21/14 12:18 PM

      12:18:44,153 INFO  [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50029 VDB PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_customerList_View.1 model "customerList_View" metadata is currently being loaded. Start Time: 5/21/14 12:18 PM

      12:18:44,353 INFO  [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50029 VDB PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource.1 model "XMLFileSource" metadata is currently being loaded. Start Time: 5/21/14 12:18 PM

      12:18:44,608 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID40003 VDB PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource.1 is set to ACTIVE

      12:18:44,649 WARN  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 3) TEIID31080 View customerList_View.customerListView validation error: QueryResolverException-TEIID30352 XMLFILESOURCE.GETTEXTFILES does not exist.->QueryMetadataException

      12:18:44,650 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40073 The metadata for the VDB PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_customerList_View.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.

      12:18:44,650 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40003 VDB PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_customerList_View.1 is set to ACTIVE

      12:18:45,026 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 2) Data Source PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection not accessible.

      12:18:45,026 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.1 is set to ACTIVE

      12:18:45,032 INFO  [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID40003 VDB PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_project.1 is set to ACTIVE

      12:18:45,037 INFO  [org.jboss.web] (ServerService Thread Pool -- 52) JBAS018210: Register web context: /modeshape-webdav

      12:18:45,070 INFO  [org.teiid.RUNTIME] (MSC service thread 1-8) Data Source PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection not accessible.

      12:18:45,071 INFO  [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID40003 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.1 is set to ACTIVE

      12:18:45,282 INFO  [org.jboss.web] (ServerService Thread Pool -- 56) JBAS018210: Register web context: /odata

      12:18:45,281 INFO  [org.jboss.web] (ServerService Thread Pool -- 53) JBAS018210: Register web context: /modeshape-rest

      12:18:45,814 INFO  [org.hibernate.validator.internal.util.Version] (ServerService Thread Pool -- 56) HV000001: Hibernate Validator 4.3.1.Final-redhat-1

      12:18:46,132 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Thread Pool -- 53) Deploying javax.ws.rs.core.Application: class org.modeshape.web.jcr.rest.JcrApplication

      12:18:46,205 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Thread Pool -- 56) Deploying javax.ws.rs.core.Application: class org.teiid.odata.TeiidODataApplication

      12:18:46,289 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40003 VDB ModeShape.1 is set to ACTIVE

      12:18:46,440 WARN  [org.jboss.as.dependency.unsupported] (MSC service thread 1-1) JBAS018568: Deployment "deployment.teiid-dashboard-builder.war" is using an unsupported module ("org.jdom:main") which may be changed or removed in future versions without notice.

      12:18:46,440 WARN  [org.jboss.as.dependency.unsupported] (MSC service thread 1-1) JBAS018568: Deployment "deployment.teiid-dashboard-builder.war" is using an unsupported module ("org.jdom:main") which may be changed or removed in future versions without notice.

      12:18:46,440 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.lang:main") which may be changed or removed in future versions without notice.

      12:18:46,441 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.lang:main") which may be changed or removed in future versions without notice.

      12:18:46,441 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.io:main") which may be changed or removed in future versions without notice.

      12:18:46,441 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.io:main") which may be changed or removed in future versions without notice.

      12:18:46,442 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.collections:main") which may be changed or removed in future versions without notice.

      12:18:46,442 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.collections:main") which may be changed or removed in future versions without notice.

      12:18:46,442 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.codec:main") which may be changed or removed in future versions without notice.

      12:18:46,442 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.apache.commons.codec:main") which may be changed or removed in future versions without notice.

      12:18:46,443 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.jboss.ironjacamar.jdbcadapters:main") which may be changed or removed in future versions without notice.

      12:18:46,443 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-1) JBAS018567: Deployment "deployment.teiid-dashboard-builder.war" is using a private module ("org.jboss.ironjacamar.jdbcadapters:main") which may be changed or removed in future versions without notice.

      12:18:46,571 INFO  [org.jboss.weld.deployer] (MSC service thread 1-2) JBAS016002: Processing weld deployment teiid-dashboard-builder.war

      12:18:46,636 INFO  [org.jboss.weld.deployer] (MSC service thread 1-6) JBAS016005: Starting Services for CDI deployment: teiid-dashboard-builder.war

      12:18:46,694 INFO  [org.jboss.weld.Version] (MSC service thread 1-6) WELD-000900 1.1.13 (redhat)

      12:18:46,726 INFO  [org.jboss.weld.deployer] (MSC service thread 1-6) JBAS016008: Starting weld service for deployment teiid-dashboard-builder.war

      12:18:48,925 INFO  [org.jboss.web] (ServerService Thread Pool -- 60) JBAS018210: Register web context: /dashboard

      12:18:48,951 INFO  [org.jboss.dashboard.ui.controller.ControllerServlet] (ServerService Thread Pool -- 60) Application Directory: C:/JBoss/DataVirtualizer/jboss-eap-6.1/standalone/deployments/teiid-dashboard-builder.war/.

      12:18:48,952 INFO  [org.jboss.dashboard.ui.controller.ControllerServlet] (ServerService Thread Pool -- 60) Application Config Directory: C:/JBoss/DataVirtualizer/jboss-eap-6.1/standalone/deployments/teiid-dashboard-builder.war/./WEB-INF/etc

      12:18:48,976 INFO  [org.jboss.dashboard.factory.Factory] (ServerService Thread Pool -- 60) Configuring Factory from directory: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\factory

      12:18:49,097 INFO  [org.jboss.dashboard.factory.Factory] (ServerService Thread Pool -- 60) Factory configured.

      12:18:49,506 INFO  [org.hibernate.annotations.common.Version] (ServerService Thread Pool -- 60) HCANN000001: Hibernate Commons Annotations {4.0.1.Final-redhat-2}

      12:18:49,512 INFO  [org.hibernate.Version] (ServerService Thread Pool -- 60) HHH000412: Hibernate Core {4.2.0.SP1-redhat-1}

      12:18:49,515 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 60) HHH000206: hibernate.properties not found

      12:18:49,517 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 60) HHH000021: Bytecode provider name : javassist

      12:18:49,539 INFO  [org.hibernate.cfg.Configuration] (ServerService Thread Pool -- 60) HHH000042: Configuring from file: hibernate.cfg.xml

      12:18:49,678 INFO  [org.hibernate.cfg.Configuration] (ServerService Thread Pool -- 60) HHH000041: Configured SessionFactory: null

      12:18:52,041 INFO  [org.jboss.dashboard.database.hibernate.HibernateInitializer] (ServerService Thread Pool -- 60) The underlying database is: h2

      12:18:52,566 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 60) HHH000400: Using dialect: org.hibernate.dialect.H2Dialect

      12:18:52,571 WARN  [org.hibernate.dialect.H2Dialect] (ServerService Thread Pool -- 60) HHH000431: Unable to determine H2 database version, certain features may not work

      12:18:52,584 INFO  [org.hibernate.engine.transaction.internal.TransactionFactoryInitiator] (ServerService Thread Pool -- 60) HHH000399: Using default transaction strategy (direct JDBC transactions)

      12:18:52,588 INFO  [org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory] (ServerService Thread Pool -- 60) HHH000397: Using ASTQueryTranslatorFactory

      12:18:53,673 INFO  [org.jboss.dashboard.cluster.ClusterNodesManager] (ServerService Thread Pool -- 60) Registering cluster node with ip address 10.128.2.252

      12:18:53,705 INFO  [org.jboss.dashboard.cluster.ClusterNodesManager] (ServerService Thread Pool -- 60) Successfuly resgister cluster node with ip address 10.128.2.252 and identifier 2312

      12:18:53,705 INFO  [org.jboss.dashboard.workspace.GraphicElementManagerImpl] (ServerService Thread Pool -- 60) Starting org.jboss.dashboard.workspace.EnvelopesManagerImpl

      12:18:53,789 INFO  [org.jboss.dashboard.ui.resources.GraphicElement] (ServerService Thread Pool -- 60) Deploying files for org.jboss.dashboard.ui.resources.Envelope Default_Envelope

      12:18:53,881 INFO  [org.jboss.dashboard.workspace.GraphicElementManagerImpl] (ServerService Thread Pool -- 60) Starting org.jboss.dashboard.workspace.LayoutsManagerImpl

      12:18:53,990 INFO  [org.jboss.dashboard.ui.resources.GraphicElement] (ServerService Thread Pool -- 60) Deploying files for org.jboss.dashboard.ui.resources.Layout Default_Layout

      12:18:53,995 INFO  [org.jboss.dashboard.ui.resources.GraphicElement] (ServerService Thread Pool -- 60) Deploying files for org.jboss.dashboard.ui.resources.Layout Default_template_with_sliding_menu

      12:18:53,999 INFO  [org.jboss.dashboard.ui.resources.GraphicElement] (ServerService Thread Pool -- 60) Deploying files for org.jboss.dashboard.ui.resources.Layout Template_25-50-25

      12:18:54,003 INFO  [org.jboss.dashboard.ui.resources.GraphicElement] (ServerService Thread Pool -- 60) Deploying files for org.jboss.dashboard.ui.resources.Layout Template_25-75

      12:18:54,007 INFO  [org.jboss.dashboard.ui.resources.GraphicElement] (ServerService Thread Pool -- 60) Deploying files for org.jboss.dashboard.ui.resources.Layout Template_75-25

      12:18:54,021 INFO  [org.jboss.dashboard.workspace.GraphicElementManagerImpl] (ServerService Thread Pool -- 60) Starting org.jboss.dashboard.workspace.SkinsManagerImpl

      12:18:54,034 INFO  [org.jboss.dashboard.ui.resources.GraphicElement] (ServerService Thread Pool -- 60) Deploying files for org.jboss.dashboard.ui.resources.Skin Default_Skin

      12:18:54,057 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Loading panels. Scanning dir: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\WEB-INF\etc\panels

      12:18:54,062 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\dashboard\dashb_filter.panel

      12:18:54,093 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\dashboard\dashb_html_editor.panel

      12:18:54,096 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\dashboard\dashb_kpi.panel

      12:18:54,100 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\dashboard\dashb_providermgr.panel

      12:18:54,103 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\breadCrumb\breadCrumb.panel

      12:18:54,107 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\logout\logout.panel

      12:18:54,110 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\navigator_language_horiz.panel

      12:18:54,114 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\navigator_sections.panel

      12:18:54,116 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\navigator_sections_horiz.panel

      12:18:54,118 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\navigator_sections_vert.panel

      12:18:54,120 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\navigator_workspace.panel

      12:18:54,121 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\navigator_workspace_horiz.panel

      12:18:54,123 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\navigator_workspace_vert.panel

      12:18:54,125 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\navigation\tree\treeMenu.panel

      12:18:54,127 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\system\dashboardExport\dashb_export.panel

      12:18:54,129 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\system\dashboardImport\dashb_import.panel

      12:18:54,133 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\system\dataSourceManagement\DataSourceManager.panel

      12:18:54,135 INFO  [org.jboss.dashboard.workspace.PanelsProvidersManagerImpl] (ServerService Thread Pool -- 60) Reading file: C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\deployments\teiid-dashboard-builder.war\.\WEB-INF\etc\panels\system\workspaceExport\workspaceImportexport.panel

      12:18:54,330 INFO  [org.jboss.dashboard.workspace.GraphicElementManagerImpl] (ServerService Thread Pool -- 60) Starting org.jboss.dashboard.workspace.ResourceGalleryManagerImpl

      12:18:54,542 INFO  [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name : "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

      12:18:54,543 INFO  [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb" (runtime-name : "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb")

      12:18:54,543 INFO  [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_project.vdb" (runtime-name : "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_project.vdb")

      12:18:54,543 INFO  [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource.vdb" (runtime-name : "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_XMLFileSource.vdb")

      12:18:54,543 INFO  [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_customerList_View.vdb" (runtime-name : "PREVIEW_08030c46-7902-4cd5-bb03-e4149847f2f0_MyXMLDataSourceProject_sources_customerList_View.vdb")

      12:18:54,543 INFO  [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "ojdbc14.jar" (runtime-name : "ojdbc14.jar")

      12:18:54,544 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 28) JBAS018559: Deployed "teiid-dashboard-builder.war" (runtime-name : "teiid-dashboard-builder.war")

      12:18:54,544 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 28) JBAS018559: Deployed "ModeShape.vdb" (runtime-name : "ModeShape.vdb")

      12:18:54,544 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 50) JBAS018559: Deployed "modeshape-webdav.war" (runtime-name : "modeshape-webdav.war")

      12:18:54,544 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 51) JBAS018559: Deployed "teiid-odata-8.4.1-redhat-7.war" (runtime-name : "teiid-odata-8.4.1-redhat-7.war")

      12:18:54,544 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 50) JBAS018559: Deployed "modeshape-rest.war" (runtime-name : "modeshape-rest.war")

      12:18:54,593 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://127.0.0.1:9990/management

      12:18:54,593 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990

      12:18:54,593 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015874: JBoss EAP 6.1.1.GA (AS 7.2.1.Final-redhat-10) started in 17027ms - Started 798 of 911 services (110 services are passive or on-demand)

      12:18:56,692 INFO  [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50026 VDB "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.1[]" undeployed.

      12:18:56,692 INFO  [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50026 VDB "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.1[OracleConnection{OracleConnection=OracleConnection, oracle, PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection}]" undeployed.

      12:18:56,701 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015877: Stopped deployment PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb (runtime-name: PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb) in 12ms

      12:18:56,739 INFO  [org.jboss.as.repository] (management-handler-thread - 3) JBAS014901: Content removed from location C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\data\content\0c\ac8244c5880d74b11257c3ef6ce84e1fbe6c7c\content

      12:18:56,739 INFO  [org.jboss.as.server] (management-handler-thread - 3) JBAS018558: Undeployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb")

      12:18:56,752 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015877: Stopped deployment PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb (runtime-name: PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb) in 8ms

      12:18:56,818 INFO  [org.jboss.as.repository] (management-handler-thread - 4) JBAS014901: Content removed from location C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\data\content\49\1aaca1c9aadbe5d138764e1ae30666b9876e9e\content

      12:18:56,818 INFO  [org.jboss.as.server] (management-handler-thread - 4) JBAS018558: Undeployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

      12:19:14,930 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015877: Stopped deployment ojdbc14.jar (runtime-name: ojdbc14.jar) in 13ms

      12:19:14,932 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "ojdbc14.jar" (runtime-name: "ojdbc14.jar")

      12:19:15,150 INFO  [org.jboss.as.server] (management-handler-thread - 2) JBAS018565: Replaced deployment "ojdbc14.jar" with deployment "ojdbc14.jar"

      12:19:16,496 INFO  [org.jboss.as.repository] (management-handler-thread - 1) JBAS014900: Content added at location C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\data\content\0f\9fce832dbf27ee0bb829054915935f35cb14ce\content

      12:19:16,497 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015876: Starting deployment of "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb")

      12:19:16,531 INFO  [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.1 model "OracleConnection" metadata is currently being loaded. Start Time: 5/21/14 12:19 PM

      12:19:16,566 INFO  [org.jboss.as.server] (management-handler-thread - 1) JBAS018559: Deployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb" (runtime-name : "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.vdb")

      12:19:16,622 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50030 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.1 model "OracleConnection" metadata loaded. End Time: 5/21/14 12:19 PM

      12:19:16,796 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 4) Data Source PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection not accessible.

      12:19:16,797 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID40003 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection.1 is set to ACTIVE

      12:19:17,124 INFO  [org.jboss.as.repository] (management-handler-thread - 4) JBAS014900: Content added at location C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\data\content\f6\ceb2ff6a18a0dd4c551e365b1bd6aa5d9ecf0e\content

      12:19:17,126 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-8) JBAS015876: Starting deployment of "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

      12:19:17,148 INFO  [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID40003 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.1 is set to ACTIVE

      12:19:17,170 INFO  [org.jboss.as.server] (management-handler-thread - 4) JBAS018559: Deployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name : "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

      12:19:17,757 INFO  [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50026 VDB "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.1[]" undeployed.

      12:19:17,761 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015877: Stopped deployment PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb (runtime-name: PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb) in 5ms

      12:19:17,776 INFO  [org.jboss.as.repository] (management-handler-thread - 3) JBAS014901: Content removed from location C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\data\content\f6\ceb2ff6a18a0dd4c551e365b1bd6aa5d9ecf0e\content

      12:19:17,776 INFO  [org.jboss.as.server] (management-handler-thread - 3) JBAS018558: Undeployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

      12:19:17,817 INFO  [org.jboss.as.repository] (management-handler-thread - 2) JBAS014900: Content added at location C:\JBoss\DataVirtualizer\jboss-eap-6.1\standalone\data\content\81\1d0c49fcb90359eb544ce68756a9fe45a34417\content

      12:19:17,818 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name: "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

      12:19:17,835 INFO  [org.teiid.RUNTIME] (MSC service thread 1-8) Data Source PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_sources_Rewards_OracleConnection not accessible.

      12:19:17,836 INFO  [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID40003 VDB PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.1 is set to ACTIVE

      12:19:17,848 INFO  [org.jboss.as.server] (management-handler-thread - 2) JBAS018559: Deployed "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb" (runtime-name : "PREVIEW_4acb84a3-e82d-450b-bf05-a72f09943b26_MyFirstProject_project.vdb")

      12:19:20,341 INFO  [org.teiid.PLANNER] (Worker0_QueryProcessorQueue0)

      ============================================================================

      USER COMMAND:

      SELECT * FROM OracleConnection.ACCT_TYPE

       

      ----------------------------------------------------------------------------

      OPTIMIZE:

      SELECT * FROM OracleConnection.ACCT_TYPE

       

      ----------------------------------------------------------------------------

      GENERATE CANONICAL:

      SELECT * FROM OracleConnection.ACCT_TYPE

       

      CANONICAL PLAN:

      Project(groups=[OracleConnection.ACCT_TYPE], props={PROJECT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3]})

        Source(groups=[OracleConnection.ACCT_TYPE])

       

       

      ============================================================================

      EXECUTING PlaceAccess

       

      AFTER:

      Project(groups=[OracleConnection.ACCT_TYPE], props={PROJECT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3]})

        Access(groups=[OracleConnection.ACCT_TYPE], props={MODEL_ID=Schema name=OracleConnection, nameInSource=null, uuid=mmuuid:bebab51c-721a-492c-86da-64fe4d61f9cc})

          Source(groups=[OracleConnection.ACCT_TYPE])

       

       

      ============================================================================

      EXECUTING RaiseAccess

       

      AFTER:

      Access(groups=[OracleConnection.ACCT_TYPE], props={MODEL_ID=Schema name=OracleConnection, nameInSource=null, uuid=mmuuid:bebab51c-721a-492c-86da-64fe4d61f9cc})

        Project(groups=[OracleConnection.ACCT_TYPE], props={PROJECT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3]})

          Source(groups=[OracleConnection.ACCT_TYPE])

       

       

      ============================================================================

      EXECUTING AssignOutputElements

       

      AFTER:

      Access(groups=[OracleConnection.ACCT_TYPE], props={MODEL_ID=Schema name=OracleConnection, nameInSource=null, uuid=mmuuid:bebab51c-721a-492c-86da-64fe4d61f9cc, OUTPUT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3]})

        Project(groups=[OracleConnection.ACCT_TYPE], props={PROJECT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3], OUTPUT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3]})

          Source(groups=[OracleConnection.ACCT_TYPE], props={OUTPUT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3]})

       

       

      ============================================================================

      EXECUTING CalculateCost

       

      AFTER:

      Access(groups=[OracleConnection.ACCT_TYPE], props={MODEL_ID=Schema name=OracleConnection, nameInSource=null, uuid=mmuuid:bebab51c-721a-492c-86da-64fe4d61f9cc, OUTPUT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3], EST_CARDINALITY=-1.0})

        Project(groups=[OracleConnection.ACCT_TYPE], props={PROJECT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3], OUTPUT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3], EST_CARDINALITY=-1.0})

          Source(groups=[OracleConnection.ACCT_TYPE], props={OUTPUT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3], EST_COL_STATS={OracleConnection.ACCT_TYPE.ACCT_TYPE_CD=[-1.0, -1.0], OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC=[-1.0, -1.0], OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1=[-1.0, -1.0], OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})

       

       

      ============================================================================

      EXECUTING PlanSorts

       

      AFTER:

      Access(groups=[OracleConnection.ACCT_TYPE])

        Project(groups=[OracleConnection.ACCT_TYPE])

          Source(groups=[OracleConnection.ACCT_TYPE])

       

       

      ============================================================================

      EXECUTING CollapseSource

       

      AFTER:

      Access(groups=[OracleConnection.ACCT_TYPE], props={MODEL_ID=Schema name=OracleConnection, nameInSource=null, uuid=mmuuid:bebab51c-721a-492c-86da-64fe4d61f9cc, OUTPUT_COLS=[OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT OracleConnection.ACCT_TYPE.ACCT_TYPE_CD, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD1, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC1, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD2, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC2, OracleConnection.ACCT_TYPE.ACCT_TYPE_CD3, OracleConnection.ACCT_TYPE.ACCT_TYPE_DESC3 FROM OracleConnection.ACCT_TYPE})

       

       

      ============================================================================

      CONVERTING PLAN TREE TO PROCESS TREE

       

      12:19:20,344 WARN  [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) TEIID30020 Processing exception for request sW3xTEP7u4dh.0 'TEIID30498 Capabilities for OracleConnection were not avaialable.  The command could not be planned properly.'. Originally QueryPlannerException PlanToProcessConverter.java:324.: org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for OracleConnection were not avaialable.  The command could not be planned properly.

          at org.teiid.query.optimizer.relational.PlanToProcessConverter.convertNode(PlanToProcessConverter.java:324) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.query.optimizer.relational.PlanToProcessConverter.convertPlan(PlanToProcessConverter.java:150) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.query.optimizer.relational.PlanToProcessConverter.convert(PlanToProcessConverter.java:127) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:247) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:159) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:409) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.Request.processRequest(Request.java:436) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:600) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:309) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-7.jar:8.4.1-redhat-7]

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]

          at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]

       

      Message was edited by: Jhon Kehmeier Added an additional step.