Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'parent_item.pick_reason_code' in 'field list' when trying to run in docker #2291

Closed
ZobairQ opened this issue Mar 18, 2021 · 8 comments
Closed

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'parent_item.pick_reason_code' in 'field list' when trying to run in docker #2291

ZobairQ opened this issue Mar 18, 2021 · 8 comments

Comments

@ZobairQ
Copy link

ZobairQ commented Mar 18, 2021 

grails_1  | liquibase.exception.JDBCException: Error executing SQL CREATE OR REPLACE VIEW `openboxes`.`product_demand` AS SELECT
grails_1  | 							-- request data
grails_1  | 							request_id,
grails_1  | 							request_status,
grails_1  | 							request_number,
grails_1  | 							date_created,
grails_1  | 							date_requested,
grails_1  | 							date_issued,
grails_1  | 							origin_id,
grails_1  | 							origin_name,
grails_1  | 							destination_id,
grails_1  | 							destination_name,
grails_1  | 
grails_1  | 							-- request item data
grails_1  | 	            request_item_id,
grails_1  | 	            product_id,
grails_1  |              	product_code,
grails_1  | 	            product_name,
grails_1  | 	            quantity_requested,
grails_1  | 	            quantity_canceled,
grails_1  | 	            quantity_approved,
grails_1  | 	            quantity_modified,
grails_1  | 	            quantity_substituted,
grails_1  | 	            quantity_picked,
grails_1  | 							reason_code_classification,
grails_1  | 
grails_1  | 							-- request item status
grails_1  | 	            CASE
grails_1  | 		            WHEN request_item_status = 'SUBSTITUTION'
grails_1  | 			            THEN 'ITEM_SUBSTITUTED'
grails_1  | 		            WHEN quantity_requested = quantity_canceled AND quantity_picked = 0
grails_1  | 			            THEN 'ITEM_CANCELED'
grails_1  | 		            WHEN quantity_requested = quantity_approved AND quantity_picked != quantity_approved
grails_1  | 			            THEN 'PICK_MODIFIED'
grails_1  | 		            WHEN quantity_requested != quantity_approved AND quantity_picked = quantity_approved
grails_1  | 			            THEN 'ITEM_MODIFIED'
grails_1  | 		            WHEN quantity_picked > 0 THEN 'ITEM_ISSUED'
grails_1  |                     ELSE  NULL
grails_1  |                 END as request_item_change_status,
grails_1  |               -- quantity demand
grails_1  | 	            CASE
grails_1  | 		            WHEN request_item_status = 'SUBSTITUTION'
grails_1  | 			            THEN quantity_requested
grails_1  | 		            WHEN quantity_picked > quantity_requested
grails_1  | 			            THEN quantity_picked
grails_1  |                 WHEN quantity_picked < quantity_requested AND reason_code_classification IN (NULL, 'INSUFFICIENT_QUANTITY_AVAILABLE')
grails_1  | 			            THEN quantity_requested
grails_1  |                 WHEN quantity_picked < quantity_requested AND reason_code_classification IN ('CLINICAL_JUDGMENT')
grails_1  | 			            THEN quantity_picked
grails_1  |                 ELSE quantity_requested
grails_1  |                 END as quantity_demand
grails_1  |             FROM (
grails_1  | 	            SELECT
grails_1  | 		            request_id,
grails_1  | 		            request_item_id,
grails_1  | 		            request_status,
grails_1  | 		            request_number,
grails_1  | 		            date_created,
grails_1  | 		            date_requested,
grails_1  | 		            date_issued,
grails_1  | 		            origin_id,
grails_1  | 		            origin_name,
grails_1  | 		            destination_id,
grails_1  | 		            destination_name,
grails_1  | 		            product_id,
grails_1  | 		            product_code,
grails_1  | 		            product_name,
grails_1  | 		            quantity_requested,
grails_1  | 		            IFNULL(quantity_canceled, 0) AS quantity_canceled,
grails_1  | 		            IFNULL(quantity_approved, 0) AS quantity_approved,
grails_1  | 		            IFNULL(quantity_modified, 0) AS quantity_modified,
grails_1  | 		            IFNULL(quantity_substituted, 0) AS quantity_substituted,
grails_1  | 		            IFNULL(quantity_picked, 0) AS quantity_picked,
grails_1  | 		            cancel_reason_code,
grails_1  | 		            cancel_comments,
grails_1  | 		            pick_reason_code,
grails_1  |                 reason_code_classification,
grails_1  | 		            insufficient_quantity_available,
grails_1  | 		            clinical_judgment,
grails_1  | 		            request_item_type,
grails_1  | 		            request_item_status,
grails_1  |                 request_item_products
grails_1  | 	            FROM (
grails_1  | 		            SELECT
grails_1  | 			            requisition.id as request_id,
grails_1  | 			            requisition_item.id as request_item_id,
grails_1  | 			            requisition.status AS request_status,
grails_1  | 			            requisition.request_number,
grails_1  | 			            requisition.date_created as date_created,
grails_1  | 			            requisition.date_requested AS date_requested,
grails_1  | 			            requisition_transaction.date_issued AS date_issued,
grails_1  | 			            origin.id AS origin_id,
grails_1  | 			            origin.name AS origin_name,
grails_1  | 			            destination.id AS destination_id,
grails_1  | 			            destination.name AS destination_name,
grails_1  | 			            requisition_item.requisition_item_type as request_item_type,
grails_1  | 			            child_request_item.status as request_item_status,
grails_1  | 			            child_request_item.products as request_item_products,
grails_1  | 			            product.id AS product_id,
grails_1  | 			            product.product_code,
grails_1  | 			            product.name AS product_name,
grails_1  | 			            cancel_reason_code,
grails_1  |                   -- FIXME converting from boolean to string does not strike me as a good idea here
grails_1  | 			            CASE
grails_1  | 				            WHEN insufficient_quantity_available = TRUE THEN 'INSUFFICIENT_QUANTITY_AVAILABLE'
grails_1  |                     WHEN clinical_judgment = TRUE THEN 'CLINICAL_JUDGMENT'
grails_1  | 				            ELSE NULL
grails_1  | 			            END as reason_code_classification,
grails_1  |                   insufficient_quantity_available,
grails_1  |                   clinical_judgment,
grails_1  | 			            cancel_comments,
grails_1  | 			            pick_reason_code,
grails_1  | 			            quantity AS quantity_requested,
grails_1  | 			            quantity_canceled,
grails_1  |                   quantity_approved,
grails_1  | 
grails_1  |                   -- quantity changed
grails_1  | 			            (
grails_1  | 				            SELECT
grails_1  | 					            SUM(quantity)
grails_1  | 				            FROM
grails_1  | 					            requisition_item child
grails_1  | 				            WHERE child.parent_requisition_item_id = requisition_item.id
grails_1  | 						          AND requisition_item_type = 'QUANTITY_CHANGE'
grails_1  | 			            ) AS quantity_modified,
grails_1  | 
grails_1  |                   -- quantity substituted (FIXME make sure the cancel reason code is necessary)
grails_1  |                   (
grails_1  | 				            SELECT
grails_1  | 					            SUM(quantity)
grails_1  | 				            FROM
grails_1  | 					            requisition_item child
grails_1  | 				            WHERE child.parent_requisition_item_id = requisition_item.id
grails_1  |                       AND requisition_item_type = 'SUBSTITUTION'
grails_1  | 					            AND requisition_item.cancel_reason_code IN ('STOCKOUT' , 'LOW_STOCK', 'COULD_NOT_LOCATE')
grails_1  | 			            ) AS quantity_substituted,
grails_1  | 
grails_1  |                   -- quantity picked
grails_1  | 			            picked_items.quantity_picked
grails_1  | 		            FROM requisition_item
grails_1  | 		            JOIN product ON product.id = requisition_item.product_id
grails_1  | 		            JOIN requisition ON requisition.id = requisition_item.requisition_id
grails_1  | 		            JOIN location destination ON destination.id = requisition.destination_id
grails_1  | 		            JOIN location origin ON origin.id = requisition.origin_id
grails_1  |                 JOIN location_type on origin.location_type_id = location_type.id
grails_1  | 
grails_1  | 		            -- Used to get issue date
grails_1  | 		            LEFT OUTER JOIN (
grails_1  |                   SELECT
grails_1  |                     requisition.id as requisition_id,
grails_1  |                     transaction.transaction_date as date_issued
grails_1  |                   FROM requisition
grails_1  |                   JOIN shipment on shipment.requisition_id = requisition.id
grails_1  |                   JOIN transaction on shipment.id = transaction.outgoing_shipment_id
grails_1  |                 ) as requisition_transaction on requisition.id = requisition_transaction.requisition_id
grails_1  | 
grails_1  |                 -- Used to get quantity picked
grails_1  | 		            LEFT OUTER JOIN (
grails_1  | 			            SELECT
grails_1  | 				            ifnull(requisition_item.parent_requisition_item_id, requisition_item.id) as requisition_item_id,
grails_1  | 				            SUM(picklist_item.quantity) as quantity_picked
grails_1  | 			            FROM
grails_1  | 				            picklist_item join requisition_item on picklist_item.requisition_item_id = requisition_item.id
grails_1  | 			            GROUP BY requisition_item.id
grails_1  | 		            ) as picked_items ON (picked_items.requisition_item_id = requisition_item.id)
grails_1  | 
grails_1  |                 -- Used to determine whether a requisition item was changed or substituted
grails_1  | 		            LEFT OUTER JOIN (
grails_1  | 			            SELECT
grails_1  | 				            requisition_item.id as requisition_item_id,
grails_1  | 				            GROUP_CONCAT(distinct(child.product_id)) as products,
grails_1  | 				            IFNULL(GROUP_CONCAT(distinct(child.requisition_item_type)), requisition_item.requisition_item_type) as status
grails_1  | 			            FROM requisition_item
grails_1  | 			            LEFT OUTER JOIN requisition_item child on child.parent_requisition_item_id = requisition_item.id
grails_1  | 			            GROUP BY requisition_item.id
grails_1  | 		            ) as child_request_item ON requisition_item.id = child_request_item.requisition_item_id
grails_1  | 
grails_1  |                 -- Used to classify whether a request item was changed or canceled due to reason code related to insufficient quantity available
grails_1  |                 LEFT OUTER JOIN (
grails_1  | 			            select
grails_1  | 				            parent_item.id as requisition_item_id,
grails_1  | 				            -- check all reason codes for insufficient quantity available
grails_1  | 				            sum(if(parent_item.cancel_reason_code in ('STOCKOUT', 'LOW_STOCK', 'COULD_NOT_LOCATE')
grails_1  | 					            or parent_item.pick_reason_code in ('STOCKOUT', 'LOW_STOCK', 'COULD_NOT_LOCATE')
grails_1  | 					            or child_item.cancel_reason_code in ('STOCKOUT', 'LOW_STOCK', 'COULD_NOT_LOCATE')
grails_1  | 					            or child_item.pick_reason_code in ('STOCKOUT', 'LOW_STOCK', 'COULD_NOT_LOCATE')
grails_1  | 					            or parent_picklist_item.reason_code in ('STOCKOUT', 'LOW_STOCK', 'COULD_NOT_LOCATE')
grails_1  | 					            or child_picklist_item.reason_code in ('STOCKOUT', 'LOW_STOCK', 'COULD_NOT_LOCATE'), true, false)) as insufficient_quantity_available,
grails_1  | 				            -- otherwise the reason code is probably related to a clinical judgment
grails_1  | 				            sum((coalesce(parent_item.cancel_reason_code, child_item.cancel_reason_code,
grails_1  | 							            parent_item.pick_reason_code, child_item.pick_reason_code,
grails_1  | 							            parent_picklist_item.reason_code, child_picklist_item.reason_code) != '')) as clinical_judgment
grails_1  | 			            from requisition_item parent_item
grails_1  | 			            left outer join requisition_item child_item on child_item.parent_requisition_item_id = parent_item.id
grails_1  | 			            left outer join picklist_item parent_picklist_item on parent_item.id = parent_picklist_item.requisition_item_id
grails_1  | 			            left outer join picklist_item child_picklist_item on child_item.id = child_picklist_item.requisition_item_id
grails_1  | 			            group by parent_item.id
grails_1  |                 ) as reason_codes on requisition_item.id = reason_codes.requisition_item_id
grails_1  | 
grails_1  | 		            WHERE requisition_item.requisition_item_type = 'ORIGINAL'
grails_1  |                 AND location_type.location_type_code = 'DEPOT'
grails_1  | 		            AND requisition.status = 'ISSUED'
grails_1  | 	            ) AS tmp1
grails_1  |             ) AS tmp2;
grails_1  | 	at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55)
grails_1  | 	at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86)
grails_1  | 	at liquibase.change.AbstractChange.execute(AbstractChange.java:247)
grails_1  | 	at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93)
grails_1  | 	at liquibase.ChangeSet.execute(ChangeSet.java:214)
grails_1  | 	at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26)
grails_1  | 	at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41)
grails_1  | 	at liquibase.Liquibase.update(Liquibase.java:112)
grails_1  | 	at liquibase.Liquibase$update.call(Unknown Source)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:124)
grails_1  | 	at BootStrap$_closure1.doCall(BootStrap.groovy:447)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:930)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:282)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:277)
grails_1  | 	at grails.util.Environment.evaluateEnvironmentSpecificBlock(Environment.java:251)
grails_1  | 	at grails.util.Environment.executeForEnvironment(Environment.java:244)
grails_1  | 	at grails.util.Environment.executeForCurrentEnvironment(Environment.java:220)
grails_1  | 	at org.codehaus.groovy.grails.commons.DefaultGrailsBootstrapClass.callInit(DefaultGrailsBootstrapClass.java:59)
grails_1  | 	at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.executeGrailsBootstraps(GrailsConfigUtils.java:74)
grails_1  | 	at org.codehaus.groovy.grails.web.context.GrailsContextLoader.createWebApplicationContext(GrailsContextLoader.java:74)
grails_1  | 	at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
grails_1  | 	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
grails_1  | 	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3961)
grails_1  | 	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4456)
grails_1  | 	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
grails_1  | 	at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
grails_1  | 	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
grails_1  | 	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
grails_1  | 	at org.apache.catalina.core.StandardService.start(StandardService.java:515)
grails_1  | 	at org.apache.catalina.core.StandardServer.start(StandardServer.java:708)
grails_1  | 	at org.apache.catalina.startup.Tomcat.start(Tomcat.java:286)
grails_1  | 	at org.apache.catalina.startup.Tomcat$start.call(Unknown Source)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:120)
grails_1  | 	at org.grails.tomcat.InlineExplodedTomcatServer.doStart(InlineExplodedTomcatServer.groovy:112)
grails_1  | 	at org.grails.tomcat.InlineExplodedTomcatServer$doStart.callCurrent(Unknown Source)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:157)
grails_1  | 	at org.grails.tomcat.TomcatServer.start(TomcatServer.groovy:97)
grails_1  | 	at grails.web.container.EmbeddableServer$start.call(Unknown Source)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:128)
grails_1  | 	at _GrailsRun_groovy$_run_closure5_closure12.doCall(_GrailsRun_groovy:158)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSite.invoke(PogoMetaMethodSite.java:225)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:51)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)
grails_1  | 	at _GrailsRun_groovy$_run_closure5_closure12.doCall(_GrailsRun_groovy)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:282)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:277)
grails_1  | 	at groovy.lang.Closure$call.call(Unknown Source)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
grails_1  | 	at groovy.lang.Closure$call.call(Unknown Source)
grails_1  | 	at _GrailsSettings_groovy$_run_closure10.doCall(_GrailsSettings_groovy:280)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSiteNoUnwrapNoCoerce.invoke(PogoMetaMethodSite.java:266)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:51)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:56)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:153)
grails_1  | 	at _GrailsSettings_groovy$_run_closure10.call(_GrailsSettings_groovy)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.MetaClassImpl.invokePropertyOrMissing(MetaClassImpl.java:1104)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1060)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:706)
grails_1  | 	at groovy.lang.GroovyObjectSupport.invokeMethod(GroovyObjectSupport.java:44)
grails_1  | 	at groovy.lang.Script.invokeMethod(Script.java:78)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethodOnGroovyObject(MetaClassImpl.java:1123)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1017)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:66)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:153)
grails_1  | 	at _GrailsRun_groovy$_run_closure5.doCall(_GrailsRun_groovy:149)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSiteNoUnwrapNoCoerce.invoke(PogoMetaMethodSite.java:266)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:51)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)
grails_1  | 	at _GrailsRun_groovy$_run_closure5.call(_GrailsRun_groovy)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.MetaClassImpl.invokePropertyOrMissing(MetaClassImpl.java:1104)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1060)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:66)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)
grails_1  | 	at _GrailsRun_groovy.runInline(_GrailsRun_groovy:116)
grails_1  | 	at _GrailsRun_groovy.this$4$runInline(_GrailsRun_groovy)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1003)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.DelegatingMetaClass.invokeMethod(DelegatingMetaClass.java:149)
grails_1  | 	at org.codehaus.gant.GantMetaClass.invokeMethod(GantMetaClass.java:127)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:66)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:161)
grails_1  | 	at _GrailsRun_groovy$_run_closure1.doCall(_GrailsRun_groovy:59)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.DelegatingMetaClass.invokeMethod(DelegatingMetaClass.java:149)
grails_1  | 	at org.codehaus.gant.GantMetaClass.invokeMethod(GantMetaClass.java:127)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:282)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:295)
grails_1  | 	at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.DelegatingMetaClass.invokeMethod(DelegatingMetaClass.java:149)
grails_1  | 	at org.codehaus.gant.GantMetaClass.invokeMethod(GantMetaClass.java:127)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.call(PogoMetaClassSite.java:39)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.call(PogoMetaClassSite.java:54)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:124)
grails_1  | 	at org.codehaus.gant.GantBinding$_initializeGantBinding_closure5_closure16_closure18.doCall(GantBinding.groovy:185)
grails_1  | 	at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSite.invoke(PogoMetaMethodSite.java:225)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:51)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)
grails_1  | 	at org.codehaus.gant.GantBinding$_initializeGantBinding_closure5_closure16_closure18.doCall(GantBinding.groovy)
grails_1  | 	at sun.reflect.GeneratedMethodAccessor151.invoke(Unknown Source)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:282)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:277)
grails_1  | 	at groovy.lang.Closure$call.call(Unknown Source)
grails_1  | 	at org.codehaus.gant.GantBinding.withTargetEvent(GantBinding.groovy:90)
grails_1  | 	at org.codehaus.gant.GantBinding.this$4$withTargetEvent(GantBinding.groovy)
grails_1  | 	at sun.reflect.GeneratedMethodAccessor146.invoke(Unknown Source)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1003)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:706)
grails_1  | 	at groovy.lang.GroovyObjectSupport.invokeMethod(GroovyObjectSupport.java:44)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethodOnGroovyObject(MetaClassImpl.java:1123)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1017)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:66)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:157)
grails_1  | 	at org.codehaus.gant.GantBinding$_initializeGantBinding_closure5_closure16.doCall(GantBinding.groovy:185)
grails_1  | 	at sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSite.invoke(PogoMetaMethodSite.java:225)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:51)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)
grails_1  | 	at org.codehaus.gant.GantBinding$_initializeGantBinding_closure5_closure16.doCall(GantBinding.groovy)
grails_1  | 	at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:282)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:277)
grails_1  | 	at sun.reflect.GeneratedMethodAccessor194.invoke(Unknown Source)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.MetaClassImpl.invokePropertyOrMissing(MetaClassImpl.java:1104)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1060)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:706)
grails_1  | 	at groovy.lang.GroovyObjectSupport.invokeMethod(GroovyObjectSupport.java:44)
grails_1  | 	at groovy.lang.Script.invokeMethod(Script.java:78)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethodOnGroovyObject(MetaClassImpl.java:1123)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1017)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.DelegatingMetaClass.invokeMethod(DelegatingMetaClass.java:149)
grails_1  | 	at org.codehaus.gant.GantMetaClass.invokeMethod(GantMetaClass.java:127)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:66)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:145)
grails_1  | 	at RunApp$_run_closure1.doCall(RunApp.groovy:33)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.DelegatingMetaClass.invokeMethod(DelegatingMetaClass.java:149)
grails_1  | 	at org.codehaus.gant.GantMetaClass.invokeMethod(GantMetaClass.java:127)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:282)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:295)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.DelegatingMetaClass.invokeMethod(DelegatingMetaClass.java:149)
grails_1  | 	at org.codehaus.gant.GantMetaClass.invokeMethod(GantMetaClass.java:127)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.call(PogoMetaClassSite.java:39)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.call(PogoMetaClassSite.java:54)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:124)
grails_1  | 	at org.codehaus.gant.GantBinding$_initializeGantBinding_closure5_closure16_closure18.doCall(GantBinding.groovy:185)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSite.invoke(PogoMetaMethodSite.java:225)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:51)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)
grails_1  | 	at org.codehaus.gant.GantBinding$_initializeGantBinding_closure5_closure16_closure18.doCall(GantBinding.groovy)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:282)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:277)
grails_1  | 	at groovy.lang.Closure$call.call(Unknown Source)
grails_1  | 	at org.codehaus.gant.GantBinding.withTargetEvent(GantBinding.groovy:90)
grails_1  | 	at org.codehaus.gant.GantBinding.this$4$withTargetEvent(GantBinding.groovy)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1003)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:706)
grails_1  | 	at groovy.lang.GroovyObjectSupport.invokeMethod(GroovyObjectSupport.java:44)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethodOnGroovyObject(MetaClassImpl.java:1123)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1017)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:66)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:157)
grails_1  | 	at org.codehaus.gant.GantBinding$_initializeGantBinding_closure5_closure16.doCall(GantBinding.groovy:185)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSite.invoke(PogoMetaMethodSite.java:225)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:51)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)
grails_1  | 	at org.codehaus.gant.GantBinding$_initializeGantBinding_closure5_closure16.doCall(GantBinding.groovy)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:282)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:277)
grails_1  | 	at groovy.lang.Closure$call.call(Unknown Source)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:120)
grails_1  | 	at gant.Gant$_dispatch_closure5.doCall(Gant.groovy:381)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:282)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:295)
grails_1  | 	at groovy.lang.Closure$call$0.call(Unknown Source)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:124)
grails_1  | 	at gant.Gant$_dispatch_closure7.doCall(Gant.groovy:415)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSite.invoke(PogoMetaMethodSite.java:225)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:51)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)
grails_1  | 	at gant.Gant$_dispatch_closure7.doCall(Gant.groovy)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:282)
grails_1  | 	at groovy.lang.Closure.call(Closure.java:277)
grails_1  | 	at groovy.lang.Closure$call.call(Unknown Source)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:120)
grails_1  | 	at gant.Gant.withBuildListeners(Gant.groovy:427)
grails_1  | 	at gant.Gant.this$2$withBuildListeners(Gant.groovy)
grails_1  | 	at gant.Gant$this$2$withBuildListeners.callCurrent(Unknown Source)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)
grails_1  | 	at gant.Gant.dispatch(Gant.groovy:415)
grails_1  | 	at gant.Gant.this$2$dispatch(Gant.groovy)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90)
grails_1  | 	at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
grails_1  | 	at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
grails_1  | 	at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:708)
grails_1  | 	at gant.Gant.invokeMethod(Gant.groovy)
grails_1  | 	at groovy.lang.GroovyObject$invokeMethod.callCurrent(Unknown Source)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:153)
grails_1  | 	at gant.Gant.executeTargets(Gant.groovy:590)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSite.invoke(PogoMetaMethodSite.java:225)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:51)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
grails_1  | 	at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:153)
grails_1  | 	at gant.Gant.executeTargets(Gant.groovy:589)
grails_1  | 	at org.codehaus.groovy.grails.cli.GrailsScriptRunner.executeWithGantInstance(GrailsScriptRunner.java:667)
grails_1  | 	at org.codehaus.groovy.grails.cli.GrailsScriptRunner.callPluginOrGrailsScript(GrailsScriptRunner.java:526)
grails_1  | 	at org.codehaus.groovy.grails.cli.GrailsScriptRunner.executeCommand(GrailsScriptRunner.java:310)
grails_1  | 	at org.codehaus.groovy.grails.cli.GrailsScriptRunner.main(GrailsScriptRunner.java:135)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
grails_1  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
grails_1  | 	at java.lang.reflect.Method.invoke(Method.java:606)
grails_1  | 	at org.codehaus.groovy.grails.cli.support.GrailsStarter.rootLoader(GrailsStarter.java:234)
grails_1  | 	at org.codehaus.groovy.grails.cli.support.GrailsStarter.main(GrailsStarter.java:262)
grails_1  | Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'parent_item.pick_reason_code' in 'field list'
grails_1  | 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
grails_1  | 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
grails_1  | 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
grails_1  | 	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
grails_1  | 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
grails_1  | 	at com.mysql.jdbc.Util.getInstance(Util.java:408)
grails_1  | 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
grails_1  | 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
grails_1  | 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
grails_1  | 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
grails_1  | 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
grails_1  | 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491)
grails_1  | 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449)
grails_1  | 	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
grails_1  | 	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
grails_1  | 	at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
grails_1  | 	at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78)
grails_1  | 	at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48)
grails_1  | 	... 458 more
@ZobairQ ZobairQ changed the title liquibase.exception.JDBCException: Error executing SQL CREATE OR REPLACE VIEW when trying to run in docker Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'parent_item.pick_reason_code' in 'field list' when trying to run in docker Mar 18, 2021
@jmiranda
Copy link
Member

