1 2 Previous Next 20 Replies Latest reply on Sep 27, 2017 8:33 AM by shawkins

Not able to run query

vijayjose Sep 19, 2017 8:26 AM

I am using JBDS 10.4 with WildFly 10,Teiid Designer 10. Successfully made a VDB by following the link: https://developer.jboss.org/wiki/SalesforceAsARESTServiceUsingDataVirtualization?_sscc=t

When running on browser getting not found error (404). Tried to execute VDB, then Database Development perspective opened and when executed the query, it starts and is not completing(not changing from 0%). I am not getting any errors,but getting following warning :

Error log after OPTIMIZATION COMPLETE:PROCESSOR PLAN:

2017-09-09 09:31:44,173 WARN [org.teiid.SECURITY] (NIO1) TEIID40011 Processing exception 'TEIID40042 Invalid Session HWYX7pgSwHa1. Session may have already been terminated.' for session null. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:31:44,175 WARN [org.teiid.SECURITY] (NIO1) TEIID40011 Processing exception 'TEIID40042 Invalid Session LopCxnhFRcHx. Session may have already been terminated.' for session null. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:31:44,176 WARN [org.teiid.SECURITY] (NIO1) TEIID40011 Processing exception 'TEIID40042 Invalid Session IYgbw2oe1pvT. Session may have already been terminated.' for session null. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:31:44,178 WARN [org.teiid.SECURITY] (NIO1) TEIID40011 Processing exception 'TEIID40042 Invalid Session Cm59XEg1MrlD. Session may have already been terminated.' for session null. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:31:44,180 WARN [org.teiid.SECURITY] (NIO1) TEIID40011 Processing exception 'TEIID40042 Invalid Session 9/F8cj7wPFXz. Session may have already been terminated.' for session null. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:31:44,181 WARN [org.teiid.SECURITY] (NIO1) TEIID40011 Processing exception 'TEIID40042 Invalid Session XPa5O+m/MYsS. Session may have already been terminated.' for session null. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:31:44,182 WARN [org.teiid.SECURITY] (NIO1) TEIID40011 Processing exception 'TEIID40042 Invalid Session omRcugzE9ky1. Session may have already been terminated.' for session null. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:31:44,184 WARN [org.teiid.SECURITY] (NIO1) TEIID40011 Processing exception 'TEIID40042 Invalid Session sP1SduL77Vb2. Session may have already been terminated.' for session null. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:31:44,193 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session i1nbdnUCs369. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:31:44,194 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session jR9QR129cvj4. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:31:44,205 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session OTQr9BXiXZeL. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:31:44,207 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session t8rpRYgRD7XT. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:31:44,211 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session /vnJ1FMRlvXB. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:33:44,082 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session HWYX7pgSwHa1. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:33:44,083 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session LopCxnhFRcHx. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:33:44,087 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session IYgbw2oe1pvT. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:33:44,089 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session Cm59XEg1MrlD. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:33:44,094 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session 9/F8cj7wPFXz. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:33:44,096 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session XPa5O+m/MYsS. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:33:44,108 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session omRcugzE9ky1. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:33:44,111 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session sP1SduL77Vb2. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:33:44,126 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session i1nbdnUCs369. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:33:44,127 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session jR9QR129cvj4. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:33:44,129 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session OTQr9BXiXZeL. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:33:44,131 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session t8rpRYgRD7XT. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace. 2017-09-09 09:33:44,132 WARN [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session /vnJ1FMRlvXB. Session may have already been terminated.' for session /Y9Sh40s5Ij9. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.

1. Re: Not able to run query

shawkins Sep 19, 2017 9:10 AM (in response to vijayjose)

All of those logs are just from failed pings and don't show anything about what your query may be doing. Do you have logs related to the query execution?
Actions

2. Re: Not able to run query

vijayjose Sep 19, 2017 9:17 AM (in response to shawkins)

After OPTIMIZATION COMPLETE:PROCESSOR PLAN,i am only getting this.there is no errors.

This is the list of things i have done:

Downloaded and install JBDS 10.4 , Merged bin,standalone,docs,module of wildfly server with it. , Installed Teiid Designer . , Added module.xml and teiid-jdbc.jar file. , Create VDB. , In Standalone-teiid.xml change driver from h2 to teiid. , Deployed the VDB

3. Re: Not able to run query

shawkins Sep 19, 2017 10:08 AM (in response to vijayjose)

You mean you see no further logs on the request id / session for the request that was executed?

Is is possible to provide the full server log?
Actions
4. Re: Not able to run query

vijayjose Sep 20, 2017 8:05 AM (in response to shawkins)
2017-09-20 10:21:43,768 INFO [org.jboss.modules] (main) JBoss Modules version 1.5.1.Final-redhat-1 2017-09-20 10:21:43,945 INFO [org.jboss.msc] (main) JBoss MSC version 1.2.6.Final 2017-09-20 10:21:44,001 INFO [org.jboss.as] (MSC service thread 1-6) WFLYSRV0049: WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final) starting 2017-09-20 10:21:44,003 DEBUG [org.jboss.as.config] (MSC service thread 1-6) Configured system properties: awt.toolkit = sun.awt.X11.XToolkit file.encoding = UTF-8 file.encoding.pkg = sun.io file.separator = / java.awt.graphicsenv = sun.awt.X11GraphicsEnvironment java.awt.headless = true java.awt.printerjob = sun.print.PSPrinterJob java.class.path = /home/Company/user/apps/jboss-install/runtimes/jboss-eap/jboss-modules.jar java.class.version = 52.0 java.endorsed.dirs = /usr/lib/jvm/java-8-openjdk-amd64/jre/lib/endorsed java.ext.dirs = /usr/lib/jvm/java-8-openjdk-amd64/jre/lib/ext:/usr/java/packages/lib/ext java.home = /usr/lib/jvm/java-8-openjdk-amd64/jre java.io.tmpdir = /tmp java.library.path = /usr/java/packages/lib/amd64:/usr/lib/x86_64-linux-gnu/jni:/lib/x86_64-linux-gnu:/usr/lib/x86_64-linux-gnu:/usr/lib/jni:/lib:/usr/lib java.net.preferIPv4Stack = true java.runtime.name = OpenJDK Runtime Environment java.runtime.version = 1.8.0_91-8u91-b14-0ubuntu4~15.10.1-b14 java.specification.name = Java Platform API Specification java.specification.vendor = Oracle Corporation java.specification.version = 1.8 java.util.logging.manager = org.jboss.logmanager.LogManager java.vendor = Oracle Corporation java.vendor.url = http://java.oracle.com/ java.vendor.url.bug = http://bugreport.sun.com/bugreport/ java.version = 1.8.0_91 java.vm.info = mixed mode java.vm.name = OpenJDK 64-Bit Server VM java.vm.specification.name = Java Virtual Machine Specification java.vm.specification.vendor = Oracle Corporation java.vm.specification.version = 1.8 java.vm.vendor = Oracle Corporation java.vm.version = 25.91-b14 javax.management.builder.initial = org.jboss.as.jmx.PluggableMBeanServerBuilder javax.xml.datatype.DatatypeFactory = __redirected.__DatatypeFactory javax.xml.parsers.DocumentBuilderFactory = __redirected.__DocumentBuilderFactory javax.xml.parsers.SAXParserFactory = __redirected.__SAXParserFactory javax.xml.stream.XMLEventFactory = __redirected.__XMLEventFactory javax.xml.stream.XMLInputFactory = __redirected.__XMLInputFactory javax.xml.stream.XMLOutputFactory = __redirected.__XMLOutputFactory javax.xml.transform.TransformerFactory = __redirected.__TransformerFactory javax.xml.validation.SchemaFactory:http://www.w3.org/2001/XMLSchema = __redirected.__SchemaFactory javax.xml.xpath.XPathFactory:http://java.sun.com/jaxp/xpath/dom = __redirected.__XPathFactory jboss.bind.address = localhost jboss.bind.address.management = localhost jboss.home.dir = /home/Company/user/apps/jboss-install/runtimes/jboss-eap jboss.host.name = Company-pcd9093 jboss.modules.dir = /home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules jboss.modules.system.pkgs = org.jboss.byteman jboss.node.name = Company-pcd9093 jboss.qualified.host.name = Company-pcd9093 jboss.server.base.dir = /home/Company/user/apps/jboss-install/runtimes/jboss-eap/standalone jboss.server.config.dir = /home/Company/user/apps/jboss-install/runtimes/jboss-eap/standalone/configuration jboss.server.data.dir = /home/Company/user/apps/jboss-install/runtimes/jboss-eap/standalone/data jboss.server.deploy.dir = /home/Company/user/apps/jboss-install/runtimes/jboss-eap/standalone/data/content jboss.server.log.dir = /home/Company/user/apps/jboss-install/runtimes/jboss-eap/standalone/log jboss.server.name = Company-pcd9093 jboss.server.persist.config = true jboss.server.temp.dir = /home/Company/user/apps/jboss-install/runtimes/jboss-eap/standalone/tmp line.separator = logging.configuration = file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/standalone/configuration/logging.properties module.path = /home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules org.jboss.boot.log.file = /home/Company/user/apps/jboss-install/runtimes/jboss-eap/standalone/log/boot.log org.jboss.logmanager.nocolor = true org.jboss.resolver.warning = true org.xml.sax.driver = __redirected.__XMLReaderFactory os.arch = amd64 os.name = Linux os.version = 4.2.0-35-generic path.separator = : program.name = JBossTools: WildFly 10.x sun.arch.data.model = 64 sun.boot.class.path = /usr/lib/jvm/java-8-openjdk-amd64/jre/lib/resources.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/rt.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/sunrsasign.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/jsse.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/jce.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/charsets.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/jfr.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/classes sun.boot.library.path = /usr/lib/jvm/java-8-openjdk-amd64/jre/lib/amd64 sun.cpu.endian = little sun.cpu.isalist = sun.desktop = gnome sun.io.unicode.encoding = UnicodeLittle sun.java.command = org.jboss.modules.Main -mp /home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules org.jboss.as.standalone -b localhost --server-config=standalone-teiid.xml -Djboss.server.base.dir=/home/Company/user/apps/jboss-install/runtimes/jboss-eap/standalone sun.java.launcher = SUN_STANDARD sun.jnu.encoding = UTF-8 sun.management.compiler = HotSpot 64-Bit Tiered Compilers sun.os.patch.level = unknown sun.rmi.dgc.client.gcInterval = 3600000 sun.rmi.dgc.server.gcInterval = 3600000 user.country = IN user.dir = /home/Company/user/apps/jboss-install/runtimes/jboss-eap/bin user.home = /home/Company user.language = en user.name = Company user.timezone = Asia/Kolkata 2017-09-20 10:21:44,003 DEBUG [org.jboss.as.config] (MSC service thread 1-6) VM Arguments: -Dprogram.name=JBossTools: WildFly 10.x -Xms64m -Xmx512m -Dorg.jboss.resolver.warning=true -Djava.net.preferIPv4Stack=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true -Dorg.jboss.boot.log.file=/home/Company/user/apps/jboss-install/runtimes/jboss-eap/standalone/log/boot.log -Dlogging.configuration=file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/standalone/configuration/logging.properties -Djboss.home.dir=/home/Company/user/apps/jboss-install/runtimes/jboss-eap -Dorg.jboss.logmanager.nocolor=true -Djboss.bind.address.management=localhost -Dfile.encoding=UTF-8 2017-09-20 10:21:45,001 INFO [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0039: Creating http management service using socket-binding (management-http) 2017-09-20 10:21:45,014 INFO [org.xnio] (MSC service thread 1-3) XNIO version 3.3.4.Final 2017-09-20 10:21:45,021 INFO [org.xnio.nio] (MSC service thread 1-3) XNIO NIO Implementation Version 3.3.4.Final 2017-09-20 10:21:45,060 INFO [org.jboss.remoting] (MSC service thread 1-3) JBoss Remoting version 4.0.18.Final 2017-09-20 10:21:45,069 INFO [org.wildfly.extension.io] (ServerService Thread Pool -- 38) WFLYIO001: Worker 'default' has auto-configured to 8 core threads with 64 task threads based on your 4 available processors 2017-09-20 10:21:45,078 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 39) WFLYCLINF0001: Activating Infinispan subsystem. 2017-09-20 10:21:45,101 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 34) WFLYJCA0004: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3) 2017-09-20 10:21:45,125 INFO [org.jboss.as.connector] (MSC service thread 1-6) WFLYJCA0009: Starting JCA Subsystem (WildFly/IronJacamar 1.3.2.Final) 2017-09-20 10:21:45,131 INFO [org.jboss.as.jsf] (ServerService Thread Pool -- 45) WFLYJSF0007: Activated the following JSF Implementations: [main] 2017-09-20 10:21:45,133 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-7) WFLYJCA0018: Started Driver service with driver-name = h2 2017-09-20 10:21:45,153 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 47) WFLYNAM0001: Activating Naming Subsystem 2017-09-20 10:21:45,162 WARN [org.jboss.as.txn] (ServerService Thread Pool -- 56) WFLYTX0013: Node identifier property is set to the default value. Please make sure it is unique. 2017-09-20 10:21:45,173 INFO [org.jboss.as.security] (ServerService Thread Pool -- 54) WFLYSEC0002: Activating Security Subsystem 2017-09-20 10:21:45,187 INFO [org.jboss.as.security] (MSC service thread 1-8) WFLYSEC0001: Current PicketBox version=4.9.4.Final 2017-09-20 10:21:45,278 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 34) WFLYJCA0005: Deploying non-JDBC-compliant driver class org.teiid.jdbc.TeiidDriver (version 9.3) 2017-09-20 10:21:45,279 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 34) WFLYJCA0005: Deploying non-JDBC-compliant driver class org.teiid.jdbc.TeiidDriver (version 9.3) 2017-09-20 10:21:45,279 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-1) WFLYJCA0018: Started Driver service with driver-name = teiid-local 2017-09-20 10:21:45,280 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-1) WFLYJCA0018: Started Driver service with driver-name = teiid 2017-09-20 10:21:45,288 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 58) WFLYWS0002: Activating WebServices Extension 2017-09-20 10:21:45,316 INFO [org.jboss.as.naming] (MSC service thread 1-7) WFLYNAM0003: Starting Naming Service 2017-09-20 10:21:45,317 INFO [org.jboss.as.mail.extension] (MSC service thread 1-7) WFLYMAIL0001: Bound mail session [java:jboss/mail/Default] 2017-09-20 10:21:45,337 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 57) WFLYUT0003: Undertow 1.3.15.Final starting 2017-09-20 10:21:45,337 INFO [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0003: Undertow 1.3.15.Final starting 2017-09-20 10:21:45,517 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 57) WFLYUT0014: Creating file handler for path '/home/Company/user/apps/jboss-install/runtimes/jboss-eap/welcome-content' with options [directory-listing: 'false', follow-symlink: 'false', case-sensitive: 'true', safe-symlink-paths: '[]'] 2017-09-20 10:21:45,531 INFO [org.wildfly.extension.undertow] (MSC service thread 1-8) WFLYUT0012: Started server default-server. 2017-09-20 10:21:45,532 INFO [org.wildfly.extension.undertow] (MSC service thread 1-8) WFLYUT0018: Host default-host starting 2017-09-20 10:21:45,555 INFO [org.jboss.as.ejb3] (MSC service thread 1-2) WFLYEJB0481: Strict pool slsb-strict-max-pool is using a max instance size of 64 (per class), which is derived from thread worker pool sizing. 2017-09-20 10:21:45,555 INFO [org.jboss.as.ejb3] (MSC service thread 1-5) WFLYEJB0482: Strict pool mdb-strict-max-pool is using a max instance size of 16 (per class), which is derived from the number of CPUs on this host. 2017-09-20 10:21:45,644 INFO [org.wildfly.extension.undertow] (MSC service thread 1-8) WFLYUT0006: Undertow HTTP listener default listening on 192.168.1.63:8080 2017-09-20 10:21:45,826 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/webservice/main/ 2017-09-20 10:21:45,827 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-6) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/couchbase/main/ 2017-09-20 10:21:45,831 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-7) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/ftp/main/ 2017-09-20 10:21:45,858 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-6) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/ldap/main/ 2017-09-20 10:21:45,859 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-6) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/file/main/ 2017-09-20 10:21:45,861 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-6) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/mongodb/main/ 2017-09-20 10:21:45,862 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-7) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/simpledb/main/ 2017-09-20 10:21:45,882 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/ 2017-09-20 10:21:45,890 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-7) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/ 2017-09-20 10:21:45,892 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/solr/main/ 2017-09-20 10:21:45,896 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/google/main/ 2017-09-20 10:21:45,902 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-5) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce-34/main/ 2017-09-20 10:21:45,904 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/accumulo/main/ 2017-09-20 10:21:45,904 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/infinispan/hotrod/main/ 2017-09-20 10:21:45,904 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-5) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/cassandra/main/ 2017-09-20 10:21:45,932 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-6) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/couchbase/main/ 2017-09-20 10:21:45,935 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-6) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/couchbase/main/ 2017-09-20 10:21:45,936 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-6) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/file/main/ 2017-09-20 10:21:45,937 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-6) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/file/main/ 2017-09-20 10:21:45,938 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/ldap/main/ 2017-09-20 10:21:45,938 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/ldap/main/ 2017-09-20 10:21:45,939 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/ftp/main/ 2017-09-20 10:21:45,940 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/mongodb/main/ 2017-09-20 10:21:45,941 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/mongodb/main/ 2017-09-20 10:21:45,941 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/accumulo/main/ 2017-09-20 10:21:45,942 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/infinispan/hotrod/main/ 2017-09-20 10:21:45,942 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/accumulo/main/ 2017-09-20 10:21:45,942 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/google/main/ 2017-09-20 10:21:45,942 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-3) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/infinispan/hotrod/main/ 2017-09-20 10:21:45,943 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/google/main/ 2017-09-20 10:21:45,943 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/ 2017-09-20 10:21:45,943 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-7) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/ 2017-09-20 10:21:45,943 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/cassandra/main/ 2017-09-20 10:21:45,943 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/webservice/main/ 2017-09-20 10:21:45,944 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-3) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/cassandra/main/ 2017-09-20 10:21:45,944 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/webservice/main/ 2017-09-20 10:21:45,940 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-4) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/ftp/main/ 2017-09-20 10:21:45,951 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-3) WFLYJCA0001: Bound data source [java:/final2] 2017-09-20 10:21:45,951 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-8) WFLYJCA0001: Bound data source [java:/final] 2017-09-20 10:21:45,952 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-6) WFLYJCA0001: Bound data source [java:jboss/datasources/ExampleDS] 2017-09-20 10:21:45,952 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-6) WFLYJCA0001: Bound data source [java:/vdbfinal] 2017-09-20 10:21:45,952 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) WFLYJCA0001: Bound data source [java:/vdba] 2017-09-20 10:21:45,952 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-6) WFLYJCA0001: Bound data source [java:/testvdb] 2017-09-20 10:21:45,952 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-5) WFLYJCA0001: Bound data source [java:/vdb111] 2017-09-20 10:21:45,953 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/simpledb/main/ 2017-09-20 10:21:45,953 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-8) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/ 2017-09-20 10:21:45,953 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-5) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/ 2017-09-20 10:21:45,953 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/simpledb/main/ 2017-09-20 10:21:45,954 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/ 2017-09-20 10:21:45,954 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/ 2017-09-20 10:21:45,954 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce-34/main/ 2017-09-20 10:21:45,955 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-7) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce-34/main/ 2017-09-20 10:21:45,955 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/solr/main/ 2017-09-20 10:21:45,956 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020018: Enabling for java:/sfsrc 2017-09-20 10:21:45,956 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020018: Enabling for java:/DataSource2 2017-09-20 10:21:45,956 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-5) IJ020018: Enabling for java:/DataSource1 2017-09-20 10:21:45,953 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-6) WFLYJCA0001: Bound data source [java:/vdb45] 2017-09-20 10:21:45,953 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-8) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/ 2017-09-20 10:21:45,987 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-3) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/solr/main/ 2017-09-20 10:21:45,998 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-5) WFLYJCA0007: Registered connection factory java:/DataSource1 2017-09-20 10:21:45,999 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-1) WFLYJCA0007: Registered connection factory java:/sfsrc 2017-09-20 10:21:46,001 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/ 2017-09-20 10:21:46,002 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-1) WFLYJCA0002: Bound JCA ConnectionFactory [java:/sfsrc] 2017-09-20 10:21:46,003 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-5) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/ 2017-09-20 10:21:46,003 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-5) WFLYJCA0002: Bound JCA ConnectionFactory [java:/DataSource1] 2017-09-20 10:21:46,010 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-2) WFLYJCA0007: Registered connection factory java:/DataSource2 2017-09-20 10:21:46,011 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-2) IJ020002: Deployed: file:/home/Company/user/apps/jboss-install/runtimes/jboss-eap/modules/system/layers/dv/org/jboss/teiid/resource-adapter/salesforce/main/ 2017-09-20 10:21:46,014 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-8) WFLYJCA0002: Bound JCA ConnectionFactory [java:/DataSource2] 2017-09-20 10:21:46,504 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "jdbc-simple" added. 2017-09-20 10:21:46,507 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "jdbc-ansi" added. 2017-09-20 10:21:46,512 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "access" added. 2017-09-20 10:21:46,520 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "db2" added. 2017-09-20 10:21:46,528 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "derby" added. 2017-09-20 10:21:46,545 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "h2" added. 2017-09-20 10:21:46,560 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "hsql" added. 2017-09-20 10:21:46,566 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "hana" added. 2017-09-20 10:21:46,597 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "informix" added. 2017-09-20 10:21:46,608 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "metamatrix" added. 2017-09-20 10:21:46,619 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "mysql" added. 2017-09-20 10:21:46,628 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "mysql5" added. 2017-09-20 10:21:46,642 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "oracle" added. 2017-09-20 10:21:46,654 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "postgresql" added. 2017-09-20 10:21:46,680 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "greenplum" added. 2017-09-20 10:21:46,690 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "sqlserver" added. 2017-09-20 10:21:46,700 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "sybase" added. 2017-09-20 10:21:46,710 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "sybaseiq" added. 2017-09-20 10:21:46,721 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "teiid" added. 2017-09-20 10:21:46,731 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "teradata" added. 2017-09-20 10:21:46,737 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "modeshape" added. 2017-09-20 10:21:46,742 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "ingres" added. 2017-09-20 10:21:46,746 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "ingres93" added. 2017-09-20 10:21:46,752 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "intersystems-cache" added. 2017-09-20 10:21:46,760 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "netezza" added. 2017-09-20 10:21:46,763 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "file" added. 2017-09-20 10:21:46,767 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "google-spreadsheet" added. 2017-09-20 10:21:46,770 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "ldap" added. 2017-09-20 10:21:46,788 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "loopback" added. 2017-09-20 10:21:46,791 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "olap" added. 2017-09-20 10:21:46,798 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "ws" added. 2017-09-20 10:21:46,806 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "salesforce" added. 2017-09-20 10:21:46,813 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "salesforce-34" added. 2017-09-20 10:21:46,818 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "hive" added. 2017-09-20 10:21:46,822 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "jpa2" added. 2017-09-20 10:21:46,830 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "odata" added. 2017-09-20 10:21:46,832 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "sap-gateway" added. 2017-09-20 10:21:46,834 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "sap-nw-gateway" added. 2017-09-20 10:21:46,841 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "mongodb" added. 2017-09-20 10:21:46,848 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "couchbase" added. 2017-09-20 10:21:46,852 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "cassandra" added. 2017-09-20 10:21:46,856 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "simpledb" added. 2017-09-20 10:21:46,861 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "accumulo" added. 2017-09-20 10:21:46,864 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "solr" added. 2017-09-20 10:21:46,874 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "excel" added. 2017-09-20 10:21:46,877 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "impala" added. 2017-09-20 10:21:46,881 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "prestodb" added. 2017-09-20 10:21:46,885 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "phoenix" added. 2017-09-20 10:21:46,887 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "hbase" added. 2017-09-20 10:21:46,899 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "ucanaccess" added. 2017-09-20 10:21:46,911 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "vertica" added. 2017-09-20 10:21:46,924 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "actian-vector" added. 2017-09-20 10:21:46,938 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "osisoft-pi" added. 2017-09-20 10:21:46,957 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "odata4" added. 2017-09-20 10:21:46,974 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "redshift" added. 2017-09-20 10:21:47,137 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "swagger" added. 2017-09-20 10:21:47,140 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "delegator" added. 2017-09-20 10:21:47,144 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 55) TEIID50006 Teiid translator "infinispan-hotrod" added. 2017-09-20 10:21:47,328 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) WFLYSRV0027: Starting deployment of "teiid-olingo-odata4.war" (runtime-name: "teiid-olingo-odata4.war") 2017-09-20 10:21:47,344 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-1) WFLYDS0013: Started FileSystemDeploymentService for directory /home/Company/user/apps/jboss-install/runtimes/jboss-eap/standalone/deployments 2017-09-20 10:21:47,344 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) WFLYSRV0027: Starting deployment of "vdba.vdb" (runtime-name: "vdba.vdb") 2017-09-20 10:21:47,345 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) WFLYSRV0027: Starting deployment of "testvdb.vdb" (runtime-name: "testvdb.vdb") 2017-09-20 10:21:47,362 INFO [org.jboss.ws.common.management] (MSC service thread 1-4) JBWS022052: Starting JBossWS 5.1.3.Final (Apache CXF 3.1.4) 2017-09-20 10:21:47,397 INFO [org.infinispan.factories.GlobalComponentRegistry] (MSC service thread 1-5) ISPN000128: Infinispan version: Infinispan 'Mahou' 8.1.0.Final 2017-09-20 10:21:47,843 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 61) WFLYCLINF0002: Started preparedplan cache from teiid container 2017-09-20 10:21:48,060 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 63) WFLYCLINF0002: Started resultset-repl cache from teiid container 2017-09-20 10:21:48,061 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 60) WFLYCLINF0002: Started resultset cache from teiid container 2017-09-20 10:21:48,180 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-4) TEIID40118 VDB testvdb.1 added to the repository 2017-09-20 10:21:48,197 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50029 VDB testvdb.1 model "sfsrc" metadata is currently being loaded. Start Time: 20/9/17 10:21 AM 2017-09-20 10:21:48,200 INFO [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50001 Teiid Engine 9.3.1 Started = Wed Sep 20 10:21:48 IST 2017 2017-09-20 10:21:48,201 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-2) TEIID40118 VDB vdba.1 added to the repository 2017-09-20 10:21:48,209 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB vdba.1 model "sfsrc" metadata is currently being loaded. Start Time: 20/9/17 10:21 AM 2017-09-20 10:21:48,223 INFO [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50038 Teiid Local transport enabled. Bound to: teiid/queryengine/odata 2017-09-20 10:21:48,223 INFO [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50038 Teiid Local transport enabled. Bound to: teiid/queryengine/local 2017-09-20 10:21:48,225 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50029 VDB testvdb.1 model "sfview" metadata is currently being loaded. Start Time: 20/9/17 10:21 AM 2017-09-20 10:21:48,231 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB vdba.1 model "sfview" metadata is currently being loaded. Start Time: 20/9/17 10:21 AM 2017-09-20 10:21:48,325 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (Worker1_async-teiid-threads1) TEIID40003 VDB vdba.1 is set to ACTIVE 2017-09-20 10:21:48,328 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (Worker2_async-teiid-threads3) TEIID40003 VDB testvdb.1 is set to ACTIVE 2017-09-20 10:21:48,552 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 64) WFLYUT0021: Registered web context: /odata4 2017-09-20 10:21:48,553 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker2_QueryProcessorQueue1) ZDsFmNBdpXdz TEIID30013 Loading materialized view table #MAT_PG_CATALOG.PG_TYPE 2017-09-20 10:21:48,552 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker0_QueryProcessorQueue0) +R2p6GidWLaV TEIID30013 Loading materialized view table #MAT_PG_CATALOG.MATPG_DATATYPE 2017-09-20 10:21:48,559 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker1_QueryProcessorQueue3) qZ+rbe6tDJqP TEIID30013 Loading materialized view table #MAT_PG_CATALOG.MATPG_DATATYPE 2017-09-20 10:21:48,560 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker3_QueryProcessorQueue2) TFl9GhNjCM9H TEIID30013 Loading materialized view table #MAT_PG_CATALOG.PG_TYPE 2017-09-20 10:21:48,641 INFO [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50012 Teiid JDBC - Name = jdbc, Host = localhost, Port = 31000, SSL = OFF 2017-09-20 10:21:48,644 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50037 Teiid ODBC - Name = odbc, Host = localhost, Port = 35432, SSL = OFF 2017-09-20 10:21:48,661 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker1_QueryProcessorQueue7) TFl9GhNjCM9H TEIID30014 Loaded materialized view table #MAT_PG_CATALOG.PG_TYPE with row count 43. 2017-09-20 10:21:48,661 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker0_QueryProcessorQueue6) ZDsFmNBdpXdz TEIID30014 Loaded materialized view table #MAT_PG_CATALOG.PG_TYPE with row count 43. 2017-09-20 10:21:48,669 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker2_QueryProcessorQueue9) qZ+rbe6tDJqP TEIID30014 Loaded materialized view table #MAT_PG_CATALOG.MATPG_DATATYPE with row count 51. 2017-09-20 10:21:48,669 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker4_QueryProcessorQueue8) +R2p6GidWLaV TEIID30014 Loaded materialized view table #MAT_PG_CATALOG.MATPG_DATATYPE with row count 51. 2017-09-20 10:21:48,696 INFO [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0010: Deployed "testvdb.vdb" (runtime-name : "testvdb.vdb") 2017-09-20 10:21:48,697 INFO [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0010: Deployed "vdba.vdb" (runtime-name : "vdba.vdb") 2017-09-20 10:21:48,698 INFO [org.jboss.as.server] (ServerService Thread Pool -- 55) WFLYSRV0010: Deployed "teiid-olingo-odata4.war" (runtime-name : "teiid-olingo-odata4.war") 2017-09-20 10:21:48,777 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http management interface listening on http://192.168.1.63:9990/management 2017-09-20 10:21:48,777 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0051: Admin console listening on http://192.168.1.63:9990 2017-09-20 10:21:48,778 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0025: WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final) started in 5306ms - Started 735 of 1116 services (545 services are lazy, passive or on-demand) 2017-09-20 10:23:39,441 INFO [org.jboss.as.repository] (management-handler-thread - 8) WFLYDR0001: Content added at location /home/Company/user/apps/jboss-install/runtimes/jboss-eap/standalone/data/content/ac/494487bc76156b9fd65d35ee60eb4724a116d4/content 2017-09-20 10:23:39,445 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) WFLYSRV0027: Starting deployment of "finalsf.vdb" (runtime-name: "finalsf.vdb") 2017-09-20 10:23:39,476 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-7) TEIID40118 VDB finalsf.1 added to the repository 2017-09-20 10:23:39,477 INFO [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50029 VDB finalsf.1 model "sfsrc" metadata is currently being loaded. Start Time: 20/9/17 10:23 AM 2017-09-20 10:23:39,477 INFO [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50029 VDB finalsf.1 model "sfview" metadata is currently being loaded. Start Time: 20/9/17 10:23 AM 2017-09-20 10:23:39,524 INFO [org.jboss.as.server] (management-handler-thread - 8) WFLYSRV0010: Deployed "finalsf.vdb" (runtime-name : "finalsf.vdb") 2017-09-20 10:23:39,532 INFO [org.teiid.RUNTIME] (Worker2_async-teiid-threads5) TEIID50030 VDB finalsf.1 model "sfview" metadata loaded. End Time: 20/9/17 10:23 AM 2017-09-20 10:23:39,532 INFO [org.teiid.RUNTIME] (Worker1_async-teiid-threads4) TEIID50030 VDB finalsf.1 model "sfsrc" metadata loaded. End Time: 20/9/17 10:23 AM 2017-09-20 10:23:39,554 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (Worker1_async-teiid-threads4) TEIID40003 VDB finalsf.1 is set to ACTIVE 2017-09-20 10:23:39,559 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker4_QueryProcessorQueue10) 6EpvjTAjoUlB TEIID30013 Loading materialized view table #MAT_PG_CATALOG.MATPG_DATATYPE 2017-09-20 10:23:39,565 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker2_QueryProcessorQueue11) gdOn3scO0+8U TEIID30013 Loading materialized view table #MAT_PG_CATALOG.PG_TYPE 2017-09-20 10:23:39,573 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker2_QueryProcessorQueue13) gdOn3scO0+8U TEIID30014 Loaded materialized view table #MAT_PG_CATALOG.PG_TYPE with row count 43. 2017-09-20 10:23:39,612 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker4_QueryProcessorQueue10) 6EpvjTAjoUlB TEIID30014 Loaded materialized view table #MAT_PG_CATALOG.MATPG_DATATYPE with row count 51. 2017-09-20 10:23:41,710 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-3) WFLYJCA0001: Bound data source [java:/finalsf] 2017-09-20 10:23:41,728 INFO [org.jboss.as.connector] (management-handler-thread - 8) WFLYJCA0093: The 'enable' operation is deprecated. Use of the 'add' or 'remove' operations is preferred, or if required the 'write-attribute' operation can used to set the deprecated 'enabled' attribute 2017-09-20 10:23:48,743 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-2) TEIID40120 VDB finalsf.1 will be removed from the repository 2017-09-20 10:23:48,743 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-2) TEIID40119 VDB finalsf.1 removed from the repository 2017-09-20 10:23:48,771 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50026 VDB "finalsf.1[sfsrc{sfsrc=sfsrc, salesforce, java:/sfsrc}, sfview{}]" undeployed. 2017-09-20 10:23:48,772 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-7) TEIID40120 VDB finalsf.1 will be removed from the repository 2017-09-20 10:23:48,782 INFO [org.hibernate.validator.internal.util.Version] (MSC service thread 1-7) HV000001: Hibernate Validator 5.2.3.Final 2017-09-20 10:23:48,817 INFO [org.jboss.as.server.deployment] (MSC service thread 1-8) WFLYSRV0028: Stopped deployment finalsf.vdb (runtime-name: finalsf.vdb) in 79ms 2017-09-20 10:23:48,819 INFO [org.jboss.as.server.deployment] (MSC service thread 1-5) WFLYSRV0027: Starting deployment of "finalsf.vdb" (runtime-name: "finalsf.vdb") 2017-09-20 10:23:48,837 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1) TEIID40118 VDB finalsf.1 added to the repository 2017-09-20 10:23:48,838 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB finalsf.1 model "sfsrc" metadata is currently being loaded. Start Time: 20/9/17 10:23 AM 2017-09-20 10:23:48,838 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB finalsf.1 model "sfview" metadata is currently being loaded. Start Time: 20/9/17 10:23 AM 2017-09-20 10:23:48,849 INFO [org.teiid.RUNTIME] (Worker2_async-teiid-threads7) TEIID50030 VDB finalsf.1 model "sfview" metadata loaded. End Time: 20/9/17 10:23 AM 2017-09-20 10:23:48,850 INFO [org.teiid.RUNTIME] (Worker1_async-teiid-threads6) TEIID50030 VDB finalsf.1 model "sfsrc" metadata loaded. End Time: 20/9/17 10:23 AM 2017-09-20 10:23:48,879 INFO [org.jboss.as.server] (management-handler-thread - 7) WFLYSRV0016: Replaced deployment "finalsf.vdb" with deployment "finalsf.vdb" 2017-09-20 10:23:48,905 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (Worker1_async-teiid-threads6) TEIID40003 VDB finalsf.1 is set to ACTIVE 2017-09-20 10:23:48,909 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker4_QueryProcessorQueue14) 3SV6pg93JrOi TEIID30013 Loading materialized view table #MAT_PG_CATALOG.MATPG_DATATYPE 2017-09-20 10:23:48,925 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker2_QueryProcessorQueue15) hsD1elQ+gAbo TEIID30013 Loading materialized view table #MAT_PG_CATALOG.PG_TYPE 2017-09-20 10:23:48,932 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker2_QueryProcessorQueue17) hsD1elQ+gAbo TEIID30014 Loaded materialized view table #MAT_PG_CATALOG.PG_TYPE with row count 43. 2017-09-20 10:23:48,936 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker4_QueryProcessorQueue14) 3SV6pg93JrOi TEIID30014 Loaded materialized view table #MAT_PG_CATALOG.MATPG_DATATYPE with row count 51. 2017-09-20 10:24:26,507 INFO [org.teiid.PLANNER] (Worker4_QueryProcessorQueue22) 9DymZB2rajri ============================================================================ USER COMMAND: SELECT sfview.tbl.Id, sfview.tbl.IsDeleted, sfview.tbl.MasterRecordId, sfview.tbl.LastName, sfview.tbl.FirstName, sfview.tbl.Salutation, sfview.tbl.Name, sfview.tbl.OtherStreet, sfview.tbl.OtherCity, sfview.tbl.OtherState, sfview.tbl.OtherPostalCode, sfview.tbl.OtherCountry, sfview.tbl.MailingStreet, sfview.tbl.MailingCity, sfview.tbl.MailingState, sfview.tbl.MailingPostalCode, sfview.tbl.MailingCountry, sfview.tbl.Phone, sfview.tbl.Fax, sfview.tbl.MobilePhone, sfview.tbl.HomePhone, sfview.tbl.OtherPhone, sfview.tbl.AssistantPhone, sfview.tbl.ReportsToId, sfview.tbl.Email, sfview.tbl.Title, sfview.tbl.Department, sfview.tbl.AssistantName, sfview.tbl.LeadSource, sfview.tbl.Birthdate, sfview.tbl.Description, sfview.tbl.OwnerId, sfview.tbl.CreatedDate, sfview.tbl.CreatedById, sfview.tbl.LastModifiedDate, sfview.tbl.LastModifiedById, sfview.tbl.SystemModstamp, sfview.tbl.LastActivityDate, sfview.tbl.LastCURequestDate, sfview.tbl.LastCUUpdateDate, sfview.tbl.EmailBouncedReason, sfview.tbl.EmailBouncedDate, sfview.tbl.Jigsaw, sfview.tbl.Level__c, sfview.tbl.Languages__c FROM sfview.tbl ---------------------------------------------------------------------------- OPTIMIZE: SELECT sfview.tbl.Id, sfview.tbl.IsDeleted, sfview.tbl.MasterRecordId, sfview.tbl.LastName, sfview.tbl.FirstName, sfview.tbl.Salutation, sfview.tbl.Name, sfview.tbl.OtherStreet, sfview.tbl.OtherCity, sfview.tbl.OtherState, sfview.tbl.OtherPostalCode, sfview.tbl.OtherCountry, sfview.tbl.MailingStreet, sfview.tbl.MailingCity, sfview.tbl.MailingState, sfview.tbl.MailingPostalCode, sfview.tbl.MailingCountry, sfview.tbl.Phone, sfview.tbl.Fax, sfview.tbl.MobilePhone, sfview.tbl.HomePhone, sfview.tbl.OtherPhone, sfview.tbl.AssistantPhone, sfview.tbl.ReportsToId, sfview.tbl.Email, sfview.tbl.Title, sfview.tbl.Department, sfview.tbl.AssistantName, sfview.tbl.LeadSource, sfview.tbl.Birthdate, sfview.tbl.Description, sfview.tbl.OwnerId, sfview.tbl.CreatedDate, sfview.tbl.CreatedById, sfview.tbl.LastModifiedDate, sfview.tbl.LastModifiedById, sfview.tbl.SystemModstamp, sfview.tbl.LastActivityDate, sfview.tbl.LastCURequestDate, sfview.tbl.LastCUUpdateDate, sfview.tbl.EmailBouncedReason, sfview.tbl.EmailBouncedDate, sfview.tbl.Jigsaw, sfview.tbl.Level__c, sfview.tbl.Languages__c FROM sfview.tbl ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT sfview.tbl.Id, sfview.tbl.IsDeleted, sfview.tbl.MasterRecordId, sfview.tbl.LastName, sfview.tbl.FirstName, sfview.tbl.Salutation, sfview.tbl.Name, sfview.tbl.OtherStreet, sfview.tbl.OtherCity, sfview.tbl.OtherState, sfview.tbl.OtherPostalCode, sfview.tbl.OtherCountry, sfview.tbl.MailingStreet, sfview.tbl.MailingCity, sfview.tbl.MailingState, sfview.tbl.MailingPostalCode, sfview.tbl.MailingCountry, sfview.tbl.Phone, sfview.tbl.Fax, sfview.tbl.MobilePhone, sfview.tbl.HomePhone, sfview.tbl.OtherPhone, sfview.tbl.AssistantPhone, sfview.tbl.ReportsToId, sfview.tbl.Email, sfview.tbl.Title, sfview.tbl.Department, sfview.tbl.AssistantName, sfview.tbl.LeadSource, sfview.tbl.Birthdate, sfview.tbl.Description, sfview.tbl.OwnerId, sfview.tbl.CreatedDate, sfview.tbl.CreatedById, sfview.tbl.LastModifiedDate, sfview.tbl.LastModifiedById, sfview.tbl.SystemModstamp, sfview.tbl.LastActivityDate, sfview.tbl.LastCURequestDate, sfview.tbl.LastCUUpdateDate, sfview.tbl.EmailBouncedReason, sfview.tbl.EmailBouncedDate, sfview.tbl.Jigsaw, sfview.tbl.Level__c, sfview.tbl.Languages__c FROM sfview.tbl CANONICAL PLAN: Project(groups=[sfview.tbl], props={PROJECT_COLS=[sfview.tbl.Id, sfview.tbl.IsDeleted, sfview.tbl.MasterRecordId, sfview.tbl.LastName, sfview.tbl.FirstName, sfview.tbl.Salutation, sfview.tbl.Name, sfview.tbl.OtherStreet, sfview.tbl.OtherCity, sfview.tbl.OtherState, sfview.tbl.OtherPostalCode, sfview.tbl.OtherCountry, sfview.tbl.MailingStreet, sfview.tbl.MailingCity, sfview.tbl.MailingState, sfview.tbl.MailingPostalCode, sfview.tbl.MailingCountry, sfview.tbl.Phone, sfview.tbl.Fax, sfview.tbl.MobilePhone, sfview.tbl.HomePhone, sfview.tbl.OtherPhone, sfview.tbl.AssistantPhone, sfview.tbl.ReportsToId, sfview.tbl.Email, sfview.tbl.Title, sfview.tbl.Department, sfview.tbl.AssistantName, sfview.tbl.LeadSource, sfview.tbl.Birthdate, sfview.tbl.Description, sfview.tbl.OwnerId, sfview.tbl.CreatedDate, sfview.tbl.CreatedById, sfview.tbl.LastModifiedDate, sfview.tbl.LastModifiedById, sfview.tbl.SystemModstamp, sfview.tbl.LastActivityDate, sfview.tbl.LastCURequestDate, sfview.tbl.LastCUUpdateDate, sfview.tbl.EmailBouncedReason, sfview.tbl.EmailBouncedDate, sfview.tbl.Jigsaw, sfview.tbl.Level__c, sfview.tbl.Languages__c]}) Source(groups=[sfview.tbl], props={NESTED_COMMAND=SELECT sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c FROM sfsrc.Contact, SYMBOL_MAP={sfview.tbl.Id=sfsrc.Contact.Id, sfview.tbl.IsDeleted=sfsrc.Contact.IsDeleted, sfview.tbl.MasterRecordId=sfsrc.Contact.MasterRecordId, sfview.tbl.LastName=sfsrc.Contact.LastName, sfview.tbl.FirstName=sfsrc.Contact.FirstName, sfview.tbl.Salutation=sfsrc.Contact.Salutation, sfview.tbl.Name=sfsrc.Contact.Name, sfview.tbl.OtherStreet=sfsrc.Contact.OtherStreet, sfview.tbl.OtherCity=sfsrc.Contact.OtherCity, sfview.tbl.OtherState=sfsrc.Contact.OtherState, sfview.tbl.OtherPostalCode=sfsrc.Contact.OtherPostalCode, sfview.tbl.OtherCountry=sfsrc.Contact.OtherCountry, sfview.tbl.MailingStreet=sfsrc.Contact.MailingStreet, sfview.tbl.MailingCity=sfsrc.Contact.MailingCity, sfview.tbl.MailingState=sfsrc.Contact.MailingState, sfview.tbl.MailingPostalCode=sfsrc.Contact.MailingPostalCode, sfview.tbl.MailingCountry=sfsrc.Contact.MailingCountry, sfview.tbl.Phone=sfsrc.Contact.Phone, sfview.tbl.Fax=sfsrc.Contact.Fax, sfview.tbl.MobilePhone=sfsrc.Contact.MobilePhone, sfview.tbl.HomePhone=sfsrc.Contact.HomePhone, sfview.tbl.OtherPhone=sfsrc.Contact.OtherPhone, sfview.tbl.AssistantPhone=sfsrc.Contact.AssistantPhone, sfview.tbl.ReportsToId=sfsrc.Contact.ReportsToId, sfview.tbl.Email=sfsrc.Contact.Email, sfview.tbl.Title=sfsrc.Contact.Title, sfview.tbl.Department=sfsrc.Contact.Department, sfview.tbl.AssistantName=sfsrc.Contact.AssistantName, sfview.tbl.LeadSource=sfsrc.Contact.LeadSource, sfview.tbl.Birthdate=sfsrc.Contact.Birthdate, sfview.tbl.Description=sfsrc.Contact.Description, sfview.tbl.OwnerId=sfsrc.Contact.OwnerId, sfview.tbl.CreatedDate=sfsrc.Contact.CreatedDate, sfview.tbl.CreatedById=sfsrc.Contact.CreatedById, sfview.tbl.LastModifiedDate=sfsrc.Contact.LastModifiedDate, sfview.tbl.LastModifiedById=sfsrc.Contact.LastModifiedById, sfview.tbl.SystemModstamp=sfsrc.Contact.SystemModstamp, sfview.tbl.LastActivityDate=sfsrc.Contact.LastActivityDate, sfview.tbl.LastCURequestDate=sfsrc.Contact.LastCURequestDate, sfview.tbl.LastCUUpdateDate=sfsrc.Contact.LastCUUpdateDate, sfview.tbl.EmailBouncedReason=sfsrc.Contact.EmailBouncedReason, sfview.tbl.EmailBouncedDate=sfsrc.Contact.EmailBouncedDate, sfview.tbl.Jigsaw=sfsrc.Contact.Jigsaw, sfview.tbl.Level__c=sfsrc.Contact.Level__c, sfview.tbl.Languages__c=sfsrc.Contact.Languages__c}}) Project(groups=[sfsrc.Contact], props={PROJECT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c]}) Source(groups=[sfsrc.Contact]) ============================================================================ EXECUTING PlaceAccess AFTER: Project(groups=[sfview.tbl], props={PROJECT_COLS=[sfview.tbl.Id, sfview.tbl.IsDeleted, sfview.tbl.MasterRecordId, sfview.tbl.LastName, sfview.tbl.FirstName, sfview.tbl.Salutation, sfview.tbl.Name, sfview.tbl.OtherStreet, sfview.tbl.OtherCity, sfview.tbl.OtherState, sfview.tbl.OtherPostalCode, sfview.tbl.OtherCountry, sfview.tbl.MailingStreet, sfview.tbl.MailingCity, sfview.tbl.MailingState, sfview.tbl.MailingPostalCode, sfview.tbl.MailingCountry, sfview.tbl.Phone, sfview.tbl.Fax, sfview.tbl.MobilePhone, sfview.tbl.HomePhone, sfview.tbl.OtherPhone, sfview.tbl.AssistantPhone, sfview.tbl.ReportsToId, sfview.tbl.Email, sfview.tbl.Title, sfview.tbl.Department, sfview.tbl.AssistantName, sfview.tbl.LeadSource, sfview.tbl.Birthdate, sfview.tbl.Description, sfview.tbl.OwnerId, sfview.tbl.CreatedDate, sfview.tbl.CreatedById, sfview.tbl.LastModifiedDate, sfview.tbl.LastModifiedById, sfview.tbl.SystemModstamp, sfview.tbl.LastActivityDate, sfview.tbl.LastCURequestDate, sfview.tbl.LastCUUpdateDate, sfview.tbl.EmailBouncedReason, sfview.tbl.EmailBouncedDate, sfview.tbl.Jigsaw, sfview.tbl.Level__c, sfview.tbl.Languages__c]}) Source(groups=[sfview.tbl], props={NESTED_COMMAND=SELECT sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c FROM sfsrc.Contact, SYMBOL_MAP={sfview.tbl.Id=sfsrc.Contact.Id, sfview.tbl.IsDeleted=sfsrc.Contact.IsDeleted, sfview.tbl.MasterRecordId=sfsrc.Contact.MasterRecordId, sfview.tbl.LastName=sfsrc.Contact.LastName, sfview.tbl.FirstName=sfsrc.Contact.FirstName, sfview.tbl.Salutation=sfsrc.Contact.Salutation, sfview.tbl.Name=sfsrc.Contact.Name, sfview.tbl.OtherStreet=sfsrc.Contact.OtherStreet, sfview.tbl.OtherCity=sfsrc.Contact.OtherCity, sfview.tbl.OtherState=sfsrc.Contact.OtherState, sfview.tbl.OtherPostalCode=sfsrc.Contact.OtherPostalCode, sfview.tbl.OtherCountry=sfsrc.Contact.OtherCountry, sfview.tbl.MailingStreet=sfsrc.Contact.MailingStreet, sfview.tbl.MailingCity=sfsrc.Contact.MailingCity, sfview.tbl.MailingState=sfsrc.Contact.MailingState, sfview.tbl.MailingPostalCode=sfsrc.Contact.MailingPostalCode, sfview.tbl.MailingCountry=sfsrc.Contact.MailingCountry, sfview.tbl.Phone=sfsrc.Contact.Phone, sfview.tbl.Fax=sfsrc.Contact.Fax, sfview.tbl.MobilePhone=sfsrc.Contact.MobilePhone, sfview.tbl.HomePhone=sfsrc.Contact.HomePhone, sfview.tbl.OtherPhone=sfsrc.Contact.OtherPhone, sfview.tbl.AssistantPhone=sfsrc.Contact.AssistantPhone, sfview.tbl.ReportsToId=sfsrc.Contact.ReportsToId, sfview.tbl.Email=sfsrc.Contact.Email, sfview.tbl.Title=sfsrc.Contact.Title, sfview.tbl.Department=sfsrc.Contact.Department, sfview.tbl.AssistantName=sfsrc.Contact.AssistantName, sfview.tbl.LeadSource=sfsrc.Contact.LeadSource, sfview.tbl.Birthdate=sfsrc.Contact.Birthdate, sfview.tbl.Description=sfsrc.Contact.Description, sfview.tbl.OwnerId=sfsrc.Contact.OwnerId, sfview.tbl.CreatedDate=sfsrc.Contact.CreatedDate, sfview.tbl.CreatedById=sfsrc.Contact.CreatedById, sfview.tbl.LastModifiedDate=sfsrc.Contact.LastModifiedDate, sfview.tbl.LastModifiedById=sfsrc.Contact.LastModifiedById, sfview.tbl.SystemModstamp=sfsrc.Contact.SystemModstamp, sfview.tbl.LastActivityDate=sfsrc.Contact.LastActivityDate, sfview.tbl.LastCURequestDate=sfsrc.Contact.LastCURequestDate, sfview.tbl.LastCUUpdateDate=sfsrc.Contact.LastCUUpdateDate, sfview.tbl.EmailBouncedReason=sfsrc.Contact.EmailBouncedReason, sfview.tbl.EmailBouncedDate=sfsrc.Contact.EmailBouncedDate, sfview.tbl.Jigsaw=sfsrc.Contact.Jigsaw, sfview.tbl.Level__c=sfsrc.Contact.Level__c, sfview.tbl.Languages__c=sfsrc.Contact.Languages__c}}) Project(groups=[sfsrc.Contact], props={PROJECT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c]}) Access(groups=[sfsrc.Contact], props={SOURCE_HINT=null, MODEL_ID=Schema name=sfsrc, nameInSource=null, uuid=mmuuid:8c94146a-acb8-453a-a0d1-d63e5deacb02}) Source(groups=[sfsrc.Contact]) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[sfview.tbl], props={PROJECT_COLS=[sfview.tbl.Id, sfview.tbl.IsDeleted, sfview.tbl.MasterRecordId, sfview.tbl.LastName, sfview.tbl.FirstName, sfview.tbl.Salutation, sfview.tbl.Name, sfview.tbl.OtherStreet, sfview.tbl.OtherCity, sfview.tbl.OtherState, sfview.tbl.OtherPostalCode, sfview.tbl.OtherCountry, sfview.tbl.MailingStreet, sfview.tbl.MailingCity, sfview.tbl.MailingState, sfview.tbl.MailingPostalCode, sfview.tbl.MailingCountry, sfview.tbl.Phone, sfview.tbl.Fax, sfview.tbl.MobilePhone, sfview.tbl.HomePhone, sfview.tbl.OtherPhone, sfview.tbl.AssistantPhone, sfview.tbl.ReportsToId, sfview.tbl.Email, sfview.tbl.Title, sfview.tbl.Department, sfview.tbl.AssistantName, sfview.tbl.LeadSource, sfview.tbl.Birthdate, sfview.tbl.Description, sfview.tbl.OwnerId, sfview.tbl.CreatedDate, sfview.tbl.CreatedById, sfview.tbl.LastModifiedDate, sfview.tbl.LastModifiedById, sfview.tbl.SystemModstamp, sfview.tbl.LastActivityDate, sfview.tbl.LastCURequestDate, sfview.tbl.LastCUUpdateDate, sfview.tbl.EmailBouncedReason, sfview.tbl.EmailBouncedDate, sfview.tbl.Jigsaw, sfview.tbl.Level__c, sfview.tbl.Languages__c], OUTPUT_COLS=[sfview.tbl.Id, sfview.tbl.IsDeleted, sfview.tbl.MasterRecordId, sfview.tbl.LastName, sfview.tbl.FirstName, sfview.tbl.Salutation, sfview.tbl.Name, sfview.tbl.OtherStreet, sfview.tbl.OtherCity, sfview.tbl.OtherState, sfview.tbl.OtherPostalCode, sfview.tbl.OtherCountry, sfview.tbl.MailingStreet, sfview.tbl.MailingCity, sfview.tbl.MailingState, sfview.tbl.MailingPostalCode, sfview.tbl.MailingCountry, sfview.tbl.Phone, sfview.tbl.Fax, sfview.tbl.MobilePhone, sfview.tbl.HomePhone, sfview.tbl.OtherPhone, sfview.tbl.AssistantPhone, sfview.tbl.ReportsToId, sfview.tbl.Email, sfview.tbl.Title, sfview.tbl.Department, sfview.tbl.AssistantName, sfview.tbl.LeadSource, sfview.tbl.Birthdate, sfview.tbl.Description, sfview.tbl.OwnerId, sfview.tbl.CreatedDate, sfview.tbl.CreatedById, sfview.tbl.LastModifiedDate, sfview.tbl.LastModifiedById, sfview.tbl.SystemModstamp, sfview.tbl.LastActivityDate, sfview.tbl.LastCURequestDate, sfview.tbl.LastCUUpdateDate, sfview.tbl.EmailBouncedReason, sfview.tbl.EmailBouncedDate, sfview.tbl.Jigsaw, sfview.tbl.Level__c, sfview.tbl.Languages__c]}) Source(groups=[sfview.tbl], props={NESTED_COMMAND=SELECT sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c FROM sfsrc.Contact, SYMBOL_MAP={sfview.tbl.Id=sfsrc.Contact.Id, sfview.tbl.IsDeleted=sfsrc.Contact.IsDeleted, sfview.tbl.MasterRecordId=sfsrc.Contact.MasterRecordId, sfview.tbl.LastName=sfsrc.Contact.LastName, sfview.tbl.FirstName=sfsrc.Contact.FirstName, sfview.tbl.Salutation=sfsrc.Contact.Salutation, sfview.tbl.Name=sfsrc.Contact.Name, sfview.tbl.OtherStreet=sfsrc.Contact.OtherStreet, sfview.tbl.OtherCity=sfsrc.Contact.OtherCity, sfview.tbl.OtherState=sfsrc.Contact.OtherState, sfview.tbl.OtherPostalCode=sfsrc.Contact.OtherPostalCode, sfview.tbl.OtherCountry=sfsrc.Contact.OtherCountry, sfview.tbl.MailingStreet=sfsrc.Contact.MailingStreet, sfview.tbl.MailingCity=sfsrc.Contact.MailingCity, sfview.tbl.MailingState=sfsrc.Contact.MailingState, sfview.tbl.MailingPostalCode=sfsrc.Contact.MailingPostalCode, sfview.tbl.MailingCountry=sfsrc.Contact.MailingCountry, sfview.tbl.Phone=sfsrc.Contact.Phone, sfview.tbl.Fax=sfsrc.Contact.Fax, sfview.tbl.MobilePhone=sfsrc.Contact.MobilePhone, sfview.tbl.HomePhone=sfsrc.Contact.HomePhone, sfview.tbl.OtherPhone=sfsrc.Contact.OtherPhone, sfview.tbl.AssistantPhone=sfsrc.Contact.AssistantPhone, sfview.tbl.ReportsToId=sfsrc.Contact.ReportsToId, sfview.tbl.Email=sfsrc.Contact.Email, sfview.tbl.Title=sfsrc.Contact.Title, sfview.tbl.Department=sfsrc.Contact.Department, sfview.tbl.AssistantName=sfsrc.Contact.AssistantName, sfview.tbl.LeadSource=sfsrc.Contact.LeadSource, sfview.tbl.Birthdate=sfsrc.Contact.Birthdate, sfview.tbl.Description=sfsrc.Contact.Description, sfview.tbl.OwnerId=sfsrc.Contact.OwnerId, sfview.tbl.CreatedDate=sfsrc.Contact.CreatedDate, sfview.tbl.CreatedById=sfsrc.Contact.CreatedById, sfview.tbl.LastModifiedDate=sfsrc.Contact.LastModifiedDate, sfview.tbl.LastModifiedById=sfsrc.Contact.LastModifiedById, sfview.tbl.SystemModstamp=sfsrc.Contact.SystemModstamp, sfview.tbl.LastActivityDate=sfsrc.Contact.LastActivityDate, sfview.tbl.LastCURequestDate=sfsrc.Contact.LastCURequestDate, sfview.tbl.LastCUUpdateDate=sfsrc.Contact.LastCUUpdateDate, sfview.tbl.EmailBouncedReason=sfsrc.Contact.EmailBouncedReason, sfview.tbl.EmailBouncedDate=sfsrc.Contact.EmailBouncedDate, sfview.tbl.Jigsaw=sfsrc.Contact.Jigsaw, sfview.tbl.Level__c=sfsrc.Contact.Level__c, sfview.tbl.Languages__c=sfsrc.Contact.Languages__c}, OUTPUT_COLS=[sfview.tbl.Id, sfview.tbl.IsDeleted, sfview.tbl.MasterRecordId, sfview.tbl.LastName, sfview.tbl.FirstName, sfview.tbl.Salutation, sfview.tbl.Name, sfview.tbl.OtherStreet, sfview.tbl.OtherCity, sfview.tbl.OtherState, sfview.tbl.OtherPostalCode, sfview.tbl.OtherCountry, sfview.tbl.MailingStreet, sfview.tbl.MailingCity, sfview.tbl.MailingState, sfview.tbl.MailingPostalCode, sfview.tbl.MailingCountry, sfview.tbl.Phone, sfview.tbl.Fax, sfview.tbl.MobilePhone, sfview.tbl.HomePhone, sfview.tbl.OtherPhone, sfview.tbl.AssistantPhone, sfview.tbl.ReportsToId, sfview.tbl.Email, sfview.tbl.Title, sfview.tbl.Department, sfview.tbl.AssistantName, sfview.tbl.LeadSource, sfview.tbl.Birthdate, sfview.tbl.Description, sfview.tbl.OwnerId, sfview.tbl.CreatedDate, sfview.tbl.CreatedById, sfview.tbl.LastModifiedDate, sfview.tbl.LastModifiedById, sfview.tbl.SystemModstamp, sfview.tbl.LastActivityDate, sfview.tbl.LastCURequestDate, sfview.tbl.LastCUUpdateDate, sfview.tbl.EmailBouncedReason, sfview.tbl.EmailBouncedDate, sfview.tbl.Jigsaw, sfview.tbl.Level__c, sfview.tbl.Languages__c]}) Project(groups=[sfsrc.Contact], props={PROJECT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c], OUTPUT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c]}) Access(groups=[sfsrc.Contact], props={SOURCE_HINT=null, MODEL_ID=Schema name=sfsrc, nameInSource=null, uuid=mmuuid:8c94146a-acb8-453a-a0d1-d63e5deacb02, OUTPUT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c]}) Source(groups=[sfsrc.Contact], props={OUTPUT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c]}) ============================================================================ EXECUTING MergeVirtual AFTER: Project(groups=[sfsrc.Contact], props={PROJECT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c], OUTPUT_COLS=[sfview.tbl.Id, sfview.tbl.IsDeleted, sfview.tbl.MasterRecordId, sfview.tbl.LastName, sfview.tbl.FirstName, sfview.tbl.Salutation, sfview.tbl.Name, sfview.tbl.OtherStreet, sfview.tbl.OtherCity, sfview.tbl.OtherState, sfview.tbl.OtherPostalCode, sfview.tbl.OtherCountry, sfview.tbl.MailingStreet, sfview.tbl.MailingCity, sfview.tbl.MailingState, sfview.tbl.MailingPostalCode, sfview.tbl.MailingCountry, sfview.tbl.Phone, sfview.tbl.Fax, sfview.tbl.MobilePhone, sfview.tbl.HomePhone, sfview.tbl.OtherPhone, sfview.tbl.AssistantPhone, sfview.tbl.ReportsToId, sfview.tbl.Email, sfview.tbl.Title, sfview.tbl.Department, sfview.tbl.AssistantName, sfview.tbl.LeadSource, sfview.tbl.Birthdate, sfview.tbl.Description, sfview.tbl.OwnerId, sfview.tbl.CreatedDate, sfview.tbl.CreatedById, sfview.tbl.LastModifiedDate, sfview.tbl.LastModifiedById, sfview.tbl.SystemModstamp, sfview.tbl.LastActivityDate, sfview.tbl.LastCURequestDate, sfview.tbl.LastCUUpdateDate, sfview.tbl.EmailBouncedReason, sfview.tbl.EmailBouncedDate, sfview.tbl.Jigsaw, sfview.tbl.Level__c, sfview.tbl.Languages__c]}) Access(groups=[sfsrc.Contact], props={SOURCE_HINT=null, MODEL_ID=Schema name=sfsrc, nameInSource=null, uuid=mmuuid:8c94146a-acb8-453a-a0d1-d63e5deacb02, OUTPUT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c]}) Source(groups=[sfsrc.Contact]) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[sfsrc.Contact], props={PROJECT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c], OUTPUT_COLS=null}) Access(groups=[sfsrc.Contact], props={SOURCE_HINT=null, MODEL_ID=Schema name=sfsrc, nameInSource=null, uuid=mmuuid:8c94146a-acb8-453a-a0d1-d63e5deacb02, OUTPUT_COLS=null}) Source(groups=[sfsrc.Contact], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess AFTER: Access(groups=[sfsrc.Contact], props={SOURCE_HINT=null, MODEL_ID=Schema name=sfsrc, nameInSource=null, uuid=mmuuid:8c94146a-acb8-453a-a0d1-d63e5deacb02, OUTPUT_COLS=null}) Project(groups=[sfsrc.Contact], props={PROJECT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c], OUTPUT_COLS=null}) Source(groups=[sfsrc.Contact], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING AssignOutputElements AFTER: Access(groups=[sfsrc.Contact], props={SOURCE_HINT=null, MODEL_ID=Schema name=sfsrc, nameInSource=null, uuid=mmuuid:8c94146a-acb8-453a-a0d1-d63e5deacb02, OUTPUT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c]}) Project(groups=[sfsrc.Contact], props={PROJECT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c], OUTPUT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c]}) Source(groups=[sfsrc.Contact], props={OUTPUT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c]}) ============================================================================ EXECUTING CalculateCost AFTER: Access(groups=[sfsrc.Contact], props={SOURCE_HINT=null, MODEL_ID=Schema name=sfsrc, nameInSource=null, uuid=mmuuid:8c94146a-acb8-453a-a0d1-d63e5deacb02, OUTPUT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c], EST_CARDINALITY=-1.0}) Project(groups=[sfsrc.Contact], props={PROJECT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c], OUTPUT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c], EST_CARDINALITY=-1.0}) Source(groups=[sfsrc.Contact], props={OUTPUT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c], EST_COL_STATS={sfsrc.Contact.Id=[-1.0, -1.0, -1.0], sfsrc.Contact.IsDeleted=[2.0, 2.0, -1.0], sfsrc.Contact.MasterRecordId=[-1.0, -1.0, -1.0], sfsrc.Contact.LastName=[-1.0, -1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING PlanSorts AFTER: Access(groups=[sfsrc.Contact]) Project(groups=[sfsrc.Contact]) Source(groups=[sfsrc.Contact]) ============================================================================ EXECUTING CollapseSource AFTER: Access(groups=[sfsrc.Contact], props={SOURCE_HINT=null, MODEL_ID=Schema name=sfsrc, nameInSource=null, uuid=mmuuid:8c94146a-acb8-453a-a0d1-d63e5deacb02, OUTPUT_COLS=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c FROM sfsrc.Contact}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = AccessNode(0) output=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c] SELECT sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c FROM sfsrc.Contact ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: AccessNode(0) output=[sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c] SELECT sfsrc.Contact.Id, sfsrc.Contact.IsDeleted, sfsrc.Contact.MasterRecordId, sfsrc.Contact.LastName, sfsrc.Contact.FirstName, sfsrc.Contact.Salutation, sfsrc.Contact.Name, sfsrc.Contact.OtherStreet, sfsrc.Contact.OtherCity, sfsrc.Contact.OtherState, sfsrc.Contact.OtherPostalCode, sfsrc.Contact.OtherCountry, sfsrc.Contact.MailingStreet, sfsrc.Contact.MailingCity, sfsrc.Contact.MailingState, sfsrc.Contact.MailingPostalCode, sfsrc.Contact.MailingCountry, sfsrc.Contact.Phone, sfsrc.Contact.Fax, sfsrc.Contact.MobilePhone, sfsrc.Contact.HomePhone, sfsrc.Contact.OtherPhone, sfsrc.Contact.AssistantPhone, sfsrc.Contact.ReportsToId, sfsrc.Contact.Email, sfsrc.Contact.Title, sfsrc.Contact.Department, sfsrc.Contact.AssistantName, sfsrc.Contact.LeadSource, sfsrc.Contact.Birthdate, sfsrc.Contact.Description, sfsrc.Contact.OwnerId, sfsrc.Contact.CreatedDate, sfsrc.Contact.CreatedById, sfsrc.Contact.LastModifiedDate, sfsrc.Contact.LastModifiedById, sfsrc.Contact.SystemModstamp, sfsrc.Contact.LastActivityDate, sfsrc.Contact.LastCURequestDate, sfsrc.Contact.LastCUUpdateDate, sfsrc.Contact.EmailBouncedReason, sfsrc.Contact.EmailBouncedDate, sfsrc.Contact.Jigsaw, sfsrc.Contact.Level__c, sfsrc.Contact.Languages__c FROM sfsrc.Contact ============================================================================

