2022-06-13 05:56:34 Apache Commons Daemon procrun stdout initialized. Using configuration locations [classpath:openboxes-config.properties, classpath:openboxes-config.groovy, file:C:\Windows\ServiceProfiles\LocalService/.grails/openboxes-config.properties, file:C:\Windows\ServiceProfiles\LocalService/.grails/openboxes-config.groovy] [production] 2022-06-13 05:57:56,850 [localhost-startStop-1] INFO context.ContextLoader - Root WebApplicationContext: initialization started 2022-06-13 05:57:56,897 [localhost-startStop-1] INFO support.XmlWebApplicationContext - Refreshing Root WebApplicationContext: startup date [Mon Jun 13 05:57:56 PDT 2022]; root of context hierarchy 2022-06-13 05:57:56,960 [localhost-startStop-1] INFO xml.XmlBeanDefinitionReader - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml] 2022-06-13 05:57:57,335 [localhost-startStop-1] INFO support.DefaultListableBeanFactory - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@5006543a: defining beans [grailsApplication,pluginManager,grailsConfigurator,grailsResourceLoader,grailsResourceHolder,characterEncodingFilter]; root of factory hierarchy 2022-06-13 05:58:01,913 [localhost-startStop-1] INFO cfg.Environment - Hibernate 3.3.1.GA 2022-06-13 05:58:01,929 [localhost-startStop-1] INFO cfg.Environment - hibernate.properties not found 2022-06-13 05:58:01,929 [localhost-startStop-1] INFO cfg.Environment - Bytecode provider name : javassist 2022-06-13 05:58:01,929 [localhost-startStop-1] INFO cfg.Environment - using JDK 1.4 java.sql.Timestamp handling 2022-06-13 05:58:05,288 [localhost-startStop-1] INFO annotation.ClassPathBeanDefinitionScanner - JSR-250 'javax.annotation.ManagedBean' found and supported for component scanning 2022-06-13 05:58:07,429 [MLog-Init-Reporter] INFO log.MLog - MLog clients using slf4j logging. 2022-06-13 05:58:09,023 [localhost-startStop-1] INFO c3p0.C3P0Registry - Initializing c3p0-0.9.5.3 [built 27-January-2019 00:11:37 -0800; debug? true; trace: 10] 2022-06-13 05:58:09,444 [localhost-startStop-1] INFO impl.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1hggeyhappudnm8je3pqh|70c2576a, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hggeyhappudnm8je3pqh|70c2576a, idleConnectionTestPeriod -> 7200, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://localhost:3307/openboxes?useSSL=false, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 14400, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 1800, maxPoolSize -> 100, maxStatements -> 180, maxStatementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3, preferredTestQuery -> SELECT 1, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 1, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ] 2022-06-13 05:58:09,819 [localhost-startStop-1] INFO annotations.Version - Hibernate Annotations 3.4.0.GA 2022-06-13 05:58:09,866 [localhost-startStop-1] INFO common.Version - Hibernate Commons Annotations 3.1.0.GA 2022-06-13 05:58:10,523 [localhost-startStop-1] WARN commons.GrailsDomainConfigurationUtil - Derived properties may not be constrained. Property [quantityNotPicked] of domain class org.pih.warehouse.product.ProductAvailability will not be checked during validation. 2022-06-13 05:58:10,569 [localhost-startStop-1] WARN commons.GrailsDomainConfigurationUtil - Derived properties may not be constrained. Property [color] of domain class org.pih.warehouse.product.Product will not be checked during validation. 2022-06-13 05:58:10,601 [localhost-startStop-1] WARN commons.GrailsDomainConfigurationUtil - Derived properties may not be constrained. Property [monthRequested] of domain class org.pih.warehouse.requisition.Requisition will not be checked during validation. 2022-06-13 05:58:10,616 [localhost-startStop-1] WARN commons.GrailsDomainConfigurationUtil - Derived properties may not be constrained. Property [statusSortOrder] of domain class org.pih.warehouse.requisition.Requisition will not be checked during validation. 2022-06-13 05:58:10,632 [localhost-startStop-1] WARN commons.GrailsDomainConfigurationUtil - Derived properties may not be constrained. Property [shipmentItemCount] of domain class org.pih.warehouse.shipping.Shipment will not be checked during validation. 2022-06-13 05:58:10,741 [localhost-startStop-1] INFO validator.Version - Hibernate Validator 3.1.0.GA 2022-06-13 05:58:10,835 [localhost-startStop-1] INFO search.HibernateSearchEventListenerRegister - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled. 2022-06-13 05:58:10,976 [localhost-startStop-1] WARN mapping.RootClass - composite-id class does not override equals(): org.pih.warehouse.invoice.InvoiceList 2022-06-13 05:58:10,976 [localhost-startStop-1] WARN mapping.RootClass - composite-id class does not override hashCode(): org.pih.warehouse.invoice.InvoiceList 2022-06-13 05:58:11,069 [localhost-startStop-1] INFO connection.ConnectionProviderFactory - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider 2022-06-13 05:58:11,069 [localhost-startStop-1] INFO cfg.SettingsFactory - RDBMS: MySQL, version: 5.5.5-10.7.3-MariaDB 2022-06-13 05:58:11,069 [localhost-startStop-1] INFO cfg.SettingsFactory - JDBC driver: MySQL Connector Java, version: mysql-connector-java-5.1.47 ( Revision: fe1903b1ecb4a96a917f7ed3190d80c049b1de29 ) 2022-06-13 05:58:11,069 [localhost-startStop-1] INFO dialect.Dialect - Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO transaction.TransactionFactoryFactory - Transaction strategy: org.springframework.orm.hibernate3.SpringTransactionFactory 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended) 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Automatic session close at end of transaction: disabled 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - JDBC batch size: 15 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - JDBC batch updates for versioned data: disabled 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Scrollable result sets: enabled 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - JDBC result set fetch size: 25 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Connection release mode: auto 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Maximum outer join fetch depth: 2 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Default batch fetch size: 25 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Generate SQL with comments: disabled 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Order SQL updates by primary key: enabled 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Order SQL inserts for batching: enabled 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Query language substitutions: {} 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - JPA-QL strict compliance: disabled 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Second-level cache: disabled 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Query cache: disabled 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Optimize cache for minimal puts: enabled 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Structured second-level cache entries: disabled 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Statistics: disabled 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Default entity-mode: pojo 2022-06-13 05:58:11,085 [localhost-startStop-1] INFO cfg.SettingsFactory - Named query checking : enabled 2022-06-13 05:58:11,132 [localhost-startStop-1] INFO impl.SessionFactoryImpl - building session factory 2022-06-13 05:58:13,101 [localhost-startStop-1] INFO util.NamingHelper - JNDI InitialContext properties:{} 2022-06-13 05:58:14,741 [localhost-startStop-1] INFO config.PropertiesFactoryBean - Loading properties file from class path resource [gsp/views.properties] 2022-06-13 05:58:16,023 [localhost-startStop-1] INFO ehcache.EhCacheManagerFactoryBean - Initializing EHCache CacheManager 2022-06-13 05:58:17,445 [localhost-startStop-1] INFO impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 2022-06-13 05:58:17,445 [localhost-startStop-1] INFO simpl.SimpleThreadPool - Job execution threads will use class loader of thread: localhost-startStop-1 2022-06-13 05:58:17,460 [localhost-startStop-1] INFO core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 2022-06-13 05:58:17,460 [localhost-startStop-1] INFO core.QuartzScheduler - Quartz Scheduler v.2.1.6 created. 2022-06-13 05:58:17,460 [localhost-startStop-1] INFO simpl.RAMJobStore - RAMJobStore initialized. 2022-06-13 05:58:17,460 [localhost-startStop-1] INFO core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.1.6) 'DefaultPluginScheduler' with instanceId 'NON_CLUSTERED' Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. NOT STARTED. Currently in standby mode. Number of jobs executed: 0 Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads. Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered. 2022-06-13 05:58:17,460 [localhost-startStop-1] INFO impl.StdSchedulerFactory - Quartz scheduler 'DefaultPluginScheduler' initialized from an externally provided properties instance. 2022-06-13 05:58:17,460 [localhost-startStop-1] INFO impl.StdSchedulerFactory - Quartz scheduler version: 2.1.6 2022-06-13 05:58:17,476 [localhost-startStop-1] INFO core.QuartzScheduler - JobFactory set to: grails.plugin.quartz2.GrailsJobFactory@152e70b1 2022-06-13 05:58:18,804 [localhost-startStop-1] INFO support.DefaultLifecycleProcessor - Starting beans in phase 2147483647 Starting Quartz Scheduler in QuartzFactoryBean 2022-06-13 05:58:18,804 [localhost-startStop-1] INFO core.QuartzScheduler - Scheduler DefaultPluginScheduler_$_NON_CLUSTERED started. 2022-06-13 05:58:19,382 [localhost-startStop-1] INFO support.DefaultListableBeanFactory - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@432109e0: defining beans [org.grails.plugin.zippedresources.ZipResourceMapper,org.grails.plugin.resource.CSSRewriterResourceMapper,org.grails.plugin.cachedresources.HashAndCacheResourceMapper,org.grails.plugin.resource.BundleResourceMapperInstance,org.grails.plugin.resource.CSSRewriterResourceMapperInstance,org.grails.plugin.resource.BundleResourceMapper,org.grails.plugin.cachedresources.HashAndCacheResourceMapperInstance,org.grails.plugin.zippedresources.ZipResourceMapperInstance,org.grails.plugin.resource.CSSPreprocessorResourceMapperInstance,org.grails.plugin.resource.CSSPreprocessorResourceMapper]; parent: org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory@6953724b 2022-06-13 05:58:42,354 [localhost-startStop-1] WARN commons.GrailsDomainConfigurationUtil - Derived properties may not be constrained. Property [shipmentItemCount] of domain class org.pih.warehouse.shipping.Shipment will not be checked during validation. 2022-06-13 05:58:42,354 [localhost-startStop-1] WARN commons.GrailsDomainConfigurationUtil - Derived properties may not be constrained. Property [quantityNotPicked] of domain class org.pih.warehouse.product.ProductAvailability will not be checked during validation. 2022-06-13 05:58:42,370 [localhost-startStop-1] WARN commons.GrailsDomainConfigurationUtil - Derived properties may not be constrained. Property [color] of domain class org.pih.warehouse.product.Product will not be checked during validation. 2022-06-13 05:58:42,370 [localhost-startStop-1] WARN commons.GrailsDomainConfigurationUtil - Derived properties may not be constrained. Property [monthRequested] of domain class org.pih.warehouse.requisition.Requisition will not be checked during validation. 2022-06-13 05:58:42,370 [localhost-startStop-1] WARN commons.GrailsDomainConfigurationUtil - Derived properties may not be constrained. Property [statusSortOrder] of domain class org.pih.warehouse.requisition.Requisition will not be checked during validation. 2022-06-13 05:58:42,620 [localhost-startStop-1] INFO bootstrap.BootStrap - Running liquibase changelog(s) ... 2022-06-13 05:58:42,729 [localhost-startStop-1] INFO bootstrap.BootStrap - Liquibase running: false 2022-06-13 05:58:42,760 [localhost-startStop-1] INFO bootstrap.BootStrap - Setting default schema to openboxes 2022-06-13 05:58:42,760 [localhost-startStop-1] INFO bootstrap.BootStrap - Product Version: 5.5.5-10.7.3-MariaDB 2022-06-13 05:58:42,760 [localhost-startStop-1] INFO bootstrap.BootStrap - Database Version: 5.5 2022-06-13 05:58:42,760 [localhost-startStop-1] INFO liquibase - Reading from `DATABASECHANGELOG` 2022-06-13 05:58:42,854 [localhost-startStop-1] INFO liquibase - Lock Database 2022-06-13 05:58:42,854 [localhost-startStop-1] INFO liquibase - Successfully acquired change log lock 2022-06-13 05:58:44,901 [localhost-startStop-1] INFO liquibase - Changeset views/drop-all-views.xml::1633402273161-1::jmiranda::(MD5Sum: 73a6b8b6caee415e6c9fc3292d0ca5c) 2022-06-13 05:58:44,901 [localhost-startStop-1] INFO liquibase - Views will be recreated after database migrations are executed. 2022-06-13 05:58:45,198 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-1::jmiranda::(MD5Sum: fdb1b3291b9ec6e2d296943668e5541) 2022-06-13 05:58:45,245 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-2::jmiranda::(MD5Sum: 287cd86a7aab4d5b8de07b0e3558dd) 2022-06-13 05:58:45,245 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-3::jmiranda::(MD5Sum: ab4d24b350f3b66a79e8deccb6ce7abf) 2022-06-13 05:58:45,276 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-4::jmiranda::(MD5Sum: 73d7ed234b27a2c72d1ddac9d1c2e52c) 2022-06-13 05:58:45,292 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-5::jmiranda::(MD5Sum: c2d2fe8cc3768852859887d70b2c363) 2022-06-13 05:58:45,307 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-6::jmiranda::(MD5Sum: 204668f546b9d28cfc1e171d1f63c332) 2022-06-13 05:58:45,323 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-7::jmiranda::(MD5Sum: 105ccb5aba6fc3f80cded9bf24e3ee) 2022-06-13 05:58:45,323 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-8::jmiranda::(MD5Sum: 6e1f5a212a81349839521befc77d9d) 2022-06-13 05:58:45,338 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-9::jmiranda::(MD5Sum: f2bc4581973c375fe4b1bf9d19961774) 2022-06-13 05:58:45,354 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-10::dhatala::(MD5Sum: 5dab9c95b978dd9f79f0a8f6a28c941d) 2022-06-13 05:58:45,370 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-11::jmiranda::(MD5Sum: be12e7b15a3323c9e4aef9fbf5437ef0) 2022-06-13 05:58:45,385 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-13::jmiranda::(MD5Sum: 7290e543f6e033fde63f3b0c089e29c) 2022-06-13 05:58:45,401 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-14::dhatala::(MD5Sum: 74bd46d68a6214730dedafeca3f7385) 2022-06-13 05:58:45,417 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-15::dhatala::(MD5Sum: f34624f62297b96d4d839e6ec121eae) 2022-06-13 05:58:45,417 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-16::dhatala::(MD5Sum: 7a911020e327dab5e58ce2c698fad8a) 2022-06-13 05:58:45,432 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-17::dhatala::(MD5Sum: 5cf4a3a39ce2d41a5d78289482a26e9d) 2022-06-13 05:58:45,448 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-18::jmiranda::(MD5Sum: 4d7ea16f2015559a729c4d47acc9165) 2022-06-13 05:58:45,479 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-19::dhatala::(MD5Sum: 6d593dd51d4e874b6dd78aaeaa4423) 2022-06-13 05:58:45,495 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-20::dhatala::(MD5Sum: 8486404cb2d5b28aa67ad8811216b770) 2022-06-13 05:58:45,495 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-21::pmuchowski::(MD5Sum: 8cdeae3d64c755276092949683b92f9) 2022-06-13 05:58:45,510 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-22::dhatala::(MD5Sum: de8a8a531d2ea0f07641713cb3543f) 2022-06-13 05:58:45,526 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-23::awalkowiak::(MD5Sum: 7647f0ca25b7b67a6bbea9615ad258d) 2022-06-13 05:58:45,573 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-24::pmuchowski::(MD5Sum: fa9352e62401cb64bf9d180e3abb3b1) 2022-06-13 05:58:45,573 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-25::dbienkowska::(MD5Sum: 4227dba941339f4cdcc183c5159317f) 2022-06-13 05:58:45,588 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-26::awalkowiak::(MD5Sum: 63b4ffde924d6b393e249803ac4fef9) 2022-06-13 05:58:45,604 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-27::pmuchowski::(MD5Sum: 376b802ad2080d148d2dc37bc44f024) 2022-06-13 05:58:45,620 [localhost-startStop-1] INFO liquibase - Release Database Lock 2022-06-13 05:58:45,620 [localhost-startStop-1] INFO liquibase - Successfully released change log lock 2022-06-13 05:58:45,620 [localhost-startStop-1] ERROR context.ContextLoader - Context initialization failed org.springframework.beans.factory.access.BootstrapException: Error executing bootstraps; nested exception is org.codehaus.groovy.runtime.InvokerInvocationException: liquibase.exception.MigrationFailedException: Migration failed for change set views/changelog.xml::1580848680306-27::pmuchowski: Reason: liquibase.exception.JDBCException: Error executing SQL CREATE OR REPLACE VIEW product_expiry_summary AS SELECT p_a.product_id, p_a.location_id, i.expiration_date, SUM(p_a.quantity_on_hand) AS quantity_on_hand, IFNULL(demand.average_daily_demand, 0) AS average_daily_demand FROM product_availability AS p_a JOIN inventory_item i ON i.id = p_a.inventory_item_id LEFT JOIN ( SELECT product_id, origin_id AS location_id, SUM(quantity_demand) / datediff(CURRENT_DATE, MIN(COALESCE(date_issued, date_requested))) AS average_daily_demand FROM product_demand_details GROUP BY product_id, location_id ) demand ON demand.product_id = p_a.product_id AND demand.location_id = p_a.location_id WHERE i.expiration_date IS NOT NULL GROUP BY p_a.product_id, p_a.location_id, i.expiration_date, demand.average_daily_demand: Caused By: Error executing SQL CREATE OR REPLACE VIEW product_expiry_summary AS SELECT p_a.product_id, p_a.location_id, i.expiration_date, SUM(p_a.quantity_on_hand) AS quantity_on_hand, IFNULL(demand.average_daily_demand, 0) AS average_daily_demand FROM product_availability AS p_a JOIN inventory_item i ON i.id = p_a.inventory_item_id LEFT JOIN ( SELECT product_id, origin_id AS location_id, SUM(quantity_demand) / datediff(CURRENT_DATE, MIN(COALESCE(date_issued, date_requested))) AS average_daily_demand FROM product_demand_details GROUP BY product_id, location_id ) demand ON demand.product_id = p_a.product_id AND demand.location_id = p_a.location_id WHERE i.expiration_date IS NOT NULL GROUP BY p_a.product_id, p_a.location_id, i.expiration_date, demand.average_daily_demand: Caused By: Table 'openboxes.product_demand_details' doesn't exist at org.codehaus.groovy.grails.web.context.GrailsContextLoader.createWebApplicationContext(GrailsContextLoader.java:87) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4763) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5232) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:753) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:727) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:695) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1016) at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1903) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748) Caused by: org.codehaus.groovy.runtime.InvokerInvocationException: liquibase.exception.MigrationFailedException: Migration failed for change set views/changelog.xml::1580848680306-27::pmuchowski: Reason: liquibase.exception.JDBCException: Error executing SQL CREATE OR REPLACE VIEW product_expiry_summary AS SELECT p_a.product_id, p_a.location_id, i.expiration_date, SUM(p_a.quantity_on_hand) AS quantity_on_hand, IFNULL(demand.average_daily_demand, 0) AS average_daily_demand FROM product_availability AS p_a JOIN inventory_item i ON i.id = p_a.inventory_item_id LEFT JOIN ( SELECT product_id, origin_id AS location_id, SUM(quantity_demand) / datediff(CURRENT_DATE, MIN(COALESCE(date_issued, date_requested))) AS average_daily_demand FROM product_demand_details GROUP BY product_id, location_id ) demand ON demand.product_id = p_a.product_id AND demand.location_id = p_a.location_id WHERE i.expiration_date IS NOT NULL GROUP BY p_a.product_id, p_a.location_id, i.expiration_date, demand.average_daily_demand: Caused By: Error executing SQL CREATE OR REPLACE VIEW product_expiry_summary AS SELECT p_a.product_id, p_a.location_id, i.expiration_date, SUM(p_a.quantity_on_hand) AS quantity_on_hand, IFNULL(demand.average_daily_demand, 0) AS average_daily_demand FROM product_availability AS p_a JOIN inventory_item i ON i.id = p_a.inventory_item_id LEFT JOIN ( SELECT product_id, origin_id AS location_id, SUM(quantity_demand) / datediff(CURRENT_DATE, MIN(COALESCE(date_issued, date_requested))) AS average_daily_demand FROM product_demand_details GROUP BY product_id, location_id ) demand ON demand.product_id = p_a.product_id AND demand.location_id = p_a.location_id WHERE i.expiration_date IS NOT NULL GROUP BY p_a.product_id, p_a.location_id, i.expiration_date, demand.average_daily_demand: Caused By: Table 'openboxes.product_demand_details' doesn't exist at grails.util.Environment.evaluateEnvironmentSpecificBlock(Environment.java:251) at grails.util.Environment.executeForEnvironment(Environment.java:244) at grails.util.Environment.executeForCurrentEnvironment(Environment.java:220) ... 5 more Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set views/changelog.xml::1580848680306-27::pmuchowski: Reason: liquibase.exception.JDBCException: Error executing SQL CREATE OR REPLACE VIEW product_expiry_summary AS SELECT p_a.product_id, p_a.location_id, i.expiration_date, SUM(p_a.quantity_on_hand) AS quantity_on_hand, IFNULL(demand.average_daily_demand, 0) AS average_daily_demand FROM product_availability AS p_a JOIN inventory_item i ON i.id = p_a.inventory_item_id LEFT JOIN ( SELECT product_id, origin_id AS location_id, SUM(quantity_demand) / datediff(CURRENT_DATE, MIN(COALESCE(date_issued, date_requested))) AS average_daily_demand FROM product_demand_details GROUP BY product_id, location_id ) demand ON demand.product_id = p_a.product_id AND demand.location_id = p_a.location_id WHERE i.expiration_date IS NOT NULL GROUP BY p_a.product_id, p_a.location_id, i.expiration_date, demand.average_daily_demand: Caused By: Error executing SQL CREATE OR REPLACE VIEW product_expiry_summary AS SELECT p_a.product_id, p_a.location_id, i.expiration_date, SUM(p_a.quantity_on_hand) AS quantity_on_hand, IFNULL(demand.average_daily_demand, 0) AS average_daily_demand FROM product_availability AS p_a JOIN inventory_item i ON i.id = p_a.inventory_item_id LEFT JOIN ( SELECT product_id, origin_id AS location_id, SUM(quantity_demand) / datediff(CURRENT_DATE, MIN(COALESCE(date_issued, date_requested))) AS average_daily_demand FROM product_demand_details GROUP BY product_id, location_id ) demand ON demand.product_id = p_a.product_id AND demand.location_id = p_a.location_id WHERE i.expiration_date IS NOT NULL GROUP BY p_a.product_id, p_a.location_id, i.expiration_date, demand.average_daily_demand: Caused By: Table 'openboxes.product_demand_details' doesn't exist at liquibase.ChangeSet.execute(ChangeSet.java:238) at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26) at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41) at liquibase.Liquibase.update(Liquibase.java:112) at liquibase.Liquibase$update.call(Unknown Source) at BootStrap$_closure1.doCall(BootStrap.groovy:469) ... 8 more Caused by: liquibase.exception.JDBCException: Error executing SQL CREATE OR REPLACE VIEW product_expiry_summary AS SELECT p_a.product_id, p_a.location_id, i.expiration_date, SUM(p_a.quantity_on_hand) AS quantity_on_hand, IFNULL(demand.average_daily_demand, 0) AS average_daily_demand FROM product_availability AS p_a JOIN inventory_item i ON i.id = p_a.inventory_item_id LEFT JOIN ( SELECT product_id, origin_id AS location_id, SUM(quantity_demand) / datediff(CURRENT_DATE, MIN(COALESCE(date_issued, date_requested))) AS average_daily_demand FROM product_demand_details GROUP BY product_id, location_id ) demand ON demand.product_id = p_a.product_id AND demand.location_id = p_a.location_id WHERE i.expiration_date IS NOT NULL GROUP BY p_a.product_id, p_a.location_id, i.expiration_date, demand.average_daily_demand at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86) at liquibase.change.AbstractChange.execute(AbstractChange.java:247) at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93) at liquibase.ChangeSet.execute(ChangeSet.java:214) ... 13 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'openboxes.product_demand_details' doesn't exist at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449) at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745) at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75) at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48) ... 17 more