2016-04-02 16:02:31,747 INFO [org.jboss.modules] (main) JBoss Modules version 1.5.0.Final 2016-04-02 16:02:33,482 INFO [org.jboss.msc] (main) JBoss MSC version 1.2.6.Final 2016-04-02 16:02:33,735 INFO [org.jboss.as] (MSC service thread 1-7) WFLYSRV0049: WildFly Full 10.0.0.CR5 (WildFly Core 2.0.5.Final) starting 2016-04-02 16:02:33,736 DEBUG [org.jboss.as.config] (MSC service thread 1-7) Configured system properties: awt.toolkit = sun.awt.windows.WToolkit file.encoding = Cp1251 file.encoding.pkg = sun.io file.separator = \ java.awt.graphicsenv = sun.awt.Win32GraphicsEnvironment java.awt.printerjob = sun.awt.windows.WPrinterJob java.class.path = F:\Servers\Wildfly10CR5\jboss-modules.jar java.class.version = 52.0 java.endorsed.dirs = C:\Program Files\Java\jdk1.8.0_65\jre\lib\endorsed java.ext.dirs = C:\Program Files\Java\jdk1.8.0_65\jre\lib\ext;C:\Windows\Sun\Java\lib\ext java.home = C:\Program Files\Java\jdk1.8.0_65\jre java.io.tmpdir = C:\Users\MESSIE~1\AppData\Local\Temp\ java.library.path = C:\Program Files\Java\jdk1.8.0_65\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\AMD\ATI.ACE\Core-Static;C:\Program Files (x86)\Skype\Phone\;C:\Program Files\TortoiseGit\bin;C:\Windows\system32\config\systemprofile\.dnx\bin;C:\Program Files\Microsoft DNX\Dnvm\;C:\Program Files\Perforce;C:\Program Files\nodejs\;C:\Program Files\Git\cmd;C:\Program Files (x86)\EaseUS\Todo Backup\bin;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Users\Messier82\AppData\Roaming\npm;. java.net.preferIPv4Stack = true java.runtime.name = Java(TM) SE Runtime Environment java.runtime.version = 1.8.0_65-b17 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_65 java.vm.info = mixed mode java.vm.name = Java HotSpot(TM) 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.65-b01 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.home.dir = F:\Servers\Wildfly10CR5 jboss.host.name = desktop-i27ptus jboss.modules.dir = F:\Servers\Wildfly10CR5\modules jboss.modules.system.pkgs = org.jboss.byteman jboss.node.name = desktop-i27ptus jboss.qualified.host.name = desktop-i27ptus jboss.server.base.dir = F:\Servers\Wildfly10CR5\standalone jboss.server.config.dir = F:\Servers\Wildfly10CR5\standalone\configuration jboss.server.data.dir = F:\Servers\Wildfly10CR5\standalone\data jboss.server.deploy.dir = F:\Servers\Wildfly10CR5\standalone\data\content jboss.server.log.dir = F:\Servers\Wildfly10CR5\standalone\log jboss.server.name = desktop-i27ptus jboss.server.persist.config = true jboss.server.temp.dir = F:\Servers\Wildfly10CR5\standalone\tmp line.separator = logging.configuration = file:F:\Servers\Wildfly10CR5\standalone\configuration/logging.properties module.path = F:\Servers\Wildfly10CR5\modules org.jboss.boot.log.file = F:\Servers\Wildfly10CR5\standalone\log\server.log org.jboss.resolver.warning = true org.xml.sax.driver = __redirected.__XMLReaderFactory os.arch = amd64 os.name = Windows 10 os.version = 10.0 path.separator = ; program.name = standalone.bat sun.arch.data.model = 64 sun.boot.class.path = C:\Program Files\Java\jdk1.8.0_65\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_65\jre\lib\rt.jar;C:\Program Files\Java\jdk1.8.0_65\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.8.0_65\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_65\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_65\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_65\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_65\jre\classes sun.boot.library.path = C:\Program Files\Java\jdk1.8.0_65\jre\bin sun.cpu.endian = little sun.cpu.isalist = amd64 sun.desktop = windows sun.io.unicode.encoding = UnicodeLittle sun.java.command = F:\Servers\Wildfly10CR5\jboss-modules.jar -mp F:\Servers\Wildfly10CR5\modules org.jboss.as.standalone -Djboss.home.dir=F:\Servers\Wildfly10CR5 sun.java.launcher = SUN_STANDARD sun.jnu.encoding = Cp1251 sun.management.compiler = HotSpot 64-Bit Tiered Compilers sun.os.patch.level = user.country = US user.dir = F:\Servers\Wildfly10CR5\bin user.home = C:\Users\Messier82 user.language = en user.name = Messier82 user.script = user.timezone = Europe/Helsinki user.variant = 2016-04-02 16:02:36,633 DEBUG [org.jboss.as.config] (MSC service thread 1-7) VM Arguments: -Dprogram.name=standalone.bat -Xms64M -Xmx512M -Djava.net.preferIPv4Stack=true -Djboss.modules.system.pkgs=org.jboss.byteman -Dorg.jboss.boot.log.file=F:\Servers\Wildfly10CR5\standalone\log\server.log -Dlogging.configuration=file:F:\Servers\Wildfly10CR5\standalone\configuration/logging.properties 2016-04-02 16:02:39,279 INFO [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0039: Creating http management service using socket-binding (management-http) 2016-04-02 16:02:39,333 INFO [org.xnio] (MSC service thread 1-1) XNIO version 3.3.4.Final 2016-04-02 16:02:39,352 INFO [org.xnio.nio] (MSC service thread 1-1) XNIO NIO Implementation Version 3.3.4.Final 2016-04-02 16:02:39,377 WARN [org.jboss.as.txn] (ServerService Thread Pool -- 54) WFLYTX0013: Node identifier property is set to the default value. Please make sure it is unique. 2016-04-02 16:02:39,389 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 46) WFLYNAM0001: Activating Naming Subsystem 2016-04-02 16:02:39,394 INFO [org.jboss.as.security] (ServerService Thread Pool -- 53) WFLYSEC0002: Activating Security Subsystem 2016-04-02 16:02:39,395 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 38) WFLYCLINF0001: Activating Infinispan subsystem. 2016-04-02 16:02:39,403 INFO [org.jboss.as.security] (MSC service thread 1-3) WFLYSEC0001: Current PicketBox version=4.9.4.Final 2016-04-02 16:02:39,408 INFO [org.jboss.as.jsf] (ServerService Thread Pool -- 44) WFLYJSF0007: Activated the following JSF Implementations: [main] 2016-04-02 16:02:39,412 INFO [org.wildfly.extension.io] (ServerService Thread Pool -- 37) WFLYIO001: Worker 'default' has auto-configured to 8 core threads with 64 task threads based on your 4 available processors 2016-04-02 16:02:39,532 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 56) WFLYWS0002: Activating WebServices Extension 2016-04-02 16:02:39,582 INFO [org.jboss.as.connector] (MSC service thread 1-6) WFLYJCA0009: Starting JCA Subsystem (WildFly/IronJacamar 1.3.1.Final) 2016-04-02 16:02:39,651 INFO [org.jboss.as.naming] (MSC service thread 1-8) WFLYNAM0003: Starting Naming Service 2016-04-02 16:02:39,686 INFO [org.jboss.as.mail.extension] (MSC service thread 1-4) WFLYMAIL0001: Bound mail session [java:jboss/mail/Default] 2016-04-02 16:02:39,800 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 33) WFLYJCA0005: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1) 2016-04-02 16:02:39,864 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 55) WFLYUT0003: Undertow 1.3.11.Final starting 2016-04-02 16:02:39,867 INFO [org.wildfly.extension.undertow] (MSC service thread 1-4) WFLYUT0003: Undertow 1.3.11.Final starting 2016-04-02 16:02:39,868 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-6) WFLYJCA0018: Started Driver service with driver-name = MySqlJDBCDriver 2016-04-02 16:02:39,884 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 33) WFLYJCA0004: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3) 2016-04-02 16:02:39,885 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) WFLYJCA0018: Started Driver service with driver-name = h2 2016-04-02 16:02:39,993 INFO [org.jboss.remoting] (MSC service thread 1-1) JBoss Remoting version 4.0.17.Final-wildfly-1 2016-04-02 16:02:40,134 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 55) WFLYUT0014: Creating file handler for path 'F:\Servers\Wildfly10CR5/welcome-content' with options [directory-listing: 'false', follow-symlink: 'false', case-sensitive: 'true', safe-symlink-paths: '[]'] 2016-04-02 16:02:40,194 INFO [org.wildfly.extension.undertow] (MSC service thread 1-5) WFLYUT0012: Started server default-server. 2016-04-02 16:02:40,195 INFO [org.wildfly.extension.undertow] (MSC service thread 1-1) WFLYUT0018: Host default-host starting 2016-04-02 16:02:40,329 INFO [org.wildfly.extension.undertow] (MSC service thread 1-7) WFLYUT0006: Undertow HTTP listener default listening on 0.0.0.0:8180 2016-04-02 16:02:40,418 INFO [org.jboss.as.ejb3] (MSC service thread 1-1) 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. 2016-04-02 16:02:40,417 INFO [org.jboss.as.ejb3] (MSC service thread 1-8) 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. 2016-04-02 16:02:40,512 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-7) WFLYJCA0001: Bound data source [java:jboss/datasources/ExampleDS] 2016-04-02 16:02:40,512 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-1) WFLYJCA0001: Bound data source [java:jboss/datasources/pvcomplete] 2016-04-02 16:02:40,513 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-7) WFLYJCA0001: Bound data source [java:jboss/datasources/hardware] 2016-04-02 16:02:40,769 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-3) WFLYDS0013: Started FileSystemDeploymentService for directory F:\Servers\Wildfly10CR5\standalone\deployments 2016-04-02 16:02:40,777 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) WFLYSRV0027: Starting deployment of "pvsketch.war" (runtime-name: "pvsketch.war") 2016-04-02 16:02:41,107 INFO [org.infinispan.factories.GlobalComponentRegistry] (MSC service thread 1-4) ISPN000128: Infinispan version: Infinispan 'Mahou' 8.1.0.Final 2016-04-02 16:02:41,105 INFO [org.infinispan.factories.GlobalComponentRegistry] (MSC service thread 1-6) ISPN000128: Infinispan version: Infinispan 'Mahou' 8.1.0.Final 2016-04-02 16:02:41,249 INFO [org.jboss.ws.common.management] (MSC service thread 1-1) JBWS022052: Starting JBossWS 5.1.2.Final (Apache CXF 3.1.4) 2016-04-02 16:02:44,432 INFO [org.jboss.as.jpa] (MSC service thread 1-3) WFLYJPA0002: Read persistence.xml for pvsketchPrimaryPU 2016-04-02 16:02:44,433 INFO [org.jboss.as.jpa] (MSC service thread 1-3) WFLYJPA0002: Read persistence.xml for hardwareDBPU 2016-04-02 16:02:44,652 WARN [org.jboss.as.dependency.private] (MSC service thread 1-4) WFLYSRV0018: Deployment "deployment.pvsketch.war" is using a private module ("org.infinispan:main") which may be changed or removed in future versions without notice. 2016-04-02 16:02:44,707 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 58) WFLYJPA0010: Starting Persistence Unit (phase 1 of 2) Service 'pvsketch.war#hardwareDBPU' 2016-04-02 16:02:44,707 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 59) WFLYJPA0010: Starting Persistence Unit (phase 1 of 2) Service 'pvsketch.war#pvsketchPrimaryPU' 2016-04-02 16:02:44,834 INFO [org.hibernate.jpa.internal.util.LogHelper] (ServerService Thread Pool -- 59) HHH000204: Processing PersistenceUnitInfo [ name: pvsketchPrimaryPU ...] 2016-04-02 16:02:44,836 INFO [org.hibernate.jpa.internal.util.LogHelper] (ServerService Thread Pool -- 58) HHH000204: Processing PersistenceUnitInfo [ name: hardwareDBPU ...] 2016-04-02 16:02:45,059 INFO [org.jboss.weld.deployer] (MSC service thread 1-1) WFLYWELD0003: Processing weld deployment pvsketch.war 2016-04-02 16:02:45,184 INFO [org.hibernate.Version] (ServerService Thread Pool -- 59) HHH000412: Hibernate Core {5.0.6.Final} 2016-04-02 16:02:45,185 INFO [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 59) HHH000206: hibernate.properties not found 2016-04-02 16:02:45,187 INFO [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 59) HHH000021: Bytecode provider name : javassist 2016-04-02 16:02:45,235 INFO [org.hibernate.validator.internal.util.Version] (MSC service thread 1-1) HV000001: Hibernate Validator 5.2.2.Final 2016-04-02 16:02:45,243 INFO [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 59) HHH90000001: Found usage of deprecated setting for specifying Scanner [hibernate.ejb.resource_scanner]; use [hibernate.archive.scanner] instead 2016-04-02 16:02:45,244 INFO [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 58) HHH90000001: Found usage of deprecated setting for specifying Scanner [hibernate.ejb.resource_scanner]; use [hibernate.archive.scanner] instead 2016-04-02 16:02:45,261 INFO [org.hibernate.annotations.common.Version] (ServerService Thread Pool -- 59) HCANN000001: Hibernate Commons Annotations {5.0.1.Final} 2016-04-02 16:02:45,402 INFO [org.apache.deltaspike.core.impl.config.EnvironmentPropertyConfigSourceProvider] (MSC service thread 1-1) Custom config found by DeltaSpike. Name: 'META-INF/apache-deltaspike.properties', URL: 'vfs:/F:/Servers/Wildfly10CR5/bin/content/pvsketch.war/WEB-INF/classes/META-INF/apache-deltaspike.properties' 2016-04-02 16:02:45,403 INFO [org.apache.deltaspike.core.impl.config.EnvironmentPropertyConfigSourceProvider] (MSC service thread 1-1) Custom config found by DeltaSpike. Name: 'META-INF/apache-deltaspike.properties', URL: 'vfs:/F:/Servers/Wildfly10CR5/bin/content/pvsketch.war/WEB-INF/lib/deltaspike-jpa-module-impl-1.5.4.jar/META-INF/apache-deltaspike.properties' 2016-04-02 16:02:45,406 INFO [org.apache.deltaspike.core.util.ProjectStageProducer] (MSC service thread 1-1) Computed the following DeltaSpike ProjectStage: Production 2016-04-02 16:02:45,414 INFO [org.jboss.as.ejb3.deployment] (MSC service thread 1-1) WFLYEJB0473: JNDI bindings for session bean named 'EmailPeriodicTimer' in deployment unit 'deployment "pvsketch.war"' are as follows: java:global/pvsketch/EmailPeriodicTimer!com.pvcomplete.pvsketch.api.core.util.EmailPeriodicTimer java:app/pvsketch/EmailPeriodicTimer!com.pvcomplete.pvsketch.api.core.util.EmailPeriodicTimer java:module/EmailPeriodicTimer!com.pvcomplete.pvsketch.api.core.util.EmailPeriodicTimer java:global/pvsketch/EmailPeriodicTimer java:app/pvsketch/EmailPeriodicTimer java:module/EmailPeriodicTimer 2016-04-02 16:02:45,750 WARN [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-6) WFLYJCA0003: Unable to instantiate driver class "org.olap4j.driver.xmla.XmlaOlap4jDriver": java.lang.NoSuchMethodException: org.olap4j.driver.xmla.XmlaOlap4jDriver.() 2016-04-02 16:02:45,751 INFO [org.jboss.weld.deployer] (MSC service thread 1-6) WFLYWELD0006: Starting Services for CDI deployment: pvsketch.war 2016-04-02 16:02:45,828 INFO [org.jboss.weld.Version] (MSC service thread 1-6) WELD-000900: 2.3.2 (Final) 2016-04-02 16:02:45,854 INFO [org.jboss.weld.deployer] (MSC service thread 1-3) WFLYWELD0009: Starting weld service for deployment pvsketch.war 2016-04-02 16:02:46,094 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 58) WFLYJPA0010: Starting Persistence Unit (phase 2 of 2) Service 'pvsketch.war#hardwareDBPU' 2016-04-02 16:02:46,094 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 59) WFLYJPA0010: Starting Persistence Unit (phase 2 of 2) Service 'pvsketch.war#pvsketchPrimaryPU' 2016-04-02 16:02:48,446 INFO [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 58) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2016-04-02 16:02:48,446 INFO [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 59) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2016-04-02 16:02:48,516 INFO [org.hibernate.envers.boot.internal.EnversServiceImpl] (ServerService Thread Pool -- 58) Envers integration enabled? : true 2016-04-02 16:02:48,516 INFO [org.hibernate.envers.boot.internal.EnversServiceImpl] (ServerService Thread Pool -- 59) Envers integration enabled? : true 2016-04-02 16:02:48,818 WARN [org.hibernate.boot.internal.SessionFactoryBuilderImpl] (ServerService Thread Pool -- 59) Unrecognized hbm2ddl_auto value : none. Supported values include create, create-drop, update, and validate. Ignoring 2016-04-02 16:02:48,818 WARN [org.hibernate.boot.internal.SessionFactoryBuilderImpl] (ServerService Thread Pool -- 58) Unrecognized hbm2ddl_auto value : none. Supported values include create, create-drop, update, and validate. Ignoring 2016-04-02 16:02:49,292 INFO [org.hibernate.hql.internal.QueryTranslatorFactoryInitiator] (ServerService Thread Pool -- 59) HHH000397: Using ASTQueryTranslatorFactory 2016-04-02 16:02:49,425 INFO [org.jboss.weld.Event] (MSC service thread 1-3) WELD-000411: Observer method [BackedAnnotatedMethod] protected org.apache.deltaspike.core.impl.interceptor.GlobalInterceptorExtension.promoteInterceptors(@Observes ProcessAnnotatedType, BeanManager) receives events for all annotated types. Consider restricting events using @WithAnnotations or a generic type with bounds. 2016-04-02 16:02:49,449 INFO [org.jboss.weld.Event] (MSC service thread 1-3) WELD-000411: Observer method [BackedAnnotatedMethod] public org.apache.deltaspike.partialbean.impl.PartialBeanBindingExtension.findInvocationHandlerBindings(@Observes ProcessAnnotatedType, BeanManager) receives events for all annotated types. Consider restricting events using @WithAnnotations or a generic type with bounds. 2016-04-02 16:02:49,466 INFO [org.jboss.weld.Event] (MSC service thread 1-3) WELD-000411: Observer method [BackedAnnotatedMethod] org.apache.deltaspike.data.impl.RepositoryExtension.processAnnotatedType(@Observes ProcessAnnotatedType) receives events for all annotated types. Consider restricting events using @WithAnnotations or a generic type with bounds. 2016-04-02 16:02:49,476 INFO [org.jboss.weld.Event] (MSC service thread 1-3) WELD-000411: Observer method [BackedAnnotatedMethod] protected org.apache.deltaspike.core.impl.exclude.extension.ExcludeExtension.vetoBeans(@Observes ProcessAnnotatedType, BeanManager) receives events for all annotated types. Consider restricting events using @WithAnnotations or a generic type with bounds. 2016-04-02 16:02:49,484 INFO [org.jboss.weld.Event] (MSC service thread 1-3) WELD-000411: Observer method [BackedAnnotatedMethod] protected org.apache.deltaspike.core.impl.message.MessageBundleExtension.detectInterfaces(@Observes ProcessAnnotatedType) receives events for all annotated types. Consider restricting events using @WithAnnotations or a generic type with bounds. 2016-04-02 16:02:49,974 INFO [org.apache.deltaspike.core.impl.exclude.extension.ExcludeExtension] (MSC service thread 1-3) org.apache.deltaspike.jpa.impl.transaction.BeanManagedUserTransactionStrategy is configured as global-alternative 2016-04-02 16:02:50,118 WARN [org.jboss.weld.Validator] (MSC service thread 1-3) WELD-001478: Interceptor class org.apache.deltaspike.jpa.impl.transaction.TransactionalInterceptor is enabled for the application and for the bean archive pvsketch.war/WEB-INF/lib/deltaspike-jpa-module-impl-1.5.4.jar. It will only be invoked in the @Priority part of the chain. 2016-04-02 16:02:50,530 WARN [org.jboss.as.mail.extension] (MSC service thread 1-2) WFLYMAIL0009: Host name [mx.int] could not be resolved! 2016-04-02 16:02:50,563 INFO [org.jboss.weld.Bootstrap] (Weld Thread Pool -- 2) WELD-001125: Illegal bean type org.apache.deltaspike.data.impl.meta.verifier.Verifier> ignored on [EnhancedAnnotatedTypeImpl] public class org.apache.deltaspike.data.impl.meta.verifier.EntityVerifier 2016-04-02 16:02:51,556 INFO [stdout] (ServerService Thread Pool -- 62) Hibernate: 2016-04-02 16:02:51,557 INFO [stdout] (ServerService Thread Pool -- 62) select 2016-04-02 16:02:51,557 INFO [stdout] (ServerService Thread Pool -- 62) profile0_.profileId as profileI1_10_, 2016-04-02 16:02:51,557 INFO [stdout] (ServerService Thread Pool -- 62) profile0_.category as category2_10_, 2016-04-02 16:02:51,557 INFO [stdout] (ServerService Thread Pool -- 62) profile0_.description as descript3_10_, 2016-04-02 16:02:51,557 INFO [stdout] (ServerService Thread Pool -- 62) profile0_.name as name4_10_, 2016-04-02 16:02:51,557 INFO [stdout] (ServerService Thread Pool -- 62) profile0_.value as value5_10_, 2016-04-02 16:02:51,557 INFO [stdout] (ServerService Thread Pool -- 62) profile0_.worksFrom as worksFro6_10_, 2016-04-02 16:02:51,557 INFO [stdout] (ServerService Thread Pool -- 62) profile0_.worksTill as worksTil7_10_ 2016-04-02 16:02:51,557 INFO [stdout] (ServerService Thread Pool -- 62) from 2016-04-02 16:02:51,557 INFO [stdout] (ServerService Thread Pool -- 62) Profile profile0_ 2016-04-02 16:02:51,557 INFO [stdout] (ServerService Thread Pool -- 62) where 2016-04-02 16:02:51,557 INFO [stdout] (ServerService Thread Pool -- 62) profile0_.name=? 2016-04-02 16:02:51,557 INFO [stdout] (ServerService Thread Pool -- 62) and ( 2016-04-02 16:02:51,558 INFO [stdout] (ServerService Thread Pool -- 62) profile0_.worksFrom is null 2016-04-02 16:02:51,558 INFO [stdout] (ServerService Thread Pool -- 62) or profile0_.worksFrom<=? 2016-04-02 16:02:51,558 INFO [stdout] (ServerService Thread Pool -- 62) ) 2016-04-02 16:02:51,558 INFO [stdout] (ServerService Thread Pool -- 62) and ( 2016-04-02 16:02:51,558 INFO [stdout] (ServerService Thread Pool -- 62) profile0_.worksTill is null 2016-04-02 16:02:51,558 INFO [stdout] (ServerService Thread Pool -- 62) or profile0_.worksTill>? 2016-04-02 16:02:51,558 INFO [stdout] (ServerService Thread Pool -- 62) ) 2016-04-02 16:02:51,953 INFO [com.pvcomplete.pvsketch.api.core.util.EmailPeriodicTimer] (ServerService Thread Pool -- 62) EmailPeriodicTimer scheduled: ScheduleExpression[second=0 minute=0/2 hour=* dayOfWeek=* dayOfMonth=* month=* year=* start=null end=null timezone=] 2016-04-02 16:02:52,189 INFO [io.undertow.servlet] (ServerService Thread Pool -- 62) Initializing Shiro environment 2016-04-02 16:02:52,189 INFO [org.apache.shiro.web.env.EnvironmentLoader] (ServerService Thread Pool -- 62) Starting Shiro environment initialization. 2016-04-02 16:02:52,695 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 62) WFLYCLINF0002: Started jpaRealm.authorizationCache cache from api container 2016-04-02 16:02:52,699 INFO [org.apache.shiro.config.IniSecurityManagerFactory] (ServerService Thread Pool -- 62) Realms have been explicitly set on the SecurityManager instance - auto-setting of realms will not occur. 2016-04-02 16:02:52,703 INFO [org.apache.shiro.web.env.EnvironmentLoader] (ServerService Thread Pool -- 62) Shiro environment initialized in 512 ms. 2016-04-02 16:02:52,731 INFO [javax.enterprise.resource.webcontainer.jsf.config] (ServerService Thread Pool -- 62) Initializing Mojarra 2.2.12-jbossorg-2 20150729-1131 for context '/pvsketch' 2016-04-02 16:02:54,324 WARN [org.jboss.as.weld] (ServerService Thread Pool -- 62) WFLYWELD0052: Using deployment classloader to load proxy classes for module org.jboss.resteasy.resteasy-jaxrs:main. Package-private access will not work. To fix this the module should declare dependencies on [org.jboss.weld.core, org.jboss.weld.spi] 2016-04-02 16:02:54,636 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002225: Deploying javax.ws.rs.core.Application: class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,637 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.AnonymousResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,638 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.InverterResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,638 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.LocaleResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,638 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.ManufacturerResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,638 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.UtilityProviderResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,638 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.BusinessResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,638 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.ProjectDetailsResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,638 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002205: Adding provider class com.pvcomplete.pvsketch.api.presentation.services.StringMessageBodyWriter from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,638 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.AuthResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,638 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.TestResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,638 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.CustomerResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,638 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.AdminResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,639 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002205: Adding provider class com.pvcomplete.pvsketch.api.presentation.services.AppExceptionMapper from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,640 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.UserResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,640 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.PVModuleResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,640 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002205: Adding provider class com.pvcomplete.pvsketch.api.presentation.services.BooleanMessageBodyWriter from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,640 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.ProjectResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,641 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 62) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.ReportResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:02:54,702 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 62) WFLYUT0021: Registered web context: /pvsketch 2016-04-02 16:02:54,772 INFO [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0010: Deployed "pvsketch.war" (runtime-name : "pvsketch.war") 2016-04-02 16:02:54,947 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http management interface listening on http://0.0.0.0:10090/management 2016-04-02 16:02:54,948 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0051: Admin console listening on http://0.0.0.0:10090 2016-04-02 16:02:54,948 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0025: WildFly Full 10.0.0.CR5 (WildFly Core 2.0.5.Final) started in 24483ms - Started 500 of 861 services (467 services are lazy, passive or on-demand) 2016-04-02 16:02:55,284 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 19) WFLYUT0022: Unregistered web context: /pvsketch 2016-04-02 16:02:55,296 INFO [io.undertow.servlet] (ServerService Thread Pool -- 19) Cleaning up Shiro Environment 2016-04-02 16:02:55,308 INFO [org.jboss.weld.deployer] (MSC service thread 1-1) WFLYWELD0010: Stopping weld service for deployment pvsketch.war 2016-04-02 16:02:55,319 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 19) WFLYJPA0011: Stopping Persistence Unit (phase 2 of 2) Service 'pvsketch.war#hardwareDBPU' 2016-04-02 16:02:55,320 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 13) WFLYJPA0011: Stopping Persistence Unit (phase 2 of 2) Service 'pvsketch.war#pvsketchPrimaryPU' 2016-04-02 16:02:55,324 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 19) WFLYJPA0011: Stopping Persistence Unit (phase 1 of 2) Service 'pvsketch.war#pvsketchPrimaryPU' 2016-04-02 16:02:55,325 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 13) WFLYJPA0011: Stopping Persistence Unit (phase 1 of 2) Service 'pvsketch.war#hardwareDBPU' 2016-04-02 16:02:55,446 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) WFLYSRV0028: Stopped deployment pvsketch.war (runtime-name: pvsketch.war) in 167ms 2016-04-02 16:02:55,528 INFO [org.jboss.as.server] (management-handler-thread - 4) WFLYSRV0009: Undeployed "pvsketch.war" (runtime-name: "pvsketch.war") 2016-04-02 16:02:55,589 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) WFLYSRV0027: Starting deployment of "pvsketch.war" (runtime-name: "pvsketch.war") 2016-04-02 16:02:57,466 INFO [org.jboss.as.jpa] (MSC service thread 1-8) WFLYJPA0002: Read persistence.xml for pvsketchPrimaryPU 2016-04-02 16:02:57,466 INFO [org.jboss.as.jpa] (MSC service thread 1-8) WFLYJPA0002: Read persistence.xml for hardwareDBPU 2016-04-02 16:02:57,562 WARN [org.jboss.as.dependency.private] (MSC service thread 1-6) WFLYSRV0018: Deployment "deployment.pvsketch.war" is using a private module ("org.infinispan:main") which may be changed or removed in future versions without notice. 2016-04-02 16:02:57,564 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 19) WFLYJPA0010: Starting Persistence Unit (phase 1 of 2) Service 'pvsketch.war#hardwareDBPU' 2016-04-02 16:02:57,564 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 13) WFLYJPA0010: Starting Persistence Unit (phase 1 of 2) Service 'pvsketch.war#pvsketchPrimaryPU' 2016-04-02 16:02:57,564 INFO [org.hibernate.jpa.internal.util.LogHelper] (ServerService Thread Pool -- 19) HHH000204: Processing PersistenceUnitInfo [ name: hardwareDBPU ...] 2016-04-02 16:02:57,564 INFO [org.hibernate.jpa.internal.util.LogHelper] (ServerService Thread Pool -- 13) HHH000204: Processing PersistenceUnitInfo [ name: pvsketchPrimaryPU ...] 2016-04-02 16:02:57,568 INFO [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 19) HHH90000001: Found usage of deprecated setting for specifying Scanner [hibernate.ejb.resource_scanner]; use [hibernate.archive.scanner] instead 2016-04-02 16:02:57,571 INFO [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 13) HHH90000001: Found usage of deprecated setting for specifying Scanner [hibernate.ejb.resource_scanner]; use [hibernate.archive.scanner] instead 2016-04-02 16:02:57,586 INFO [org.jboss.weld.deployer] (MSC service thread 1-5) WFLYWELD0003: Processing weld deployment pvsketch.war 2016-04-02 16:02:57,607 INFO [org.apache.deltaspike.core.impl.config.EnvironmentPropertyConfigSourceProvider] (MSC service thread 1-5) Custom config found by DeltaSpike. Name: 'META-INF/apache-deltaspike.properties', URL: 'vfs:/F:/Servers/Wildfly10CR5/bin/content/pvsketch.war/WEB-INF/classes/META-INF/apache-deltaspike.properties' 2016-04-02 16:02:57,608 INFO [org.apache.deltaspike.core.impl.config.EnvironmentPropertyConfigSourceProvider] (MSC service thread 1-5) Custom config found by DeltaSpike. Name: 'META-INF/apache-deltaspike.properties', URL: 'vfs:/F:/Servers/Wildfly10CR5/bin/content/pvsketch.war/WEB-INF/lib/deltaspike-jpa-module-impl-1.5.4.jar/META-INF/apache-deltaspike.properties' 2016-04-02 16:02:57,612 INFO [org.apache.deltaspike.core.util.ProjectStageProducer] (MSC service thread 1-5) Computed the following DeltaSpike ProjectStage: Production 2016-04-02 16:02:57,620 INFO [org.jboss.as.ejb3.deployment] (MSC service thread 1-5) WFLYEJB0473: JNDI bindings for session bean named 'EmailPeriodicTimer' in deployment unit 'deployment "pvsketch.war"' are as follows: java:global/pvsketch/EmailPeriodicTimer!com.pvcomplete.pvsketch.api.core.util.EmailPeriodicTimer java:app/pvsketch/EmailPeriodicTimer!com.pvcomplete.pvsketch.api.core.util.EmailPeriodicTimer java:module/EmailPeriodicTimer!com.pvcomplete.pvsketch.api.core.util.EmailPeriodicTimer java:global/pvsketch/EmailPeriodicTimer java:app/pvsketch/EmailPeriodicTimer java:module/EmailPeriodicTimer 2016-04-02 16:02:57,691 WARN [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-2) WFLYJCA0003: Unable to instantiate driver class "org.olap4j.driver.xmla.XmlaOlap4jDriver": java.lang.NoSuchMethodException: org.olap4j.driver.xmla.XmlaOlap4jDriver.() 2016-04-02 16:02:57,692 INFO [org.jboss.weld.deployer] (MSC service thread 1-2) WFLYWELD0006: Starting Services for CDI deployment: pvsketch.war 2016-04-02 16:02:57,695 INFO [org.jboss.weld.deployer] (MSC service thread 1-3) WFLYWELD0009: Starting weld service for deployment pvsketch.war 2016-04-02 16:02:57,921 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 19) WFLYJPA0010: Starting Persistence Unit (phase 2 of 2) Service 'pvsketch.war#hardwareDBPU' 2016-04-02 16:02:57,923 INFO [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 19) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2016-04-02 16:02:57,942 INFO [org.hibernate.envers.boot.internal.EnversServiceImpl] (ServerService Thread Pool -- 19) Envers integration enabled? : true 2016-04-02 16:02:57,949 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 13) WFLYJPA0010: Starting Persistence Unit (phase 2 of 2) Service 'pvsketch.war#pvsketchPrimaryPU' 2016-04-02 16:02:57,950 INFO [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 13) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2016-04-02 16:02:57,959 INFO [org.hibernate.envers.boot.internal.EnversServiceImpl] (ServerService Thread Pool -- 13) Envers integration enabled? : true 2016-04-02 16:02:57,955 WARN [org.hibernate.boot.internal.SessionFactoryBuilderImpl] (ServerService Thread Pool -- 19) Unrecognized hbm2ddl_auto value : none. Supported values include create, create-drop, update, and validate. Ignoring 2016-04-02 16:02:58,019 WARN [org.hibernate.boot.internal.SessionFactoryBuilderImpl] (ServerService Thread Pool -- 13) Unrecognized hbm2ddl_auto value : none. Supported values include create, create-drop, update, and validate. Ignoring 2016-04-02 16:02:58,124 INFO [org.hibernate.hql.internal.QueryTranslatorFactoryInitiator] (ServerService Thread Pool -- 13) HHH000397: Using ASTQueryTranslatorFactory 2016-04-02 16:02:58,167 INFO [org.jboss.weld.Event] (MSC service thread 1-5) WELD-000411: Observer method [BackedAnnotatedMethod] protected org.apache.deltaspike.core.impl.exclude.extension.ExcludeExtension.vetoBeans(@Observes ProcessAnnotatedType, BeanManager) receives events for all annotated types. Consider restricting events using @WithAnnotations or a generic type with bounds. 2016-04-02 16:02:58,170 INFO [org.jboss.weld.Event] (MSC service thread 1-5) WELD-000411: Observer method [BackedAnnotatedMethod] protected org.apache.deltaspike.core.impl.message.MessageBundleExtension.detectInterfaces(@Observes ProcessAnnotatedType) receives events for all annotated types. Consider restricting events using @WithAnnotations or a generic type with bounds. 2016-04-02 16:02:58,174 INFO [org.jboss.weld.Event] (MSC service thread 1-5) WELD-000411: Observer method [BackedAnnotatedMethod] public org.apache.deltaspike.partialbean.impl.PartialBeanBindingExtension.findInvocationHandlerBindings(@Observes ProcessAnnotatedType, BeanManager) receives events for all annotated types. Consider restricting events using @WithAnnotations or a generic type with bounds. 2016-04-02 16:02:58,176 INFO [org.jboss.weld.Event] (MSC service thread 1-5) WELD-000411: Observer method [BackedAnnotatedMethod] org.apache.deltaspike.data.impl.RepositoryExtension.processAnnotatedType(@Observes ProcessAnnotatedType) receives events for all annotated types. Consider restricting events using @WithAnnotations or a generic type with bounds. 2016-04-02 16:02:58,177 INFO [org.jboss.weld.Event] (MSC service thread 1-5) WELD-000411: Observer method [BackedAnnotatedMethod] protected org.apache.deltaspike.core.impl.interceptor.GlobalInterceptorExtension.promoteInterceptors(@Observes ProcessAnnotatedType, BeanManager) receives events for all annotated types. Consider restricting events using @WithAnnotations or a generic type with bounds. 2016-04-02 16:02:58,488 INFO [org.apache.deltaspike.core.impl.exclude.extension.ExcludeExtension] (MSC service thread 1-5) org.apache.deltaspike.jpa.impl.transaction.BeanManagedUserTransactionStrategy is configured as global-alternative 2016-04-02 16:02:58,569 WARN [org.jboss.weld.Validator] (MSC service thread 1-5) WELD-001478: Interceptor class org.apache.deltaspike.jpa.impl.transaction.TransactionalInterceptor is enabled for the application and for the bean archive pvsketch.war/WEB-INF/lib/deltaspike-jpa-module-impl-1.5.4.jar. It will only be invoked in the @Priority part of the chain. 2016-04-02 16:02:58,582 INFO [org.jboss.weld.Bootstrap] (Weld Thread Pool -- 2) WELD-001125: Illegal bean type org.apache.deltaspike.data.impl.meta.verifier.Verifier> ignored on [EnhancedAnnotatedTypeImpl] public class org.apache.deltaspike.data.impl.meta.verifier.EntityVerifier 2016-04-02 16:02:59,019 INFO [stdout] (ServerService Thread Pool -- 29) Hibernate: 2016-04-02 16:02:59,019 INFO [stdout] (ServerService Thread Pool -- 29) select 2016-04-02 16:02:59,019 INFO [stdout] (ServerService Thread Pool -- 29) profile0_.profileId as profileI1_10_, 2016-04-02 16:02:59,019 INFO [stdout] (ServerService Thread Pool -- 29) profile0_.category as category2_10_, 2016-04-02 16:02:59,020 INFO [stdout] (ServerService Thread Pool -- 29) profile0_.description as descript3_10_, 2016-04-02 16:02:59,020 INFO [stdout] (ServerService Thread Pool -- 29) profile0_.name as name4_10_, 2016-04-02 16:02:59,020 INFO [stdout] (ServerService Thread Pool -- 29) profile0_.value as value5_10_, 2016-04-02 16:02:59,020 INFO [stdout] (ServerService Thread Pool -- 29) profile0_.worksFrom as worksFro6_10_, 2016-04-02 16:02:59,020 INFO [stdout] (ServerService Thread Pool -- 29) profile0_.worksTill as worksTil7_10_ 2016-04-02 16:02:59,020 INFO [stdout] (ServerService Thread Pool -- 29) from 2016-04-02 16:02:59,020 INFO [stdout] (ServerService Thread Pool -- 29) Profile profile0_ 2016-04-02 16:02:59,020 INFO [stdout] (ServerService Thread Pool -- 29) where 2016-04-02 16:02:59,020 INFO [stdout] (ServerService Thread Pool -- 29) profile0_.name=? 2016-04-02 16:02:59,020 INFO [stdout] (ServerService Thread Pool -- 29) and ( 2016-04-02 16:02:59,020 INFO [stdout] (ServerService Thread Pool -- 29) profile0_.worksFrom is null 2016-04-02 16:02:59,020 INFO [stdout] (ServerService Thread Pool -- 29) or profile0_.worksFrom<=? 2016-04-02 16:02:59,020 INFO [stdout] (ServerService Thread Pool -- 29) ) 2016-04-02 16:02:59,020 INFO [stdout] (ServerService Thread Pool -- 29) and ( 2016-04-02 16:02:59,021 INFO [stdout] (ServerService Thread Pool -- 29) profile0_.worksTill is null 2016-04-02 16:02:59,021 INFO [stdout] (ServerService Thread Pool -- 29) or profile0_.worksTill>? 2016-04-02 16:02:59,021 INFO [stdout] (ServerService Thread Pool -- 29) ) 2016-04-02 16:02:59,211 INFO [com.pvcomplete.pvsketch.api.core.util.EmailPeriodicTimer] (ServerService Thread Pool -- 29) EmailPeriodicTimer scheduled: ScheduleExpression[second=0 minute=0/2 hour=* dayOfWeek=* dayOfMonth=* month=* year=* start=null end=null timezone=] 2016-04-02 16:02:59,224 INFO [io.undertow.servlet] (ServerService Thread Pool -- 29) Initializing Shiro environment 2016-04-02 16:02:59,224 INFO [org.apache.shiro.web.env.EnvironmentLoader] (ServerService Thread Pool -- 29) Starting Shiro environment initialization. 2016-04-02 16:02:59,299 INFO [org.apache.shiro.config.IniSecurityManagerFactory] (ServerService Thread Pool -- 29) Realms have been explicitly set on the SecurityManager instance - auto-setting of realms will not occur. 2016-04-02 16:02:59,303 INFO [org.apache.shiro.web.env.EnvironmentLoader] (ServerService Thread Pool -- 29) Shiro environment initialized in 79 ms. 2016-04-02 16:02:59,306 INFO [javax.enterprise.resource.webcontainer.jsf.config] (ServerService Thread Pool -- 29) Initializing Mojarra 2.2.12-jbossorg-2 20150729-1131 for context '/pvsketch' 2016-04-02 16:03:00,321 WARN [org.jboss.as.weld] (ServerService Thread Pool -- 29) WFLYWELD0052: Using deployment classloader to load proxy classes for module org.jboss.resteasy.resteasy-jaxrs:main. Package-private access will not work. To fix this the module should declare dependencies on [org.jboss.weld.core, org.jboss.weld.spi] 2016-04-02 16:03:00,367 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002225: Deploying javax.ws.rs.core.Application: class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,369 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.ManufacturerResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,369 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.ProjectDetailsResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,369 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002205: Adding provider class com.pvcomplete.pvsketch.api.presentation.services.StringMessageBodyWriter from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,369 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.LocaleResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,369 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.CustomerResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,369 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.InverterResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,369 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.BusinessResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,369 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.PVModuleResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,369 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.AdminResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,369 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.ProjectResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,369 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002205: Adding provider class com.pvcomplete.pvsketch.api.presentation.services.BooleanMessageBodyWriter from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,369 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.AnonymousResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,370 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002205: Adding provider class com.pvcomplete.pvsketch.api.presentation.services.AppExceptionMapper from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,371 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.ReportResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,371 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.UtilityProviderResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,371 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.TestResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,371 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.UserResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,371 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool -- 29) RESTEASY002200: Adding class resource com.pvcomplete.pvsketch.api.presentation.services.AuthResource from Application class com.pvcomplete.pvsketch.api.presentation.services.ApplicationConfig$Proxy$_$$_WeldClientProxy 2016-04-02 16:03:00,399 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 29) WFLYUT0021: Registered web context: /pvsketch 2016-04-02 16:03:00,414 INFO [org.jboss.as.server] (management-handler-thread - 4) WFLYSRV0010: Deployed "pvsketch.war" (runtime-name : "pvsketch.war") 2016-04-02 16:03:08,026 INFO [stdout] (default task-13) Hibernate: 2016-04-02 16:03:08,026 INFO [stdout] (default task-13) select 2016-04-02 16:03:08,026 INFO [stdout] (default task-13) useraccoun0_.userAccountId as userAcco1_16_, 2016-04-02 16:03:08,026 INFO [stdout] (default task-13) useraccoun0_.businessAccountId as business2_16_, 2016-04-02 16:03:08,026 INFO [stdout] (default task-13) useraccoun0_.isConfirmed as isConfir3_16_, 2016-04-02 16:03:08,026 INFO [stdout] (default task-13) useraccoun0_.displayName as displayN4_16_, 2016-04-02 16:03:08,026 INFO [stdout] (default task-13) useraccoun0_.email as email5_16_, 2016-04-02 16:03:08,027 INFO [stdout] (default task-13) useraccoun0_.isEnabled as isEnable6_16_, 2016-04-02 16:03:08,027 INFO [stdout] (default task-13) useraccoun0_.firstName as firstNam7_16_, 2016-04-02 16:03:08,027 INFO [stdout] (default task-13) useraccoun0_.lastName as lastName8_16_, 2016-04-02 16:03:08,027 INFO [stdout] (default task-13) useraccoun0_.password as password9_16_, 2016-04-02 16:03:08,027 INFO [stdout] (default task-13) useraccoun0_.phoneNumber as phoneNu10_16_, 2016-04-02 16:03:08,027 INFO [stdout] (default task-13) useraccoun0_.roleId as roleId12_16_, 2016-04-02 16:03:08,027 INFO [stdout] (default task-13) useraccoun0_.userName as userNam11_16_ 2016-04-02 16:03:08,027 INFO [stdout] (default task-13) from 2016-04-02 16:03:08,027 INFO [stdout] (default task-13) UserAccount useraccoun0_ 2016-04-02 16:03:08,027 INFO [stdout] (default task-13) where 2016-04-02 16:03:08,027 INFO [stdout] (default task-13) useraccoun0_.userName=? 2016-04-02 16:03:08,422 INFO [stdout] (default task-13) Hibernate: 2016-04-02 16:03:08,422 INFO [stdout] (default task-13) select 2016-04-02 16:03:08,422 INFO [stdout] (default task-13) role0_.roleId as roleId1_12_, 2016-04-02 16:03:08,422 INFO [stdout] (default task-13) role0_.description as descript2_12_, 2016-04-02 16:03:08,422 INFO [stdout] (default task-13) role0_.name as name3_12_ 2016-04-02 16:03:08,422 INFO [stdout] (default task-13) from 2016-04-02 16:03:08,422 INFO [stdout] (default task-13) Role role0_ 2016-04-02 16:03:08,637 INFO [stdout] (default task-13) Hibernate: 2016-04-02 16:03:08,637 INFO [stdout] (default task-13) select 2016-04-02 16:03:08,637 INFO [stdout] (default task-13) permission0_.roleId as roleId1_13_0_, 2016-04-02 16:03:08,637 INFO [stdout] (default task-13) permission0_.permissionId as permissi2_13_0_, 2016-04-02 16:03:08,637 INFO [stdout] (default task-13) permission1_.permissionId as permissi1_9_1_, 2016-04-02 16:03:08,637 INFO [stdout] (default task-13) permission1_.code as code2_9_1_, 2016-04-02 16:03:08,637 INFO [stdout] (default task-13) permission1_.description as descript3_9_1_ 2016-04-02 16:03:08,637 INFO [stdout] (default task-13) from 2016-04-02 16:03:08,637 INFO [stdout] (default task-13) RolePermission permission0_ 2016-04-02 16:03:08,637 INFO [stdout] (default task-13) inner join 2016-04-02 16:03:08,637 INFO [stdout] (default task-13) Permission permission1_ 2016-04-02 16:03:08,637 INFO [stdout] (default task-13) on permission0_.permissionId=permission1_.permissionId 2016-04-02 16:03:08,637 INFO [stdout] (default task-13) where 2016-04-02 16:03:08,637 INFO [stdout] (default task-13) permission0_.roleId=? 2016-04-02 16:03:08,874 INFO [stdout] (default task-13) Hibernate: 2016-04-02 16:03:08,874 INFO [stdout] (default task-13) select 2016-04-02 16:03:08,874 INFO [stdout] (default task-13) useraccoun0_.userAccountId as userAcco1_16_0_, 2016-04-02 16:03:08,874 INFO [stdout] (default task-13) role1_.roleId as roleId1_12_1_, 2016-04-02 16:03:08,874 INFO [stdout] (default task-13) useraccoun0_.businessAccountId as business2_16_0_, 2016-04-02 16:03:08,874 INFO [stdout] (default task-13) useraccoun0_.isConfirmed as isConfir3_16_0_, 2016-04-02 16:03:08,874 INFO [stdout] (default task-13) useraccoun0_.displayName as displayN4_16_0_, 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) useraccoun0_.email as email5_16_0_, 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) useraccoun0_.isEnabled as isEnable6_16_0_, 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) useraccoun0_.firstName as firstNam7_16_0_, 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) useraccoun0_.lastName as lastName8_16_0_, 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) useraccoun0_.password as password9_16_0_, 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) useraccoun0_.phoneNumber as phoneNu10_16_0_, 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) useraccoun0_.roleId as roleId12_16_0_, 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) useraccoun0_.userName as userNam11_16_0_, 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) role1_.description as descript2_12_1_, 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) role1_.name as name3_12_1_ 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) from 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) UserAccount useraccoun0_ 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) left outer join 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) Role role1_ 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) on useraccoun0_.roleId=role1_.roleId 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) where 2016-04-02 16:03:08,875 INFO [stdout] (default task-13) useraccoun0_.userAccountId=? 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) Hibernate: 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) select 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) role0_.roleId as roleId1_12_0_, 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) permission2_.permissionId as permissi1_9_1_, 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) role0_.description as descript2_12_0_, 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) role0_.name as name3_12_0_, 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) permission2_.code as code2_9_1_, 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) permission2_.description as descript3_9_1_, 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) permission1_.roleId as roleId1_13_0__, 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) permission1_.permissionId as permissi2_13_0__ 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) from 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) Role role0_ 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) left outer join 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) RolePermission permission1_ 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) on role0_.roleId=permission1_.roleId 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) left outer join 2016-04-02 16:03:09,070 INFO [stdout] (default task-13) Permission permission2_ 2016-04-02 16:03:09,071 INFO [stdout] (default task-13) on permission1_.permissionId=permission2_.permissionId 2016-04-02 16:03:09,071 INFO [stdout] (default task-13) where 2016-04-02 16:03:09,071 INFO [stdout] (default task-13) role0_.roleId=? 2016-04-02 16:03:09,879 INFO [com.pvcomplete.pvsketch.api.core.dal.util.QueryHelper] (default task-21) SELECT e FROM Project e LEFT JOIN FETCH e.address a LEFT JOIN FETCH e.createdBy u LEFT JOIN FETCH e.customer c WHERE e.businessAccountId = :businessAccountId 2016-04-02 16:03:09,891 INFO [stdout] (default task-21) Hibernate: 2016-04-02 16:03:09,891 INFO [stdout] (default task-21) select 2016-04-02 16:03:09,891 INFO [stdout] (default task-21) project0_.projectId as projectI1_11_0_, 2016-04-02 16:03:09,891 INFO [stdout] (default task-21) address1_.addressId as addressI1_0_1_, 2016-04-02 16:03:09,891 INFO [stdout] (default task-21) useraccoun2_.userAccountId as userAcco1_16_2_, 2016-04-02 16:03:09,891 INFO [stdout] (default task-21) customer3_.customerId as customer1_2_3_, 2016-04-02 16:03:09,891 INFO [stdout] (default task-21) project0_.addressId as address10_11_0_, 2016-04-02 16:03:09,891 INFO [stdout] (default task-21) project0_.businessAccountId as business2_11_0_, 2016-04-02 16:03:09,891 INFO [stdout] (default task-21) project0_.createdBy as created11_11_0_, 2016-04-02 16:03:09,891 INFO [stdout] (default task-21) project0_.createdOn as createdO3_11_0_, 2016-04-02 16:03:09,891 INFO [stdout] (default task-21) project0_.customerId as custome12_11_0_, 2016-04-02 16:03:09,891 INFO [stdout] (default task-21) project0_.latitude as latitude4_11_0_, 2016-04-02 16:03:09,891 INFO [stdout] (default task-21) project0_.longitude as longitud5_11_0_, 2016-04-02 16:03:09,892 INFO [stdout] (default task-21) project0_.modifiedBy as modifie13_11_0_, 2016-04-02 16:03:09,892 INFO [stdout] (default task-21) project0_.modifiedOn as modified6_11_0_, 2016-04-02 16:03:09,892 INFO [stdout] (default task-21) project0_.name as name7_11_0_, 2016-04-02 16:03:09,892 INFO [stdout] (default task-21) project0_.notes as notes8_11_0_, 2016-04-02 16:03:09,892 INFO [stdout] (default task-21) project0_.utilityProviderId as utilityP9_11_0_, 2016-04-02 16:03:09,892 INFO [stdout] (default task-21) address1_.address1 as address2_0_1_, 2016-04-02 16:03:09,892 INFO [stdout] (default task-21) address1_.address2 as address3_0_1_, 2016-04-02 16:03:09,892 INFO [stdout] (default task-21) address1_.city as city4_0_1_, 2016-04-02 16:03:09,892 INFO [stdout] (default task-21) address1_.country as country5_0_1_, 2016-04-02 16:03:09,892 INFO [stdout] (default task-21) address1_.stateProvince as statePro6_0_1_, 2016-04-02 16:03:09,892 INFO [stdout] (default task-21) address1_.zipCode as zipCode7_0_1_, 2016-04-02 16:03:09,892 INFO [stdout] (default task-21) useraccoun2_.businessAccountId as business2_16_2_, 2016-04-02 16:03:09,892 INFO [stdout] (default task-21) useraccoun2_.isConfirmed as isConfir3_16_2_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) useraccoun2_.displayName as displayN4_16_2_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) useraccoun2_.email as email5_16_2_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) useraccoun2_.isEnabled as isEnable6_16_2_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) useraccoun2_.firstName as firstNam7_16_2_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) useraccoun2_.lastName as lastName8_16_2_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) useraccoun2_.password as password9_16_2_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) useraccoun2_.phoneNumber as phoneNu10_16_2_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) useraccoun2_.roleId as roleId12_16_2_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) useraccoun2_.userName as userNam11_16_2_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) customer3_.addressId as address10_2_3_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) customer3_.businessAccountId as business2_2_3_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) customer3_.companyName as companyN3_2_3_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) customer3_.createdBy as created11_2_3_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) customer3_.createdOn as createdO4_2_3_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) customer3_.email as email5_2_3_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) customer3_.firstName as firstNam6_2_3_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) customer3_.lastName as lastName7_2_3_, 2016-04-02 16:03:09,893 INFO [stdout] (default task-21) customer3_.modifiedBy as modifie12_2_3_, 2016-04-02 16:03:09,894 INFO [stdout] (default task-21) customer3_.modifiedOn as modified8_2_3_, 2016-04-02 16:03:09,894 INFO [stdout] (default task-21) customer3_.phoneNumber as phoneNum9_2_3_ 2016-04-02 16:03:09,894 INFO [stdout] (default task-21) from 2016-04-02 16:03:09,895 INFO [stdout] (default task-21) Project project0_ 2016-04-02 16:03:09,895 INFO [stdout] (default task-21) left outer join 2016-04-02 16:03:09,895 INFO [stdout] (default task-21) Address address1_ 2016-04-02 16:03:09,895 INFO [stdout] (default task-21) on project0_.addressId=address1_.addressId 2016-04-02 16:03:09,895 INFO [stdout] (default task-21) left outer join 2016-04-02 16:03:09,895 INFO [stdout] (default task-21) UserAccount useraccoun2_ 2016-04-02 16:03:09,895 INFO [stdout] (default task-21) on project0_.createdBy=useraccoun2_.userAccountId 2016-04-02 16:03:09,895 INFO [stdout] (default task-21) left outer join 2016-04-02 16:03:09,895 INFO [stdout] (default task-21) Customer customer3_ 2016-04-02 16:03:09,895 INFO [stdout] (default task-21) on project0_.customerId=customer3_.customerId 2016-04-02 16:03:09,895 INFO [stdout] (default task-21) where 2016-04-02 16:03:09,895 INFO [stdout] (default task-21) project0_.businessAccountId=? limit ? 2016-04-02 16:03:10,099 INFO [stdout] (default task-21) Hibernate: 2016-04-02 16:03:10,099 INFO [stdout] (default task-21) select 2016-04-02 16:03:10,099 INFO [stdout] (default task-21) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:10,099 INFO [stdout] (default task-21) address0_.address1 as address2_0_0_, 2016-04-02 16:03:10,099 INFO [stdout] (default task-21) address0_.address2 as address3_0_0_, 2016-04-02 16:03:10,099 INFO [stdout] (default task-21) address0_.city as city4_0_0_, 2016-04-02 16:03:10,099 INFO [stdout] (default task-21) address0_.country as country5_0_0_, 2016-04-02 16:03:10,099 INFO [stdout] (default task-21) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:10,099 INFO [stdout] (default task-21) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:10,099 INFO [stdout] (default task-21) from 2016-04-02 16:03:10,099 INFO [stdout] (default task-21) Address address0_ 2016-04-02 16:03:10,099 INFO [stdout] (default task-21) where 2016-04-02 16:03:10,099 INFO [stdout] (default task-21) address0_.addressId=? 2016-04-02 16:03:10,297 INFO [stdout] (default task-21) Hibernate: 2016-04-02 16:03:10,297 INFO [stdout] (default task-21) select 2016-04-02 16:03:10,297 INFO [stdout] (default task-21) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:10,297 INFO [stdout] (default task-21) address0_.address1 as address2_0_0_, 2016-04-02 16:03:10,297 INFO [stdout] (default task-21) address0_.address2 as address3_0_0_, 2016-04-02 16:03:10,297 INFO [stdout] (default task-21) address0_.city as city4_0_0_, 2016-04-02 16:03:10,297 INFO [stdout] (default task-21) address0_.country as country5_0_0_, 2016-04-02 16:03:10,297 INFO [stdout] (default task-21) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:10,297 INFO [stdout] (default task-21) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:10,297 INFO [stdout] (default task-21) from 2016-04-02 16:03:10,297 INFO [stdout] (default task-21) Address address0_ 2016-04-02 16:03:10,298 INFO [stdout] (default task-21) where 2016-04-02 16:03:10,298 INFO [stdout] (default task-21) address0_.addressId=? 2016-04-02 16:03:10,494 INFO [stdout] (default task-21) Hibernate: 2016-04-02 16:03:10,494 INFO [stdout] (default task-21) select 2016-04-02 16:03:10,494 INFO [stdout] (default task-21) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:10,494 INFO [stdout] (default task-21) address0_.address1 as address2_0_0_, 2016-04-02 16:03:10,494 INFO [stdout] (default task-21) address0_.address2 as address3_0_0_, 2016-04-02 16:03:10,494 INFO [stdout] (default task-21) address0_.city as city4_0_0_, 2016-04-02 16:03:10,494 INFO [stdout] (default task-21) address0_.country as country5_0_0_, 2016-04-02 16:03:10,494 INFO [stdout] (default task-21) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:10,494 INFO [stdout] (default task-21) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:10,494 INFO [stdout] (default task-21) from 2016-04-02 16:03:10,494 INFO [stdout] (default task-21) Address address0_ 2016-04-02 16:03:10,494 INFO [stdout] (default task-21) where 2016-04-02 16:03:10,494 INFO [stdout] (default task-21) address0_.addressId=? 2016-04-02 16:03:10,692 INFO [com.pvcomplete.pvsketch.api.core.dal.util.QueryHelper] (default task-21) SELECT count(e.projectId) FROM Project e LEFT JOIN e.address a LEFT JOIN e.customer c WHERE e.businessAccountId = :businessAccountId 2016-04-02 16:03:10,699 INFO [stdout] (default task-21) Hibernate: 2016-04-02 16:03:10,699 INFO [stdout] (default task-21) select 2016-04-02 16:03:10,699 INFO [stdout] (default task-21) count(project0_.projectId) as col_0_0_ 2016-04-02 16:03:10,699 INFO [stdout] (default task-21) from 2016-04-02 16:03:10,699 INFO [stdout] (default task-21) Project project0_ 2016-04-02 16:03:10,699 INFO [stdout] (default task-21) left outer join 2016-04-02 16:03:10,699 INFO [stdout] (default task-21) Address address1_ 2016-04-02 16:03:10,699 INFO [stdout] (default task-21) on project0_.addressId=address1_.addressId 2016-04-02 16:03:10,699 INFO [stdout] (default task-21) left outer join 2016-04-02 16:03:10,699 INFO [stdout] (default task-21) Customer customer2_ 2016-04-02 16:03:10,699 INFO [stdout] (default task-21) on project0_.customerId=customer2_.customerId 2016-04-02 16:03:10,699 INFO [stdout] (default task-21) where 2016-04-02 16:03:10,699 INFO [stdout] (default task-21) project0_.businessAccountId=? 2016-04-02 16:03:14,662 INFO [stdout] (default task-22) Hibernate: 2016-04-02 16:03:14,662 INFO [stdout] (default task-22) select 2016-04-02 16:03:14,662 INFO [stdout] (default task-22) project0_.projectId as projectI1_11_0_, 2016-04-02 16:03:14,662 INFO [stdout] (default task-22) address1_.addressId as addressI1_0_1_, 2016-04-02 16:03:14,662 INFO [stdout] (default task-22) useraccoun2_.userAccountId as userAcco1_16_2_, 2016-04-02 16:03:14,662 INFO [stdout] (default task-22) customer3_.customerId as customer1_2_3_, 2016-04-02 16:03:14,662 INFO [stdout] (default task-22) roofs4_.roofId as roofId1_14_4_, 2016-04-02 16:03:14,662 INFO [stdout] (default task-22) project0_.addressId as address10_11_0_, 2016-04-02 16:03:14,662 INFO [stdout] (default task-22) project0_.businessAccountId as business2_11_0_, 2016-04-02 16:03:14,662 INFO [stdout] (default task-22) project0_.createdBy as created11_11_0_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) project0_.createdOn as createdO3_11_0_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) project0_.customerId as custome12_11_0_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) project0_.latitude as latitude4_11_0_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) project0_.longitude as longitud5_11_0_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) project0_.modifiedBy as modifie13_11_0_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) project0_.modifiedOn as modified6_11_0_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) project0_.name as name7_11_0_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) project0_.notes as notes8_11_0_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) project0_.utilityProviderId as utilityP9_11_0_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) address1_.address1 as address2_0_1_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) address1_.address2 as address3_0_1_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) address1_.city as city4_0_1_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) address1_.country as country5_0_1_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) address1_.stateProvince as statePro6_0_1_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) address1_.zipCode as zipCode7_0_1_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) useraccoun2_.businessAccountId as business2_16_2_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) useraccoun2_.isConfirmed as isConfir3_16_2_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) useraccoun2_.displayName as displayN4_16_2_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) useraccoun2_.email as email5_16_2_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) useraccoun2_.isEnabled as isEnable6_16_2_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) useraccoun2_.firstName as firstNam7_16_2_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) useraccoun2_.lastName as lastName8_16_2_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) useraccoun2_.password as password9_16_2_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) useraccoun2_.phoneNumber as phoneNu10_16_2_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) useraccoun2_.roleId as roleId12_16_2_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) useraccoun2_.userName as userNam11_16_2_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) customer3_.addressId as address10_2_3_, 2016-04-02 16:03:14,663 INFO [stdout] (default task-22) customer3_.businessAccountId as business2_2_3_, 2016-04-02 16:03:14,664 INFO [stdout] (default task-22) customer3_.companyName as companyN3_2_3_, 2016-04-02 16:03:14,664 INFO [stdout] (default task-22) customer3_.createdBy as created11_2_3_, 2016-04-02 16:03:14,664 INFO [stdout] (default task-22) customer3_.createdOn as createdO4_2_3_, 2016-04-02 16:03:14,664 INFO [stdout] (default task-22) customer3_.email as email5_2_3_, 2016-04-02 16:03:14,664 INFO [stdout] (default task-22) customer3_.firstName as firstNam6_2_3_, 2016-04-02 16:03:14,664 INFO [stdout] (default task-22) customer3_.lastName as lastName7_2_3_, 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) customer3_.modifiedBy as modifie12_2_3_, 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) customer3_.modifiedOn as modified8_2_3_, 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) customer3_.phoneNumber as phoneNum9_2_3_, 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) roofs4_.description as descript2_14_4_, 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) roofs4_.hasParapetWall as hasParap3_14_4_, 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) roofs4_.roofIndex as roofInde4_14_4_, 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) roofs4_.meanHeight as meanHeig5_14_4_, 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) roofs4_.name as name6_14_4_, 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) roofs4_.parapetWallHeight as parapetW7_14_4_, 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) roofs4_.projectId as projectI9_14_4_, 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) roofs4_.setback as setback8_14_4_, 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) roofs4_.projectId as projectI9_14_0__, 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) roofs4_.roofId as roofId1_14_0__ 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) from 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) Project project0_ 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) left outer join 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) Address address1_ 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) on project0_.addressId=address1_.addressId 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) left outer join 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) UserAccount useraccoun2_ 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) on project0_.createdBy=useraccoun2_.userAccountId 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) left outer join 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) Customer customer3_ 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) on project0_.customerId=customer3_.customerId 2016-04-02 16:03:14,665 INFO [stdout] (default task-22) left outer join 2016-04-02 16:03:14,666 INFO [stdout] (default task-22) Roof roofs4_ 2016-04-02 16:03:14,666 INFO [stdout] (default task-22) on project0_.projectId=roofs4_.projectId 2016-04-02 16:03:14,666 INFO [stdout] (default task-22) where 2016-04-02 16:03:14,666 INFO [stdout] (default task-22) project0_.projectId=? 2016-04-02 16:03:14,666 INFO [stdout] (default task-22) order by 2016-04-02 16:03:14,666 INFO [stdout] (default task-22) roofs4_.roofId, 2016-04-02 16:03:14,666 INFO [stdout] (default task-22) roofs4_.roofId 2016-04-02 16:03:14,736 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) select 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) customer0_.customerId as customer1_2_, 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) customer0_.addressId as address10_2_, 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) customer0_.businessAccountId as business2_2_, 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) customer0_.companyName as companyN3_2_, 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) customer0_.createdBy as created11_2_, 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) customer0_.createdOn as createdO4_2_, 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) customer0_.email as email5_2_, 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) customer0_.firstName as firstNam6_2_, 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) customer0_.lastName as lastName7_2_, 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) customer0_.modifiedBy as modifie12_2_, 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) customer0_.modifiedOn as modified8_2_, 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) customer0_.phoneNumber as phoneNum9_2_ 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) from 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) Customer customer0_ 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) where 2016-04-02 16:03:14,737 INFO [stdout] (default task-23) customer0_.businessAccountId=? 2016-04-02 16:03:14,746 INFO [stdout] (default task-24) Hibernate: 2016-04-02 16:03:14,746 INFO [stdout] (default task-24) select 2016-04-02 16:03:14,746 INFO [stdout] (default task-24) utilitypro0_.utilityProviderId as utilityP1_17_, 2016-04-02 16:03:14,746 INFO [stdout] (default task-24) utilitypro0_.fullName as fullName2_17_, 2016-04-02 16:03:14,746 INFO [stdout] (default task-24) utilitypro0_.shortName as shortNam3_17_ 2016-04-02 16:03:14,746 INFO [stdout] (default task-24) from 2016-04-02 16:03:14,746 INFO [stdout] (default task-24) UtilityProvider utilitypro0_ 2016-04-02 16:03:14,746 INFO [stdout] (default task-24) order by 2016-04-02 16:03:14,746 INFO [stdout] (default task-24) utilitypro0_.shortName asc 2016-04-02 16:03:14,860 INFO [stdout] (default task-22) Hibernate: 2016-04-02 16:03:14,860 INFO [stdout] (default task-22) select 2016-04-02 16:03:14,860 INFO [stdout] (default task-22) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:14,860 INFO [stdout] (default task-22) address0_.address1 as address2_0_0_, 2016-04-02 16:03:14,860 INFO [stdout] (default task-22) address0_.address2 as address3_0_0_, 2016-04-02 16:03:14,860 INFO [stdout] (default task-22) address0_.city as city4_0_0_, 2016-04-02 16:03:14,861 INFO [stdout] (default task-22) address0_.country as country5_0_0_, 2016-04-02 16:03:14,861 INFO [stdout] (default task-22) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:14,861 INFO [stdout] (default task-22) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:14,861 INFO [stdout] (default task-22) from 2016-04-02 16:03:14,861 INFO [stdout] (default task-22) Address address0_ 2016-04-02 16:03:14,861 INFO [stdout] (default task-22) where 2016-04-02 16:03:14,861 INFO [stdout] (default task-22) address0_.addressId=? 2016-04-02 16:03:15,054 INFO [stdout] (default task-22) Hibernate: 2016-04-02 16:03:15,055 INFO [stdout] (default task-22) select 2016-04-02 16:03:15,055 INFO [stdout] (default task-22) rooffaces0_.roofId as roofId5_15_0_, 2016-04-02 16:03:15,055 INFO [stdout] (default task-22) rooffaces0_.roofFaceId as roofFace1_15_0_, 2016-04-02 16:03:15,055 INFO [stdout] (default task-22) rooffaces0_.roofFaceId as roofFace1_15_1_, 2016-04-02 16:03:15,055 INFO [stdout] (default task-22) rooffaces0_.azimuth as azimuth2_15_1_, 2016-04-02 16:03:15,055 INFO [stdout] (default task-22) rooffaces0_.polygon2dLocalJson as polygon3_15_1_, 2016-04-02 16:03:15,055 INFO [stdout] (default task-22) rooffaces0_.roofId as roofId5_15_1_, 2016-04-02 16:03:15,055 INFO [stdout] (default task-22) rooffaces0_.slope as slope4_15_1_ 2016-04-02 16:03:15,055 INFO [stdout] (default task-22) from 2016-04-02 16:03:15,055 INFO [stdout] (default task-22) RoofFace rooffaces0_ 2016-04-02 16:03:15,055 INFO [stdout] (default task-22) where 2016-04-02 16:03:15,055 INFO [stdout] (default task-22) rooffaces0_.roofId=? 2016-04-02 16:03:15,251 INFO [stdout] (default task-22) Hibernate: 2016-04-02 16:03:15,251 INFO [stdout] (default task-22) select 2016-04-02 16:03:15,251 INFO [stdout] (default task-22) obstructio0_.roofId as roofId9_8_0_, 2016-04-02 16:03:15,251 INFO [stdout] (default task-22) obstructio0_.obstructionId as obstruct1_8_0_, 2016-04-02 16:03:15,251 INFO [stdout] (default task-22) obstructio0_.obstructionId as obstruct1_8_1_, 2016-04-02 16:03:15,251 INFO [stdout] (default task-22) obstructio0_.description as descript2_8_1_, 2016-04-02 16:03:15,252 INFO [stdout] (default task-22) obstructio0_.height as height3_8_1_, 2016-04-02 16:03:15,252 INFO [stdout] (default task-22) obstructio0_.obstructionIndex as obstruct4_8_1_, 2016-04-02 16:03:15,252 INFO [stdout] (default task-22) obstructio0_.name as name5_8_1_, 2016-04-02 16:03:15,252 INFO [stdout] (default task-22) obstructio0_.polygon2dLocalJson as polygon6_8_1_, 2016-04-02 16:03:15,252 INFO [stdout] (default task-22) obstructio0_.projectId as projectI8_8_1_, 2016-04-02 16:03:15,252 INFO [stdout] (default task-22) obstructio0_.roofId as roofId9_8_1_, 2016-04-02 16:03:15,252 INFO [stdout] (default task-22) obstructio0_.setback as setback7_8_1_ 2016-04-02 16:03:15,252 INFO [stdout] (default task-22) from 2016-04-02 16:03:15,252 INFO [stdout] (default task-22) Obstruction obstructio0_ 2016-04-02 16:03:15,252 INFO [stdout] (default task-22) where 2016-04-02 16:03:15,252 INFO [stdout] (default task-22) obstructio0_.roofId=? 2016-04-02 16:03:15,446 INFO [stdout] (default task-22) Hibernate: 2016-04-02 16:03:15,446 INFO [stdout] (default task-22) select 2016-04-02 16:03:15,446 INFO [stdout] (default task-22) installati0_.roofId as roofId6_6_0_, 2016-04-02 16:03:15,446 INFO [stdout] (default task-22) installati0_.installationAreaId as installa1_6_0_, 2016-04-02 16:03:15,446 INFO [stdout] (default task-22) installati0_.installationAreaId as installa1_6_1_, 2016-04-02 16:03:15,446 INFO [stdout] (default task-22) installati0_.description as descript2_6_1_, 2016-04-02 16:03:15,446 INFO [stdout] (default task-22) installati0_.installationAreaIndex as installa3_6_1_, 2016-04-02 16:03:15,446 INFO [stdout] (default task-22) installati0_.name as name4_6_1_, 2016-04-02 16:03:15,446 INFO [stdout] (default task-22) installati0_.polygon2dLocalJson as polygon5_6_1_, 2016-04-02 16:03:15,446 INFO [stdout] (default task-22) installati0_.roofId as roofId6_6_1_ 2016-04-02 16:03:15,446 INFO [stdout] (default task-22) from 2016-04-02 16:03:15,446 INFO [stdout] (default task-22) InstallationArea installati0_ 2016-04-02 16:03:15,446 INFO [stdout] (default task-22) where 2016-04-02 16:03:15,446 INFO [stdout] (default task-22) installati0_.roofId=? 2016-04-02 16:03:15,642 INFO [stdout] (default task-22) Hibernate: 2016-04-02 16:03:15,642 INFO [stdout] (default task-22) select 2016-04-02 16:03:15,642 INFO [stdout] (default task-22) rooffaces0_.roofId as roofId5_15_0_, 2016-04-02 16:03:15,642 INFO [stdout] (default task-22) rooffaces0_.roofFaceId as roofFace1_15_0_, 2016-04-02 16:03:15,642 INFO [stdout] (default task-22) rooffaces0_.roofFaceId as roofFace1_15_1_, 2016-04-02 16:03:15,642 INFO [stdout] (default task-22) rooffaces0_.azimuth as azimuth2_15_1_, 2016-04-02 16:03:15,642 INFO [stdout] (default task-22) rooffaces0_.polygon2dLocalJson as polygon3_15_1_, 2016-04-02 16:03:15,642 INFO [stdout] (default task-22) rooffaces0_.roofId as roofId5_15_1_, 2016-04-02 16:03:15,642 INFO [stdout] (default task-22) rooffaces0_.slope as slope4_15_1_ 2016-04-02 16:03:15,642 INFO [stdout] (default task-22) from 2016-04-02 16:03:15,642 INFO [stdout] (default task-22) RoofFace rooffaces0_ 2016-04-02 16:03:15,642 INFO [stdout] (default task-22) where 2016-04-02 16:03:15,643 INFO [stdout] (default task-22) rooffaces0_.roofId=? 2016-04-02 16:03:15,840 INFO [stdout] (default task-22) Hibernate: 2016-04-02 16:03:15,840 INFO [stdout] (default task-22) select 2016-04-02 16:03:15,840 INFO [stdout] (default task-22) obstructio0_.roofId as roofId9_8_0_, 2016-04-02 16:03:15,840 INFO [stdout] (default task-22) obstructio0_.obstructionId as obstruct1_8_0_, 2016-04-02 16:03:15,840 INFO [stdout] (default task-22) obstructio0_.obstructionId as obstruct1_8_1_, 2016-04-02 16:03:15,840 INFO [stdout] (default task-22) obstructio0_.description as descript2_8_1_, 2016-04-02 16:03:15,840 INFO [stdout] (default task-22) obstructio0_.height as height3_8_1_, 2016-04-02 16:03:15,841 INFO [stdout] (default task-22) obstructio0_.obstructionIndex as obstruct4_8_1_, 2016-04-02 16:03:15,841 INFO [stdout] (default task-22) obstructio0_.name as name5_8_1_, 2016-04-02 16:03:15,841 INFO [stdout] (default task-22) obstructio0_.polygon2dLocalJson as polygon6_8_1_, 2016-04-02 16:03:15,841 INFO [stdout] (default task-22) obstructio0_.projectId as projectI8_8_1_, 2016-04-02 16:03:15,841 INFO [stdout] (default task-22) obstructio0_.roofId as roofId9_8_1_, 2016-04-02 16:03:15,841 INFO [stdout] (default task-22) obstructio0_.setback as setback7_8_1_ 2016-04-02 16:03:15,841 INFO [stdout] (default task-22) from 2016-04-02 16:03:15,841 INFO [stdout] (default task-22) Obstruction obstructio0_ 2016-04-02 16:03:15,841 INFO [stdout] (default task-22) where 2016-04-02 16:03:15,841 INFO [stdout] (default task-22) obstructio0_.roofId=? 2016-04-02 16:03:16,037 INFO [stdout] (default task-22) Hibernate: 2016-04-02 16:03:16,037 INFO [stdout] (default task-22) select 2016-04-02 16:03:16,037 INFO [stdout] (default task-22) installati0_.roofId as roofId6_6_0_, 2016-04-02 16:03:16,037 INFO [stdout] (default task-22) installati0_.installationAreaId as installa1_6_0_, 2016-04-02 16:03:16,037 INFO [stdout] (default task-22) installati0_.installationAreaId as installa1_6_1_, 2016-04-02 16:03:16,037 INFO [stdout] (default task-22) installati0_.description as descript2_6_1_, 2016-04-02 16:03:16,037 INFO [stdout] (default task-22) installati0_.installationAreaIndex as installa3_6_1_, 2016-04-02 16:03:16,037 INFO [stdout] (default task-22) installati0_.name as name4_6_1_, 2016-04-02 16:03:16,037 INFO [stdout] (default task-22) installati0_.polygon2dLocalJson as polygon5_6_1_, 2016-04-02 16:03:16,037 INFO [stdout] (default task-22) installati0_.roofId as roofId6_6_1_ 2016-04-02 16:03:16,037 INFO [stdout] (default task-22) from 2016-04-02 16:03:16,038 INFO [stdout] (default task-22) InstallationArea installati0_ 2016-04-02 16:03:16,038 INFO [stdout] (default task-22) where 2016-04-02 16:03:16,038 INFO [stdout] (default task-22) installati0_.roofId=? 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) Hibernate: 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) select 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) obstructio0_.obstructionId as obstruct1_8_, 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) obstructio0_.description as descript2_8_, 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) obstructio0_.height as height3_8_, 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) obstructio0_.obstructionIndex as obstruct4_8_, 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) obstructio0_.name as name5_8_, 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) obstructio0_.polygon2dLocalJson as polygon6_8_, 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) obstructio0_.projectId as projectI8_8_, 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) obstructio0_.roofId as roofId9_8_, 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) obstructio0_.setback as setback7_8_ 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) from 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) Obstruction obstructio0_ 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) where 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) obstructio0_.projectId=? 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) and ( 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) obstructio0_.roofId is null 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) ) 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) order by 2016-04-02 16:03:16,238 INFO [stdout] (default task-22) obstructio0_.obstructionId 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) Hibernate: 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) select 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) version0_.versionId as versionI1_18_, 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) version0_.dhRatio as dhRatio2_18_, 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) version0_.ewSpacing as ewSpacin3_18_, 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) version0_.inverterId as inverter4_18_, 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) version0_.layoutId as layoutI10_18_, 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) version0_.orientation as orientat5_18_, 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) version0_.projectId as project11_18_, 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) version0_.pvModuleId as pvModule6_18_, 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) version0_.rackingId as rackingI7_18_, 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) version0_.rowSpacing as rowSpaci8_18_, 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) version0_.tilt as tilt9_18_ 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) from 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) Version version0_ 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) where 2016-04-02 16:03:16,433 INFO [stdout] (default task-22) version0_.projectId=? 2016-04-02 16:03:16,434 INFO [stdout] (default task-22) order by 2016-04-02 16:03:16,434 INFO [stdout] (default task-22) version0_.versionId 2016-04-02 16:03:16,668 INFO [org.hibernate.jpa.internal.util.LogHelper] (default task-22) HHH000204: Processing PersistenceUnitInfo [ name: hardwareDBPU ...] 2016-04-02 16:03:16,676 INFO [org.hibernate.dialect.Dialect] (default task-22) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2016-04-02 16:03:16,679 INFO [org.hibernate.envers.boot.internal.EnversServiceImpl] (default task-22) Envers integration enabled? : true 2016-04-02 16:03:16,687 WARN [org.hibernate.boot.internal.SessionFactoryBuilderImpl] (default task-22) Unrecognized hbm2ddl_auto value : none. Supported values include create, create-drop, update, and validate. Ignoring 2016-04-02 16:03:16,708 INFO [stdout] (default task-22) Hibernate: 2016-04-02 16:03:16,708 INFO [stdout] (default task-22) select 2016-04-02 16:03:16,708 INFO [stdout] (default task-22) inverter0_.id as id1_0_0_, 2016-04-02 16:03:16,708 INFO [stdout] (default task-22) inverter0_.isActive as isActive2_0_0_, 2016-04-02 16:03:16,708 INFO [stdout] (default task-22) inverter0_.isAvailableForSimulation as isAvaila3_0_0_, 2016-04-02 16:03:16,708 INFO [stdout] (default task-22) inverter0_.enabled as enabled4_0_0_, 2016-04-02 16:03:16,708 INFO [stdout] (default task-22) inverter0_.manufacturerId as manufact5_0_0_, 2016-04-02 16:03:16,708 INFO [stdout] (default task-22) inverter0_.originalInverterId as original6_0_0_, 2016-04-02 16:03:16,708 INFO [stdout] (default task-22) inverter0_.productFamilyName as productF7_0_0_ 2016-04-02 16:03:16,708 INFO [stdout] (default task-22) from 2016-04-02 16:03:16,708 INFO [stdout] (default task-22) inverter inverter0_ 2016-04-02 16:03:16,708 INFO [stdout] (default task-22) where 2016-04-02 16:03:16,708 INFO [stdout] (default task-22) inverter0_.id=? 2016-04-02 16:03:16,918 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:16,918 INFO [stdout] (default task-23) select 2016-04-02 16:03:16,918 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:16,919 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:16,919 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:16,919 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:16,919 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:16,919 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:16,919 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:16,919 INFO [stdout] (default task-23) from 2016-04-02 16:03:16,919 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:16,919 INFO [stdout] (default task-23) where 2016-04-02 16:03:16,919 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:16,919 INFO [org.hibernate.jpa.internal.util.LogHelper] (default task-22) HHH000204: Processing PersistenceUnitInfo [ name: hardwareDBPU ...] 2016-04-02 16:03:16,924 INFO [org.hibernate.dialect.Dialect] (default task-22) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2016-04-02 16:03:16,928 INFO [org.hibernate.envers.boot.internal.EnversServiceImpl] (default task-22) Envers integration enabled? : true 2016-04-02 16:03:16,933 WARN [org.hibernate.boot.internal.SessionFactoryBuilderImpl] (default task-22) Unrecognized hbm2ddl_auto value : none. Supported values include create, create-drop, update, and validate. Ignoring 2016-04-02 16:03:16,949 WARN [org.hibernate.jpa.internal.EntityManagerFactoryRegistry] (default task-22) HHH000436: Entity manager factory name (hardwareDBPU) is already registered. If entity manager will be clustered or passivated, specify a unique value for property 'hibernate.ejb.entitymanager_factory_name' 2016-04-02 16:03:16,950 INFO [stdout] (default task-22) Hibernate: 2016-04-02 16:03:16,950 INFO [stdout] (default task-22) select 2016-04-02 16:03:16,950 INFO [stdout] (default task-22) pvmodule0_.id as id1_2_0_, 2016-04-02 16:03:16,950 INFO [stdout] (default task-22) pvmodule0_.isActive as isActive2_2_0_, 2016-04-02 16:03:16,951 INFO [stdout] (default task-22) pvmodule0_.isAvailableForSimulation as isAvaila3_2_0_, 2016-04-02 16:03:16,951 INFO [stdout] (default task-22) pvmodule0_.enabled as enabled4_2_0_, 2016-04-02 16:03:16,951 INFO [stdout] (default task-22) pvmodule0_.manufacturerId as manufact5_2_0_, 2016-04-02 16:03:16,951 INFO [stdout] (default task-22) pvmodule0_.nominal_power_rating as nominal_6_2_0_, 2016-04-02 16:03:16,951 INFO [stdout] (default task-22) pvmodule0_.originalModuleId as original7_2_0_, 2016-04-02 16:03:16,951 INFO [stdout] (default task-22) pvmodule0_.productFamilyName as productF8_2_0_ 2016-04-02 16:03:16,951 INFO [stdout] (default task-22) from 2016-04-02 16:03:16,951 INFO [stdout] (default task-22) pvmodule pvmodule0_ 2016-04-02 16:03:16,951 INFO [stdout] (default task-22) where 2016-04-02 16:03:16,951 INFO [stdout] (default task-22) pvmodule0_.id=? 2016-04-02 16:03:17,118 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:17,118 INFO [stdout] (default task-23) select 2016-04-02 16:03:17,118 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:17,118 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:17,118 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:17,118 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:17,118 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:17,118 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:17,118 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:17,118 INFO [stdout] (default task-23) from 2016-04-02 16:03:17,118 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:17,118 INFO [stdout] (default task-23) where 2016-04-02 16:03:17,118 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:17,197 INFO [org.hibernate.jpa.internal.util.LogHelper] (default task-27) HHH000204: Processing PersistenceUnitInfo [ name: hardwareDBPU ...] 2016-04-02 16:03:17,219 INFO [org.hibernate.dialect.Dialect] (default task-27) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2016-04-02 16:03:17,221 INFO [org.hibernate.jpa.internal.util.LogHelper] (default task-25) HHH000204: Processing PersistenceUnitInfo [ name: hardwareDBPU ...] 2016-04-02 16:03:17,226 INFO [org.hibernate.jpa.internal.util.LogHelper] (default task-26) HHH000204: Processing PersistenceUnitInfo [ name: hardwareDBPU ...] 2016-04-02 16:03:17,227 INFO [org.hibernate.dialect.Dialect] (default task-25) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2016-04-02 16:03:17,230 INFO [org.hibernate.envers.boot.internal.EnversServiceImpl] (default task-25) Envers integration enabled? : true 2016-04-02 16:03:17,234 WARN [org.hibernate.boot.internal.SessionFactoryBuilderImpl] (default task-25) Unrecognized hbm2ddl_auto value : none. Supported values include create, create-drop, update, and validate. Ignoring 2016-04-02 16:03:17,239 INFO [org.hibernate.envers.boot.internal.EnversServiceImpl] (default task-27) Envers integration enabled? : true 2016-04-02 16:03:17,244 WARN [org.hibernate.boot.internal.SessionFactoryBuilderImpl] (default task-27) Unrecognized hbm2ddl_auto value : none. Supported values include create, create-drop, update, and validate. Ignoring 2016-04-02 16:03:17,256 INFO [org.hibernate.dialect.Dialect] (default task-26) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2016-04-02 16:03:17,259 INFO [org.hibernate.envers.boot.internal.EnversServiceImpl] (default task-26) Envers integration enabled? : true 2016-04-02 16:03:17,265 WARN [org.hibernate.boot.internal.SessionFactoryBuilderImpl] (default task-26) Unrecognized hbm2ddl_auto value : none. Supported values include create, create-drop, update, and validate. Ignoring 2016-04-02 16:03:17,288 WARN [org.hibernate.jpa.internal.EntityManagerFactoryRegistry] (default task-25) HHH000436: Entity manager factory name (hardwareDBPU) is already registered. If entity manager will be clustered or passivated, specify a unique value for property 'hibernate.ejb.entitymanager_factory_name' 2016-04-02 16:03:17,291 INFO [org.hibernate.hql.internal.QueryTranslatorFactoryInitiator] (default task-25) HHH000397: Using ASTQueryTranslatorFactory 2016-04-02 16:03:17,298 INFO [stdout] (default task-25) Hibernate: 2016-04-02 16:03:17,298 INFO [stdout] (default task-25) select 2016-04-02 16:03:17,298 INFO [stdout] (default task-25) distinct manufactur1_.id as id1_1_, 2016-04-02 16:03:17,298 INFO [stdout] (default task-25) manufactur1_.fullName as fullName2_1_, 2016-04-02 16:03:17,298 INFO [stdout] (default task-25) manufactur1_.shortName as shortNam3_1_ 2016-04-02 16:03:17,298 INFO [stdout] (default task-25) from 2016-04-02 16:03:17,298 INFO [stdout] (default task-25) pvmodule pvmodule0_ 2016-04-02 16:03:17,298 INFO [stdout] (default task-25) left outer join 2016-04-02 16:03:17,298 INFO [stdout] (default task-25) manufacturer manufactur1_ 2016-04-02 16:03:17,299 INFO [stdout] (default task-25) on pvmodule0_.manufacturerId=manufactur1_.id 2016-04-02 16:03:17,299 INFO [stdout] (default task-25) where 2016-04-02 16:03:17,299 INFO [stdout] (default task-25) pvmodule0_.enabled=1 2016-04-02 16:03:17,299 INFO [stdout] (default task-25) and pvmodule0_.isActive=1 2016-04-02 16:03:17,299 INFO [stdout] (default task-25) and pvmodule0_.isAvailableForSimulation=1 2016-04-02 16:03:17,299 INFO [stdout] (default task-25) and ( 2016-04-02 16:03:17,299 INFO [stdout] (default task-25) pvmodule0_.originalModuleId is null 2016-04-02 16:03:17,299 INFO [stdout] (default task-25) ) 2016-04-02 16:03:17,299 INFO [stdout] (default task-25) order by 2016-04-02 16:03:17,299 INFO [stdout] (default task-25) manufactur1_.fullName 2016-04-02 16:03:17,303 WARN [org.hibernate.jpa.internal.EntityManagerFactoryRegistry] (default task-26) HHH000436: Entity manager factory name (hardwareDBPU) is already registered. If entity manager will be clustered or passivated, specify a unique value for property 'hibernate.ejb.entitymanager_factory_name' 2016-04-02 16:03:17,304 INFO [org.hibernate.hql.internal.QueryTranslatorFactoryInitiator] (default task-26) HHH000397: Using ASTQueryTranslatorFactory 2016-04-02 16:03:17,307 WARN [org.hibernate.jpa.internal.EntityManagerFactoryRegistry] (default task-27) HHH000436: Entity manager factory name (hardwareDBPU) is already registered. If entity manager will be clustered or passivated, specify a unique value for property 'hibernate.ejb.entitymanager_factory_name' 2016-04-02 16:03:17,318 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:17,318 INFO [stdout] (default task-23) select 2016-04-02 16:03:17,318 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:17,318 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:17,318 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:17,318 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:17,318 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:17,318 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:17,318 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:17,318 INFO [stdout] (default task-23) from 2016-04-02 16:03:17,318 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:17,318 INFO [stdout] (default task-23) where 2016-04-02 16:03:17,319 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:17,322 INFO [stdout] (default task-26) Hibernate: 2016-04-02 16:03:17,322 INFO [org.hibernate.hql.internal.QueryTranslatorFactoryInitiator] (default task-27) HHH000397: Using ASTQueryTranslatorFactory 2016-04-02 16:03:17,322 INFO [stdout] (default task-26) select 2016-04-02 16:03:17,322 INFO [stdout] (default task-26) distinct manufactur1_.id as id1_1_, 2016-04-02 16:03:17,322 INFO [stdout] (default task-26) manufactur1_.fullName as fullName2_1_, 2016-04-02 16:03:17,322 INFO [stdout] (default task-26) manufactur1_.shortName as shortNam3_1_ 2016-04-02 16:03:17,322 INFO [stdout] (default task-26) from 2016-04-02 16:03:17,322 INFO [stdout] (default task-26) inverter inverter0_ 2016-04-02 16:03:17,322 INFO [stdout] (default task-26) left outer join 2016-04-02 16:03:17,323 INFO [stdout] (default task-26) manufacturer manufactur1_ 2016-04-02 16:03:17,323 INFO [stdout] (default task-26) on inverter0_.manufacturerId=manufactur1_.id 2016-04-02 16:03:17,323 INFO [stdout] (default task-26) where 2016-04-02 16:03:17,323 INFO [stdout] (default task-26) inverter0_.enabled=1 2016-04-02 16:03:17,323 INFO [stdout] (default task-26) and inverter0_.isActive=1 2016-04-02 16:03:17,323 INFO [stdout] (default task-26) and inverter0_.isAvailableForSimulation=1 2016-04-02 16:03:17,323 INFO [stdout] (default task-26) and ( 2016-04-02 16:03:17,323 INFO [stdout] (default task-26) inverter0_.originalInverterId is null 2016-04-02 16:03:17,323 INFO [stdout] (default task-26) ) 2016-04-02 16:03:17,323 INFO [stdout] (default task-26) order by 2016-04-02 16:03:17,323 INFO [stdout] (default task-26) manufactur1_.fullName 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) Hibernate: 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) select 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) pvmodule0_.id as id1_2_, 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) pvmodule0_.isActive as isActive2_2_, 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) pvmodule0_.isAvailableForSimulation as isAvaila3_2_, 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) pvmodule0_.enabled as enabled4_2_, 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) pvmodule0_.manufacturerId as manufact5_2_, 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) pvmodule0_.nominal_power_rating as nominal_6_2_, 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) pvmodule0_.originalModuleId as original7_2_, 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) pvmodule0_.productFamilyName as productF8_2_ 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) from 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) pvmodule pvmodule0_ 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) where 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) pvmodule0_.enabled=1 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) and pvmodule0_.isActive=1 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) and pvmodule0_.isAvailableForSimulation=1 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) and ( 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) pvmodule0_.originalModuleId is null 2016-04-02 16:03:17,336 INFO [stdout] (default task-27) ) 2016-04-02 16:03:17,339 INFO [stdout] (default task-27) and pvmodule0_.manufacturerId=? 2016-04-02 16:03:17,339 INFO [stdout] (default task-27) order by 2016-04-02 16:03:17,339 INFO [stdout] (default task-27) pvmodule0_.productFamilyName 2016-04-02 16:03:17,492 INFO [org.hibernate.jpa.internal.util.LogHelper] (default task-28) HHH000204: Processing PersistenceUnitInfo [ name: hardwareDBPU ...] 2016-04-02 16:03:17,522 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:17,522 INFO [stdout] (default task-23) select 2016-04-02 16:03:17,522 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:17,522 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:17,522 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:17,522 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:17,522 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:17,522 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:17,522 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:17,522 INFO [stdout] (default task-23) from 2016-04-02 16:03:17,522 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:17,522 INFO [stdout] (default task-23) where 2016-04-02 16:03:17,522 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:17,718 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:17,718 INFO [stdout] (default task-23) select 2016-04-02 16:03:17,719 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:17,719 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:17,719 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:17,719 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:17,719 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:17,719 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:17,719 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:17,719 INFO [stdout] (default task-23) from 2016-04-02 16:03:17,719 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:17,719 INFO [stdout] (default task-23) where 2016-04-02 16:03:17,719 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:17,916 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:17,916 INFO [stdout] (default task-23) select 2016-04-02 16:03:17,916 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:17,916 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:17,916 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:17,916 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:17,916 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:17,916 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:17,916 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:17,916 INFO [stdout] (default task-23) from 2016-04-02 16:03:17,916 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:17,916 INFO [stdout] (default task-23) where 2016-04-02 16:03:17,916 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:18,112 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:18,112 INFO [stdout] (default task-23) select 2016-04-02 16:03:18,112 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:18,112 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:18,112 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:18,112 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:18,112 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:18,112 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:18,112 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:18,112 INFO [stdout] (default task-23) from 2016-04-02 16:03:18,112 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:18,112 INFO [stdout] (default task-23) where 2016-04-02 16:03:18,112 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:18,309 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:18,309 INFO [stdout] (default task-23) select 2016-04-02 16:03:18,309 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:18,309 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:18,309 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:18,309 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:18,309 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:18,309 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:18,309 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:18,309 INFO [stdout] (default task-23) from 2016-04-02 16:03:18,309 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:18,309 INFO [stdout] (default task-23) where 2016-04-02 16:03:18,309 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:18,505 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:18,505 INFO [stdout] (default task-23) select 2016-04-02 16:03:18,506 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:18,506 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:18,506 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:18,506 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:18,506 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:18,506 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:18,506 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:18,506 INFO [stdout] (default task-23) from 2016-04-02 16:03:18,506 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:18,506 INFO [stdout] (default task-23) where 2016-04-02 16:03:18,506 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:18,703 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:18,703 INFO [stdout] (default task-23) select 2016-04-02 16:03:18,703 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:18,703 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:18,703 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:18,703 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:18,703 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:18,703 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:18,703 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:18,703 INFO [stdout] (default task-23) from 2016-04-02 16:03:18,703 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:18,703 INFO [stdout] (default task-23) where 2016-04-02 16:03:18,703 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:18,899 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:18,899 INFO [stdout] (default task-23) select 2016-04-02 16:03:18,899 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:18,899 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:18,899 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:18,900 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:18,900 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:18,900 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:18,900 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:18,900 INFO [stdout] (default task-23) from 2016-04-02 16:03:18,900 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:18,900 INFO [stdout] (default task-23) where 2016-04-02 16:03:18,900 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:19,096 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:19,096 INFO [stdout] (default task-23) select 2016-04-02 16:03:19,096 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:19,096 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:19,096 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:19,096 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:19,096 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:19,096 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:19,096 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:19,096 INFO [stdout] (default task-23) from 2016-04-02 16:03:19,096 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:19,096 INFO [stdout] (default task-23) where 2016-04-02 16:03:19,096 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:19,293 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:19,293 INFO [stdout] (default task-23) select 2016-04-02 16:03:19,293 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:19,293 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:19,294 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:19,294 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:19,294 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:19,294 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:19,294 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:19,294 INFO [stdout] (default task-23) from 2016-04-02 16:03:19,294 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:19,294 INFO [stdout] (default task-23) where 2016-04-02 16:03:19,294 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:19,490 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:19,490 INFO [stdout] (default task-23) select 2016-04-02 16:03:19,490 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:19,490 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:19,490 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:19,490 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:19,490 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:19,490 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:19,490 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:19,490 INFO [stdout] (default task-23) from 2016-04-02 16:03:19,490 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:19,490 INFO [stdout] (default task-23) where 2016-04-02 16:03:19,490 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:19,542 INFO [org.hibernate.dialect.Dialect] (default task-28) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2016-04-02 16:03:19,555 INFO [org.hibernate.envers.boot.internal.EnversServiceImpl] (default task-28) Envers integration enabled? : true 2016-04-02 16:03:19,562 WARN [org.hibernate.boot.internal.SessionFactoryBuilderImpl] (default task-28) Unrecognized hbm2ddl_auto value : none. Supported values include create, create-drop, update, and validate. Ignoring 2016-04-02 16:03:19,577 WARN [org.hibernate.jpa.internal.EntityManagerFactoryRegistry] (default task-28) HHH000436: Entity manager factory name (hardwareDBPU) is already registered. If entity manager will be clustered or passivated, specify a unique value for property 'hibernate.ejb.entitymanager_factory_name' 2016-04-02 16:03:19,578 INFO [org.hibernate.hql.internal.QueryTranslatorFactoryInitiator] (default task-28) HHH000397: Using ASTQueryTranslatorFactory 2016-04-02 16:03:19,583 INFO [stdout] (default task-28) Hibernate: 2016-04-02 16:03:19,583 INFO [stdout] (default task-28) select 2016-04-02 16:03:19,583 INFO [stdout] (default task-28) inverter0_.id as id1_0_, 2016-04-02 16:03:19,583 INFO [stdout] (default task-28) inverter0_.isActive as isActive2_0_, 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) inverter0_.isAvailableForSimulation as isAvaila3_0_, 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) inverter0_.enabled as enabled4_0_, 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) inverter0_.manufacturerId as manufact5_0_, 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) inverter0_.originalInverterId as original6_0_, 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) inverter0_.productFamilyName as productF7_0_ 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) from 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) inverter inverter0_ 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) where 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) inverter0_.enabled=1 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) and inverter0_.isActive=1 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) and inverter0_.isAvailableForSimulation=1 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) and ( 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) inverter0_.originalInverterId is null 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) ) 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) and inverter0_.manufacturerId=? 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) order by 2016-04-02 16:03:19,584 INFO [stdout] (default task-28) inverter0_.productFamilyName 2016-04-02 16:03:19,687 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:19,687 INFO [stdout] (default task-23) select 2016-04-02 16:03:19,687 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:19,687 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:19,687 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:19,687 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:19,687 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:19,687 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:19,687 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:19,687 INFO [stdout] (default task-23) from 2016-04-02 16:03:19,687 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:19,687 INFO [stdout] (default task-23) where 2016-04-02 16:03:19,687 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:19,884 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:19,884 INFO [stdout] (default task-23) select 2016-04-02 16:03:19,884 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:19,884 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:19,884 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:19,884 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:19,884 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:19,884 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:19,884 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:19,884 INFO [stdout] (default task-23) from 2016-04-02 16:03:19,884 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:19,884 INFO [stdout] (default task-23) where 2016-04-02 16:03:19,884 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:20,081 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:20,081 INFO [stdout] (default task-23) select 2016-04-02 16:03:20,081 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:20,081 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:20,081 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:20,081 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:20,081 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:20,081 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:20,081 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:20,081 INFO [stdout] (default task-23) from 2016-04-02 16:03:20,081 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:20,081 INFO [stdout] (default task-23) where 2016-04-02 16:03:20,081 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:20,278 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:20,278 INFO [stdout] (default task-23) select 2016-04-02 16:03:20,278 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:20,278 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:20,278 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:20,278 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:20,278 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:20,278 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:20,278 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:20,278 INFO [stdout] (default task-23) from 2016-04-02 16:03:20,278 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:20,278 INFO [stdout] (default task-23) where 2016-04-02 16:03:20,278 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:20,475 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:20,475 INFO [stdout] (default task-23) select 2016-04-02 16:03:20,475 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:20,475 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:20,475 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:20,475 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:20,475 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:20,475 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:20,476 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:20,476 INFO [stdout] (default task-23) from 2016-04-02 16:03:20,476 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:20,476 INFO [stdout] (default task-23) where 2016-04-02 16:03:20,476 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:20,672 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:20,672 INFO [stdout] (default task-23) select 2016-04-02 16:03:20,672 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:20,672 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:20,672 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:20,672 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:20,672 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:20,672 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:20,672 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:20,672 INFO [stdout] (default task-23) from 2016-04-02 16:03:20,672 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:20,672 INFO [stdout] (default task-23) where 2016-04-02 16:03:20,672 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:20,869 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:20,869 INFO [stdout] (default task-23) select 2016-04-02 16:03:20,869 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:20,869 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:20,869 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:20,869 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:20,869 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:20,869 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:20,869 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:20,869 INFO [stdout] (default task-23) from 2016-04-02 16:03:20,869 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:20,869 INFO [stdout] (default task-23) where 2016-04-02 16:03:20,869 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:21,066 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:21,066 INFO [stdout] (default task-23) select 2016-04-02 16:03:21,067 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:21,067 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:21,067 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:21,067 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:21,067 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:21,067 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:21,067 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:21,067 INFO [stdout] (default task-23) from 2016-04-02 16:03:21,067 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:21,067 INFO [stdout] (default task-23) where 2016-04-02 16:03:21,067 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:21,262 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:21,262 INFO [stdout] (default task-23) select 2016-04-02 16:03:21,262 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:21,262 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:21,262 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:21,263 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:21,263 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:21,263 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:21,263 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:21,263 INFO [stdout] (default task-23) from 2016-04-02 16:03:21,263 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:21,263 INFO [stdout] (default task-23) where 2016-04-02 16:03:21,263 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:21,459 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:21,459 INFO [stdout] (default task-23) select 2016-04-02 16:03:21,459 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:21,459 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:21,459 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:21,459 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:21,459 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:21,459 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:21,459 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:21,459 INFO [stdout] (default task-23) from 2016-04-02 16:03:21,459 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:21,459 INFO [stdout] (default task-23) where 2016-04-02 16:03:21,459 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:21,657 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:21,657 INFO [stdout] (default task-23) select 2016-04-02 16:03:21,657 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:21,657 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:21,657 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:21,657 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:21,657 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:21,657 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:21,657 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:21,657 INFO [stdout] (default task-23) from 2016-04-02 16:03:21,657 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:21,657 INFO [stdout] (default task-23) where 2016-04-02 16:03:21,657 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:21,854 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:21,854 INFO [stdout] (default task-23) select 2016-04-02 16:03:21,854 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:21,854 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:21,854 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:21,854 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:21,854 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:21,854 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:21,854 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:21,854 INFO [stdout] (default task-23) from 2016-04-02 16:03:21,854 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:21,854 INFO [stdout] (default task-23) where 2016-04-02 16:03:21,854 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:22,050 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:22,050 INFO [stdout] (default task-23) select 2016-04-02 16:03:22,050 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:22,050 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:22,050 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:22,050 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:22,050 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:22,050 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:22,050 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:22,050 INFO [stdout] (default task-23) from 2016-04-02 16:03:22,050 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:22,050 INFO [stdout] (default task-23) where 2016-04-02 16:03:22,050 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:22,247 INFO [stdout] (default task-23) Hibernate: 2016-04-02 16:03:22,248 INFO [stdout] (default task-23) select 2016-04-02 16:03:22,248 INFO [stdout] (default task-23) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:22,248 INFO [stdout] (default task-23) address0_.address1 as address2_0_0_, 2016-04-02 16:03:22,248 INFO [stdout] (default task-23) address0_.address2 as address3_0_0_, 2016-04-02 16:03:22,248 INFO [stdout] (default task-23) address0_.city as city4_0_0_, 2016-04-02 16:03:22,248 INFO [stdout] (default task-23) address0_.country as country5_0_0_, 2016-04-02 16:03:22,248 INFO [stdout] (default task-23) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:22,248 INFO [stdout] (default task-23) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:22,248 INFO [stdout] (default task-23) from 2016-04-02 16:03:22,248 INFO [stdout] (default task-23) Address address0_ 2016-04-02 16:03:22,248 INFO [stdout] (default task-23) where 2016-04-02 16:03:22,248 INFO [stdout] (default task-23) address0_.addressId=? 2016-04-02 16:03:54,783 INFO [com.pvcomplete.pvsketch.api.core.dal.util.QueryHelper] (default task-29) SELECT e FROM Project e LEFT JOIN FETCH e.address a LEFT JOIN FETCH e.createdBy u LEFT JOIN FETCH e.customer c WHERE e.businessAccountId = :businessAccountId 2016-04-02 16:03:54,784 INFO [stdout] (default task-29) Hibernate: 2016-04-02 16:03:54,784 INFO [stdout] (default task-29) select 2016-04-02 16:03:54,784 INFO [stdout] (default task-29) project0_.projectId as projectI1_11_0_, 2016-04-02 16:03:54,784 INFO [stdout] (default task-29) address1_.addressId as addressI1_0_1_, 2016-04-02 16:03:54,784 INFO [stdout] (default task-29) useraccoun2_.userAccountId as userAcco1_16_2_, 2016-04-02 16:03:54,784 INFO [stdout] (default task-29) customer3_.customerId as customer1_2_3_, 2016-04-02 16:03:54,784 INFO [stdout] (default task-29) project0_.addressId as address10_11_0_, 2016-04-02 16:03:54,784 INFO [stdout] (default task-29) project0_.businessAccountId as business2_11_0_, 2016-04-02 16:03:54,784 INFO [stdout] (default task-29) project0_.createdBy as created11_11_0_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) project0_.createdOn as createdO3_11_0_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) project0_.customerId as custome12_11_0_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) project0_.latitude as latitude4_11_0_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) project0_.longitude as longitud5_11_0_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) project0_.modifiedBy as modifie13_11_0_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) project0_.modifiedOn as modified6_11_0_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) project0_.name as name7_11_0_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) project0_.notes as notes8_11_0_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) project0_.utilityProviderId as utilityP9_11_0_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) address1_.address1 as address2_0_1_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) address1_.address2 as address3_0_1_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) address1_.city as city4_0_1_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) address1_.country as country5_0_1_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) address1_.stateProvince as statePro6_0_1_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) address1_.zipCode as zipCode7_0_1_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) useraccoun2_.businessAccountId as business2_16_2_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) useraccoun2_.isConfirmed as isConfir3_16_2_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) useraccoun2_.displayName as displayN4_16_2_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) useraccoun2_.email as email5_16_2_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) useraccoun2_.isEnabled as isEnable6_16_2_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) useraccoun2_.firstName as firstNam7_16_2_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) useraccoun2_.lastName as lastName8_16_2_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) useraccoun2_.password as password9_16_2_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) useraccoun2_.phoneNumber as phoneNu10_16_2_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) useraccoun2_.roleId as roleId12_16_2_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) useraccoun2_.userName as userNam11_16_2_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) customer3_.addressId as address10_2_3_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) customer3_.businessAccountId as business2_2_3_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) customer3_.companyName as companyN3_2_3_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) customer3_.createdBy as created11_2_3_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) customer3_.createdOn as createdO4_2_3_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) customer3_.email as email5_2_3_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) customer3_.firstName as firstNam6_2_3_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) customer3_.lastName as lastName7_2_3_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) customer3_.modifiedBy as modifie12_2_3_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) customer3_.modifiedOn as modified8_2_3_, 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) customer3_.phoneNumber as phoneNum9_2_3_ 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) from 2016-04-02 16:03:54,785 INFO [stdout] (default task-29) Project project0_ 2016-04-02 16:03:54,786 INFO [stdout] (default task-29) left outer join 2016-04-02 16:03:54,786 INFO [stdout] (default task-29) Address address1_ 2016-04-02 16:03:54,786 INFO [stdout] (default task-29) on project0_.addressId=address1_.addressId 2016-04-02 16:03:54,786 INFO [stdout] (default task-29) left outer join 2016-04-02 16:03:54,786 INFO [stdout] (default task-29) UserAccount useraccoun2_ 2016-04-02 16:03:54,786 INFO [stdout] (default task-29) on project0_.createdBy=useraccoun2_.userAccountId 2016-04-02 16:03:54,786 INFO [stdout] (default task-29) left outer join 2016-04-02 16:03:54,786 INFO [stdout] (default task-29) Customer customer3_ 2016-04-02 16:03:54,786 INFO [stdout] (default task-29) on project0_.customerId=customer3_.customerId 2016-04-02 16:03:54,786 INFO [stdout] (default task-29) where 2016-04-02 16:03:54,786 INFO [stdout] (default task-29) project0_.businessAccountId=? limit ? 2016-04-02 16:03:55,137 INFO [stdout] (default task-29) Hibernate: 2016-04-02 16:03:55,137 INFO [stdout] (default task-29) select 2016-04-02 16:03:55,138 INFO [stdout] (default task-29) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:55,138 INFO [stdout] (default task-29) address0_.address1 as address2_0_0_, 2016-04-02 16:03:55,138 INFO [stdout] (default task-29) address0_.address2 as address3_0_0_, 2016-04-02 16:03:55,138 INFO [stdout] (default task-29) address0_.city as city4_0_0_, 2016-04-02 16:03:55,138 INFO [stdout] (default task-29) address0_.country as country5_0_0_, 2016-04-02 16:03:55,138 INFO [stdout] (default task-29) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:55,138 INFO [stdout] (default task-29) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:55,138 INFO [stdout] (default task-29) from 2016-04-02 16:03:55,138 INFO [stdout] (default task-29) Address address0_ 2016-04-02 16:03:55,138 INFO [stdout] (default task-29) where 2016-04-02 16:03:55,138 INFO [stdout] (default task-29) address0_.addressId=? 2016-04-02 16:03:55,339 INFO [stdout] (default task-29) Hibernate: 2016-04-02 16:03:55,340 INFO [stdout] (default task-29) select 2016-04-02 16:03:55,340 INFO [stdout] (default task-29) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:55,340 INFO [stdout] (default task-29) address0_.address1 as address2_0_0_, 2016-04-02 16:03:55,340 INFO [stdout] (default task-29) address0_.address2 as address3_0_0_, 2016-04-02 16:03:55,340 INFO [stdout] (default task-29) address0_.city as city4_0_0_, 2016-04-02 16:03:55,340 INFO [stdout] (default task-29) address0_.country as country5_0_0_, 2016-04-02 16:03:55,340 INFO [stdout] (default task-29) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:55,340 INFO [stdout] (default task-29) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:55,340 INFO [stdout] (default task-29) from 2016-04-02 16:03:55,340 INFO [stdout] (default task-29) Address address0_ 2016-04-02 16:03:55,340 INFO [stdout] (default task-29) where 2016-04-02 16:03:55,340 INFO [stdout] (default task-29) address0_.addressId=? 2016-04-02 16:03:55,536 INFO [stdout] (default task-29) Hibernate: 2016-04-02 16:03:55,536 INFO [stdout] (default task-29) select 2016-04-02 16:03:55,536 INFO [stdout] (default task-29) address0_.addressId as addressI1_0_0_, 2016-04-02 16:03:55,536 INFO [stdout] (default task-29) address0_.address1 as address2_0_0_, 2016-04-02 16:03:55,536 INFO [stdout] (default task-29) address0_.address2 as address3_0_0_, 2016-04-02 16:03:55,536 INFO [stdout] (default task-29) address0_.city as city4_0_0_, 2016-04-02 16:03:55,536 INFO [stdout] (default task-29) address0_.country as country5_0_0_, 2016-04-02 16:03:55,536 INFO [stdout] (default task-29) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:03:55,536 INFO [stdout] (default task-29) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:03:55,536 INFO [stdout] (default task-29) from 2016-04-02 16:03:55,536 INFO [stdout] (default task-29) Address address0_ 2016-04-02 16:03:55,536 INFO [stdout] (default task-29) where 2016-04-02 16:03:55,536 INFO [stdout] (default task-29) address0_.addressId=? 2016-04-02 16:03:55,733 INFO [com.pvcomplete.pvsketch.api.core.dal.util.QueryHelper] (default task-29) SELECT count(e.projectId) FROM Project e LEFT JOIN e.address a LEFT JOIN e.customer c WHERE e.businessAccountId = :businessAccountId 2016-04-02 16:03:55,734 INFO [stdout] (default task-29) Hibernate: 2016-04-02 16:03:55,734 INFO [stdout] (default task-29) select 2016-04-02 16:03:55,734 INFO [stdout] (default task-29) count(project0_.projectId) as col_0_0_ 2016-04-02 16:03:55,734 INFO [stdout] (default task-29) from 2016-04-02 16:03:55,734 INFO [stdout] (default task-29) Project project0_ 2016-04-02 16:03:55,734 INFO [stdout] (default task-29) left outer join 2016-04-02 16:03:55,734 INFO [stdout] (default task-29) Address address1_ 2016-04-02 16:03:55,734 INFO [stdout] (default task-29) on project0_.addressId=address1_.addressId 2016-04-02 16:03:55,734 INFO [stdout] (default task-29) left outer join 2016-04-02 16:03:55,734 INFO [stdout] (default task-29) Customer customer2_ 2016-04-02 16:03:55,734 INFO [stdout] (default task-29) on project0_.customerId=customer2_.customerId 2016-04-02 16:03:55,734 INFO [stdout] (default task-29) where 2016-04-02 16:03:55,734 INFO [stdout] (default task-29) project0_.businessAccountId=? 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) Hibernate: 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) select 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) useraccoun0_.userAccountId as userAcco1_16_0_, 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) useraccoun0_.businessAccountId as business2_16_0_, 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) useraccoun0_.isConfirmed as isConfir3_16_0_, 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) useraccoun0_.displayName as displayN4_16_0_, 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) useraccoun0_.email as email5_16_0_, 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) useraccoun0_.isEnabled as isEnable6_16_0_, 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) useraccoun0_.firstName as firstNam7_16_0_, 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) useraccoun0_.lastName as lastName8_16_0_, 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) useraccoun0_.password as password9_16_0_, 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) useraccoun0_.phoneNumber as phoneNu10_16_0_, 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) useraccoun0_.roleId as roleId12_16_0_, 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) useraccoun0_.userName as userNam11_16_0_ 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) from 2016-04-02 16:03:57,724 INFO [stdout] (default task-30) UserAccount useraccoun0_ 2016-04-02 16:03:57,725 INFO [stdout] (default task-30) where 2016-04-02 16:03:57,725 INFO [stdout] (default task-30) useraccoun0_.userAccountId=? 2016-04-02 16:03:59,096 INFO [stdout] (default task-31) Hibernate: 2016-04-02 16:03:59,096 INFO [stdout] (default task-31) select 2016-04-02 16:03:59,096 INFO [stdout] (default task-31) businessac0_.businessAccountId as business1_1_0_, 2016-04-02 16:03:59,096 INFO [stdout] (default task-31) businessac0_.address1 as address2_1_0_, 2016-04-02 16:03:59,097 INFO [stdout] (default task-31) businessac0_.address2 as address3_1_0_, 2016-04-02 16:03:59,097 INFO [stdout] (default task-31) businessac0_.city as city4_1_0_, 2016-04-02 16:03:59,097 INFO [stdout] (default task-31) businessac0_.companyName as companyN5_1_0_, 2016-04-02 16:03:59,097 INFO [stdout] (default task-31) businessac0_.country as country6_1_0_, 2016-04-02 16:03:59,097 INFO [stdout] (default task-31) businessac0_.imageFilename as imageFil7_1_0_, 2016-04-02 16:03:59,097 INFO [stdout] (default task-31) businessac0_.licenseNumber as licenseN8_1_0_, 2016-04-02 16:03:59,097 INFO [stdout] (default task-31) businessac0_.stateProvince as statePro9_1_0_, 2016-04-02 16:03:59,097 INFO [stdout] (default task-31) businessac0_.zipCode as zipCode10_1_0_ 2016-04-02 16:03:59,097 INFO [stdout] (default task-31) from 2016-04-02 16:03:59,097 INFO [stdout] (default task-31) BusinessAccount businessac0_ 2016-04-02 16:03:59,097 INFO [stdout] (default task-31) where 2016-04-02 16:03:59,097 INFO [stdout] (default task-31) businessac0_.businessAccountId=? 2016-04-02 16:03:59,333 INFO [stdout] (default task-31) Hibernate: 2016-04-02 16:03:59,333 INFO [stdout] (default task-31) select 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) profile0_.profileId as profileI1_10_, 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) profile0_.category as category2_10_, 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) profile0_.description as descript3_10_, 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) profile0_.name as name4_10_, 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) profile0_.value as value5_10_, 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) profile0_.worksFrom as worksFro6_10_, 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) profile0_.worksTill as worksTil7_10_ 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) from 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) Profile profile0_ 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) where 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) profile0_.name=? 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) and profile0_.category=? 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) and ( 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) profile0_.worksFrom is null 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) or profile0_.worksFrom<=? 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) ) 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) and ( 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) profile0_.worksTill is null 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) or profile0_.worksTill>? 2016-04-02 16:03:59,334 INFO [stdout] (default task-31) ) 2016-04-02 16:03:59,536 INFO [stdout] (default task-31) Hibernate: 2016-04-02 16:03:59,536 INFO [stdout] (default task-31) select 2016-04-02 16:03:59,536 INFO [stdout] (default task-31) profile0_.profileId as profileI1_10_, 2016-04-02 16:03:59,536 INFO [stdout] (default task-31) profile0_.category as category2_10_, 2016-04-02 16:03:59,536 INFO [stdout] (default task-31) profile0_.description as descript3_10_, 2016-04-02 16:03:59,536 INFO [stdout] (default task-31) profile0_.name as name4_10_, 2016-04-02 16:03:59,536 INFO [stdout] (default task-31) profile0_.value as value5_10_, 2016-04-02 16:03:59,536 INFO [stdout] (default task-31) profile0_.worksFrom as worksFro6_10_, 2016-04-02 16:03:59,536 INFO [stdout] (default task-31) profile0_.worksTill as worksTil7_10_ 2016-04-02 16:03:59,536 INFO [stdout] (default task-31) from 2016-04-02 16:03:59,536 INFO [stdout] (default task-31) Profile profile0_ 2016-04-02 16:03:59,536 INFO [stdout] (default task-31) where 2016-04-02 16:03:59,536 INFO [stdout] (default task-31) profile0_.name=? 2016-04-02 16:03:59,536 INFO [stdout] (default task-31) and profile0_.category=? 2016-04-02 16:03:59,536 INFO [stdout] (default task-31) and ( 2016-04-02 16:03:59,537 INFO [stdout] (default task-31) profile0_.worksFrom is null 2016-04-02 16:03:59,537 INFO [stdout] (default task-31) or profile0_.worksFrom<=? 2016-04-02 16:03:59,537 INFO [stdout] (default task-31) ) 2016-04-02 16:03:59,537 INFO [stdout] (default task-31) and ( 2016-04-02 16:03:59,537 INFO [stdout] (default task-31) profile0_.worksTill is null 2016-04-02 16:03:59,537 INFO [stdout] (default task-31) or profile0_.worksTill>? 2016-04-02 16:03:59,537 INFO [stdout] (default task-31) ) 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) Hibernate: 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) select 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) profile0_.profileId as profileI1_10_, 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) profile0_.category as category2_10_, 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) profile0_.description as descript3_10_, 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) profile0_.name as name4_10_, 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) profile0_.value as value5_10_, 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) profile0_.worksFrom as worksFro6_10_, 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) profile0_.worksTill as worksTil7_10_ 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) from 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) Profile profile0_ 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) where 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) profile0_.name=? 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) and profile0_.category=? 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) and ( 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) profile0_.worksFrom is null 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) or profile0_.worksFrom<=? 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) ) 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) and ( 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) profile0_.worksTill is null 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) or profile0_.worksTill>? 2016-04-02 16:03:59,742 INFO [stdout] (default task-31) ) 2016-04-02 16:04:00,007 INFO [com.pvcomplete.pvsketch.api.core.util.EmailPeriodicTimer] (EJB default - 1) Email periodic timer start... 2016-04-02 16:04:00,013 INFO [stdout] (EJB default - 1) Hibernate: 2016-04-02 16:04:00,013 INFO [stdout] (EJB default - 1) select 2016-04-02 16:04:00,013 INFO [stdout] (EJB default - 1) emailqueue0_.emailQueueId as emailQue1_4_, 2016-04-02 16:04:00,013 INFO [stdout] (EJB default - 1) emailqueue0_.created as created2_4_, 2016-04-02 16:04:00,013 INFO [stdout] (EJB default - 1) emailqueue0_.emailId as emailId3_4_, 2016-04-02 16:04:00,013 INFO [stdout] (EJB default - 1) emailqueue0_.priority as priority4_4_, 2016-04-02 16:04:00,013 INFO [stdout] (EJB default - 1) emailqueue0_.retry as retry5_4_, 2016-04-02 16:04:00,014 INFO [stdout] (EJB default - 1) emailqueue0_.status as status6_4_, 2016-04-02 16:04:00,014 INFO [stdout] (EJB default - 1) emailqueue0_.statusDescription as statusDe7_4_, 2016-04-02 16:04:00,014 INFO [stdout] (EJB default - 1) emailqueue0_.updated as updated8_4_ 2016-04-02 16:04:00,014 INFO [stdout] (EJB default - 1) from 2016-04-02 16:04:00,014 INFO [stdout] (EJB default - 1) EmailQueue emailqueue0_ 2016-04-02 16:04:00,014 INFO [stdout] (EJB default - 1) where 2016-04-02 16:04:00,014 INFO [stdout] (EJB default - 1) emailqueue0_.status=? 2016-04-02 16:04:00,014 INFO [stdout] (EJB default - 1) order by 2016-04-02 16:04:00,014 INFO [stdout] (EJB default - 1) emailqueue0_.priority desc 2016-04-02 16:04:00,086 INFO [stdout] (default task-31) Hibernate: 2016-04-02 16:04:00,086 INFO [stdout] (default task-31) select 2016-04-02 16:04:00,086 INFO [stdout] (default task-31) profile0_.profileId as profileI1_10_, 2016-04-02 16:04:00,086 INFO [stdout] (default task-31) profile0_.category as category2_10_, 2016-04-02 16:04:00,086 INFO [stdout] (default task-31) profile0_.description as descript3_10_, 2016-04-02 16:04:00,086 INFO [stdout] (default task-31) profile0_.name as name4_10_, 2016-04-02 16:04:00,086 INFO [stdout] (default task-31) profile0_.value as value5_10_, 2016-04-02 16:04:00,086 INFO [stdout] (default task-31) profile0_.worksFrom as worksFro6_10_, 2016-04-02 16:04:00,086 INFO [stdout] (default task-31) profile0_.worksTill as worksTil7_10_ 2016-04-02 16:04:00,086 INFO [stdout] (default task-31) from 2016-04-02 16:04:00,087 INFO [stdout] (default task-31) Profile profile0_ 2016-04-02 16:04:00,087 INFO [stdout] (default task-31) where 2016-04-02 16:04:00,087 INFO [stdout] (default task-31) profile0_.name=? 2016-04-02 16:04:00,087 INFO [stdout] (default task-31) and profile0_.category=? 2016-04-02 16:04:00,087 INFO [stdout] (default task-31) and ( 2016-04-02 16:04:00,087 INFO [stdout] (default task-31) profile0_.worksFrom is null 2016-04-02 16:04:00,087 INFO [stdout] (default task-31) or profile0_.worksFrom<=? 2016-04-02 16:04:00,087 INFO [stdout] (default task-31) ) 2016-04-02 16:04:00,087 INFO [stdout] (default task-31) and ( 2016-04-02 16:04:00,087 INFO [stdout] (default task-31) profile0_.worksTill is null 2016-04-02 16:04:00,087 INFO [stdout] (default task-31) or profile0_.worksTill>? 2016-04-02 16:04:00,087 INFO [stdout] (default task-31) ) 2016-04-02 16:04:00,212 INFO [com.pvcomplete.pvsketch.api.core.util.EmailPeriodicTimer] (EJB default - 1) Email periodic timer end... 2016-04-02 16:04:07,500 INFO [com.pvcomplete.pvsketch.api.core.dal.util.QueryHelper] (default task-32) SELECT e FROM Project e LEFT JOIN FETCH e.address a LEFT JOIN FETCH e.createdBy u LEFT JOIN FETCH e.customer c WHERE e.businessAccountId = :businessAccountId 2016-04-02 16:04:07,501 INFO [stdout] (default task-32) Hibernate: 2016-04-02 16:04:07,502 INFO [stdout] (default task-32) select 2016-04-02 16:04:07,502 INFO [stdout] (default task-32) project0_.projectId as projectI1_11_0_, 2016-04-02 16:04:07,502 INFO [stdout] (default task-32) address1_.addressId as addressI1_0_1_, 2016-04-02 16:04:07,502 INFO [stdout] (default task-32) useraccoun2_.userAccountId as userAcco1_16_2_, 2016-04-02 16:04:07,502 INFO [stdout] (default task-32) customer3_.customerId as customer1_2_3_, 2016-04-02 16:04:07,502 INFO [stdout] (default task-32) project0_.addressId as address10_11_0_, 2016-04-02 16:04:07,502 INFO [stdout] (default task-32) project0_.businessAccountId as business2_11_0_, 2016-04-02 16:04:07,502 INFO [stdout] (default task-32) project0_.createdBy as created11_11_0_, 2016-04-02 16:04:07,502 INFO [stdout] (default task-32) project0_.createdOn as createdO3_11_0_, 2016-04-02 16:04:07,502 INFO [stdout] (default task-32) project0_.customerId as custome12_11_0_, 2016-04-02 16:04:07,502 INFO [stdout] (default task-32) project0_.latitude as latitude4_11_0_, 2016-04-02 16:04:07,502 INFO [stdout] (default task-32) project0_.longitude as longitud5_11_0_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) project0_.modifiedBy as modifie13_11_0_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) project0_.modifiedOn as modified6_11_0_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) project0_.name as name7_11_0_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) project0_.notes as notes8_11_0_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) project0_.utilityProviderId as utilityP9_11_0_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) address1_.address1 as address2_0_1_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) address1_.address2 as address3_0_1_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) address1_.city as city4_0_1_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) address1_.country as country5_0_1_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) address1_.stateProvince as statePro6_0_1_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) address1_.zipCode as zipCode7_0_1_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) useraccoun2_.businessAccountId as business2_16_2_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) useraccoun2_.isConfirmed as isConfir3_16_2_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) useraccoun2_.displayName as displayN4_16_2_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) useraccoun2_.email as email5_16_2_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) useraccoun2_.isEnabled as isEnable6_16_2_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) useraccoun2_.firstName as firstNam7_16_2_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) useraccoun2_.lastName as lastName8_16_2_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) useraccoun2_.password as password9_16_2_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) useraccoun2_.phoneNumber as phoneNu10_16_2_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) useraccoun2_.roleId as roleId12_16_2_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) useraccoun2_.userName as userNam11_16_2_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) customer3_.addressId as address10_2_3_, 2016-04-02 16:04:07,503 INFO [stdout] (default task-32) customer3_.businessAccountId as business2_2_3_, 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) customer3_.companyName as companyN3_2_3_, 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) customer3_.createdBy as created11_2_3_, 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) customer3_.createdOn as createdO4_2_3_, 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) customer3_.email as email5_2_3_, 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) customer3_.firstName as firstNam6_2_3_, 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) customer3_.lastName as lastName7_2_3_, 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) customer3_.modifiedBy as modifie12_2_3_, 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) customer3_.modifiedOn as modified8_2_3_, 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) customer3_.phoneNumber as phoneNum9_2_3_ 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) from 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) Project project0_ 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) left outer join 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) Address address1_ 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) on project0_.addressId=address1_.addressId 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) left outer join 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) UserAccount useraccoun2_ 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) on project0_.createdBy=useraccoun2_.userAccountId 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) left outer join 2016-04-02 16:04:07,504 INFO [stdout] (default task-32) Customer customer3_ 2016-04-02 16:04:07,505 INFO [stdout] (default task-32) on project0_.customerId=customer3_.customerId 2016-04-02 16:04:07,505 INFO [stdout] (default task-32) where 2016-04-02 16:04:07,505 INFO [stdout] (default task-32) project0_.businessAccountId=? limit ? 2016-04-02 16:04:07,697 INFO [stdout] (default task-32) Hibernate: 2016-04-02 16:04:07,697 INFO [stdout] (default task-32) select 2016-04-02 16:04:07,697 INFO [stdout] (default task-32) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:07,697 INFO [stdout] (default task-32) address0_.address1 as address2_0_0_, 2016-04-02 16:04:07,697 INFO [stdout] (default task-32) address0_.address2 as address3_0_0_, 2016-04-02 16:04:07,697 INFO [stdout] (default task-32) address0_.city as city4_0_0_, 2016-04-02 16:04:07,697 INFO [stdout] (default task-32) address0_.country as country5_0_0_, 2016-04-02 16:04:07,697 INFO [stdout] (default task-32) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:07,698 INFO [stdout] (default task-32) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:07,698 INFO [stdout] (default task-32) from 2016-04-02 16:04:07,698 INFO [stdout] (default task-32) Address address0_ 2016-04-02 16:04:07,698 INFO [stdout] (default task-32) where 2016-04-02 16:04:07,698 INFO [stdout] (default task-32) address0_.addressId=? 2016-04-02 16:04:07,879 INFO [stdout] (default task-32) Hibernate: 2016-04-02 16:04:07,879 INFO [stdout] (default task-32) select 2016-04-02 16:04:07,879 INFO [stdout] (default task-32) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:07,879 INFO [stdout] (default task-32) address0_.address1 as address2_0_0_, 2016-04-02 16:04:07,879 INFO [stdout] (default task-32) address0_.address2 as address3_0_0_, 2016-04-02 16:04:07,880 INFO [stdout] (default task-32) address0_.city as city4_0_0_, 2016-04-02 16:04:07,880 INFO [stdout] (default task-32) address0_.country as country5_0_0_, 2016-04-02 16:04:07,880 INFO [stdout] (default task-32) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:07,880 INFO [stdout] (default task-32) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:07,880 INFO [stdout] (default task-32) from 2016-04-02 16:04:07,880 INFO [stdout] (default task-32) Address address0_ 2016-04-02 16:04:07,880 INFO [stdout] (default task-32) where 2016-04-02 16:04:07,880 INFO [stdout] (default task-32) address0_.addressId=? 2016-04-02 16:04:08,067 INFO [stdout] (default task-32) Hibernate: 2016-04-02 16:04:08,067 INFO [stdout] (default task-32) select 2016-04-02 16:04:08,067 INFO [stdout] (default task-32) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:08,067 INFO [stdout] (default task-32) address0_.address1 as address2_0_0_, 2016-04-02 16:04:08,067 INFO [stdout] (default task-32) address0_.address2 as address3_0_0_, 2016-04-02 16:04:08,067 INFO [stdout] (default task-32) address0_.city as city4_0_0_, 2016-04-02 16:04:08,067 INFO [stdout] (default task-32) address0_.country as country5_0_0_, 2016-04-02 16:04:08,067 INFO [stdout] (default task-32) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:08,067 INFO [stdout] (default task-32) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:08,067 INFO [stdout] (default task-32) from 2016-04-02 16:04:08,067 INFO [stdout] (default task-32) Address address0_ 2016-04-02 16:04:08,067 INFO [stdout] (default task-32) where 2016-04-02 16:04:08,067 INFO [stdout] (default task-32) address0_.addressId=? 2016-04-02 16:04:08,253 INFO [com.pvcomplete.pvsketch.api.core.dal.util.QueryHelper] (default task-32) SELECT count(e.projectId) FROM Project e LEFT JOIN e.address a LEFT JOIN e.customer c WHERE e.businessAccountId = :businessAccountId 2016-04-02 16:04:08,253 INFO [stdout] (default task-32) Hibernate: 2016-04-02 16:04:08,253 INFO [stdout] (default task-32) select 2016-04-02 16:04:08,253 INFO [stdout] (default task-32) count(project0_.projectId) as col_0_0_ 2016-04-02 16:04:08,253 INFO [stdout] (default task-32) from 2016-04-02 16:04:08,254 INFO [stdout] (default task-32) Project project0_ 2016-04-02 16:04:08,254 INFO [stdout] (default task-32) left outer join 2016-04-02 16:04:08,254 INFO [stdout] (default task-32) Address address1_ 2016-04-02 16:04:08,254 INFO [stdout] (default task-32) on project0_.addressId=address1_.addressId 2016-04-02 16:04:08,254 INFO [stdout] (default task-32) left outer join 2016-04-02 16:04:08,254 INFO [stdout] (default task-32) Customer customer2_ 2016-04-02 16:04:08,254 INFO [stdout] (default task-32) on project0_.customerId=customer2_.customerId 2016-04-02 16:04:08,254 INFO [stdout] (default task-32) where 2016-04-02 16:04:08,254 INFO [stdout] (default task-32) project0_.businessAccountId=? 2016-04-02 16:04:15,906 INFO [stdout] (default task-33) Hibernate: 2016-04-02 16:04:15,906 INFO [stdout] (default task-33) select 2016-04-02 16:04:15,906 INFO [stdout] (default task-33) project0_.projectId as projectI1_11_0_, 2016-04-02 16:04:15,906 INFO [stdout] (default task-33) address1_.addressId as addressI1_0_1_, 2016-04-02 16:04:15,906 INFO [stdout] (default task-33) useraccoun2_.userAccountId as userAcco1_16_2_, 2016-04-02 16:04:15,906 INFO [stdout] (default task-33) customer3_.customerId as customer1_2_3_, 2016-04-02 16:04:15,906 INFO [stdout] (default task-33) roofs4_.roofId as roofId1_14_4_, 2016-04-02 16:04:15,906 INFO [stdout] (default task-33) project0_.addressId as address10_11_0_, 2016-04-02 16:04:15,906 INFO [stdout] (default task-33) project0_.businessAccountId as business2_11_0_, 2016-04-02 16:04:15,906 INFO [stdout] (default task-33) project0_.createdBy as created11_11_0_, 2016-04-02 16:04:15,906 INFO [stdout] (default task-33) project0_.createdOn as createdO3_11_0_, 2016-04-02 16:04:15,906 INFO [stdout] (default task-33) project0_.customerId as custome12_11_0_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) project0_.latitude as latitude4_11_0_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) project0_.longitude as longitud5_11_0_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) project0_.modifiedBy as modifie13_11_0_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) project0_.modifiedOn as modified6_11_0_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) project0_.name as name7_11_0_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) project0_.notes as notes8_11_0_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) project0_.utilityProviderId as utilityP9_11_0_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) address1_.address1 as address2_0_1_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) address1_.address2 as address3_0_1_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) address1_.city as city4_0_1_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) address1_.country as country5_0_1_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) address1_.stateProvince as statePro6_0_1_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) address1_.zipCode as zipCode7_0_1_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) useraccoun2_.businessAccountId as business2_16_2_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) useraccoun2_.isConfirmed as isConfir3_16_2_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) useraccoun2_.displayName as displayN4_16_2_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) useraccoun2_.email as email5_16_2_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) useraccoun2_.isEnabled as isEnable6_16_2_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) useraccoun2_.firstName as firstNam7_16_2_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) useraccoun2_.lastName as lastName8_16_2_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) useraccoun2_.password as password9_16_2_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) useraccoun2_.phoneNumber as phoneNu10_16_2_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) useraccoun2_.roleId as roleId12_16_2_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) useraccoun2_.userName as userNam11_16_2_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) customer3_.addressId as address10_2_3_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) customer3_.businessAccountId as business2_2_3_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) customer3_.companyName as companyN3_2_3_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) customer3_.createdBy as created11_2_3_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) customer3_.createdOn as createdO4_2_3_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) customer3_.email as email5_2_3_, 2016-04-02 16:04:15,907 INFO [stdout] (default task-33) customer3_.firstName as firstNam6_2_3_, 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) customer3_.lastName as lastName7_2_3_, 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) customer3_.modifiedBy as modifie12_2_3_, 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) customer3_.modifiedOn as modified8_2_3_, 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) customer3_.phoneNumber as phoneNum9_2_3_, 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) roofs4_.description as descript2_14_4_, 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) roofs4_.hasParapetWall as hasParap3_14_4_, 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) roofs4_.roofIndex as roofInde4_14_4_, 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) roofs4_.meanHeight as meanHeig5_14_4_, 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) roofs4_.name as name6_14_4_, 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) roofs4_.parapetWallHeight as parapetW7_14_4_, 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) roofs4_.projectId as projectI9_14_4_, 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) roofs4_.setback as setback8_14_4_, 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) roofs4_.projectId as projectI9_14_0__, 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) roofs4_.roofId as roofId1_14_0__ 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) from 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) Project project0_ 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) left outer join 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) Address address1_ 2016-04-02 16:04:15,908 INFO [stdout] (default task-33) on project0_.addressId=address1_.addressId 2016-04-02 16:04:15,909 INFO [stdout] (default task-33) left outer join 2016-04-02 16:04:15,909 INFO [stdout] (default task-33) UserAccount useraccoun2_ 2016-04-02 16:04:15,909 INFO [stdout] (default task-33) on project0_.createdBy=useraccoun2_.userAccountId 2016-04-02 16:04:15,909 INFO [stdout] (default task-33) left outer join 2016-04-02 16:04:15,909 INFO [stdout] (default task-33) Customer customer3_ 2016-04-02 16:04:15,909 INFO [stdout] (default task-33) on project0_.customerId=customer3_.customerId 2016-04-02 16:04:15,909 INFO [stdout] (default task-33) left outer join 2016-04-02 16:04:15,909 INFO [stdout] (default task-33) Roof roofs4_ 2016-04-02 16:04:15,909 INFO [stdout] (default task-33) on project0_.projectId=roofs4_.projectId 2016-04-02 16:04:15,909 INFO [stdout] (default task-33) where 2016-04-02 16:04:15,909 INFO [stdout] (default task-33) project0_.projectId=? 2016-04-02 16:04:15,909 INFO [stdout] (default task-33) order by 2016-04-02 16:04:15,909 INFO [stdout] (default task-33) roofs4_.roofId, 2016-04-02 16:04:15,909 INFO [stdout] (default task-33) roofs4_.roofId 2016-04-02 16:04:15,915 INFO [stdout] (default task-35) Hibernate: 2016-04-02 16:04:15,915 INFO [stdout] (default task-35) select 2016-04-02 16:04:15,915 INFO [stdout] (default task-35) utilitypro0_.utilityProviderId as utilityP1_17_, 2016-04-02 16:04:15,915 INFO [stdout] (default task-35) utilitypro0_.fullName as fullName2_17_, 2016-04-02 16:04:15,915 INFO [stdout] (default task-35) utilitypro0_.shortName as shortNam3_17_ 2016-04-02 16:04:15,915 INFO [stdout] (default task-35) from 2016-04-02 16:04:15,915 INFO [stdout] (default task-35) UtilityProvider utilitypro0_ 2016-04-02 16:04:15,915 INFO [stdout] (default task-35) order by 2016-04-02 16:04:15,915 INFO [stdout] (default task-35) utilitypro0_.shortName asc 2016-04-02 16:04:15,915 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:15,915 INFO [stdout] (default task-34) select 2016-04-02 16:04:15,915 INFO [stdout] (default task-34) customer0_.customerId as customer1_2_, 2016-04-02 16:04:15,915 INFO [stdout] (default task-34) customer0_.addressId as address10_2_, 2016-04-02 16:04:15,915 INFO [stdout] (default task-34) customer0_.businessAccountId as business2_2_, 2016-04-02 16:04:15,915 INFO [stdout] (default task-34) customer0_.companyName as companyN3_2_, 2016-04-02 16:04:15,915 INFO [stdout] (default task-34) customer0_.createdBy as created11_2_, 2016-04-02 16:04:15,915 INFO [stdout] (default task-34) customer0_.createdOn as createdO4_2_, 2016-04-02 16:04:15,915 INFO [stdout] (default task-34) customer0_.email as email5_2_, 2016-04-02 16:04:15,915 INFO [stdout] (default task-34) customer0_.firstName as firstNam6_2_, 2016-04-02 16:04:15,915 INFO [stdout] (default task-34) customer0_.lastName as lastName7_2_, 2016-04-02 16:04:15,915 INFO [stdout] (default task-34) customer0_.modifiedBy as modifie12_2_, 2016-04-02 16:04:15,915 INFO [stdout] (default task-34) customer0_.modifiedOn as modified8_2_, 2016-04-02 16:04:15,916 INFO [stdout] (default task-34) customer0_.phoneNumber as phoneNum9_2_ 2016-04-02 16:04:15,916 INFO [stdout] (default task-34) from 2016-04-02 16:04:15,916 INFO [stdout] (default task-34) Customer customer0_ 2016-04-02 16:04:15,916 INFO [stdout] (default task-34) where 2016-04-02 16:04:15,916 INFO [stdout] (default task-34) customer0_.businessAccountId=? 2016-04-02 16:04:16,093 INFO [stdout] (default task-33) Hibernate: 2016-04-02 16:04:16,093 INFO [stdout] (default task-33) select 2016-04-02 16:04:16,093 INFO [stdout] (default task-33) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:16,094 INFO [stdout] (default task-33) address0_.address1 as address2_0_0_, 2016-04-02 16:04:16,094 INFO [stdout] (default task-33) address0_.address2 as address3_0_0_, 2016-04-02 16:04:16,094 INFO [stdout] (default task-33) address0_.city as city4_0_0_, 2016-04-02 16:04:16,094 INFO [stdout] (default task-33) address0_.country as country5_0_0_, 2016-04-02 16:04:16,094 INFO [stdout] (default task-33) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:16,094 INFO [stdout] (default task-33) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:16,094 INFO [stdout] (default task-33) from 2016-04-02 16:04:16,094 INFO [stdout] (default task-33) Address address0_ 2016-04-02 16:04:16,094 INFO [stdout] (default task-33) where 2016-04-02 16:04:16,094 INFO [stdout] (default task-33) address0_.addressId=? 2016-04-02 16:04:16,112 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:16,112 INFO [stdout] (default task-34) select 2016-04-02 16:04:16,112 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:16,112 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:16,112 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:16,112 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:16,112 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:16,112 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:16,112 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:16,112 INFO [stdout] (default task-34) from 2016-04-02 16:04:16,112 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:16,112 INFO [stdout] (default task-34) where 2016-04-02 16:04:16,112 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:16,279 INFO [stdout] (default task-33) Hibernate: 2016-04-02 16:04:16,279 INFO [stdout] (default task-33) select 2016-04-02 16:04:16,279 INFO [stdout] (default task-33) rooffaces0_.roofId as roofId5_15_0_, 2016-04-02 16:04:16,279 INFO [stdout] (default task-33) rooffaces0_.roofFaceId as roofFace1_15_0_, 2016-04-02 16:04:16,279 INFO [stdout] (default task-33) rooffaces0_.roofFaceId as roofFace1_15_1_, 2016-04-02 16:04:16,279 INFO [stdout] (default task-33) rooffaces0_.azimuth as azimuth2_15_1_, 2016-04-02 16:04:16,279 INFO [stdout] (default task-33) rooffaces0_.polygon2dLocalJson as polygon3_15_1_, 2016-04-02 16:04:16,279 INFO [stdout] (default task-33) rooffaces0_.roofId as roofId5_15_1_, 2016-04-02 16:04:16,279 INFO [stdout] (default task-33) rooffaces0_.slope as slope4_15_1_ 2016-04-02 16:04:16,279 INFO [stdout] (default task-33) from 2016-04-02 16:04:16,279 INFO [stdout] (default task-33) RoofFace rooffaces0_ 2016-04-02 16:04:16,279 INFO [stdout] (default task-33) where 2016-04-02 16:04:16,279 INFO [stdout] (default task-33) rooffaces0_.roofId=? 2016-04-02 16:04:16,306 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:16,306 INFO [stdout] (default task-34) select 2016-04-02 16:04:16,306 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:16,306 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:16,306 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:16,306 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:16,306 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:16,306 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:16,306 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:16,306 INFO [stdout] (default task-34) from 2016-04-02 16:04:16,306 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:16,306 INFO [stdout] (default task-34) where 2016-04-02 16:04:16,306 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:16,465 INFO [stdout] (default task-33) Hibernate: 2016-04-02 16:04:16,465 INFO [stdout] (default task-33) select 2016-04-02 16:04:16,465 INFO [stdout] (default task-33) obstructio0_.roofId as roofId9_8_0_, 2016-04-02 16:04:16,465 INFO [stdout] (default task-33) obstructio0_.obstructionId as obstruct1_8_0_, 2016-04-02 16:04:16,465 INFO [stdout] (default task-33) obstructio0_.obstructionId as obstruct1_8_1_, 2016-04-02 16:04:16,465 INFO [stdout] (default task-33) obstructio0_.description as descript2_8_1_, 2016-04-02 16:04:16,465 INFO [stdout] (default task-33) obstructio0_.height as height3_8_1_, 2016-04-02 16:04:16,465 INFO [stdout] (default task-33) obstructio0_.obstructionIndex as obstruct4_8_1_, 2016-04-02 16:04:16,465 INFO [stdout] (default task-33) obstructio0_.name as name5_8_1_, 2016-04-02 16:04:16,465 INFO [stdout] (default task-33) obstructio0_.polygon2dLocalJson as polygon6_8_1_, 2016-04-02 16:04:16,466 INFO [stdout] (default task-33) obstructio0_.projectId as projectI8_8_1_, 2016-04-02 16:04:16,466 INFO [stdout] (default task-33) obstructio0_.roofId as roofId9_8_1_, 2016-04-02 16:04:16,466 INFO [stdout] (default task-33) obstructio0_.setback as setback7_8_1_ 2016-04-02 16:04:16,466 INFO [stdout] (default task-33) from 2016-04-02 16:04:16,466 INFO [stdout] (default task-33) Obstruction obstructio0_ 2016-04-02 16:04:16,466 INFO [stdout] (default task-33) where 2016-04-02 16:04:16,466 INFO [stdout] (default task-33) obstructio0_.roofId=? 2016-04-02 16:04:16,502 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:16,502 INFO [stdout] (default task-34) select 2016-04-02 16:04:16,502 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:16,502 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:16,502 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:16,502 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:16,502 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:16,502 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:16,502 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:16,502 INFO [stdout] (default task-34) from 2016-04-02 16:04:16,502 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:16,502 INFO [stdout] (default task-34) where 2016-04-02 16:04:16,502 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:16,653 INFO [stdout] (default task-33) Hibernate: 2016-04-02 16:04:16,653 INFO [stdout] (default task-33) select 2016-04-02 16:04:16,653 INFO [stdout] (default task-33) installati0_.roofId as roofId6_6_0_, 2016-04-02 16:04:16,653 INFO [stdout] (default task-33) installati0_.installationAreaId as installa1_6_0_, 2016-04-02 16:04:16,653 INFO [stdout] (default task-33) installati0_.installationAreaId as installa1_6_1_, 2016-04-02 16:04:16,653 INFO [stdout] (default task-33) installati0_.description as descript2_6_1_, 2016-04-02 16:04:16,653 INFO [stdout] (default task-33) installati0_.installationAreaIndex as installa3_6_1_, 2016-04-02 16:04:16,653 INFO [stdout] (default task-33) installati0_.name as name4_6_1_, 2016-04-02 16:04:16,653 INFO [stdout] (default task-33) installati0_.polygon2dLocalJson as polygon5_6_1_, 2016-04-02 16:04:16,653 INFO [stdout] (default task-33) installati0_.roofId as roofId6_6_1_ 2016-04-02 16:04:16,653 INFO [stdout] (default task-33) from 2016-04-02 16:04:16,653 INFO [stdout] (default task-33) InstallationArea installati0_ 2016-04-02 16:04:16,653 INFO [stdout] (default task-33) where 2016-04-02 16:04:16,653 INFO [stdout] (default task-33) installati0_.roofId=? 2016-04-02 16:04:16,699 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:16,699 INFO [stdout] (default task-34) select 2016-04-02 16:04:16,699 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:16,699 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:16,699 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:16,699 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:16,699 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:16,700 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:16,700 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:16,700 INFO [stdout] (default task-34) from 2016-04-02 16:04:16,700 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:16,700 INFO [stdout] (default task-34) where 2016-04-02 16:04:16,700 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) Hibernate: 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) select 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) useraccoun0_.userAccountId as userAcco1_16_0_, 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) useraccoun0_.businessAccountId as business2_16_0_, 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) useraccoun0_.isConfirmed as isConfir3_16_0_, 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) useraccoun0_.displayName as displayN4_16_0_, 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) useraccoun0_.email as email5_16_0_, 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) useraccoun0_.isEnabled as isEnable6_16_0_, 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) useraccoun0_.firstName as firstNam7_16_0_, 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) useraccoun0_.lastName as lastName8_16_0_, 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) useraccoun0_.password as password9_16_0_, 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) useraccoun0_.phoneNumber as phoneNu10_16_0_, 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) useraccoun0_.roleId as roleId12_16_0_, 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) useraccoun0_.userName as userNam11_16_0_ 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) from 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) UserAccount useraccoun0_ 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) where 2016-04-02 16:04:16,839 INFO [stdout] (default task-33) useraccoun0_.userAccountId=? 2016-04-02 16:04:16,896 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:16,896 INFO [stdout] (default task-34) select 2016-04-02 16:04:16,896 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:16,896 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:16,896 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:16,896 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:16,896 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:16,896 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:16,896 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:16,896 INFO [stdout] (default task-34) from 2016-04-02 16:04:16,896 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:16,896 INFO [stdout] (default task-34) where 2016-04-02 16:04:16,896 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:17,026 INFO [stdout] (default task-33) Hibernate: 2016-04-02 16:04:17,026 INFO [stdout] (default task-33) select 2016-04-02 16:04:17,026 INFO [stdout] (default task-33) obstructio0_.obstructionId as obstruct1_8_, 2016-04-02 16:04:17,026 INFO [stdout] (default task-33) obstructio0_.description as descript2_8_, 2016-04-02 16:04:17,026 INFO [stdout] (default task-33) obstructio0_.height as height3_8_, 2016-04-02 16:04:17,026 INFO [stdout] (default task-33) obstructio0_.obstructionIndex as obstruct4_8_, 2016-04-02 16:04:17,026 INFO [stdout] (default task-33) obstructio0_.name as name5_8_, 2016-04-02 16:04:17,026 INFO [stdout] (default task-33) obstructio0_.polygon2dLocalJson as polygon6_8_, 2016-04-02 16:04:17,026 INFO [stdout] (default task-33) obstructio0_.projectId as projectI8_8_, 2016-04-02 16:04:17,026 INFO [stdout] (default task-33) obstructio0_.roofId as roofId9_8_, 2016-04-02 16:04:17,026 INFO [stdout] (default task-33) obstructio0_.setback as setback7_8_ 2016-04-02 16:04:17,026 INFO [stdout] (default task-33) from 2016-04-02 16:04:17,026 INFO [stdout] (default task-33) Obstruction obstructio0_ 2016-04-02 16:04:17,027 INFO [stdout] (default task-33) where 2016-04-02 16:04:17,027 INFO [stdout] (default task-33) obstructio0_.projectId=? 2016-04-02 16:04:17,027 INFO [stdout] (default task-33) and ( 2016-04-02 16:04:17,027 INFO [stdout] (default task-33) obstructio0_.roofId is null 2016-04-02 16:04:17,027 INFO [stdout] (default task-33) ) 2016-04-02 16:04:17,027 INFO [stdout] (default task-33) order by 2016-04-02 16:04:17,027 INFO [stdout] (default task-33) obstructio0_.obstructionId 2016-04-02 16:04:17,093 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:17,093 INFO [stdout] (default task-34) select 2016-04-02 16:04:17,093 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:17,093 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:17,093 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:17,093 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:17,093 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:17,093 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:17,093 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:17,093 INFO [stdout] (default task-34) from 2016-04-02 16:04:17,093 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:17,093 INFO [stdout] (default task-34) where 2016-04-02 16:04:17,093 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) Hibernate: 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) select 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) version0_.versionId as versionI1_18_, 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) version0_.dhRatio as dhRatio2_18_, 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) version0_.ewSpacing as ewSpacin3_18_, 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) version0_.inverterId as inverter4_18_, 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) version0_.layoutId as layoutI10_18_, 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) version0_.orientation as orientat5_18_, 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) version0_.projectId as project11_18_, 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) version0_.pvModuleId as pvModule6_18_, 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) version0_.rackingId as rackingI7_18_, 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) version0_.rowSpacing as rowSpaci8_18_, 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) version0_.tilt as tilt9_18_ 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) from 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) Version version0_ 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) where 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) version0_.projectId=? 2016-04-02 16:04:17,214 INFO [stdout] (default task-33) order by 2016-04-02 16:04:17,215 INFO [stdout] (default task-33) version0_.versionId 2016-04-02 16:04:17,290 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:17,290 INFO [stdout] (default task-34) select 2016-04-02 16:04:17,290 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:17,290 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:17,290 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:17,290 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:17,290 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:17,290 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:17,291 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:17,291 INFO [stdout] (default task-34) from 2016-04-02 16:04:17,291 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:17,291 INFO [stdout] (default task-34) where 2016-04-02 16:04:17,291 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:17,401 INFO [stdout] (default task-33) Hibernate: 2016-04-02 16:04:17,401 INFO [stdout] (default task-33) select 2016-04-02 16:04:17,401 INFO [stdout] (default task-33) layout0_.layoutId as layoutId1_7_0_, 2016-04-02 16:04:17,401 INFO [stdout] (default task-33) layout0_.layoutUnitsJson as layoutUn2_7_0_ 2016-04-02 16:04:17,401 INFO [stdout] (default task-33) from 2016-04-02 16:04:17,401 INFO [stdout] (default task-33) Layout layout0_ 2016-04-02 16:04:17,401 INFO [stdout] (default task-33) where 2016-04-02 16:04:17,401 INFO [stdout] (default task-33) layout0_.layoutId=? 2016-04-02 16:04:17,487 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:17,487 INFO [stdout] (default task-34) select 2016-04-02 16:04:17,487 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:17,487 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:17,487 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:17,487 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:17,487 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:17,487 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:17,487 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:17,487 INFO [stdout] (default task-34) from 2016-04-02 16:04:17,487 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:17,487 INFO [stdout] (default task-34) where 2016-04-02 16:04:17,487 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:17,615 INFO [org.hibernate.jpa.internal.util.LogHelper] (default task-36) HHH000204: Processing PersistenceUnitInfo [ name: hardwareDBPU ...] 2016-04-02 16:04:17,623 INFO [org.hibernate.dialect.Dialect] (default task-36) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2016-04-02 16:04:17,630 INFO [org.hibernate.envers.boot.internal.EnversServiceImpl] (default task-36) Envers integration enabled? : true 2016-04-02 16:04:17,631 INFO [org.hibernate.jpa.internal.util.LogHelper] (default task-37) HHH000204: Processing PersistenceUnitInfo [ name: hardwareDBPU ...] 2016-04-02 16:04:17,639 INFO [org.hibernate.dialect.Dialect] (default task-37) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2016-04-02 16:04:17,650 WARN [org.hibernate.boot.internal.SessionFactoryBuilderImpl] (default task-36) Unrecognized hbm2ddl_auto value : none. Supported values include create, create-drop, update, and validate. Ignoring 2016-04-02 16:04:17,660 INFO [org.hibernate.envers.boot.internal.EnversServiceImpl] (default task-37) Envers integration enabled? : true 2016-04-02 16:04:17,685 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:17,685 INFO [stdout] (default task-34) select 2016-04-02 16:04:17,685 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:17,685 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:17,685 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:17,685 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:17,685 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:17,685 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:17,685 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:17,685 INFO [stdout] (default task-34) from 2016-04-02 16:04:17,685 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:17,685 INFO [stdout] (default task-34) where 2016-04-02 16:04:17,685 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:17,713 WARN [org.hibernate.boot.internal.SessionFactoryBuilderImpl] (default task-37) Unrecognized hbm2ddl_auto value : none. Supported values include create, create-drop, update, and validate. Ignoring 2016-04-02 16:04:17,731 WARN [org.hibernate.jpa.internal.EntityManagerFactoryRegistry] (default task-36) HHH000436: Entity manager factory name (hardwareDBPU) is already registered. If entity manager will be clustered or passivated, specify a unique value for property 'hibernate.ejb.entitymanager_factory_name' 2016-04-02 16:04:17,732 INFO [org.hibernate.hql.internal.QueryTranslatorFactoryInitiator] (default task-36) HHH000397: Using ASTQueryTranslatorFactory 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) Hibernate: 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) select 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) distinct manufactur1_.id as id1_1_, 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) manufactur1_.fullName as fullName2_1_, 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) manufactur1_.shortName as shortNam3_1_ 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) from 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) pvmodule pvmodule0_ 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) left outer join 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) manufacturer manufactur1_ 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) on pvmodule0_.manufacturerId=manufactur1_.id 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) where 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) pvmodule0_.enabled=1 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) and pvmodule0_.isActive=1 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) and pvmodule0_.isAvailableForSimulation=1 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) and ( 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) pvmodule0_.originalModuleId is null 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) ) 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) order by 2016-04-02 16:04:17,739 INFO [stdout] (default task-36) manufactur1_.fullName 2016-04-02 16:04:17,741 WARN [org.hibernate.jpa.internal.EntityManagerFactoryRegistry] (default task-37) HHH000436: Entity manager factory name (hardwareDBPU) is already registered. If entity manager will be clustered or passivated, specify a unique value for property 'hibernate.ejb.entitymanager_factory_name' 2016-04-02 16:04:17,745 INFO [org.hibernate.hql.internal.QueryTranslatorFactoryInitiator] (default task-37) HHH000397: Using ASTQueryTranslatorFactory 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) Hibernate: 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) select 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) distinct manufactur1_.id as id1_1_, 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) manufactur1_.fullName as fullName2_1_, 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) manufactur1_.shortName as shortNam3_1_ 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) from 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) inverter inverter0_ 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) left outer join 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) manufacturer manufactur1_ 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) on inverter0_.manufacturerId=manufactur1_.id 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) where 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) inverter0_.enabled=1 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) and inverter0_.isActive=1 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) and inverter0_.isAvailableForSimulation=1 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) and ( 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) inverter0_.originalInverterId is null 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) ) 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) order by 2016-04-02 16:04:17,752 INFO [stdout] (default task-37) manufactur1_.fullName 2016-04-02 16:04:17,881 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:17,881 INFO [stdout] (default task-34) select 2016-04-02 16:04:17,881 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:17,881 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:17,881 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:17,882 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:17,882 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:17,882 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:17,882 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:17,882 INFO [stdout] (default task-34) from 2016-04-02 16:04:17,882 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:17,882 INFO [stdout] (default task-34) where 2016-04-02 16:04:17,882 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:18,077 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:18,078 INFO [stdout] (default task-34) select 2016-04-02 16:04:18,078 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:18,078 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:18,078 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:18,078 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:18,078 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:18,078 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:18,078 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:18,078 INFO [stdout] (default task-34) from 2016-04-02 16:04:18,078 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:18,078 INFO [stdout] (default task-34) where 2016-04-02 16:04:18,078 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:18,275 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:18,275 INFO [stdout] (default task-34) select 2016-04-02 16:04:18,275 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:18,275 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:18,275 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:18,275 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:18,275 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:18,275 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:18,275 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:18,275 INFO [stdout] (default task-34) from 2016-04-02 16:04:18,275 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:18,275 INFO [stdout] (default task-34) where 2016-04-02 16:04:18,275 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:18,471 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:18,472 INFO [stdout] (default task-34) select 2016-04-02 16:04:18,472 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:18,472 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:18,472 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:18,472 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:18,472 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:18,472 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:18,472 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:18,472 INFO [stdout] (default task-34) from 2016-04-02 16:04:18,472 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:18,472 INFO [stdout] (default task-34) where 2016-04-02 16:04:18,472 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:18,668 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:18,668 INFO [stdout] (default task-34) select 2016-04-02 16:04:18,668 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:18,668 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:18,668 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:18,668 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:18,668 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:18,668 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:18,668 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:18,668 INFO [stdout] (default task-34) from 2016-04-02 16:04:18,668 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:18,668 INFO [stdout] (default task-34) where 2016-04-02 16:04:18,668 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:18,866 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:18,866 INFO [stdout] (default task-34) select 2016-04-02 16:04:18,866 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:18,866 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:18,866 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:18,866 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:18,866 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:18,866 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:18,866 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:18,866 INFO [stdout] (default task-34) from 2016-04-02 16:04:18,866 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:18,866 INFO [stdout] (default task-34) where 2016-04-02 16:04:18,866 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:19,062 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:19,062 INFO [stdout] (default task-34) select 2016-04-02 16:04:19,062 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:19,062 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:19,062 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:19,062 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:19,062 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:19,062 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:19,062 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:19,062 INFO [stdout] (default task-34) from 2016-04-02 16:04:19,062 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:19,062 INFO [stdout] (default task-34) where 2016-04-02 16:04:19,063 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:19,259 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:19,259 INFO [stdout] (default task-34) select 2016-04-02 16:04:19,259 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:19,259 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:19,259 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:19,259 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:19,259 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:19,259 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:19,259 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:19,259 INFO [stdout] (default task-34) from 2016-04-02 16:04:19,259 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:19,259 INFO [stdout] (default task-34) where 2016-04-02 16:04:19,259 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:19,456 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:19,456 INFO [stdout] (default task-34) select 2016-04-02 16:04:19,456 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:19,456 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:19,456 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:19,456 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:19,456 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:19,456 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:19,456 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:19,456 INFO [stdout] (default task-34) from 2016-04-02 16:04:19,456 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:19,456 INFO [stdout] (default task-34) where 2016-04-02 16:04:19,456 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:19,653 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:19,653 INFO [stdout] (default task-34) select 2016-04-02 16:04:19,653 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:19,653 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:19,653 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:19,653 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:19,653 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:19,654 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:19,654 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:19,654 INFO [stdout] (default task-34) from 2016-04-02 16:04:19,654 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:19,654 INFO [stdout] (default task-34) where 2016-04-02 16:04:19,654 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:19,850 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:19,850 INFO [stdout] (default task-34) select 2016-04-02 16:04:19,850 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:19,850 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:19,850 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:19,850 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:19,850 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:19,850 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:19,850 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:19,850 INFO [stdout] (default task-34) from 2016-04-02 16:04:19,850 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:19,850 INFO [stdout] (default task-34) where 2016-04-02 16:04:19,850 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:20,047 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:20,047 INFO [stdout] (default task-34) select 2016-04-02 16:04:20,047 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:20,047 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:20,047 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:20,047 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:20,047 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:20,047 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:20,047 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:20,047 INFO [stdout] (default task-34) from 2016-04-02 16:04:20,047 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:20,047 INFO [stdout] (default task-34) where 2016-04-02 16:04:20,047 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:20,243 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:20,243 INFO [stdout] (default task-34) select 2016-04-02 16:04:20,243 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:20,243 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:20,244 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:20,244 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:20,244 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:20,244 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:20,244 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:20,244 INFO [stdout] (default task-34) from 2016-04-02 16:04:20,244 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:20,244 INFO [stdout] (default task-34) where 2016-04-02 16:04:20,244 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:20,441 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:20,441 INFO [stdout] (default task-34) select 2016-04-02 16:04:20,441 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:20,441 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:20,441 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:20,441 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:20,441 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:20,441 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:20,441 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:20,441 INFO [stdout] (default task-34) from 2016-04-02 16:04:20,441 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:20,441 INFO [stdout] (default task-34) where 2016-04-02 16:04:20,441 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:20,638 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:20,638 INFO [stdout] (default task-34) select 2016-04-02 16:04:20,638 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:20,638 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:20,638 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:20,638 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:20,638 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:20,639 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:20,639 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:20,639 INFO [stdout] (default task-34) from 2016-04-02 16:04:20,639 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:20,639 INFO [stdout] (default task-34) where 2016-04-02 16:04:20,639 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:20,834 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:20,834 INFO [stdout] (default task-34) select 2016-04-02 16:04:20,834 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:20,835 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:20,835 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:20,835 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:20,835 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:20,835 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:20,835 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:20,835 INFO [stdout] (default task-34) from 2016-04-02 16:04:20,835 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:20,835 INFO [stdout] (default task-34) where 2016-04-02 16:04:20,835 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:21,031 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:21,032 INFO [stdout] (default task-34) select 2016-04-02 16:04:21,032 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:21,032 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:21,032 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:21,032 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:21,032 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:21,032 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:21,032 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:21,032 INFO [stdout] (default task-34) from 2016-04-02 16:04:21,032 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:21,032 INFO [stdout] (default task-34) where 2016-04-02 16:04:21,032 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:21,228 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:21,229 INFO [stdout] (default task-34) select 2016-04-02 16:04:21,229 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:21,229 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:21,229 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:21,229 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:21,229 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:21,229 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:21,229 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:21,229 INFO [stdout] (default task-34) from 2016-04-02 16:04:21,229 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:21,229 INFO [stdout] (default task-34) where 2016-04-02 16:04:21,229 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:21,425 INFO [stdout] (default task-34) Hibernate: 2016-04-02 16:04:21,425 INFO [stdout] (default task-34) select 2016-04-02 16:04:21,425 INFO [stdout] (default task-34) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:21,425 INFO [stdout] (default task-34) address0_.address1 as address2_0_0_, 2016-04-02 16:04:21,425 INFO [stdout] (default task-34) address0_.address2 as address3_0_0_, 2016-04-02 16:04:21,425 INFO [stdout] (default task-34) address0_.city as city4_0_0_, 2016-04-02 16:04:21,425 INFO [stdout] (default task-34) address0_.country as country5_0_0_, 2016-04-02 16:04:21,425 INFO [stdout] (default task-34) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:21,425 INFO [stdout] (default task-34) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:21,425 INFO [stdout] (default task-34) from 2016-04-02 16:04:21,425 INFO [stdout] (default task-34) Address address0_ 2016-04-02 16:04:21,425 INFO [stdout] (default task-34) where 2016-04-02 16:04:21,425 INFO [stdout] (default task-34) address0_.addressId=? 2016-04-02 16:04:24,744 INFO [com.pvcomplete.pvsketch.api.core.dal.util.QueryHelper] (default task-38) SELECT e FROM Project e LEFT JOIN FETCH e.address a LEFT JOIN FETCH e.createdBy u LEFT JOIN FETCH e.customer c WHERE e.businessAccountId = :businessAccountId 2016-04-02 16:04:24,745 INFO [stdout] (default task-38) Hibernate: 2016-04-02 16:04:24,745 INFO [stdout] (default task-38) select 2016-04-02 16:04:24,745 INFO [stdout] (default task-38) project0_.projectId as projectI1_11_0_, 2016-04-02 16:04:24,745 INFO [stdout] (default task-38) address1_.addressId as addressI1_0_1_, 2016-04-02 16:04:24,745 INFO [stdout] (default task-38) useraccoun2_.userAccountId as userAcco1_16_2_, 2016-04-02 16:04:24,745 INFO [stdout] (default task-38) customer3_.customerId as customer1_2_3_, 2016-04-02 16:04:24,745 INFO [stdout] (default task-38) project0_.addressId as address10_11_0_, 2016-04-02 16:04:24,745 INFO [stdout] (default task-38) project0_.businessAccountId as business2_11_0_, 2016-04-02 16:04:24,745 INFO [stdout] (default task-38) project0_.createdBy as created11_11_0_, 2016-04-02 16:04:24,745 INFO [stdout] (default task-38) project0_.createdOn as createdO3_11_0_, 2016-04-02 16:04:24,745 INFO [stdout] (default task-38) project0_.customerId as custome12_11_0_, 2016-04-02 16:04:24,745 INFO [stdout] (default task-38) project0_.latitude as latitude4_11_0_, 2016-04-02 16:04:24,745 INFO [stdout] (default task-38) project0_.longitude as longitud5_11_0_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) project0_.modifiedBy as modifie13_11_0_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) project0_.modifiedOn as modified6_11_0_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) project0_.name as name7_11_0_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) project0_.notes as notes8_11_0_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) project0_.utilityProviderId as utilityP9_11_0_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) address1_.address1 as address2_0_1_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) address1_.address2 as address3_0_1_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) address1_.city as city4_0_1_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) address1_.country as country5_0_1_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) address1_.stateProvince as statePro6_0_1_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) address1_.zipCode as zipCode7_0_1_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) useraccoun2_.businessAccountId as business2_16_2_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) useraccoun2_.isConfirmed as isConfir3_16_2_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) useraccoun2_.displayName as displayN4_16_2_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) useraccoun2_.email as email5_16_2_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) useraccoun2_.isEnabled as isEnable6_16_2_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) useraccoun2_.firstName as firstNam7_16_2_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) useraccoun2_.lastName as lastName8_16_2_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) useraccoun2_.password as password9_16_2_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) useraccoun2_.phoneNumber as phoneNu10_16_2_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) useraccoun2_.roleId as roleId12_16_2_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) useraccoun2_.userName as userNam11_16_2_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) customer3_.addressId as address10_2_3_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) customer3_.businessAccountId as business2_2_3_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) customer3_.companyName as companyN3_2_3_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) customer3_.createdBy as created11_2_3_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) customer3_.createdOn as createdO4_2_3_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) customer3_.email as email5_2_3_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) customer3_.firstName as firstNam6_2_3_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) customer3_.lastName as lastName7_2_3_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) customer3_.modifiedBy as modifie12_2_3_, 2016-04-02 16:04:24,746 INFO [stdout] (default task-38) customer3_.modifiedOn as modified8_2_3_, 2016-04-02 16:04:24,747 INFO [stdout] (default task-38) customer3_.phoneNumber as phoneNum9_2_3_ 2016-04-02 16:04:24,747 INFO [stdout] (default task-38) from 2016-04-02 16:04:24,747 INFO [stdout] (default task-38) Project project0_ 2016-04-02 16:04:24,747 INFO [stdout] (default task-38) left outer join 2016-04-02 16:04:24,747 INFO [stdout] (default task-38) Address address1_ 2016-04-02 16:04:24,747 INFO [stdout] (default task-38) on project0_.addressId=address1_.addressId 2016-04-02 16:04:24,747 INFO [stdout] (default task-38) left outer join 2016-04-02 16:04:24,747 INFO [stdout] (default task-38) UserAccount useraccoun2_ 2016-04-02 16:04:24,747 INFO [stdout] (default task-38) on project0_.createdBy=useraccoun2_.userAccountId 2016-04-02 16:04:24,747 INFO [stdout] (default task-38) left outer join 2016-04-02 16:04:24,747 INFO [stdout] (default task-38) Customer customer3_ 2016-04-02 16:04:24,747 INFO [stdout] (default task-38) on project0_.customerId=customer3_.customerId 2016-04-02 16:04:24,747 INFO [stdout] (default task-38) where 2016-04-02 16:04:24,747 INFO [stdout] (default task-38) project0_.businessAccountId=? limit ? 2016-04-02 16:04:24,943 INFO [stdout] (default task-38) Hibernate: 2016-04-02 16:04:24,944 INFO [stdout] (default task-38) select 2016-04-02 16:04:24,944 INFO [stdout] (default task-38) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:24,944 INFO [stdout] (default task-38) address0_.address1 as address2_0_0_, 2016-04-02 16:04:24,944 INFO [stdout] (default task-38) address0_.address2 as address3_0_0_, 2016-04-02 16:04:24,944 INFO [stdout] (default task-38) address0_.city as city4_0_0_, 2016-04-02 16:04:24,944 INFO [stdout] (default task-38) address0_.country as country5_0_0_, 2016-04-02 16:04:24,944 INFO [stdout] (default task-38) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:24,944 INFO [stdout] (default task-38) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:24,944 INFO [stdout] (default task-38) from 2016-04-02 16:04:24,944 INFO [stdout] (default task-38) Address address0_ 2016-04-02 16:04:24,944 INFO [stdout] (default task-38) where 2016-04-02 16:04:24,944 INFO [stdout] (default task-38) address0_.addressId=? 2016-04-02 16:04:25,138 INFO [stdout] (default task-38) Hibernate: 2016-04-02 16:04:25,138 INFO [stdout] (default task-38) select 2016-04-02 16:04:25,138 INFO [stdout] (default task-38) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:25,138 INFO [stdout] (default task-38) address0_.address1 as address2_0_0_, 2016-04-02 16:04:25,138 INFO [stdout] (default task-38) address0_.address2 as address3_0_0_, 2016-04-02 16:04:25,138 INFO [stdout] (default task-38) address0_.city as city4_0_0_, 2016-04-02 16:04:25,138 INFO [stdout] (default task-38) address0_.country as country5_0_0_, 2016-04-02 16:04:25,138 INFO [stdout] (default task-38) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:25,138 INFO [stdout] (default task-38) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:25,138 INFO [stdout] (default task-38) from 2016-04-02 16:04:25,138 INFO [stdout] (default task-38) Address address0_ 2016-04-02 16:04:25,138 INFO [stdout] (default task-38) where 2016-04-02 16:04:25,138 INFO [stdout] (default task-38) address0_.addressId=? 2016-04-02 16:04:25,334 INFO [stdout] (default task-38) Hibernate: 2016-04-02 16:04:25,335 INFO [stdout] (default task-38) select 2016-04-02 16:04:25,335 INFO [stdout] (default task-38) address0_.addressId as addressI1_0_0_, 2016-04-02 16:04:25,335 INFO [stdout] (default task-38) address0_.address1 as address2_0_0_, 2016-04-02 16:04:25,335 INFO [stdout] (default task-38) address0_.address2 as address3_0_0_, 2016-04-02 16:04:25,335 INFO [stdout] (default task-38) address0_.city as city4_0_0_, 2016-04-02 16:04:25,335 INFO [stdout] (default task-38) address0_.country as country5_0_0_, 2016-04-02 16:04:25,335 INFO [stdout] (default task-38) address0_.stateProvince as statePro6_0_0_, 2016-04-02 16:04:25,335 INFO [stdout] (default task-38) address0_.zipCode as zipCode7_0_0_ 2016-04-02 16:04:25,335 INFO [stdout] (default task-38) from 2016-04-02 16:04:25,335 INFO [stdout] (default task-38) Address address0_ 2016-04-02 16:04:25,335 INFO [stdout] (default task-38) where 2016-04-02 16:04:25,335 INFO [stdout] (default task-38) address0_.addressId=? 2016-04-02 16:04:25,531 INFO [com.pvcomplete.pvsketch.api.core.dal.util.QueryHelper] (default task-38) SELECT count(e.projectId) FROM Project e LEFT JOIN e.address a LEFT JOIN e.customer c WHERE e.businessAccountId = :businessAccountId 2016-04-02 16:04:25,531 INFO [stdout] (default task-38) Hibernate: 2016-04-02 16:04:25,532 INFO [stdout] (default task-38) select 2016-04-02 16:04:25,532 INFO [stdout] (default task-38) count(project0_.projectId) as col_0_0_ 2016-04-02 16:04:25,532 INFO [stdout] (default task-38) from 2016-04-02 16:04:25,532 INFO [stdout] (default task-38) Project project0_ 2016-04-02 16:04:25,532 INFO [stdout] (default task-38) left outer join 2016-04-02 16:04:25,532 INFO [stdout] (default task-38) Address address1_ 2016-04-02 16:04:25,532 INFO [stdout] (default task-38) on project0_.addressId=address1_.addressId 2016-04-02 16:04:25,532 INFO [stdout] (default task-38) left outer join 2016-04-02 16:04:25,532 INFO [stdout] (default task-38) Customer customer2_ 2016-04-02 16:04:25,532 INFO [stdout] (default task-38) on project0_.customerId=customer2_.customerId 2016-04-02 16:04:25,532 INFO [stdout] (default task-38) where 2016-04-02 16:04:25,532 INFO [stdout] (default task-38) project0_.businessAccountId=? 2016-04-02 16:04:35,589 INFO [org.jboss.as.server] (management-handler-thread - 5) WFLYSRV0211: Suspending server with 0ms timeout. 2016-04-02 16:04:35,594 INFO [org.jboss.as.server] (Thread-2) WFLYSRV0220: Server shutdown has been requested. 2016-04-02 16:04:35,646 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 67) WFLYUT0022: Unregistered web context: /pvsketch