teiid log.txt.zip 8.5 KB
Actions
5. Re: Not able to run query

rareddy Sep 20, 2017 8:54 AM (in response to vijayjose)

There will be more to that log than what you have given us. Seems like you truncated it.
Actions
6. Re: Not able to run query

vijayjose Sep 20, 2017 9:01 AM (in response to rareddy)

This is the complete log after i restarted .whats actually missing?
Actions
7. Re: Not able to run query

rareddy Sep 20, 2017 9:34 AM (in response to vijayjose)

The log stopped in the middle to end of the query plan, there typically is more. Turn on DEBUG mode in the configuration and re-run your query and attach the log as is.
Actions
8. Re: Not able to run query

vijayjose Sep 21, 2017 12:13 AM (in response to rareddy)
Attaching the log in debug mode.

debug log.txt.zip 9.7 KB
Actions
9. Re: Not able to run query

rareddy Sep 21, 2017 9:12 AM (in response to vijayjose)

Is server getting killed? Looks like your JVM heap settings are too low, in standalone.conf change jvm settings to give it more heap, at least 4GB. The current settings are -Xms64m -Xmx512m

Also, looks like you are trying to issue the command before the server is completely started. Also delete or copy all files in "standalone/log" to somewhere else, then restart in DEBUG
in standalone-teiid.xml or standalone.xml (depending upon you are using community or product) in logging subsystem, add/change to

            <logger category="org.teiid">
                <level name="TRACE"/>
            </logger>

