Teiid Designer - Unable to preview data - TEIID30498 Capabilities for OracleConnection were not avaialable. The command could not be planned properly
jmk33392 May 21, 2014 2:57 PMHi 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.