@ZobairQ Thanks for the ticket. Can you restart OpenBoxes and see if you get the same error? And if so, what version are you deploying?

@ZobairQ
Copy link
Author

ZobairQ commented Mar 19, 2021

Hello and thank you for your reply. I am getting this everytime. I did try restarting 3 times and still the error is present.
I did not change anything i just cloned the two repos and started it with docker compose using - - Build first then just docker compose up. I am running on master so whatever version is specified in openboxes docker repo.

@jmiranda
Copy link
Member

Ok, great. Thanks for the information. I'll test it out myself and get back to you. The issue might be resolving itself though. I think we may have a timing issue with the initial creation of the view. But the database migrations always execute the most up-to-date version of the view definitions at the end. So assuming the application actually starts, just go to the Stock Card page and see if the demand value is rendered (e.g. should be 0) without an error in the logs.

@jmiranda
Copy link
Member

@ZobairQ I just confirmed that the issue is a bug, but that OpenBoxes should continue executing database migrations until the system fixes itself. Can you let me know what you're seeing after this error? Does docker stop on the error?

image

@ZobairQ
Copy link
Author

ZobairQ commented Mar 19, 2021

@jmiranda the container does not stop. However it seem running and i am getting grails_1 | 2021-03-19 17:05:00,455 [DefaultPluginScheduler_Worker-2] INFO jobs.AssignIdentifierJob - Postponing job execution until liquibase migrations are complete for hours. How long does a migration typically take?

@jmiranda
Copy link
Member

@ZobairQ On a normal installation it seems to be pushing 30 minutes. On docker it can take longer depending on the amount of memory allocated to the Grails/Tomcat process.

See this discussion for more details about docker slowness due to memory allocation.
https://discuss.openboxes.com/t/website-run-really-slow-on-my-development/307

It shouldn't be stuck for an hour so you're probably ok to kill the process.

Before starting back up you'll need to increase memory (as per the discourse link above) and remove the databasechangeloglock record in the database.

$ mysql -u <username> -p <database>
mysql> delete from DATABASECHANGELOGLOCK;

@ZobairQ
Copy link
Author

ZobairQ commented Mar 19, 2021

Hello again @jmiranda,
thank you for your reply! I have increased the memory settings and it does not seem to give that error and I was able to boot rather quickly!

@jmiranda
Copy link
Member

Yay! So glad to hear. Don't hesitate to reach if you find any other issues. If you have general questions sign up and join the #development channel on slack (http:https://slack.openboxes.com/) or post a new topic on discourse (https://discuss.openboxes.com). Best of luck.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@jmiranda @ZobairQ