save, and start the server and wait for it to start completely then issue the query using a SQL client like SquirreL then attach "server.log" AS IS do not copy to another file etc.
Actions
10. Re: Not able to run query

vijayjose Sep 22, 2017 7:31 AM (in response to rareddy)
Made changes as mentioned above.

Firstly, started the server and run the query ,showing warning.
When starting in debugging mode ,showing warning and not able to run query.
Attaching server.log

server.log.zip 71.5 KB
Actions
11. Re: Not able to run query

shawkins Sep 22, 2017 8:40 AM (in response to vijayjose)

> Firstly, started the server and run the query ,showing warning.

Just to confirm you are using a socket connection into the server correct? There are two sessions that are shown in your log.

C/CDZC4FLZDM issues "SELECT * FROM vdbsf.tbl", an exception is returned then the client kills the connection.

nBL1ALFbSieW issues "SELECT * FROM sfview.tbl" at 2017-09-22 16:42:49,653
A request is sent to salesforce at 2017-09-22 16:42:49,684
The client cancels the request at 2017-09-22 16:45:40,597

In between the source query and the cancel there are a couple of failed pings that seem to indicate the client is an older version - what client jar are you using?

Otherwise we don't see any response from the salesforce source query in that log, so there are no results that could have yet been delivered to the client. We should narrow in on what is going on at the salesforce connector layer. Do all, even small queries, against salesforce seem to have the same issue? What does your vdb and resource adapter configuration look like for salesforce? Are the both salesforce-34, or just salesforce?
Actions
12. Re: Not able to run query

