2010-06-25 10:54:04,129 INFO [org.jboss.web.WebService] (main) Using RMI server codebase: http://pnittel.localdomain:8083/ 2010-06-25 10:54:11,112 INFO [org.jboss.wsf.stack.jbws.NativeServerConfig] (main) JBoss Web Services - Stack Native Core 2010-06-25 10:54:11,112 INFO [org.jboss.wsf.stack.jbws.NativeServerConfig] (main) 3.1.2.GA 2010-06-25 10:54:13,048 DEBUG [org.teiid.jboss.JBossLifeCycleListener] (main) Creating JBossLifeCycleListener 2010-06-25 10:54:13,048 DEBUG [org.teiid.jboss.JBossLifeCycleListener] (main) Created JBossLifeCycleListener 2010-06-25 10:54:13,048 DEBUG [org.teiid.jboss.JBossLifeCycleListener] (main) Starting JBossLifeCycleListener 2010-06-25 10:54:13,048 DEBUG [org.teiid.jboss.JBossLifeCycleListener] (main) Started JBossLifeCycleListener 2010-06-25 10:54:13,779 INFO [org.jboss.dependency.plugins.AttributeCallbackItem] (main) Owner callback not implemented. 2010-06-25 10:54:15,567 INFO [org.jboss.logbridge.LogNotificationListener] (main) Adding notification listener for logging mbean "jboss.system:service=Logging,type=Log4jService" to server org.jboss.mx.server.MBeanServerImpl@1fb050c[ defaultDomain='jboss' ] 2010-06-25 10:54:28,112 INFO [org.jboss.ejb3.deployers.Ejb3DependenciesDeployer] (main) Encountered deployment AbstractVFSDeploymentContext@18200526{vfsfile:/home/pnittel/Teiid7CR2/jboss-5.1.0.GA/server/default/deploy/profileservice-secured.jar/} 2010-06-25 10:54:28,113 INFO [org.jboss.ejb3.deployers.Ejb3DependenciesDeployer] (main) Encountered deployment AbstractVFSDeploymentContext@18200526{vfsfile:/home/pnittel/Teiid7CR2/jboss-5.1.0.GA/server/default/deploy/profileservice-secured.jar/} 2010-06-25 10:54:28,113 INFO [org.jboss.ejb3.deployers.Ejb3DependenciesDeployer] (main) Encountered deployment AbstractVFSDeploymentContext@18200526{vfsfile:/home/pnittel/Teiid7CR2/jboss-5.1.0.GA/server/default/deploy/profileservice-secured.jar/} 2010-06-25 10:54:28,113 INFO [org.jboss.ejb3.deployers.Ejb3DependenciesDeployer] (main) Encountered deployment AbstractVFSDeploymentContext@18200526{vfsfile:/home/pnittel/Teiid7CR2/jboss-5.1.0.GA/server/default/deploy/profileservice-secured.jar/} 2010-06-25 10:54:30,961 INFO [org.jboss.mx.remoting.service.JMXConnectorServerService] (main) JMX Connector server: service:jmx:rmi://pnittel.localdomain/jndi/rmi://pnittel.localdomain:1090/jmxconnector 2010-06-25 10:54:31,132 INFO [org.jboss.mail.MailService] (main) Mail Service bound to java:/Mail 2010-06-25 10:54:35,527 WARN [org.jboss.jms.server.jbosssx.JBossASSecurityMetadataStore] (main) WARNING! POTENTIAL SECURITY RISK. It has been detected that the MessageSucker component which sucks messages from one node to another has not had its password changed from the installation default. Please see the JBoss Messaging user guide for instructions on how to do this. 2010-06-25 10:54:35,541 WARN [org.jboss.annotation.factory.AnnotationCreator] (main) No ClassLoader provided, using TCCL: org.jboss.managed.api.annotation.ManagementComponent 2010-06-25 10:54:35,846 FINE [org.teiid.SECURITY] (main) Admin Security Enabled: true 2010-06-25 10:54:35,846 FINE [org.teiid.SECURITY] (main) Security Enabled: true 2010-06-25 10:54:36,579 WARN [org.jboss.annotation.factory.AnnotationCreator] (main) No ClassLoader provided, using TCCL: org.jboss.managed.api.annotation.ManagementComponent 2010-06-25 10:54:36,687 INFO [com.arjuna.ats.jbossatx.jta.TransactionManagerService] (main) JBossTS Transaction Service (JTA version - tag:JBOSSTS_4_6_1_GA) - JBoss Inc. 2010-06-25 10:54:36,687 INFO [com.arjuna.ats.jbossatx.jta.TransactionManagerService] (main) Setting up property manager MBean and JMX layer 2010-06-25 10:54:37,210 INFO [com.arjuna.ats.jbossatx.jta.TransactionManagerService] (main) Initializing recovery manager 2010-06-25 10:54:37,465 INFO [com.arjuna.ats.jbossatx.jta.TransactionManagerService] (main) Recovery manager configured 2010-06-25 10:54:37,465 INFO [com.arjuna.ats.jbossatx.jta.TransactionManagerService] (main) Binding TransactionManager JNDI Reference 2010-06-25 10:54:37,551 INFO [com.arjuna.ats.jbossatx.jta.TransactionManagerService] (main) Starting transaction recovery manager 2010-06-25 10:54:37,778 INFO [org.teiid.PROCESSOR] (main) Processor debug allowed: false 2010-06-25 10:54:39,592 DEBUG [org.teiid.TRANSPORT] (main) server = 127.0.0.1binding to port:31000 2010-06-25 10:54:39,767 DEBUG [org.teiid.TRANSPORT] (main) Bound to address 127.0.0.1 listening on port 31000 2010-06-25 10:54:39,776 INFO [org.teiid.RUNTIME] (main) Teiid JDBC = mm://pnittel.localdomain:31000 2010-06-25 10:54:39,776 DEBUG [org.teiid.TRANSPORT] (main) server = 127.0.0.1binding to port:31443 2010-06-25 10:54:39,778 DEBUG [org.teiid.TRANSPORT] (main) Bound to address 127.0.0.1 listening on port 31443 2010-06-25 10:54:39,778 INFO [org.teiid.RUNTIME] (main) Teiid Admin mm://pnittel.localdomain:31443 2010-06-25 10:54:39,784 INFO [org.teiid.RUNTIME] (main) Teiid Engine Started = Fri Jun 25 10:54:39 CDT 2010 2010-06-25 10:54:40,126 INFO [org.apache.catalina.core.AprLifecycleListener] (main) The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-1.6.0-sunjdk1.6.0_17/jre/lib/i386/server:/usr/lib/jvm/java-1.6.0-sunjdk1.6.0_17/jre/lib/i386:/usr/lib/jvm/java-1.6.0-sunjdk1.6.0_17/jre/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib 2010-06-25 10:54:40,204 INFO [org.apache.coyote.http11.Http11Protocol] (main) Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080 2010-06-25 10:54:40,208 INFO [org.apache.coyote.ajp.AjpProtocol] (main) Initializing Coyote AJP/1.3 on ajp-0.0.0.0-8009 2010-06-25 10:54:40,243 INFO [org.apache.catalina.core.StandardService] (main) Starting service jboss.web 2010-06-25 10:54:40,246 INFO [org.apache.catalina.core.StandardEngine] (main) Starting Servlet Engine: JBoss Web/2.1.3.GA 2010-06-25 10:54:40,354 INFO [org.apache.catalina.startup.Catalina] (main) Server startup in 144 ms 2010-06-25 10:54:40,377 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/web-console 2010-06-25 10:54:41,177 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/invoker 2010-06-25 10:54:41,229 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/jbossws 2010-06-25 10:54:41,315 INFO [org.jboss.resource.deployers.RARDeployment] (main) Required license terms exist, view vfszip:/home/pnittel/Teiid7CR2/jboss-5.1.0.GA/server/default/deploy/teiid/connectors/connector-file-7.0.0-SNAPSHOT.rar/META-INF/ra.xml 2010-06-25 10:54:41,333 INFO [org.jboss.resource.deployers.RARDeployment] (main) Required license terms exist, view vfszip:/home/pnittel/Teiid7CR2/jboss-5.1.0.GA/server/default/deploy/teiid/connectors/connector-ldap-7.0.0-SNAPSHOT.rar/META-INF/ra.xml 2010-06-25 10:54:41,375 INFO [org.jboss.resource.deployers.RARDeployment] (main) Required license terms exist, view vfszip:/home/pnittel/Teiid7CR2/jboss-5.1.0.GA/server/default/deploy/teiid/connectors/connector-salesforce-7.0.0-SNAPSHOT.rar/META-INF/ra.xml 2010-06-25 10:54:41,387 INFO [org.jboss.resource.deployers.RARDeployment] (main) Required license terms exist, view vfszip:/home/pnittel/Teiid7CR2/jboss-5.1.0.GA/server/default/deploy/teiid/connectors/connector-ws-7.0.0-SNAPSHOT.rar/META-INF/ra.xml 2010-06-25 10:54:41,406 INFO [org.jboss.resource.deployers.RARDeployment] (main) Required license terms exist, view vfszip:/home/pnittel/Teiid7CR2/jboss-5.1.0.GA/server/default/deploy/jboss-local-jdbc.rar/META-INF/ra.xml 2010-06-25 10:54:41,434 INFO [org.jboss.resource.deployers.RARDeployment] (main) Required license terms exist, view vfszip:/home/pnittel/Teiid7CR2/jboss-5.1.0.GA/server/default/deploy/jboss-xa-jdbc.rar/META-INF/ra.xml 2010-06-25 10:54:41,467 INFO [org.jboss.resource.deployers.RARDeployment] (main) Required license terms exist, view vfszip:/home/pnittel/Teiid7CR2/jboss-5.1.0.GA/server/default/deploy/jms-ra.rar/META-INF/ra.xml 2010-06-25 10:54:41,486 INFO [org.jboss.resource.deployers.RARDeployment] (main) Required license terms exist, view vfszip:/home/pnittel/Teiid7CR2/jboss-5.1.0.GA/server/default/deploy/mail-ra.rar/META-INF/ra.xml 2010-06-25 10:54:41,514 INFO [org.jboss.resource.deployers.RARDeployment] (main) Required license terms exist, view vfszip:/home/pnittel/Teiid7CR2/jboss-5.1.0.GA/server/default/deploy/quartz-ra.rar/META-INF/ra.xml 2010-06-25 10:54:41,619 INFO [org.quartz.simpl.SimpleThreadPool] (main) Job execution threads will use class loader of thread: main 2010-06-25 10:54:41,649 INFO [org.quartz.core.QuartzScheduler] (main) Quartz Scheduler v.1.5.2 created. 2010-06-25 10:54:41,652 INFO [org.quartz.simpl.RAMJobStore] (main) RAMJobStore initialized. 2010-06-25 10:54:41,653 INFO [org.quartz.impl.StdSchedulerFactory] (main) Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties' 2010-06-25 10:54:41,653 INFO [org.quartz.impl.StdSchedulerFactory] (main) Quartz scheduler version: 1.5.2 2010-06-25 10:54:41,653 INFO [org.quartz.core.QuartzScheduler] (main) Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started. 2010-06-25 10:54:41,803 INFO [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=7fd04942-83de-4a84-a916-de398455e491__m1_Parts_MySQL' to JNDI name 'java:7fd04942-83de-4a84-a916-de398455e491__m1_Parts_MySQL' 2010-06-25 10:54:41,841 INFO [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=7fd04942-83de-4a84-a916-de398455e491__m1_Parts_Oracle' to JNDI name 'java:7fd04942-83de-4a84-a916-de398455e491__m1_Parts_Oracle' 2010-06-25 10:54:41,911 INFO [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=9cc74d93-435a-4b64-b81b-2e1f42ee15fb__monday_Parts_MySQL' to JNDI name 'java:9cc74d93-435a-4b64-b81b-2e1f42ee15fb__monday_Parts_MySQL' 2010-06-25 10:54:42,097 INFO [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=FarceDS' to JNDI name 'java:FarceDS' 2010-06-25 10:54:42,206 INFO [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=PaulDS' to JNDI name 'java:PaulDS' 2010-06-25 10:54:42,348 INFO [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=bob' to JNDI name 'java:bob' 2010-06-25 10:54:43,103 INFO [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS' 2010-06-25 10:54:43,700 INFO [org.jboss.jms.server.ServerPeer] (main) JBoss Messaging 1.4.3.GA server [0] started 2010-06-25 10:54:43,846 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactory] (main) Connector bisocket://pnittel.localdomain:4457 has leasing enabled, lease period 10000 milliseconds 2010-06-25 10:54:43,846 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactory] (main) org.jboss.jms.server.connectionfactory.ConnectionFactory@14c6598 started 2010-06-25 10:54:43,858 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactory] (main) Connector bisocket://pnittel.localdomain:4457 has leasing enabled, lease period 10000 milliseconds 2010-06-25 10:54:43,858 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactory] (main) org.jboss.jms.server.connectionfactory.ConnectionFactory@fc9074 started 2010-06-25 10:54:43,878 INFO [org.jboss.jms.server.destination.QueueService] (main) Queue[/queue/DLQ] started, fullSize=200000, pageSize=2000, downCacheSize=2000 2010-06-25 10:54:43,880 INFO [org.jboss.jms.server.destination.QueueService] (main) Queue[/queue/ExpiryQueue] started, fullSize=200000, pageSize=2000, downCacheSize=2000 2010-06-25 10:54:43,881 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactoryJNDIMapper] (main) supportsFailover attribute is true on connection factory: jboss.messaging.connectionfactory:service=ClusteredConnectionFactory but post office is non clustered. So connection factory will *not* support failover 2010-06-25 10:54:43,881 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactoryJNDIMapper] (main) supportsLoadBalancing attribute is true on connection factory: jboss.messaging.connectionfactory:service=ClusteredConnectionFactory but post office is non clustered. So connection factory will *not* support load balancing 2010-06-25 10:54:43,883 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactory] (main) Connector bisocket://pnittel.localdomain:4457 has leasing enabled, lease period 10000 milliseconds 2010-06-25 10:54:43,883 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactory] (main) org.jboss.jms.server.connectionfactory.ConnectionFactory@a7a03b started 2010-06-25 10:54:43,995 INFO [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA' 2010-06-25 10:54:45,650 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) Created KernelDeployment for: profileservice-secured.jar 2010-06-25 10:54:45,656 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) installing bean: jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3 2010-06-25 10:54:45,656 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) with dependencies: 2010-06-25 10:54:45,656 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) and demands: 2010-06-25 10:54:45,656 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jndi:SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView 2010-06-25 10:54:45,656 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jboss.ejb:service=EJBTimerService 2010-06-25 10:54:45,656 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) and supplies: 2010-06-25 10:54:45,656 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) Class:org.jboss.profileservice.spi.ProfileService 2010-06-25 10:54:45,657 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jndi:SecureProfileService/remote 2010-06-25 10:54:45,657 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jndi:SecureProfileService/remote-org.jboss.profileservice.spi.ProfileService 2010-06-25 10:54:45,657 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) Added bean(jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3) to KernelDeployment of: profileservice-secured.jar 2010-06-25 10:54:45,658 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) installing bean: jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3 2010-06-25 10:54:45,658 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) with dependencies: 2010-06-25 10:54:45,658 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) and demands: 2010-06-25 10:54:45,658 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jboss.ejb:service=EJBTimerService 2010-06-25 10:54:45,658 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) and supplies: 2010-06-25 10:54:45,658 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jndi:SecureDeploymentManager/remote-org.jboss.deployers.spi.management.deploy.DeploymentManager 2010-06-25 10:54:45,658 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) Class:org.jboss.deployers.spi.management.deploy.DeploymentManager 2010-06-25 10:54:45,658 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jndi:SecureDeploymentManager/remote 2010-06-25 10:54:45,659 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) Added bean(jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3) to KernelDeployment of: profileservice-secured.jar 2010-06-25 10:54:45,659 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) installing bean: jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3 2010-06-25 10:54:45,659 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) with dependencies: 2010-06-25 10:54:45,659 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) and demands: 2010-06-25 10:54:45,659 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jboss.ejb:service=EJBTimerService 2010-06-25 10:54:45,659 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) and supplies: 2010-06-25 10:54:45,660 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jndi:SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView 2010-06-25 10:54:45,660 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) Class:org.jboss.deployers.spi.management.ManagementView 2010-06-25 10:54:45,660 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jndi:SecureManagementView/remote 2010-06-25 10:54:45,660 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) Added bean(jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3) to KernelDeployment of: profileservice-secured.jar 2010-06-25 10:54:45,669 INFO [org.jboss.ejb3.endpoint.deployers.EJB3EndpointDeployer] (main) Deploy AbstractBeanMetaData@5497cb{name=jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3_endpoint bean=org.jboss.ejb3.endpoint.deployers.impl.EndpointImpl properties=[container] constructor=null autowireCandidate=true} 2010-06-25 10:54:45,669 INFO [org.jboss.ejb3.endpoint.deployers.EJB3EndpointDeployer] (main) Deploy AbstractBeanMetaData@69094{name=jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3_endpoint bean=org.jboss.ejb3.endpoint.deployers.impl.EndpointImpl properties=[container] constructor=null autowireCandidate=true} 2010-06-25 10:54:45,669 INFO [org.jboss.ejb3.endpoint.deployers.EJB3EndpointDeployer] (main) Deploy AbstractBeanMetaData@1728b26{name=jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3_endpoint bean=org.jboss.ejb3.endpoint.deployers.impl.EndpointImpl properties=[container] constructor=null autowireCandidate=true} 2010-06-25 10:54:45,786 INFO [org.jboss.ejb3.session.SessionSpecContainer] (main) Starting jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3 2010-06-25 10:54:45,800 INFO [org.jboss.ejb3.EJBContainer] (main) STARTED EJB: org.jboss.profileservice.ejb.SecureDeploymentManager ejbName: SecureDeploymentManager 2010-06-25 10:54:45,854 INFO [org.jboss.ejb3.proxy.impl.jndiregistrar.JndiSessionRegistrarBase] (main) Binding the following Entries in Global JNDI: SecureDeploymentManager/remote - EJB3.x Default Remote Business Interface SecureDeploymentManager/remote-org.jboss.deployers.spi.management.deploy.DeploymentManager - EJB3.x Remote Business Interface 2010-06-25 10:54:45,923 INFO [org.jboss.ejb3.session.SessionSpecContainer] (main) Starting jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3 2010-06-25 10:54:45,924 INFO [org.jboss.ejb3.EJBContainer] (main) STARTED EJB: org.jboss.profileservice.ejb.SecureManagementView ejbName: SecureManagementView 2010-06-25 10:54:45,941 INFO [org.jboss.ejb3.proxy.impl.jndiregistrar.JndiSessionRegistrarBase] (main) Binding the following Entries in Global JNDI: SecureManagementView/remote - EJB3.x Default Remote Business Interface SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView - EJB3.x Remote Business Interface 2010-06-25 10:54:46,041 INFO [org.jboss.ejb3.session.SessionSpecContainer] (main) Starting jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3 2010-06-25 10:54:46,043 INFO [org.jboss.ejb3.EJBContainer] (main) STARTED EJB: org.jboss.profileservice.ejb.SecureProfileServiceBean ejbName: SecureProfileService 2010-06-25 10:54:46,054 INFO [org.jboss.ejb3.proxy.impl.jndiregistrar.JndiSessionRegistrarBase] (main) Binding the following Entries in Global JNDI: SecureProfileService/remote - EJB3.x Default Remote Business Interface SecureProfileService/remote-org.jboss.profileservice.spi.ProfileService - EJB3.x Remote Business Interface 2010-06-25 10:54:46,316 INFO [org.teiid.RUNTIME] (main) Teiid translator "file" has been added. 2010-06-25 10:54:47,076 INFO [org.teiid.RUNTIME] (main) Teiid translator "jdbc-simple" has been added. 2010-06-25 10:54:47,079 INFO [org.teiid.RUNTIME] (main) Teiid translator "informix" has been added. 2010-06-25 10:54:47,081 INFO [org.teiid.RUNTIME] (main) Teiid translator "db2" has been added. 2010-06-25 10:54:47,084 INFO [org.teiid.RUNTIME] (main) Teiid translator "access" has been added. 2010-06-25 10:54:47,087 INFO [org.teiid.RUNTIME] (main) Teiid translator "postgresql" has been added. 2010-06-25 10:54:47,093 INFO [org.teiid.RUNTIME] (main) Teiid translator "mysql5" has been added. 2010-06-25 10:54:47,094 INFO [org.teiid.RUNTIME] (main) Teiid translator "jdbc-ansi" has been added. 2010-06-25 10:54:47,097 INFO [org.teiid.RUNTIME] (main) Teiid translator "mysql" has been added. 2010-06-25 10:54:47,100 INFO [org.teiid.RUNTIME] (main) Teiid translator "derby" has been added. 2010-06-25 10:54:47,107 INFO [org.teiid.RUNTIME] (main) Teiid translator "modeshape" has been added. 2010-06-25 10:54:47,110 INFO [org.teiid.RUNTIME] (main) Teiid translator "sybase" has been added. 2010-06-25 10:54:47,112 INFO [org.teiid.RUNTIME] (main) Teiid translator "h2" has been added. 2010-06-25 10:54:47,115 INFO [org.teiid.RUNTIME] (main) Teiid translator "sqlserver" has been added. 2010-06-25 10:54:47,118 INFO [org.teiid.RUNTIME] (main) Teiid translator "teiid" has been added. 2010-06-25 10:54:47,120 INFO [org.teiid.RUNTIME] (main) Teiid translator "teradata" has been added. 2010-06-25 10:54:47,122 INFO [org.teiid.RUNTIME] (main) Teiid translator "hsql" has been added. 2010-06-25 10:54:47,124 INFO [org.teiid.RUNTIME] (main) Teiid translator "metamatrix" has been added. 2010-06-25 10:54:47,127 INFO [org.teiid.RUNTIME] (main) Teiid translator "oracle" has been added. 2010-06-25 10:54:47,165 INFO [org.teiid.RUNTIME] (main) Teiid translator "ldap" has been added. 2010-06-25 10:54:47,233 INFO [org.teiid.RUNTIME] (main) Teiid translator "loopback" has been added. 2010-06-25 10:54:47,270 INFO [org.teiid.RUNTIME] (main) Teiid translator "salesforce" has been added. 2010-06-25 10:54:47,319 INFO [org.teiid.RUNTIME] (main) Teiid translator "ws" has been added. 2010-06-25 10:54:47,387 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/admin-console 2010-06-25 10:54:47,459 INFO [javax.enterprise.resource.webcontainer.jsf.config] (main) Initializing Mojarra (1.2_12-b01-FCS) for context '/admin-console' 2010-06-25 10:54:49,878 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/ 2010-06-25 10:54:49,954 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/jdbc 2010-06-25 10:54:50,070 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/jmx-console 2010-06-25 10:54:50,152 DEBUG [org.teiid.CONNECTOR] (main) Started 2010-06-25 10:54:50,397 INFO [org.teiid.RUNTIME] (main) VDB "SalesFarceVDB.1[SalesforceExtensions[], bob[bob/salesforce/bob], SYS[SYS/SYS/SYS]]" deployed in active state. 2010-06-25 10:54:50,407 INFO [org.teiid.RUNTIME] (main) VDB "one.1[Parts_MySQL[Parts_MySQL/mysql/9cc74d93-435a-4b64-b81b-2e1f42ee15fb__monday_Parts_MySQL], SYS[SYS/SYS/SYS]]" deployed in active state. 2010-06-25 10:54:50,415 INFO [org.teiid.RUNTIME] (main) VDB "two.1[Parts_Oracle[Parts_Oracle/oracle/7fd04942-83de-4a84-a916-de398455e491__m1_Parts_Oracle], Parts_MySQL[Parts_MySQL/mysql/7fd04942-83de-4a84-a916-de398455e491__m1_Parts_MySQL], SYS[SYS/SYS/SYS]]" deployed in active state. 2010-06-25 10:54:50,548 INFO [org.apache.coyote.http11.Http11Protocol] (main) Starting Coyote HTTP/1.1 on http-0.0.0.0-8080 2010-06-25 10:54:50,591 INFO [org.apache.coyote.ajp.AjpProtocol] (main) Starting Coyote AJP/1.3 on ajp-0.0.0.0-8009 2010-06-25 10:54:50,613 INFO [org.jboss.bootstrap.microcontainer.ServerImpl] (main) JBoss (Microcontainer) [5.1.0.GA (build: SVNTag=JBoss_5_1_0_GA date=200905221053)] Started in 54s:665ms 2010-06-25 10:55:05,165 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=javax.crypto.SealedObject@6d18e 2010-06-25 10:55:05,194 DEBUG [org.teiid.SECURITY] (New I/O server worker #1-1) authenticateUser admin JDBC 2010-06-25 10:55:05,244 DEBUG [org.teiid.SECURITY] (New I/O server worker #1-1) Logon successful for " admin " 2010-06-25 10:55:05,251 DEBUG [org.teiid.SECURITY] (New I/O server worker #1-1) Logon successful for " admin@teiid-security " - created SessionID " cfxvONHwRHds " 2010-06-25 10:55:05,255 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) message: MessageHolder: contents=javax.crypto.SealedObject@6d3bea for request ID:0 2010-06-25 10:55:05,481 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@1326b24 2010-06-25 10:55:05,481 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before executeRequest:org.teiid.dqp.internal.process.DQPCore@1184498(0,org.teiid.client.RequestMessage@3f788b) 2010-06-25 10:55:05,545 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-1) START USER COMMAND: startTime=Jun 25, 2010 requestID=cfxvONHwRHds.0 txID=null sessionID=cfxvONHwRHds applicationName=JDBC principal=admin@teiid-security vdbName=SalesFarceVDB vdbVersion=1 sql=SELECT Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG FROM SYS.Schemas WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(Name) LIKE ? ESCAPE '\' ORDER BY TABLE_SCHEM 2010-06-25 10:55:05,548 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after executeRequest : org.teiid.client.util.ResultsFuture@10ba4ad 2010-06-25 10:55:05,554 DEBUG [org.teiid.RUNTIME] (WorkManager(2)-2_QueryProcessorQueue0) Beginning work with virtual worker WorkManager(2)-2_QueryProcessorQueue0 2010-06-25 10:55:05,568 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-2_QueryProcessorQueue0) cfxvONHwRHds.0 start processing MORE_WORK 2010-06-25 10:55:05,571 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-2_QueryProcessorQueue0) Request Thread cfxvONHwRHds.0 with state NEW 2010-06-25 10:55:05,574 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-2_QueryProcessorQueue0) cfxvONHwRHds.0 executing prepared SELECT Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG FROM SYS.Schemas WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(Name) LIKE ? ESCAPE '\' ORDER BY TABLE_SCHEM 2010-06-25 10:55:05,584 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-2_QueryProcessorQueue0) Query does not exist in cache: SELECT Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG FROM SYS.Schemas WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(Name) LIKE ? ESCAPE '\' ORDER BY TABLE_SCHEM 2010-06-25 10:55:05,717 DEBUG [org.teiid.PLANNER.RESOLVER] (WorkManager(2)-2_QueryProcessorQueue0) Resolving command SELECT Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG FROM SYS.Schemas WHERE (UCASE(VDBName) LIKE ? ESCAPE '\') AND (UCASE(Name) LIKE ? ESCAPE '\') ORDER BY TABLE_SCHEM 2010-06-25 10:55:05,990 DEBUG [org.teiid.PLANNER] (WorkManager(2)-2_QueryProcessorQueue0) ============================================================================ USER COMMAND: SELECT Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG FROM SYS.Schemas WHERE (UCASE(VDBName) LIKE ? ESCAPE '\') AND (UCASE(Name) LIKE ? ESCAPE '\') ORDER BY TABLE_SCHEM ---------------------------------------------------------------------------- OPTIMIZE: SELECT Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG FROM SYS.Schemas WHERE (UCASE(VDBName) LIKE ? ESCAPE '\') AND (UCASE(Name) LIKE ? ESCAPE '\') ORDER BY TABLE_SCHEM ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG FROM SYS.Schemas WHERE (UCASE(VDBName) LIKE ? ESCAPE '\') AND (UCASE(Name) LIKE ? ESCAPE '\') ORDER BY TABLE_SCHEM CANONICAL PLAN: Sort(groups=[SYS.Schemas], props={SORT_ORDER=ORDER BY TABLE_SCHEM}) Project(groups=[SYS.Schemas], props={PROJECT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG]}) Select(groups=[SYS.Schemas], props={SELECT_CRITERIA=UCASE(Name) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Schemas], props={SELECT_CRITERIA=UCASE(VDBName) LIKE ? ESCAPE '\'}) Source(groups=[SYS.Schemas]) ============================================================================ EXECUTING PlaceAccess AFTER: Sort(groups=[SYS.Schemas], props={SORT_ORDER=ORDER BY TABLE_SCHEM}) Project(groups=[SYS.Schemas], props={PROJECT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG]}) Select(groups=[SYS.Schemas], props={SELECT_CRITERIA=UCASE(Name) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Schemas], props={SELECT_CRITERIA=UCASE(VDBName) LIKE ? ESCAPE '\'}) Access(groups=[SYS.Schemas]) Source(groups=[SYS.Schemas]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[SYS.Schemas], props={SORT_ORDER=ORDER BY TABLE_SCHEM}) Project(groups=[SYS.Schemas], props={PROJECT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG]}) Select(groups=[SYS.Schemas], props={SELECT_CRITERIA=UCASE(VDBName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Schemas], props={SELECT_CRITERIA=UCASE(Name) LIKE ? ESCAPE '\'}) Access(groups=[SYS.Schemas], props={MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de}) Source(groups=[SYS.Schemas]) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[SYS.Schemas], props={SORT_ORDER=ORDER BY TABLE_SCHEM}) Project(groups=[SYS.Schemas], props={PROJECT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG]}) Select(groups=[SYS.Schemas], props={SELECT_CRITERIA=UCASE(VDBName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Schemas], props={SELECT_CRITERIA=UCASE(Name) LIKE ? ESCAPE '\'}) Access(groups=[SYS.Schemas], props={MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de}) Source(groups=[SYS.Schemas]) ============================================================================ EXECUTING RaiseAccess AFTER: Sort(groups=[SYS.Schemas], props={SORT_ORDER=ORDER BY TABLE_SCHEM}) Project(groups=[SYS.Schemas], props={PROJECT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG]}) Select(groups=[SYS.Schemas], props={SELECT_CRITERIA=UCASE(VDBName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Schemas], props={SELECT_CRITERIA=UCASE(Name) LIKE ? ESCAPE '\'}) Access(groups=[SYS.Schemas], props={MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de}) Source(groups=[SYS.Schemas]) ============================================================================ EXECUTING MergeCriteria AFTER: Sort(groups=[SYS.Schemas], props={SORT_ORDER=ORDER BY TABLE_SCHEM}) Project(groups=[SYS.Schemas], props={PROJECT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG]}) Select(groups=[SYS.Schemas], props={SELECT_CRITERIA=(UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\')}) Access(groups=[SYS.Schemas], props={MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de}) Source(groups=[SYS.Schemas]) ============================================================================ EXECUTING CalculateCost AFTER: Sort(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY TABLE_SCHEM}) Project(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG]}) Select(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, SELECT_CRITERIA=(UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\')}) Access(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de}) Source(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING AssignOutputElements AFTER: Sort(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY TABLE_SCHEM, OUTPUT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG]}) Project(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG], OUTPUT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG]}) Select(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[Name, VDBName], SELECT_CRITERIA=(UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\')}) Access(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de, OUTPUT_COLS=[Name, VDBName]}) Source(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[Name, VDBName]}) ============================================================================ EXECUTING PlanSorts AFTER: Sort(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY TABLE_SCHEM, OUTPUT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG]}) Project(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG], OUTPUT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG]}) Select(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[Name, VDBName], SELECT_CRITERIA=(UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\')}) Access(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de, OUTPUT_COLS=[Name, VDBName]}) Source(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[Name, VDBName]}) ============================================================================ EXECUTING CollapseSource AFTER: Sort(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY TABLE_SCHEM, OUTPUT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG]}) Project(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG], OUTPUT_COLS=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG]}) Select(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[Name, VDBName], SELECT_CRITERIA=(UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\')}) Access(groups=[SYS.Schemas], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de, ATOMIC_REQUEST=SELECT Name, VDBName FROM SYS.Schemas, OUTPUT_COLS=[Name, VDBName]}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = SortNode(1) output=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG] [SORT] [Name AS TABLE_SCHEM] ProjectNode(2) output=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG] [Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG] SelectNode(3) output=[Name, VDBName] (UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\') ProjectNode(5) output=[Name, VDBName] [Name, VDBName] AccessNode(4) output=[SYS.Schemas.VDBName, SYS.Schemas.Name, SYS.Schemas.IsPhysical, SYS.Schemas.UID, SYS.Schemas.Description, SYS.Schemas.PrimaryMetamodelURI] SELECT SYS.Schemas.Name, SYS.Schemas.VDBName FROM SYS.Schemas ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: SortNode(1) output=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG] [SORT] [Name AS TABLE_SCHEM] ProjectNode(2) output=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG] [Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG] SelectNode(3) output=[Name, VDBName] (UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\') ProjectNode(5) output=[Name, VDBName] [Name, VDBName] AccessNode(4) output=[SYS.Schemas.VDBName, SYS.Schemas.Name, SYS.Schemas.IsPhysical, SYS.Schemas.UID, SYS.Schemas.Description, SYS.Schemas.PrimaryMetamodelURI] SELECT SYS.Schemas.Name, SYS.Schemas.VDBName FROM SYS.Schemas ============================================================================ 2010-06-25 10:55:05,991 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-2_QueryProcessorQueue0) ProcessTree for cfxvONHwRHds.0 SortNode(1) output=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG] [SORT] [Name AS TABLE_SCHEM] ProjectNode(2) output=[Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG] [Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG] SelectNode(3) output=[Name, VDBName] (UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\') ProjectNode(5) output=[Name, VDBName] [Name, VDBName] AccessNode(4) output=[SYS.Schemas.VDBName, SYS.Schemas.Name, SYS.Schemas.IsPhysical, SYS.Schemas.UID, SYS.Schemas.Description, SYS.Schemas.PrimaryMetamodelURI] SELECT SYS.Schemas.Name, SYS.Schemas.VDBName FROM SYS.Schemas 2010-06-25 10:55:06,002 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-2_QueryProcessorQueue0) before getOrCreateTransactionContext:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds) 2010-06-25 10:55:06,003 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-2_QueryProcessorQueue0) after getOrCreateTransactionContext : cfxvONHwRHds NONE ID:NONE 2010-06-25 10:55:06,019 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-2_QueryProcessorQueue0) Creating TupleBuffer: 0 of type PROCESSOR 2010-06-25 10:55:06,036 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-2_QueryProcessorQueue0) Creating TupleBuffer: 1 of type PROCESSOR 2010-06-25 10:55:06,038 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-2_QueryProcessorQueue0) Removing TupleBuffer: 1 2010-06-25 10:55:06,038 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-2_QueryProcessorQueue0) QueryProcessor: closing processor 2010-06-25 10:55:06,038 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-2_QueryProcessorQueue0) [RequestWorkItem.sendResultsIfNeeded] requestID: cfxvONHwRHds.0 resultsID: 0 done: true 2010-06-25 10:55:06,040 DEBUG [org.teiid.TRANSPORT] (WorkManager(2)-2_QueryProcessorQueue0) message: MessageHolder: contents=ResultsMessage rowCount=2 finalRow=2 for request ID:1 2010-06-25 10:55:06,063 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-2_QueryProcessorQueue0) before suspend:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds NONE ID:NONE) 2010-06-25 10:55:06,063 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-2_QueryProcessorQueue0) after suspend : null 2010-06-25 10:55:06,064 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-2_QueryProcessorQueue0) cfxvONHwRHds.0 end processing WORKING 2010-06-25 10:55:06,064 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@1daa31e 2010-06-25 10:55:06,077 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before getMetadata:org.teiid.dqp.internal.process.DQPCore@1184498(0) 2010-06-25 10:55:06,086 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after getMetadata : org.teiid.client.metadata.MetadataResult@1b58992 2010-06-25 10:55:06,086 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) message: MessageHolder: contents=org.teiid.client.metadata.MetadataResult@1b58992 for request ID:2 2010-06-25 10:55:06,092 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@1f4d184 2010-06-25 10:55:06,093 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before closeRequest:org.teiid.dqp.internal.process.DQPCore@1184498(0) 2010-06-25 10:55:06,095 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) closeQuery for requestID=cfxvONHwRHds.0 2010-06-25 10:55:06,097 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-1) before cancelTransactions:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds,true) 2010-06-25 10:55:06,101 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-1) after cancelTransactions : null 2010-06-25 10:55:06,101 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) cfxvONHwRHds.0 more work IDLE 2010-06-25 10:55:06,101 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) cfxvONHwRHds.0 more work MORE_WORK 2010-06-25 10:55:06,102 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after closeRequest : org.teiid.client.util.ResultsFuture@1a055b2 2010-06-25 10:55:06,102 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) message: MessageHolder: contents=null for request ID:3 2010-06-25 10:55:06,120 DEBUG [org.teiid.RUNTIME] (WorkManager(2)-3_QueryProcessorQueue1) Beginning work with virtual worker WorkManager(2)-3_QueryProcessorQueue1 2010-06-25 10:55:06,120 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-3_QueryProcessorQueue1) cfxvONHwRHds.0 start processing MORE_WORK 2010-06-25 10:55:06,120 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-3_QueryProcessorQueue1) Request Thread cfxvONHwRHds.0 with state PROCESSING 2010-06-25 10:55:06,120 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-3_QueryProcessorQueue1) Removing tuplesource for the request cfxvONHwRHds.0 2010-06-25 10:55:06,120 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-3_QueryProcessorQueue1) Removing TupleBuffer: 0 2010-06-25 10:55:06,124 DEBUG [org.teiid.COMMAND_LOG] (WorkManager(2)-3_QueryProcessorQueue1) END USER COMMAND: endTime=Jun 25, 2010 requestID=cfxvONHwRHds.0 txID=null sessionID=cfxvONHwRHds principal=admin@teiid-security vdbName=SalesFarceVDB vdbVersion=1 finalRowCount=0 2010-06-25 10:55:06,128 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-3_QueryProcessorQueue1) before suspend:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds NONE ID:NONE) 2010-06-25 10:55:06,128 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-3_QueryProcessorQueue1) after suspend : null 2010-06-25 10:55:06,129 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-3_QueryProcessorQueue1) cfxvONHwRHds.0 end processing WORKING 2010-06-25 10:55:06,129 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-3_QueryProcessorQueue1) cfxvONHwRHds.0 done processing WORKING 2010-06-25 10:55:06,602 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@1eb1bb8 2010-06-25 10:55:06,602 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before executeRequest:org.teiid.dqp.internal.process.DQPCore@1184498(1,org.teiid.client.RequestMessage@68e7a9) 2010-06-25 10:55:06,602 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-1) START USER COMMAND: startTime=Jun 25, 2010 requestID=cfxvONHwRHds.1 txID=null sessionID=cfxvONHwRHds applicationName=JDBC principal=admin@teiid-security vdbName=SalesFarceVDB vdbVersion=1 sql=SELECT Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG FROM SYS.Schemas WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(Name) LIKE ? ESCAPE '\' ORDER BY TABLE_SCHEM 2010-06-25 10:55:06,607 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after executeRequest : org.teiid.client.util.ResultsFuture@f68d93 2010-06-25 10:55:06,623 DEBUG [org.teiid.RUNTIME] (WorkManager(2)-4_QueryProcessorQueue2) Beginning work with virtual worker WorkManager(2)-4_QueryProcessorQueue2 2010-06-25 10:55:06,624 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-4_QueryProcessorQueue2) cfxvONHwRHds.1 start processing MORE_WORK 2010-06-25 10:55:06,624 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-4_QueryProcessorQueue2) Request Thread cfxvONHwRHds.1 with state NEW 2010-06-25 10:55:06,624 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-4_QueryProcessorQueue2) cfxvONHwRHds.1 executing prepared SELECT Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG FROM SYS.Schemas WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(Name) LIKE ? ESCAPE '\' ORDER BY TABLE_SCHEM 2010-06-25 10:55:06,626 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-4_QueryProcessorQueue2) Query exist in cache: SELECT Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG FROM SYS.Schemas WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(Name) LIKE ? ESCAPE '\' ORDER BY TABLE_SCHEM 2010-06-25 10:55:06,626 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-4_QueryProcessorQueue2) before getOrCreateTransactionContext:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds) 2010-06-25 10:55:06,626 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-4_QueryProcessorQueue2) after getOrCreateTransactionContext : cfxvONHwRHds NONE ID:NONE 2010-06-25 10:55:06,626 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-4_QueryProcessorQueue2) Creating TupleBuffer: 2 of type PROCESSOR 2010-06-25 10:55:06,627 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-4_QueryProcessorQueue2) Creating TupleBuffer: 3 of type PROCESSOR 2010-06-25 10:55:06,627 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-4_QueryProcessorQueue2) Removing TupleBuffer: 3 2010-06-25 10:55:06,627 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-4_QueryProcessorQueue2) QueryProcessor: closing processor 2010-06-25 10:55:06,627 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-4_QueryProcessorQueue2) [RequestWorkItem.sendResultsIfNeeded] requestID: cfxvONHwRHds.1 resultsID: 2 done: true 2010-06-25 10:55:06,630 DEBUG [org.teiid.TRANSPORT] (WorkManager(2)-4_QueryProcessorQueue2) message: MessageHolder: contents=ResultsMessage rowCount=2 finalRow=2 for request ID:4 2010-06-25 10:55:06,631 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-4_QueryProcessorQueue2) before suspend:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds NONE ID:NONE) 2010-06-25 10:55:06,631 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-4_QueryProcessorQueue2) after suspend : null 2010-06-25 10:55:06,631 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-4_QueryProcessorQueue2) cfxvONHwRHds.1 end processing WORKING 2010-06-25 10:55:06,636 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@45a218 2010-06-25 10:55:06,636 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before getMetadata:org.teiid.dqp.internal.process.DQPCore@1184498(1) 2010-06-25 10:55:06,636 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after getMetadata : org.teiid.client.metadata.MetadataResult@194f8ac 2010-06-25 10:55:06,636 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) message: MessageHolder: contents=org.teiid.client.metadata.MetadataResult@194f8ac for request ID:5 2010-06-25 10:55:06,642 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@1f2465d 2010-06-25 10:55:06,642 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before closeRequest:org.teiid.dqp.internal.process.DQPCore@1184498(1) 2010-06-25 10:55:06,642 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) closeQuery for requestID=cfxvONHwRHds.1 2010-06-25 10:55:06,642 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-1) before cancelTransactions:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds,true) 2010-06-25 10:55:06,642 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-1) after cancelTransactions : null 2010-06-25 10:55:06,642 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) cfxvONHwRHds.1 more work IDLE 2010-06-25 10:55:06,643 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) cfxvONHwRHds.1 more work MORE_WORK 2010-06-25 10:55:06,643 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after closeRequest : org.teiid.client.util.ResultsFuture@1a055b2 2010-06-25 10:55:06,643 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) message: MessageHolder: contents=null for request ID:6 2010-06-25 10:55:06,644 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@882c28 2010-06-25 10:55:06,644 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before executeRequest:org.teiid.dqp.internal.process.DQPCore@1184498(2,org.teiid.client.RequestMessage@b2cbc) 2010-06-25 10:55:06,644 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-1) START USER COMMAND: startTime=Jun 25, 2010 requestID=cfxvONHwRHds.2 txID=null sessionID=cfxvONHwRHds applicationName=JDBC principal=admin@teiid-security vdbName=SalesFarceVDB vdbVersion=1 sql=SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION, IsPhysical AS ISPHYSICAL FROM SYS.Tables g WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(SchemaName) LIKE ? ESCAPE '\' AND UCASE(Name) LIKE ? ESCAPE '\' AND (CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' OR CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' OR CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' ) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME 2010-06-25 10:55:06,645 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after executeRequest : org.teiid.client.util.ResultsFuture@400d61 2010-06-25 10:55:06,658 DEBUG [org.teiid.RUNTIME] (WorkManager(2)-5_QueryProcessorQueue3) Beginning work with virtual worker WorkManager(2)-5_QueryProcessorQueue3 2010-06-25 10:55:06,659 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-5_QueryProcessorQueue3) cfxvONHwRHds.1 start processing MORE_WORK 2010-06-25 10:55:06,659 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-5_QueryProcessorQueue3) Request Thread cfxvONHwRHds.1 with state PROCESSING 2010-06-25 10:55:06,659 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-5_QueryProcessorQueue3) Removing tuplesource for the request cfxvONHwRHds.1 2010-06-25 10:55:06,659 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-5_QueryProcessorQueue3) Removing TupleBuffer: 2 2010-06-25 10:55:06,659 DEBUG [org.teiid.COMMAND_LOG] (WorkManager(2)-5_QueryProcessorQueue3) END USER COMMAND: endTime=Jun 25, 2010 requestID=cfxvONHwRHds.1 txID=null sessionID=cfxvONHwRHds principal=admin@teiid-security vdbName=SalesFarceVDB vdbVersion=1 finalRowCount=0 2010-06-25 10:55:06,659 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-5_QueryProcessorQueue3) before suspend:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds NONE ID:NONE) 2010-06-25 10:55:06,659 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-5_QueryProcessorQueue3) after suspend : null 2010-06-25 10:55:06,659 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-5_QueryProcessorQueue3) cfxvONHwRHds.1 end processing WORKING 2010-06-25 10:55:06,659 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-5_QueryProcessorQueue3) cfxvONHwRHds.1 done processing WORKING 2010-06-25 10:55:06,663 DEBUG [org.teiid.RUNTIME] (WorkManager(2)-6_QueryProcessorQueue4) Beginning work with virtual worker WorkManager(2)-6_QueryProcessorQueue4 2010-06-25 10:55:06,668 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-6_QueryProcessorQueue4) cfxvONHwRHds.2 start processing MORE_WORK 2010-06-25 10:55:06,668 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-6_QueryProcessorQueue4) Request Thread cfxvONHwRHds.2 with state NEW 2010-06-25 10:55:06,668 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-6_QueryProcessorQueue4) cfxvONHwRHds.2 executing prepared SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION, IsPhysical AS ISPHYSICAL FROM SYS.Tables g WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(SchemaName) LIKE ? ESCAPE '\' AND UCASE(Name) LIKE ? ESCAPE '\' AND (CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' OR CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' OR CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' ) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME 2010-06-25 10:55:06,668 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-6_QueryProcessorQueue4) Query does not exist in cache: SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION, IsPhysical AS ISPHYSICAL FROM SYS.Tables g WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(SchemaName) LIKE ? ESCAPE '\' AND UCASE(Name) LIKE ? ESCAPE '\' AND (CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' OR CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' OR CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\' ) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME 2010-06-25 10:55:06,684 DEBUG [org.teiid.PLANNER.RESOLVER] (WorkManager(2)-6_QueryProcessorQueue4) Resolving command SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = 'true') AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL FROM SYS.Tables AS g WHERE (UCASE(VDBName) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(Name) LIKE ? ESCAPE '\') AND ((CASE WHEN (IsSystem = 'true') AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = 'true') AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = 'true') AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME 2010-06-25 10:55:06,737 DEBUG [org.teiid.PLANNER] (WorkManager(2)-6_QueryProcessorQueue4) ============================================================================ USER COMMAND: SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL FROM SYS.Tables AS g WHERE (UCASE(VDBName) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(Name) LIKE ? ESCAPE '\') AND ((CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME ---------------------------------------------------------------------------- OPTIMIZE: SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL FROM SYS.Tables AS g WHERE (UCASE(VDBName) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(Name) LIKE ? ESCAPE '\') AND ((CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL FROM SYS.Tables AS g WHERE (UCASE(VDBName) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(Name) LIKE ? ESCAPE '\') AND ((CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME CANONICAL PLAN: Sort(groups=[SYS.Tables AS g], props={SORT_ORDER=ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME}) Project(groups=[SYS.Tables AS g], props={PROJECT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL]}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=(CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=UCASE(Name) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=UCASE(SchemaName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=UCASE(VDBName) LIKE ? ESCAPE '\'}) Source(groups=[SYS.Tables AS g]) ============================================================================ EXECUTING PlaceAccess AFTER: Sort(groups=[SYS.Tables AS g], props={SORT_ORDER=ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME}) Project(groups=[SYS.Tables AS g], props={PROJECT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL]}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=(CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=UCASE(Name) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=UCASE(SchemaName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=UCASE(VDBName) LIKE ? ESCAPE '\'}) Access(groups=[SYS.Tables AS g]) Source(groups=[SYS.Tables AS g]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[SYS.Tables AS g], props={SORT_ORDER=ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME}) Project(groups=[SYS.Tables AS g], props={PROJECT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL]}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=UCASE(VDBName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=UCASE(SchemaName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=UCASE(Name) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=(CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')}) Access(groups=[SYS.Tables AS g], props={MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de}) Source(groups=[SYS.Tables AS g]) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[SYS.Tables AS g], props={SORT_ORDER=ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME}) Project(groups=[SYS.Tables AS g], props={PROJECT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL]}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=UCASE(VDBName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=UCASE(SchemaName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=UCASE(Name) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=(CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')}) Access(groups=[SYS.Tables AS g], props={MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de}) Source(groups=[SYS.Tables AS g]) ============================================================================ EXECUTING RaiseAccess AFTER: Sort(groups=[SYS.Tables AS g], props={SORT_ORDER=ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME}) Project(groups=[SYS.Tables AS g], props={PROJECT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL]}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=UCASE(VDBName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=UCASE(SchemaName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=UCASE(Name) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=(CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')}) Access(groups=[SYS.Tables AS g], props={MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de}) Source(groups=[SYS.Tables AS g]) ============================================================================ EXECUTING MergeCriteria AFTER: Sort(groups=[SYS.Tables AS g], props={SORT_ORDER=ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME}) Project(groups=[SYS.Tables AS g], props={PROJECT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL]}) Select(groups=[SYS.Tables AS g], props={SELECT_CRITERIA=((CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')) AND (UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\')}) Access(groups=[SYS.Tables AS g], props={MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de}) Source(groups=[SYS.Tables AS g]) ============================================================================ EXECUTING CalculateCost AFTER: Sort(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME}) Project(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL]}) Select(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, SELECT_CRITERIA=((CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')) AND (UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\')}) Access(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de}) Source(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING AssignOutputElements AFTER: Sort(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME, OUTPUT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL]}) Project(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL], OUTPUT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL]}) Select(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[VDBName, SchemaName, Name, IsSystem, Type, Description, IsPhysical], SELECT_CRITERIA=((CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')) AND (UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\')}) Access(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de, OUTPUT_COLS=[IsSystem, Type, Name, SchemaName, VDBName, Description, IsPhysical]}) Source(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[IsSystem, Type, Name, SchemaName, VDBName, Description, IsPhysical]}) ============================================================================ EXECUTING PlanSorts AFTER: Sort(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME, OUTPUT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL]}) Project(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL], OUTPUT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL]}) Select(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[VDBName, SchemaName, Name, IsSystem, Type, Description, IsPhysical], SELECT_CRITERIA=((CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')) AND (UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\')}) Access(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de, OUTPUT_COLS=[IsSystem, Type, Name, SchemaName, VDBName, Description, IsPhysical]}) Source(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[IsSystem, Type, Name, SchemaName, VDBName, Description, IsPhysical]}) ============================================================================ EXECUTING CollapseSource AFTER: Sort(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME, OUTPUT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL]}) Project(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL], OUTPUT_COLS=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL]}) Select(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[VDBName, SchemaName, Name, IsSystem, Type, Description, IsPhysical], SELECT_CRITERIA=((CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')) AND (UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\')}) Access(groups=[SYS.Tables AS g], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de, ATOMIC_REQUEST=SELECT IsSystem, Type, Name, SchemaName, VDBName, Description, IsPhysical FROM SYS.Tables AS g, OUTPUT_COLS=[IsSystem, Type, Name, SchemaName, VDBName, Description, IsPhysical]}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = SortNode(1) output=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL] [SORT] [CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME] ProjectNode(2) output=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL] [VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL] SelectNode(3) output=[VDBName, SchemaName, Name, IsSystem, Type, Description, IsPhysical] ((CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')) AND (UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\') ProjectNode(5) output=[IsSystem, Type, Name, SchemaName, VDBName, Description, IsPhysical] [IsSystem, Type, Name, SchemaName, VDBName, Description, IsPhysical] AccessNode(4) output=[g.VDBName, g.SchemaName, g.Name, g.Type, g.NameInSource, g.IsPhysical, g.SupportsUpdates, g.UID, g.Cardinality, g.Description, g.IsSystem, g.IsMaterialized] SELECT SYS.Tables.IsSystem, SYS.Tables.Type, SYS.Tables.Name, SYS.Tables.SchemaName, SYS.Tables.VDBName, SYS.Tables.Description, SYS.Tables.IsPhysical FROM SYS.Tables ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: SortNode(1) output=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL] [SORT] [CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME] ProjectNode(2) output=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL] [VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL] SelectNode(3) output=[VDBName, SchemaName, Name, IsSystem, Type, Description, IsPhysical] ((CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')) AND (UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\') ProjectNode(5) output=[IsSystem, Type, Name, SchemaName, VDBName, Description, IsPhysical] [IsSystem, Type, Name, SchemaName, VDBName, Description, IsPhysical] AccessNode(4) output=[g.VDBName, g.SchemaName, g.Name, g.Type, g.NameInSource, g.IsPhysical, g.SupportsUpdates, g.UID, g.Cardinality, g.Description, g.IsSystem, g.IsMaterialized] SELECT SYS.Tables.IsSystem, SYS.Tables.Type, SYS.Tables.Name, SYS.Tables.SchemaName, SYS.Tables.VDBName, SYS.Tables.Description, SYS.Tables.IsPhysical FROM SYS.Tables ============================================================================ 2010-06-25 10:55:06,738 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-6_QueryProcessorQueue4) ProcessTree for cfxvONHwRHds.2 SortNode(1) output=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL] [SORT] [CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME] ProjectNode(2) output=[VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL] [VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME, CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END AS TABLE_TYPE, Description AS REMARKS, null AS TYPE_CAT, null AS TYPE_SCHEM, null AS TYPE_NAME, null AS SELF_REFERENCING_COL_NAME, null AS REF_GENERATION, IsPhysical AS ISPHYSICAL] SelectNode(3) output=[VDBName, SchemaName, Name, IsSystem, Type, Description, IsPhysical] ((CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\') OR (CASE WHEN (IsSystem = TRUE) AND (UCASE(Type) = 'TABLE') THEN 'SYSTEM TABLE' ELSE UCASE(Type) END LIKE ? ESCAPE '\')) AND (UCASE(Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\') ProjectNode(5) output=[IsSystem, Type, Name, SchemaName, VDBName, Description, IsPhysical] [IsSystem, Type, Name, SchemaName, VDBName, Description, IsPhysical] AccessNode(4) output=[g.VDBName, g.SchemaName, g.Name, g.Type, g.NameInSource, g.IsPhysical, g.SupportsUpdates, g.UID, g.Cardinality, g.Description, g.IsSystem, g.IsMaterialized] SELECT SYS.Tables.IsSystem, SYS.Tables.Type, SYS.Tables.Name, SYS.Tables.SchemaName, SYS.Tables.VDBName, SYS.Tables.Description, SYS.Tables.IsPhysical FROM SYS.Tables 2010-06-25 10:55:06,743 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-6_QueryProcessorQueue4) before getOrCreateTransactionContext:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds) 2010-06-25 10:55:06,743 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-6_QueryProcessorQueue4) after getOrCreateTransactionContext : cfxvONHwRHds NONE ID:NONE 2010-06-25 10:55:06,744 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-6_QueryProcessorQueue4) Creating TupleBuffer: 4 of type PROCESSOR 2010-06-25 10:55:06,779 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-6_QueryProcessorQueue4) Creating TupleBuffer: 5 of type PROCESSOR 2010-06-25 10:55:06,779 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-6_QueryProcessorQueue4) Creating FileStore: 5 2010-06-25 10:55:06,791 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-6_QueryProcessorQueue4) Add batch to BufferManager 1 2010-06-25 10:55:06,792 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-6_QueryProcessorQueue4) 5 getting batch 1 reference hits 0 2010-06-25 10:55:06,793 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-6_QueryProcessorQueue4) Removing TupleBuffer: 5 2010-06-25 10:55:06,793 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-6_QueryProcessorQueue4) QueryProcessor: closing processor 2010-06-25 10:55:06,793 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-6_QueryProcessorQueue4) [RequestWorkItem.sendResultsIfNeeded] requestID: cfxvONHwRHds.2 resultsID: 4 done: true 2010-06-25 10:55:06,796 DEBUG [org.teiid.TRANSPORT] (WorkManager(2)-6_QueryProcessorQueue4) message: MessageHolder: contents=ResultsMessage rowCount=100 finalRow=100 for request ID:7 2010-06-25 10:55:06,801 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-6_QueryProcessorQueue4) before suspend:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds NONE ID:NONE) 2010-06-25 10:55:06,801 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-6_QueryProcessorQueue4) after suspend : null 2010-06-25 10:55:06,801 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-6_QueryProcessorQueue4) cfxvONHwRHds.2 end processing WORKING 2010-06-25 10:55:06,806 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@be9ade 2010-06-25 10:55:06,820 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before getMetadata:org.teiid.dqp.internal.process.DQPCore@1184498(2) 2010-06-25 10:55:06,820 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after getMetadata : org.teiid.client.metadata.MetadataResult@19de054 2010-06-25 10:55:06,820 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) message: MessageHolder: contents=org.teiid.client.metadata.MetadataResult@19de054 for request ID:8 2010-06-25 10:55:06,829 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@16f4a2d 2010-06-25 10:55:06,830 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before closeRequest:org.teiid.dqp.internal.process.DQPCore@1184498(2) 2010-06-25 10:55:06,830 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) closeQuery for requestID=cfxvONHwRHds.2 2010-06-25 10:55:06,830 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-1) before cancelTransactions:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds,true) 2010-06-25 10:55:06,830 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-1) after cancelTransactions : null 2010-06-25 10:55:06,830 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) cfxvONHwRHds.2 more work IDLE 2010-06-25 10:55:06,830 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) cfxvONHwRHds.2 more work MORE_WORK 2010-06-25 10:55:06,830 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after closeRequest : org.teiid.client.util.ResultsFuture@1a055b2 2010-06-25 10:55:06,831 DEBUG [org.teiid.RUNTIME] (WorkManager(2)-7_QueryProcessorQueue5) Beginning work with virtual worker WorkManager(2)-7_QueryProcessorQueue5 2010-06-25 10:55:06,831 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) message: MessageHolder: contents=null for request ID:9 2010-06-25 10:55:06,831 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-7_QueryProcessorQueue5) cfxvONHwRHds.2 start processing MORE_WORK 2010-06-25 10:55:06,831 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-7_QueryProcessorQueue5) Request Thread cfxvONHwRHds.2 with state PROCESSING 2010-06-25 10:55:06,831 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-7_QueryProcessorQueue5) Removing tuplesource for the request cfxvONHwRHds.2 2010-06-25 10:55:06,831 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-7_QueryProcessorQueue5) Removing TupleBuffer: 4 2010-06-25 10:55:06,831 DEBUG [org.teiid.COMMAND_LOG] (WorkManager(2)-7_QueryProcessorQueue5) END USER COMMAND: endTime=Jun 25, 2010 requestID=cfxvONHwRHds.2 txID=null sessionID=cfxvONHwRHds principal=admin@teiid-security vdbName=SalesFarceVDB vdbVersion=1 finalRowCount=0 2010-06-25 10:55:06,832 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-7_QueryProcessorQueue5) before suspend:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds NONE ID:NONE) 2010-06-25 10:55:06,832 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-7_QueryProcessorQueue5) after suspend : null 2010-06-25 10:55:06,832 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-7_QueryProcessorQueue5) cfxvONHwRHds.2 end processing WORKING 2010-06-25 10:55:06,832 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-7_QueryProcessorQueue5) cfxvONHwRHds.2 done processing WORKING 2010-06-25 10:55:06,944 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@da902d 2010-06-25 10:55:06,945 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before executeRequest:org.teiid.dqp.internal.process.DQPCore@1184498(3,org.teiid.client.RequestMessage@12f8406) 2010-06-25 10:55:06,945 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-1) START USER COMMAND: startTime=Jun 25, 2010 requestID=cfxvONHwRHds.3 txID=null sessionID=cfxvONHwRHds applicationName=JDBC principal=admin@teiid-security vdbName=SalesFarceVDB vdbVersion=1 sql=SELECT Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG FROM SYS.Schemas WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(Name) LIKE ? ESCAPE '\' ORDER BY TABLE_SCHEM 2010-06-25 10:55:06,946 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after executeRequest : org.teiid.client.util.ResultsFuture@b5c72a 2010-06-25 10:55:06,952 DEBUG [org.teiid.RUNTIME] (WorkManager(2)-8_QueryProcessorQueue6) Beginning work with virtual worker WorkManager(2)-8_QueryProcessorQueue6 2010-06-25 10:55:06,960 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-8_QueryProcessorQueue6) cfxvONHwRHds.3 start processing MORE_WORK 2010-06-25 10:55:06,960 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-8_QueryProcessorQueue6) Request Thread cfxvONHwRHds.3 with state NEW 2010-06-25 10:55:06,960 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-8_QueryProcessorQueue6) cfxvONHwRHds.3 executing prepared SELECT Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG FROM SYS.Schemas WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(Name) LIKE ? ESCAPE '\' ORDER BY TABLE_SCHEM 2010-06-25 10:55:06,960 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-8_QueryProcessorQueue6) Query exist in cache: SELECT Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG FROM SYS.Schemas WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(Name) LIKE ? ESCAPE '\' ORDER BY TABLE_SCHEM 2010-06-25 10:55:06,961 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-8_QueryProcessorQueue6) before getOrCreateTransactionContext:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds) 2010-06-25 10:55:06,961 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-8_QueryProcessorQueue6) after getOrCreateTransactionContext : cfxvONHwRHds NONE ID:NONE 2010-06-25 10:55:06,961 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-8_QueryProcessorQueue6) Creating TupleBuffer: 6 of type PROCESSOR 2010-06-25 10:55:06,962 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-8_QueryProcessorQueue6) Creating TupleBuffer: 7 of type PROCESSOR 2010-06-25 10:55:06,962 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-8_QueryProcessorQueue6) Removing TupleBuffer: 7 2010-06-25 10:55:06,962 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-8_QueryProcessorQueue6) QueryProcessor: closing processor 2010-06-25 10:55:06,962 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-8_QueryProcessorQueue6) [RequestWorkItem.sendResultsIfNeeded] requestID: cfxvONHwRHds.3 resultsID: 6 done: true 2010-06-25 10:55:06,975 DEBUG [org.teiid.TRANSPORT] (WorkManager(2)-8_QueryProcessorQueue6) message: MessageHolder: contents=ResultsMessage rowCount=2 finalRow=2 for request ID:10 2010-06-25 10:55:06,975 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-8_QueryProcessorQueue6) before suspend:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds NONE ID:NONE) 2010-06-25 10:55:06,975 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-8_QueryProcessorQueue6) after suspend : null 2010-06-25 10:55:06,975 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-8_QueryProcessorQueue6) cfxvONHwRHds.3 end processing WORKING 2010-06-25 10:55:06,977 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@9d4921 2010-06-25 10:55:06,977 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before getMetadata:org.teiid.dqp.internal.process.DQPCore@1184498(3) 2010-06-25 10:55:06,978 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after getMetadata : org.teiid.client.metadata.MetadataResult@2c5157 2010-06-25 10:55:06,978 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) message: MessageHolder: contents=org.teiid.client.metadata.MetadataResult@2c5157 for request ID:11 2010-06-25 10:55:06,981 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@18fddb1 2010-06-25 10:55:06,982 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before closeRequest:org.teiid.dqp.internal.process.DQPCore@1184498(3) 2010-06-25 10:55:06,982 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) closeQuery for requestID=cfxvONHwRHds.3 2010-06-25 10:55:06,982 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-1) before cancelTransactions:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds,true) 2010-06-25 10:55:06,982 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-1) after cancelTransactions : null 2010-06-25 10:55:06,982 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) cfxvONHwRHds.3 more work IDLE 2010-06-25 10:55:06,982 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) cfxvONHwRHds.3 more work MORE_WORK 2010-06-25 10:55:06,982 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after closeRequest : org.teiid.client.util.ResultsFuture@1a055b2 2010-06-25 10:55:06,986 DEBUG [org.teiid.RUNTIME] (WorkManager(2)-9_QueryProcessorQueue7) Beginning work with virtual worker WorkManager(2)-9_QueryProcessorQueue7 2010-06-25 10:55:06,986 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) message: MessageHolder: contents=null for request ID:12 2010-06-25 10:55:06,986 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-9_QueryProcessorQueue7) cfxvONHwRHds.3 start processing MORE_WORK 2010-06-25 10:55:06,986 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-9_QueryProcessorQueue7) Request Thread cfxvONHwRHds.3 with state PROCESSING 2010-06-25 10:55:06,986 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-9_QueryProcessorQueue7) Removing tuplesource for the request cfxvONHwRHds.3 2010-06-25 10:55:06,986 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-9_QueryProcessorQueue7) Removing TupleBuffer: 6 2010-06-25 10:55:06,986 DEBUG [org.teiid.COMMAND_LOG] (WorkManager(2)-9_QueryProcessorQueue7) END USER COMMAND: endTime=Jun 25, 2010 requestID=cfxvONHwRHds.3 txID=null sessionID=cfxvONHwRHds principal=admin@teiid-security vdbName=SalesFarceVDB vdbVersion=1 finalRowCount=0 2010-06-25 10:55:06,986 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-9_QueryProcessorQueue7) before suspend:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds NONE ID:NONE) 2010-06-25 10:55:06,986 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-9_QueryProcessorQueue7) after suspend : null 2010-06-25 10:55:06,986 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-9_QueryProcessorQueue7) cfxvONHwRHds.3 end processing WORKING 2010-06-25 10:55:06,986 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-9_QueryProcessorQueue7) cfxvONHwRHds.3 done processing WORKING 2010-06-25 10:55:06,987 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@12f2320 2010-06-25 10:55:06,987 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before executeRequest:org.teiid.dqp.internal.process.DQPCore@1184498(4,org.teiid.client.RequestMessage@1ab14bd) 2010-06-25 10:55:06,987 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-1) START USER COMMAND: startTime=Jun 25, 2010 requestID=cfxvONHwRHds.4 txID=null sessionID=cfxvONHwRHds applicationName=JDBC principal=admin@teiid-security vdbName=SalesFarceVDB vdbVersion=1 sql=SELECT VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, convert(null, string) AS RESERVED_1, convert(null, string) AS RESERVED_2, convert(null, string) AS RESERVED_3, p.Description AS REMARKS, convert(decodeString(p.ReturnsResults, 'true, 2, false, 1'), short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME FROM SYS.Procedures as p WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(SchemaName) LIKE ? ESCAPE '\' AND UCASE(p.Name) LIKE ? ESCAPE '\' ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME 2010-06-25 10:55:06,988 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after executeRequest : org.teiid.client.util.ResultsFuture@20231a 2010-06-25 10:55:06,992 DEBUG [org.teiid.RUNTIME] (WorkManager(2)-10_QueryProcessorQueue8) Beginning work with virtual worker WorkManager(2)-10_QueryProcessorQueue8 2010-06-25 10:55:07,006 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-10_QueryProcessorQueue8) cfxvONHwRHds.4 start processing MORE_WORK 2010-06-25 10:55:07,006 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-10_QueryProcessorQueue8) Request Thread cfxvONHwRHds.4 with state NEW 2010-06-25 10:55:07,006 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-10_QueryProcessorQueue8) cfxvONHwRHds.4 executing prepared SELECT VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, convert(null, string) AS RESERVED_1, convert(null, string) AS RESERVED_2, convert(null, string) AS RESERVED_3, p.Description AS REMARKS, convert(decodeString(p.ReturnsResults, 'true, 2, false, 1'), short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME FROM SYS.Procedures as p WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(SchemaName) LIKE ? ESCAPE '\' AND UCASE(p.Name) LIKE ? ESCAPE '\' ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME 2010-06-25 10:55:07,006 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-10_QueryProcessorQueue8) Query does not exist in cache: SELECT VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, convert(null, string) AS RESERVED_1, convert(null, string) AS RESERVED_2, convert(null, string) AS RESERVED_3, p.Description AS REMARKS, convert(decodeString(p.ReturnsResults, 'true, 2, false, 1'), short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME FROM SYS.Procedures as p WHERE UCASE(VDBName) LIKE ? ESCAPE '\' AND UCASE(SchemaName) LIKE ? ESCAPE '\' AND UCASE(p.Name) LIKE ? ESCAPE '\' ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME 2010-06-25 10:55:07,008 DEBUG [org.teiid.PLANNER.RESOLVER] (WorkManager(2)-10_QueryProcessorQueue8) Resolving command SELECT VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, convert(null, string) AS RESERVED_1, convert(null, string) AS RESERVED_2, convert(null, string) AS RESERVED_3, p.Description AS REMARKS, convert(decodeString(p.ReturnsResults, 'true, 2, false, 1'), short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME FROM SYS.Procedures AS p WHERE (UCASE(VDBName) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(p.Name) LIKE ? ESCAPE '\') ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME 2010-06-25 10:55:07,022 DEBUG [org.teiid.PLANNER] (WorkManager(2)-10_QueryProcessorQueue8) ============================================================================ USER COMMAND: SELECT VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME FROM SYS.Procedures AS p WHERE (UCASE(VDBName) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(p.Name) LIKE ? ESCAPE '\') ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME ---------------------------------------------------------------------------- OPTIMIZE: SELECT VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME FROM SYS.Procedures AS p WHERE (UCASE(VDBName) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(p.Name) LIKE ? ESCAPE '\') ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME FROM SYS.Procedures AS p WHERE (UCASE(VDBName) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(p.Name) LIKE ? ESCAPE '\') ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME CANONICAL PLAN: Sort(groups=[SYS.Procedures AS p], props={SORT_ORDER=ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME}) Project(groups=[SYS.Procedures AS p], props={PROJECT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME]}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=UCASE(p.Name) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=UCASE(SchemaName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=UCASE(VDBName) LIKE ? ESCAPE '\'}) Source(groups=[SYS.Procedures AS p]) ============================================================================ EXECUTING PlaceAccess AFTER: Sort(groups=[SYS.Procedures AS p], props={SORT_ORDER=ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME}) Project(groups=[SYS.Procedures AS p], props={PROJECT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME]}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=UCASE(p.Name) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=UCASE(SchemaName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=UCASE(VDBName) LIKE ? ESCAPE '\'}) Access(groups=[SYS.Procedures AS p]) Source(groups=[SYS.Procedures AS p]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[SYS.Procedures AS p], props={SORT_ORDER=ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME}) Project(groups=[SYS.Procedures AS p], props={PROJECT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME]}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=UCASE(VDBName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=UCASE(SchemaName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=UCASE(p.Name) LIKE ? ESCAPE '\'}) Access(groups=[SYS.Procedures AS p], props={MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de}) Source(groups=[SYS.Procedures AS p]) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[SYS.Procedures AS p], props={SORT_ORDER=ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME}) Project(groups=[SYS.Procedures AS p], props={PROJECT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME]}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=UCASE(VDBName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=UCASE(SchemaName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=UCASE(p.Name) LIKE ? ESCAPE '\'}) Access(groups=[SYS.Procedures AS p], props={MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de}) Source(groups=[SYS.Procedures AS p]) ============================================================================ EXECUTING RaiseAccess AFTER: Sort(groups=[SYS.Procedures AS p], props={SORT_ORDER=ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME}) Project(groups=[SYS.Procedures AS p], props={PROJECT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME]}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=UCASE(VDBName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=UCASE(SchemaName) LIKE ? ESCAPE '\'}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=UCASE(p.Name) LIKE ? ESCAPE '\'}) Access(groups=[SYS.Procedures AS p], props={MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de}) Source(groups=[SYS.Procedures AS p]) ============================================================================ EXECUTING MergeCriteria AFTER: Sort(groups=[SYS.Procedures AS p], props={SORT_ORDER=ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME}) Project(groups=[SYS.Procedures AS p], props={PROJECT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME]}) Select(groups=[SYS.Procedures AS p], props={SELECT_CRITERIA=(UCASE(p.Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\')}) Access(groups=[SYS.Procedures AS p], props={MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de}) Source(groups=[SYS.Procedures AS p]) ============================================================================ EXECUTING CalculateCost AFTER: Sort(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME}) Project(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME]}) Select(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, SELECT_CRITERIA=(UCASE(p.Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\')}) Access(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de}) Source(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING AssignOutputElements AFTER: Sort(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME, OUTPUT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME]}) Project(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME], OUTPUT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME]}) Select(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[VDBName, SchemaName, p.Name, p.Description, p.ReturnsResults], SELECT_CRITERIA=(UCASE(p.Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\')}) Access(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de, OUTPUT_COLS=[p.Name, SchemaName, VDBName, p.Description, p.ReturnsResults]}) Source(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[p.Name, SchemaName, VDBName, p.Description, p.ReturnsResults]}) ============================================================================ EXECUTING PlanSorts AFTER: Sort(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME, OUTPUT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME]}) Project(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME], OUTPUT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME]}) Select(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[VDBName, SchemaName, p.Name, p.Description, p.ReturnsResults], SELECT_CRITERIA=(UCASE(p.Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\')}) Access(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de, OUTPUT_COLS=[p.Name, SchemaName, VDBName, p.Description, p.ReturnsResults]}) Source(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[p.Name, SchemaName, VDBName, p.Description, p.ReturnsResults]}) ============================================================================ EXECUTING CollapseSource AFTER: Sort(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME, OUTPUT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME]}) Project(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME], OUTPUT_COLS=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME]}) Select(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[VDBName, SchemaName, p.Name, p.Description, p.ReturnsResults], SELECT_CRITERIA=(UCASE(p.Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\')}) Access(groups=[SYS.Procedures AS p], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de, ATOMIC_REQUEST=SELECT p.Name, SchemaName, VDBName, p.Description, p.ReturnsResults FROM SYS.Procedures AS p, OUTPUT_COLS=[p.Name, SchemaName, VDBName, p.Description, p.ReturnsResults]}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = SortNode(1) output=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME] [SORT] [SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME] ProjectNode(2) output=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME] [VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME] SelectNode(3) output=[VDBName, SchemaName, p.Name, p.Description, p.ReturnsResults] (UCASE(p.Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\') ProjectNode(5) output=[p.Name, SchemaName, VDBName, p.Description, p.ReturnsResults] [p.Name, SchemaName, VDBName, p.Description, p.ReturnsResults] AccessNode(4) output=[p.VDBName, p.SchemaName, p.Name, p.NameInSource, p.ReturnsResults, p.UID, p.Description] SELECT SYS.Procedures.Name, SYS.Procedures.SchemaName, SYS.Procedures.VDBName, SYS.Procedures.Description, SYS.Procedures.ReturnsResults FROM SYS.Procedures ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: SortNode(1) output=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME] [SORT] [SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME] ProjectNode(2) output=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME] [VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME] SelectNode(3) output=[VDBName, SchemaName, p.Name, p.Description, p.ReturnsResults] (UCASE(p.Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\') ProjectNode(5) output=[p.Name, SchemaName, VDBName, p.Description, p.ReturnsResults] [p.Name, SchemaName, VDBName, p.Description, p.ReturnsResults] AccessNode(4) output=[p.VDBName, p.SchemaName, p.Name, p.NameInSource, p.ReturnsResults, p.UID, p.Description] SELECT SYS.Procedures.Name, SYS.Procedures.SchemaName, SYS.Procedures.VDBName, SYS.Procedures.Description, SYS.Procedures.ReturnsResults FROM SYS.Procedures ============================================================================ 2010-06-25 10:55:07,022 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-10_QueryProcessorQueue8) ProcessTree for cfxvONHwRHds.4 SortNode(1) output=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME] [SORT] [SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME] ProjectNode(2) output=[VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME] [VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM, p.Name AS PROCEDURE_NAME, null AS RESERVED_1, null AS RESERVED_2, null AS RESERVED_3, p.Description AS REMARKS, convert(CASE WHEN p.ReturnsResults = TRUE THEN '2' WHEN p.ReturnsResults = FALSE THEN '1' ELSE p.ReturnsResults END, short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME] SelectNode(3) output=[VDBName, SchemaName, p.Name, p.Description, p.ReturnsResults] (UCASE(p.Name) LIKE ? ESCAPE '\') AND (UCASE(SchemaName) LIKE ? ESCAPE '\') AND (UCASE(VDBName) LIKE ? ESCAPE '\') ProjectNode(5) output=[p.Name, SchemaName, VDBName, p.Description, p.ReturnsResults] [p.Name, SchemaName, VDBName, p.Description, p.ReturnsResults] AccessNode(4) output=[p.VDBName, p.SchemaName, p.Name, p.NameInSource, p.ReturnsResults, p.UID, p.Description] SELECT SYS.Procedures.Name, SYS.Procedures.SchemaName, SYS.Procedures.VDBName, SYS.Procedures.Description, SYS.Procedures.ReturnsResults FROM SYS.Procedures 2010-06-25 10:55:07,024 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-10_QueryProcessorQueue8) before getOrCreateTransactionContext:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds) 2010-06-25 10:55:07,024 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-10_QueryProcessorQueue8) after getOrCreateTransactionContext : cfxvONHwRHds NONE ID:NONE 2010-06-25 10:55:07,024 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-10_QueryProcessorQueue8) Creating TupleBuffer: 8 of type PROCESSOR 2010-06-25 10:55:07,026 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-10_QueryProcessorQueue8) Creating TupleBuffer: 9 of type PROCESSOR 2010-06-25 10:55:07,026 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-10_QueryProcessorQueue8) Removing TupleBuffer: 9 2010-06-25 10:55:07,026 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-10_QueryProcessorQueue8) QueryProcessor: closing processor 2010-06-25 10:55:07,026 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-10_QueryProcessorQueue8) [RequestWorkItem.sendResultsIfNeeded] requestID: cfxvONHwRHds.4 resultsID: 8 done: true 2010-06-25 10:55:07,029 DEBUG [org.teiid.TRANSPORT] (WorkManager(2)-10_QueryProcessorQueue8) message: MessageHolder: contents=ResultsMessage rowCount=4 finalRow=4 for request ID:13 2010-06-25 10:55:07,030 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-10_QueryProcessorQueue8) before suspend:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds NONE ID:NONE) 2010-06-25 10:55:07,030 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-10_QueryProcessorQueue8) after suspend : null 2010-06-25 10:55:07,030 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-10_QueryProcessorQueue8) cfxvONHwRHds.4 end processing WORKING 2010-06-25 10:55:07,035 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@e28774 2010-06-25 10:55:07,049 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before getMetadata:org.teiid.dqp.internal.process.DQPCore@1184498(4) 2010-06-25 10:55:07,049 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after getMetadata : org.teiid.client.metadata.MetadataResult@19a7a4a 2010-06-25 10:55:07,049 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) message: MessageHolder: contents=org.teiid.client.metadata.MetadataResult@19a7a4a for request ID:14 2010-06-25 10:55:07,056 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@12eaba4 2010-06-25 10:55:07,056 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before closeRequest:org.teiid.dqp.internal.process.DQPCore@1184498(4) 2010-06-25 10:55:07,056 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) closeQuery for requestID=cfxvONHwRHds.4 2010-06-25 10:55:07,056 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-1) before cancelTransactions:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds,true) 2010-06-25 10:55:07,056 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-1) after cancelTransactions : null 2010-06-25 10:55:07,056 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) cfxvONHwRHds.4 more work IDLE 2010-06-25 10:55:07,057 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) cfxvONHwRHds.4 more work MORE_WORK 2010-06-25 10:55:07,057 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after closeRequest : org.teiid.client.util.ResultsFuture@1a055b2 2010-06-25 10:55:07,057 DEBUG [org.teiid.RUNTIME] (WorkManager(2)-11_QueryProcessorQueue9) Beginning work with virtual worker WorkManager(2)-11_QueryProcessorQueue9 2010-06-25 10:55:07,058 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) message: MessageHolder: contents=null for request ID:15 2010-06-25 10:55:07,058 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-11_QueryProcessorQueue9) cfxvONHwRHds.4 start processing MORE_WORK 2010-06-25 10:55:07,058 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-11_QueryProcessorQueue9) Request Thread cfxvONHwRHds.4 with state PROCESSING 2010-06-25 10:55:07,058 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-11_QueryProcessorQueue9) Removing tuplesource for the request cfxvONHwRHds.4 2010-06-25 10:55:07,058 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-11_QueryProcessorQueue9) Removing TupleBuffer: 8 2010-06-25 10:55:07,058 DEBUG [org.teiid.COMMAND_LOG] (WorkManager(2)-11_QueryProcessorQueue9) END USER COMMAND: endTime=Jun 25, 2010 requestID=cfxvONHwRHds.4 txID=null sessionID=cfxvONHwRHds principal=admin@teiid-security vdbName=SalesFarceVDB vdbVersion=1 finalRowCount=0 2010-06-25 10:55:07,058 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-11_QueryProcessorQueue9) before suspend:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds NONE ID:NONE) 2010-06-25 10:55:07,058 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-11_QueryProcessorQueue9) after suspend : null 2010-06-25 10:55:07,058 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-11_QueryProcessorQueue9) cfxvONHwRHds.4 end processing WORKING 2010-06-25 10:55:07,058 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-11_QueryProcessorQueue9) cfxvONHwRHds.4 done processing WORKING 2010-06-25 10:55:19,431 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@1525c8d 2010-06-25 10:55:19,432 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) before executeRequest:org.teiid.dqp.internal.process.DQPCore@1184498(5,org.teiid.client.RequestMessage@3a37ea) 2010-06-25 10:55:19,432 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-1) START USER COMMAND: startTime=Jun 25, 2010 requestID=cfxvONHwRHds.5 txID=null sessionID=cfxvONHwRHds applicationName=JDBC principal=admin@teiid-security vdbName=SalesFarceVDB vdbVersion=1 sql=select count(*) from "bob"."salesforce.Contact" 2010-06-25 10:55:19,433 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-1) after executeRequest : org.teiid.client.util.ResultsFuture@12188b4 2010-06-25 10:55:19,434 DEBUG [org.teiid.RUNTIME] (WorkManager(2)-12_QueryProcessorQueue10) Beginning work with virtual worker WorkManager(2)-12_QueryProcessorQueue10 2010-06-25 10:55:19,434 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-12_QueryProcessorQueue10) cfxvONHwRHds.5 start processing MORE_WORK 2010-06-25 10:55:19,434 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-12_QueryProcessorQueue10) Request Thread cfxvONHwRHds.5 with state NEW 2010-06-25 10:55:19,435 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-12_QueryProcessorQueue10) cfxvONHwRHds.5 executing select count(*) from "bob"."salesforce.Contact" 2010-06-25 10:55:19,437 DEBUG [org.teiid.PLANNER.RESOLVER] (WorkManager(2)-12_QueryProcessorQueue10) Resolving command SELECT COUNT(*) FROM bob.salesforce.Contact 2010-06-25 10:55:19,447 DEBUG [org.teiid.PLANNER] (WorkManager(2)-12_QueryProcessorQueue10) ============================================================================ USER COMMAND: SELECT COUNT(*) FROM bob.salesforce.Contact ---------------------------------------------------------------------------- OPTIMIZE: SELECT COUNT(*) FROM bob.salesforce.Contact ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT COUNT(*) FROM bob.salesforce.Contact CANONICAL PLAN: Project(groups=[], props={PROJECT_COLS=[COUNT(*)]}) Group(groups=[]) Source(groups=[bob.salesforce.Contact]) ============================================================================ EXECUTING PlaceAccess AFTER: Project(groups=[], props={PROJECT_COLS=[COUNT(*)]}) Group(groups=[]) Access(groups=[bob.salesforce.Contact]) Source(groups=[bob.salesforce.Contact]) ============================================================================ EXECUTING RaiseAccess AFTER: Access(groups=[bob.salesforce.Contact], props={MODEL_ID=Schema name=bob, nameInSource=null, uuid=mmuuid:62b27a31-f4b0-48be-b37d-1f64b92c6ebe}) Project(groups=[], props={PROJECT_COLS=[COUNT(*)]}) Group(groups=[]) Source(groups=[bob.salesforce.Contact]) ============================================================================ EXECUTING PushAggregates AFTER: Access(groups=[bob.salesforce.Contact], props={MODEL_ID=Schema name=bob, nameInSource=null, uuid=mmuuid:62b27a31-f4b0-48be-b37d-1f64b92c6ebe}) Project(groups=[], props={PROJECT_COLS=[COUNT(*)]}) Group(groups=[]) Source(groups=[bob.salesforce.Contact]) ============================================================================ EXECUTING CalculateCost AFTER: Access(groups=[bob.salesforce.Contact], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=bob, nameInSource=null, uuid=mmuuid:62b27a31-f4b0-48be-b37d-1f64b92c6ebe}) Project(groups=[], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[COUNT(*)]}) Group(groups=[], props={EST_CARDINALITY=-1.0}) Source(groups=[bob.salesforce.Contact], props={EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING AssignOutputElements AFTER: Access(groups=[bob.salesforce.Contact], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=bob, nameInSource=null, uuid=mmuuid:62b27a31-f4b0-48be-b37d-1f64b92c6ebe, OUTPUT_COLS=[COUNT(*)]}) Project(groups=[], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[COUNT(*)], OUTPUT_COLS=[COUNT(*)]}) Group(groups=[], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[COUNT(*)]}) Source(groups=[bob.salesforce.Contact], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[bob.salesforce.Contact.Id_PK.Id]}) ============================================================================ EXECUTING PlanSorts AFTER: Access(groups=[bob.salesforce.Contact], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=bob, nameInSource=null, uuid=mmuuid:62b27a31-f4b0-48be-b37d-1f64b92c6ebe, OUTPUT_COLS=[COUNT(*)]}) Project(groups=[], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[COUNT(*)], OUTPUT_COLS=[COUNT(*)]}) Group(groups=[], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[COUNT(*)]}) Source(groups=[bob.salesforce.Contact], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[bob.salesforce.Contact.Id_PK.Id]}) ============================================================================ EXECUTING CollapseSource AFTER: Access(groups=[bob.salesforce.Contact], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=bob, nameInSource=null, uuid=mmuuid:62b27a31-f4b0-48be-b37d-1f64b92c6ebe, ATOMIC_REQUEST=SELECT COUNT(*) FROM bob.salesforce.Contact, OUTPUT_COLS=[COUNT(*)]}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = AccessNode(1) output=[COUNT(*)] SELECT COUNT(*) FROM bob.salesforce.Contact ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: AccessNode(1) output=[COUNT(*)] SELECT COUNT(*) FROM bob.salesforce.Contact ============================================================================ 2010-06-25 10:55:19,447 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-12_QueryProcessorQueue10) ProcessTree for cfxvONHwRHds.5 AccessNode(1) output=[COUNT(*)] SELECT COUNT(*) FROM bob.salesforce.Contact 2010-06-25 10:55:19,447 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-12_QueryProcessorQueue10) before getOrCreateTransactionContext:org.teiid.dqp.internal.transaction.TransactionServerImpl@187bd3a(cfxvONHwRHds) 2010-06-25 10:55:19,448 DEBUG [org.teiid.TXN_LOG] (WorkManager(2)-12_QueryProcessorQueue10) after getOrCreateTransactionContext : cfxvONHwRHds NONE ID:NONE 2010-06-25 10:55:19,448 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-12_QueryProcessorQueue10) Creating TupleBuffer: 10 of type PROCESSOR 2010-06-25 10:55:19,452 DEBUG [org.teiid.CONNECTOR] (WorkManager(2)-12_QueryProcessorQueue10) cfxvONHwRHds.5.1.0 Create State 2010-06-25 10:55:19,459 DEBUG [org.teiid.CONNECTOR] (WorkManager(2)-12_QueryProcessorQueue10) cfxvONHwRHds.5.1.0 Processing NEW request: SELECT COUNT(*) FROM bob.salesforce.Contact 2010-06-25 10:55:23,458 ERROR [org.jboss.remoting.transport.http.HTTPClientInvoker] (WorkManager(2)-12_QueryProcessorQueue10) Error creating SSL Socket Factory for client invoker: Error initializing socket factory SSL context: Can not find truststore url. 2010-06-25 10:55:24,842 DEBUG [org.teiid.CONNECTOR] (WorkManager(2)-12_QueryProcessorQueue10) Login was successful for username pnittel@redhat.com 2010-06-25 10:55:24,849 ERROR [org.jboss.remoting.transport.http.HTTPClientInvoker] (WorkManager(2)-12_QueryProcessorQueue10) Error creating SSL Socket Factory for client invoker: Error initializing socket factory SSL context: Can not find truststore url. 2010-06-25 10:55:25,584 DEBUG [org.teiid.CONNECTOR] (WorkManager(2)-12_QueryProcessorQueue10) cfxvONHwRHds.5.1.0 Obtained execution 2010-06-25 10:55:25,585 DEBUG [org.teiid.COMMAND_LOG] (WorkManager(2)-12_QueryProcessorQueue10) START DATA SRC COMMAND: startTime=Jun 25, 2010 requestID=cfxvONHwRHds.5 sourceCommandID=1 txID=null modelName=bob connectorBindingName=salesforce sessionID=cfxvONHwRHds principal=admin@teiid-security sql=SELECT COUNT(*) FROM bob.salesforce.Contact 2010-06-25 10:55:25,587 DEBUG [org.teiid.CONNECTOR] (WorkManager(2)-12_QueryProcessorQueue10) bob.cfxvONHwRHds.cfxvONHwRHds.5.1: Incoming Query: SELECT COUNT(*) FROM Contact 2010-06-25 10:55:25,593 DEBUG [org.teiid.CONNECTOR] (WorkManager(2)-12_QueryProcessorQueue10) bob.cfxvONHwRHds.cfxvONHwRHds.5.1: Executing Query: SELECT count() FROM Contact 2010-06-25 10:55:25,599 ERROR [org.jboss.remoting.transport.http.HTTPClientInvoker] (WorkManager(2)-12_QueryProcessorQueue10) Error creating SSL Socket Factory for client invoker: Error initializing socket factory SSL context: Can not find truststore url. 2010-06-25 10:55:25,759 DEBUG [org.teiid.CONNECTOR] (WorkManager(2)-12_QueryProcessorQueue10) cfxvONHwRHds.5.1.0 Executed command 2010-06-25 10:55:25,760 DEBUG [org.teiid.CONNECTOR] (WorkManager(2)-12_QueryProcessorQueue10) cfxvONHwRHds.5.1.0 Sending results from connector 2010-06-25 10:55:25,760 DEBUG [org.teiid.COMMAND_LOG] (WorkManager(2)-12_QueryProcessorQueue10) ERROR SRC COMMAND: endTime=Jun 25, 2010 requestID=cfxvONHwRHds.5 sourceCommandID=1 txID=null modelName=bob connectorBindingName=salesforce sessionID=cfxvONHwRHds principal=admin@teiid-security finalRowCount=null 2010-06-25 10:55:25,761 ERROR [org.teiid.CONNECTOR] (WorkManager(2)-12_QueryProcessorQueue10) Connector worker process failed for atomic-request=cfxvONHwRHds.5.1.0 java.lang.NullPointerException at org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:150) at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:314) at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.execute(ConnectorWorkItem.java:299) at org.teiid.dqp.internal.process.DataTierTupleSource.open(DataTierTupleSource.java:118) at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:82) at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:136) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:260) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:106) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:157) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:107) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:67) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:177) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.java:190) at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.java:187) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:176) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:187) at org.teiid.dqp.internal.process.StatsCapturingWorkManager$WorkWrapper.run(StatsCapturingWorkManager.java:102) at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:205) at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) 2010-06-25 10:55:25,762 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-12_QueryProcessorQueue10) [Ljava.lang.Object;@1f1192d java.lang.NullPointerException at org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:150) at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:314) at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.execute(ConnectorWorkItem.java:299) at org.teiid.dqp.internal.process.DataTierTupleSource.open(DataTierTupleSource.java:118) at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:82) at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:136) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:260) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:106) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:157) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:107) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:67) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:177) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.java:190) at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.java:187) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:176) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:187) at org.teiid.dqp.internal.process.StatsCapturingWorkManager$WorkWrapper.run(StatsCapturingWorkManager.java:102) at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:205) at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) 2010-06-25 10:55:25,762 DEBUG [org.teiid.COMMAND_LOG] (WorkManager(2)-12_QueryProcessorQueue10) CANCEL USER COMMAND: endTime=Jun 25, 2010 requestID=cfxvONHwRHds.5 txID=null sessionID=cfxvONHwRHds principal=admin@teiid-security vdbName=SalesFarceVDB vdbVersion=1 finalRowCount=null 2010-06-25 10:55:25,763 ERROR [org.teiid.PROCESSOR] (WorkManager(2)-12_QueryProcessorQueue10) Unexpected exception for request cfxvONHwRHds.5 java.lang.NullPointerException at org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:150) at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:314) at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.execute(ConnectorWorkItem.java:299) at org.teiid.dqp.internal.process.DataTierTupleSource.open(DataTierTupleSource.java:118) at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:82) at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:136) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:260) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:106) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:157) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:107) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:67) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:177) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.java:190) at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.java:187) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:176) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:187) at org.teiid.dqp.internal.process.StatsCapturingWorkManager$WorkWrapper.run(StatsCapturingWorkManager.java:102) at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:205) at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) 2010-06-25 10:55:25,764 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-12_QueryProcessorQueue10) QueryProcessor: closing processor 2010-06-25 10:55:25,764 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-12_QueryProcessorQueue10) closed atomic-request: cfxvONHwRHds.5.1.0 2010-06-25 10:55:25,764 DEBUG [org.teiid.CONNECTOR] (WorkManager(2)-12_QueryProcessorQueue10) cfxvONHwRHds.5.1.0 Processing Close : SELECT COUNT(*) FROM bob.salesforce.Contact 2010-06-25 10:55:25,772 DEBUG [org.teiid.CONNECTOR] (WorkManager(2)-12_QueryProcessorQueue10) SynchQueryExecution.close() called 2010-06-25 10:55:25,772 DEBUG [org.teiid.CONNECTOR] (WorkManager(2)-12_QueryProcessorQueue10) cfxvONHwRHds.5.1.0 Closed execution 2010-06-25 10:55:25,772 DEBUG [org.teiid.CONNECTOR] (WorkManager(2)-12_QueryProcessorQueue10) cfxvONHwRHds.5.1.0 Remove State 2010-06-25 10:55:25,772 DEBUG [org.teiid.CONNECTOR] (WorkManager(2)-12_QueryProcessorQueue10) cfxvONHwRHds.5.1.0 Closed connection 2010-06-25 10:55:25,772 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-12_QueryProcessorQueue10) Removing tuplesource for the request cfxvONHwRHds.5 2010-06-25 10:55:25,772 DEBUG [org.teiid.BUFFER_MGR] (WorkManager(2)-12_QueryProcessorQueue10) Removing TupleBuffer: 10 2010-06-25 10:55:25,772 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-12_QueryProcessorQueue10) [Ljava.lang.Object;@13fcf9d java.lang.NullPointerException at org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:150) at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:314) at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.execute(ConnectorWorkItem.java:299) at org.teiid.dqp.internal.process.DataTierTupleSource.open(DataTierTupleSource.java:118) at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:82) at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:136) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:260) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:106) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:157) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:107) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:67) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:177) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.java:190) at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.java:187) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:176) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:187) at org.teiid.dqp.internal.process.StatsCapturingWorkManager$WorkWrapper.run(StatsCapturingWorkManager.java:102) at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:205) at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) 2010-06-25 10:55:25,783 DEBUG [org.teiid.TRANSPORT] (WorkManager(2)-12_QueryProcessorQueue10) message: MessageHolder: contents=ResultsMessage rowCount=0 finalRow=-1 for request ID:16 2010-06-25 10:55:25,811 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-12_QueryProcessorQueue10) [Ljava.lang.Object;@1f2af49 java.lang.NullPointerException at org.teiid.translator.salesforce.execution.QueryExecutionImpl.next(QueryExecutionImpl.java:150) at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:314) at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.execute(ConnectorWorkItem.java:299) at org.teiid.dqp.internal.process.DataTierTupleSource.open(DataTierTupleSource.java:118) at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:82) at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:136) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:260) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:106) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:157) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:107) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:67) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:177) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.java:190) at org.teiid.dqp.internal.process.DQPWorkContext$2.call(DQPWorkContext.java:187) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:176) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:187) at org.teiid.dqp.internal.process.StatsCapturingWorkManager$WorkWrapper.run(StatsCapturingWorkManager.java:102) at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:205) at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) 2010-06-25 10:55:25,811 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-12_QueryProcessorQueue10) cfxvONHwRHds.5 end processing WORKING 2010-06-25 10:55:25,811 DEBUG [org.teiid.PROCESSOR] (WorkManager(2)-12_QueryProcessorQueue10) cfxvONHwRHds.5 done processing WORKING