vijayjose Sep 22, 2017 9:20 AM (in response to shawkins)

client jar is 9.3.1
resource-adapter is salesforce.
Actions
13. Re: Not able to run query

shawkins Sep 22, 2017 9:54 AM (in response to vijayjose)

> client jar is 9.3.1

That seems quite odd. You shouldn't get a message like:

2017-09-22 16:43:10,420 WARN [org.teiid.SECURITY] (NIO2) TEIID40011 Processing exception 'TEIID40042 Invalid Session 64aWH8KspT9u. Session may have already been terminated.' for session null. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347).: org.teiid.client.security.InvalidSessionException: TEIID40042 Invalid Session 64aWH8KspT9u. Session may have already been terminated.
at org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347)
at org.teiid.services.SessionServiceImpl.validateSession(SessionServiceImpl.java:336)
at org.teiid.transport.LogonImpl.assertIdentity(LogonImpl.java:288)

Unless the client is an older version. This however is not a major concern as the real issue is that you aren't seeing a response back from salesforce.

> resource-adapter is salesforce.

And what about other salesforce queries, is anything successful?
Actions
14. Re: Not able to run query

vijayjose Sep 22, 2017 11:43 PM (in response to shawkins)

No,all have the same result.
Actions

1 2 Previous Next

Go to original post