When creating an outbond i get the following error “No such property: quantity_counted for class: groovy.sql.GroovyRowResult”
Looks like you may have encountered an issue with your upgrade. This column was added to the requisition item table back in May 2023. You can check to see whether the column exists and/or whether a database migration was executed for the column. If you don’t see either or you only see the database migration, then something might have happened during the upgrade process, so we may need to see your log files from the upgrade to troubleshoot what happened, whether it’s an isolated incident or bug, and come up with a procedure for rectifying the issue.
mysql> show create table requisition_item \G;
*************************** 1. row ***************************
Table: requisition_item
Create Table: CREATE TABLE `requisition_item` (
`id` char(38) NOT NULL DEFAULT '',
`version` bigint NOT NULL,
`category_id` char(38) DEFAULT NULL,
`date_created` datetime NOT NULL,
`description` varchar(255) DEFAULT NULL,
`inventory_item_id` char(38) DEFAULT NULL,
`last_updated` datetime NOT NULL,
`product_id` char(38) NOT NULL,
`quantity` int NOT NULL,
`requisition_id` char(38) DEFAULT NULL,
`requested_by_id` char(38) DEFAULT NULL,
`unit_price` float(12,0) DEFAULT NULL,
`product_group_id` char(38) DEFAULT NULL,
`comment` varchar(255) DEFAULT NULL,
`recipient_id` varchar(255) DEFAULT NULL,
`substitutable` bit(1) NOT NULL,
`order_index` int DEFAULT NULL,
`requisition_items_idx` int DEFAULT NULL,
`quantity_canceled` int DEFAULT NULL,
`cancel_reason_code` varchar(255) DEFAULT NULL,
`cancel_comments` varchar(255) DEFAULT NULL,
`parent_requisition_item_id` char(38) DEFAULT NULL,
`product_package_id` char(38) DEFAULT NULL,
`requisition_item_type` varchar(255) DEFAULT NULL,
`quantity_approved` int DEFAULT NULL,
`created_by_id` char(38) DEFAULT NULL,
`updated_by_id` char(38) DEFAULT NULL,
`substitution_item_id` char(38) DEFAULT NULL,
`modification_item_id` char(38) DEFAULT NULL,
`pallet_name` varchar(255) DEFAULT NULL,
`box_name` varchar(255) DEFAULT NULL,
`lot_number` varchar(255) DEFAULT NULL,
`expiration_date` datetime DEFAULT NULL,
`pick_reason_code` varchar(255) DEFAULT NULL,
`quantity_counted` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK4DA982C3EF4C770D` (`category_id`),
KEY `FK4DA982C3AA992CED` (`inventory_item_id`),
KEY `FK4DA982C3DED5FAE7` (`product_id`),
KEY `FK4DA982C35DE21C87` (`requisition_id`),
KEY `FK5358E4D6217F5972` (`created_by_id`),
KEY `FK5358E4D614F7BB8E` (`product_group_id`),
KEY `FK5358E4D6DD302242` (`requested_by_id`),
KEY `FK5358E4D6426DD105` (`updated_by_id`),
KEY `FK5358E4D629B2552E` (`product_package_id`),
KEY `FK5358E4D6405AC22D` (`modification_item_id`),
KEY `FK5358E4D6F84BDE18` (`parent_requisition_item_id`),
KEY `FK5358E4D61594028E` (`substitution_item_id`),
KEY `FK5358E4D644979D51` (`recipient_id`),
CONSTRAINT `FK4DA982C35DE21C87` FOREIGN KEY (`requisition_id`) REFERENCES `requisition` (`id`),
CONSTRAINT `FK4DA982C3911E7578` FOREIGN KEY (`requested_by_id`) REFERENCES `user` (`id`),
CONSTRAINT `FK4DA982C3AA992CED` FOREIGN KEY (`inventory_item_id`) REFERENCES `inventory_item` (`id`),
CONSTRAINT `FK4DA982C3DED5FAE7` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`),
CONSTRAINT `FK4DA982C3EF4C770D` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
CONSTRAINT `FK5358E4D614F7BB8E` FOREIGN KEY (`product_group_id`) REFERENCES `product_group` (`id`),
CONSTRAINT `FK5358E4D61594028E` FOREIGN KEY (`substitution_item_id`) REFERENCES `requisition_item` (`id`),
CONSTRAINT `FK5358E4D6217F5972` FOREIGN KEY (`created_by_id`) REFERENCES `user` (`id`),
CONSTRAINT `FK5358E4D629B2552E` FOREIGN KEY (`product_package_id`) REFERENCES `product_package` (`id`),
CONSTRAINT `FK5358E4D6405AC22D` FOREIGN KEY (`modification_item_id`) REFERENCES `requisition_item` (`id`),
CONSTRAINT `FK5358E4D6426DD105` FOREIGN KEY (`updated_by_id`) REFERENCES `user` (`id`),
CONSTRAINT `FK5358E4D644979D51` FOREIGN KEY (`recipient_id`) REFERENCES `person` (`id`),
CONSTRAINT `FK5358E4D6DD302242` FOREIGN KEY (`requested_by_id`) REFERENCES `person` (`id`),
CONSTRAINT `FK5358E4D6F84BDE18` FOREIGN KEY (`parent_requisition_item_id`) REFERENCES `requisition_item` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
1 row in set (0.00 sec)
Then, check whether the database migration for this column was executed.
mysql> select * from DATABASECHANGELOG where ID = '170520231453-0' \G;
*************************** 1. row ***************************
ID: 170520231453-0
AUTHOR: AlanNadolny
FILENAME: 0.8.x/changelog-2023-05-17-1453-add-quantity-counted-column.xml
DATEEXECUTED: 2023-05-26 12:57:59
MD5SUM: 1938629a2a805fee258c6529a543d
DESCRIPTION: Add Column
COMMENTS:
TAG: NULL
LIQUIBASE: 1.9.3
1 row in set (0.01 sec)
I checked the upgrade and it showed no errors. and i ran “select * from DATABASECHANGELOG where ID = ‘170520231453-0’ \G;” and returned the same record you posted.
What about the requisition_item table? Does that have the quanity_counted? Can you paste the output from the following statement?
mysql> show create table requisition_item \G
If the column is there, then this might be an issue with the views not being updated properly. Can you paste the output from the following query when you get a chance?
mysql> show create view stock_movement_item \G
mysql> use openboxes
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show create table requisition_item \G
*************************** 1. row ***************************
Table: requisition_item
Create Table: CREATE TABLE `requisition_item` (
`id` char(38) NOT NULL DEFAULT '',
`version` bigint NOT NULL,
`category_id` char(38) DEFAULT NULL,
`date_created` datetime NOT NULL,
`description` varchar(255) DEFAULT NULL,
`inventory_item_id` char(38) DEFAULT NULL,
`last_updated` datetime NOT NULL,
`product_id` char(38) NOT NULL,
`quantity` int NOT NULL,
`requisition_id` char(38) DEFAULT NULL,
`requested_by_id` char(38) DEFAULT NULL,
`unit_price` float(12,0) DEFAULT NULL,
`product_group_id` char(38) DEFAULT NULL,
`comment` varchar(255) DEFAULT NULL,
`recipient_id` varchar(255) DEFAULT NULL,
`substitutable` bit(1) NOT NULL,
`order_index` int DEFAULT NULL,
`requisition_items_idx` int DEFAULT NULL,
`quantity_canceled` int DEFAULT NULL,
`cancel_reason_code` varchar(255) DEFAULT NULL,
`cancel_comments` varchar(255) DEFAULT NULL,
`parent_requisition_item_id` char(38) DEFAULT NULL,
`product_package_id` char(38) DEFAULT NULL,
`requisition_item_type` varchar(255) DEFAULT NULL,
`quantity_approved` int DEFAULT NULL,
`created_by_id` char(38) DEFAULT NULL,
`updated_by_id` char(38) DEFAULT NULL,
`substitution_item_id` char(38) DEFAULT NULL,
`modification_item_id` char(38) DEFAULT NULL,
`pallet_name` varchar(255) DEFAULT NULL,
`box_name` varchar(255) DEFAULT NULL,
`lot_number` varchar(255) DEFAULT NULL,
`expiration_date` datetime DEFAULT NULL,
`pick_reason_code` varchar(255) DEFAULT NULL,
`quantity_counted` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK4DA982C3EF4C770D` (`category_id`),
KEY `FK4DA982C3AA992CED` (`inventory_item_id`),
KEY `FK4DA982C3DED5FAE7` (`product_id`),
KEY `FK4DA982C35DE21C87` (`requisition_id`),
KEY `FK5358E4D6217F5972` (`created_by_id`),
KEY `FK5358E4D614F7BB8E` (`product_group_id`),
KEY `FK5358E4D6DD302242` (`requested_by_id`),
KEY `FK5358E4D6426DD105` (`updated_by_id`),
KEY `FK5358E4D629B2552E` (`product_package_id`),
KEY `FK5358E4D6405AC22D` (`modification_item_id`),
KEY `FK5358E4D6F84BDE18` (`parent_requisition_item_id`),
KEY `FK5358E4D61594028E` (`substitution_item_id`),
KEY `FK5358E4D644979D51` (`recipient_id`),
CONSTRAINT `FK4DA982C35DE21C87` FOREIGN KEY (`requisition_id`) REFERENCES `requisition` (`id`),
CONSTRAINT `FK4DA982C3911E7578` FOREIGN KEY (`requested_by_id`) REFERENCES `user` (`id`),
CONSTRAINT `FK4DA982C3AA992CED` FOREIGN KEY (`inventory_item_id`) REFERENCES `inventory_item` (`id`),
CONSTRAINT `FK4DA982C3DED5FAE7` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`),
CONSTRAINT `FK4DA982C3EF4C770D` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
CONSTRAINT `FK5358E4D614F7BB8E` FOREIGN KEY (`product_group_id`) REFERENCES `product_group` (`id`),
CONSTRAINT `FK5358E4D61594028E` FOREIGN KEY (`substitution_item_id`) REFERENCES `requisition_item` (`id`),
CONSTRAINT `FK5358E4D6217F5972` FOREIGN KEY (`created_by_id`) REFERENCES `user` (`id`),
CONSTRAINT `FK5358E4D629B2552E` FOREIGN KEY (`product_package_id`) REFERENCES `product_package` (`id`),
CONSTRAINT `FK5358E4D6405AC22D` FOREIGN KEY (`modification_item_id`) REFERENCES `requisition_item` (`id`),
CONSTRAINT `FK5358E4D6426DD105` FOREIGN KEY (`updated_by_id`) REFERENCES `user` (`id`),
CONSTRAINT `FK5358E4D644979D51` FOREIGN KEY (`recipient_id`) REFERENCES `person` (`id`),
CONSTRAINT `FK5358E4D6DD302242` FOREIGN KEY (`requested_by_id`) REFERENCES `person` (`id`),
CONSTRAINT `FK5358E4D6F84BDE18` FOREIGN KEY (`parent_requisition_item_id`) REFERENCES `requisition_item` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
1 row in set (0.04 sec)
mysql> show create view stock_movement_item \G
*************************** 1. row ***************************
View: stock_movement_item
Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`openboxes`@`localhost` SQL SECURITY DEFINER VIEW `stock_movement_item` AS select `requisition_item`.`id` AS `id`,`requisition_item`.`requisition_item_type` AS `requisition_item_type`,`requisition_item`.`parent_requisition_item_id` AS `parent_requisition_item_id`,`requisition_item`.`requisition_id` AS `requisition_id`,`requisition`.`origin_id` AS `origin_id`,`requisition`.`destination_id` AS `destination_id`,`requisition_item`.`product_id` AS `product_id`,`product`.`product_code` AS `product_code`,`product`.`name` AS `name`,`requisition_item`.`quantity` AS `quantity`,`requisition_item`.`quantity_canceled` AS `quantity_canceled`,`requisition_item`.`order_index` AS `order_index`,`requisition_item`.`cancel_reason_code` AS `cancel_reason_code`,`requisition_item`.`comment` AS `comments`,(case when `modification_item`.`quantity` then `modification_item`.`quantity` when (`requisition_item`.`quantity_canceled` = `requisition_item`.`quantity`) then 0 else NULL end) AS `quantity_revised` from (((`requisition_item` join `requisition` on((`requisition_item`.`requisition_id` = `requisition`.`id`))) join `product` on((`product`.`id` = `requisition_item`.`product_id`))) left join `requisition_item` `modification_item` on(((`modification_item`.`parent_requisition_item_id` = `requisition_item`.`id`) and (`modification_item`.`requisition_item_type` = 'QUANTITY_CHANGE'))))
character_set_client: utf8mb4
collation_connection: utf8mb4_0900_ai_ci
1 row in set (0.00 sec)
Alright, I’m not seeing quantity_counted in the stock_movement_item view, so that probably explains the error you’re seeing.
However, the underlying cause of that is not clear. Views are recreated on every server restart. That does not seem to be happening on your system for some reason. If you could restart the server and paste the last 200 lines from catalina.out, that would be helpful.
I want to make sure the delete-all-views and create views database migrations are being executed successfully.
2023-11-09 16:30:49,215 [localhost-startStop-1] INFO bootstrap.BootStrap - Running liquibase changelog(s) ...
2023-11-09 16:30:49,339 [localhost-startStop-1] INFO bootstrap.BootStrap - Liquibase running: false
2023-11-09 16:30:49,341 [localhost-startStop-1] INFO bootstrap.BootStrap - Setting default schema to openboxes
2023-11-09 16:30:49,341 [localhost-startStop-1] INFO bootstrap.BootStrap - Product Version: 5.5.5-10.11.3-MariaDB-1:10.11.3+maria~ubu2204-log
2023-11-09 16:30:49,341 [localhost-startStop-1] INFO bootstrap.BootStrap - Database Version: 5.5
2023-11-09 16:30:49,343 [localhost-startStop-1] INFO liquibase - Reading from `DATABASECHANGELOG`
2023-11-09 16:30:49,483 [localhost-startStop-1] INFO liquibase - Lock Database
2023-11-09 16:30:49,486 [localhost-startStop-1] INFO liquibase - Successfully acquired change log lock
2023-11-09 16:30:51,303 [localhost-startStop-1] INFO liquibase - Changeset views/drop-all-views.xml::1633402273161-1::jmiranda::(MD5Sum: 3ed2f63fcddf2ea15f65eb76214ea186)
2023-11-09 16:30:51,303 [localhost-startStop-1] INFO liquibase - Views will be recreated after database migrations are executed.
2023-11-09 16:30:51,361 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-1::jmiranda::(MD5Sum: fdb1b3291b9ec6e2d296943668e5541)
2023-11-09 16:30:51,371 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-1b::jmiranda::(MD5Sum: 5b89dbf448c32309b34a901c7db2b2)
2023-11-09 16:30:54,907 [localhost-startStop-1] INFO liquibase - Marking ChangeSet: views/changelog.xml::1580848680306-1b::jmiranda::(MD5Sum: 5b89dbf448c32309b34a901c7db2b2) ran due to precondition failure:
Not precondition failed
2023-11-09 16:30:54,910 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-2::jmiranda::(MD5Sum: 287cd86a7aab4d5b8de07b0e3558dd)
2023-11-09 16:30:54,914 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-3::jmiranda::(MD5Sum: ab4d24b350f3b66a79e8deccb6ce7abf)
2023-11-09 16:30:54,916 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-4::jmiranda::(MD5Sum: 73d7ed234b27a2c72d1ddac9d1c2e52c)
2023-11-09 16:30:54,919 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-5::jmiranda::(MD5Sum: c2d2fe8cc3768852859887d70b2c363)
2023-11-09 16:30:54,922 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-6::jmiranda::(MD5Sum: 204668f546b9d28cfc1e171d1f63c332)
2023-11-09 16:30:54,925 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-7::jmiranda::(MD5Sum: 4a94ad0851f6c15ad2188ab9e52a5)
2023-11-09 16:30:54,928 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-8::jmiranda::(MD5Sum: 6e1f5a212a81349839521befc77d9d)
2023-11-09 16:30:54,932 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-9::jmiranda::(MD5Sum: f2bc4581973c375fe4b1bf9d19961774)
2023-11-09 16:30:54,935 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-10::dhatala::(MD5Sum: 5dab9c95b978dd9f79f0a8f6a28c941d)
2023-11-09 16:30:54,938 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-11::jmiranda::(MD5Sum: be12e7b15a3323c9e4aef9fbf5437ef0)
2023-11-09 16:30:54,940 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-13::jmiranda::(MD5Sum: 7290e543f6e033fde63f3b0c089e29c)
2023-11-09 16:30:54,943 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-14::dhatala::(MD5Sum: 74bd46d68a6214730dedafeca3f7385)
2023-11-09 16:30:54,946 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-15::dhatala::(MD5Sum: e1f4de3140657f7eddc76ee18480a4ca)
2023-11-09 16:30:54,949 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-16::dhatala::(MD5Sum: 57db51d93ad34d1c639045887a042da)
2023-11-09 16:30:54,951 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-17::dhatala::(MD5Sum: 5db594b28ea496d2e8cce84746d7a3d)
2023-11-09 16:30:54,954 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-18::jmiranda::(MD5Sum: 4d7ea16f2015559a729c4d47acc9165)
2023-11-09 16:30:54,959 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-19::dhatala::(MD5Sum: 6d593dd51d4e874b6dd78aaeaa4423)
2023-11-09 16:30:54,961 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-20::dhatala::(MD5Sum: 8486404cb2d5b28aa67ad8811216b770)
2023-11-09 16:30:54,964 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-21::pmuchowski::(MD5Sum: 8cdeae3d64c755276092949683b92f9)
2023-11-09 16:30:54,968 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-22::dhatala::(MD5Sum: de8a8a531d2ea0f07641713cb3543f)
2023-11-09 16:30:54,970 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-23::awalkowiak::(MD5Sum: 429c53125e5765f413d96f4e97af6416)
2023-11-09 16:30:54,981 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-23b::awalkowiak::(MD5Sum: d2c664aa1bd3127078a1eb6bb5bbe85)
2023-11-09 16:30:57,559 [localhost-startStop-1] INFO liquibase - Marking ChangeSet: views/changelog.xml::1580848680306-23b::awalkowiak::(MD5Sum: d2c664aa1bd3127078a1eb6bb5bbe85) ran due to precondition failure:
Not precondition failed
2023-11-09 16:30:57,561 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-24::pmuchowski::(MD5Sum: a6ac361936b441ddd8d439f4fa8a457)
2023-11-09 16:30:57,564 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-25::dbienkowska::(MD5Sum: 4227dba941339f4cdcc183c5159317f)
2023-11-09 16:30:57,567 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-26::awalkowiak::(MD5Sum: 3fa0ac8c34124cccfd3d76a569edfb)
2023-11-09 16:30:57,569 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-27::pmuchowski::(MD5Sum: 376b802ad2080d148d2dc37bc44f024)
2023-11-09 16:30:57,572 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-28::pmuchowski::(MD5Sum: 8218dd1ca7f3b55527a5566e6c6da97)
2023-11-09 16:30:57,575 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-29::awalkowiak::(MD5Sum: 60104f587df8ae8c94b85a80b6125ba8)
2023-11-09 16:30:57,579 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-30::awalkowiak::(MD5Sum: c1a75e2ec3a8361ceece50a99738cc)
2023-11-09 16:30:57,593 [localhost-startStop-1] INFO liquibase - Release Database Lock
2023-11-09 16:30:57,594 [localhost-startStop-1] INFO liquibase - Successfully released change log lock
2023-11-09 16:30:57,612 [localhost-startStop-1] INFO bootstrap.BootStrap - Finished running liquibase changelog(s)!
2023-11-09 16:30:57,613 [localhost-startStop-1] INFO core.UploadService - Find or create uploads directory uploads
2023-11-09 16:30:57,616 [localhost-startStop-1] INFO core.FileService - Attempting to create directory /var/lib/tomcat7/uploads
2023-11-09 16:30:57,617 [localhost-startStop-1] INFO core.FileService - - Directory /var/lib/tomcat7/uploads already exists
2023-11-09 16:30:57,619 [localhost-startStop-1] INFO context.ContextLoader - Root WebApplicationContext: initialization completed in 30827 ms
2023-11-10 08:52:51,601 [localhost-startStop-1] INFO bootstrap.BootStrap - Running liquibase changelog(s) ...
2023-11-10 08:52:51,859 [localhost-startStop-1] INFO bootstrap.BootStrap - Liquibase running: false
2023-11-10 08:52:51,868 [localhost-startStop-1] INFO bootstrap.BootStrap - Setting default schema to openboxes
2023-11-10 08:52:51,870 [localhost-startStop-1] INFO bootstrap.BootStrap - Product Version: 8.0.35-0ubuntu0.22.04.1
2023-11-10 08:52:51,870 [localhost-startStop-1] INFO bootstrap.BootStrap - Database Version: 8.0
2023-11-10 08:52:51,875 [localhost-startStop-1] INFO liquibase - Reading from `DATABASECHANGELOG`
2023-11-10 08:52:52,307 [localhost-startStop-1] INFO liquibase - Lock Database
2023-11-10 08:52:52,325 [localhost-startStop-1] INFO liquibase - Successfully acquired change log lock
2023-11-10 08:52:56,649 [localhost-startStop-1] INFO liquibase - Changeset views/drop-all-views.xml::1633402273161-1::jmiranda::(MD5Sum: 3ed2f63fcddf2ea15f65eb76214ea186)
2023-11-10 08:52:56,649 [localhost-startStop-1] INFO liquibase - Views will be recreated after database migrations are executed.
2023-11-10 08:52:56,889 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-1::jmiranda::(MD5Sum: fdb1b3291b9ec6e2d296943668e5541)
2023-11-10 08:52:57,113 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-1b::jmiranda::(MD5Sum: 5b89dbf448c32309b34a901c7db2b2)
2023-11-10 08:53:00,071 [DefaultPluginScheduler_Worker-1] INFO jobs.JobUtils - Postponing job execution for assignIdentifierJob until liquibase migrations are complete
2023-11-10 08:53:03,599 [localhost-startStop-1] INFO liquibase - Marking ChangeSet: views/changelog.xml::1580848680306-1b::jmiranda::(MD5Sum: 5b89dbf448c32309b34a901c7db2b2) ran due to precondition failure:
Not precondition failed
2023-11-10 08:53:03,605 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-2::jmiranda::(MD5Sum: 287cd86a7aab4d5b8de07b0e3558dd)
2023-11-10 08:53:03,613 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-3::jmiranda::(MD5Sum: ab4d24b350f3b66a79e8deccb6ce7abf)
2023-11-10 08:53:03,645 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-4::jmiranda::(MD5Sum: 73d7ed234b27a2c72d1ddac9d1c2e52c)
2023-11-10 08:53:03,653 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-5::jmiranda::(MD5Sum: c2d2fe8cc3768852859887d70b2c363)
2023-11-10 08:53:03,661 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-6::jmiranda::(MD5Sum: 204668f546b9d28cfc1e171d1f63c332)
2023-11-10 08:53:03,668 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-7::jmiranda::(MD5Sum: 4a94ad0851f6c15ad2188ab9e52a5)
2023-11-10 08:53:03,676 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-8::jmiranda::(MD5Sum: 6e1f5a212a81349839521befc77d9d)
2023-11-10 08:53:03,685 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-9::jmiranda::(MD5Sum: f2bc4581973c375fe4b1bf9d19961774)
2023-11-10 08:53:03,696 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-10::dhatala::(MD5Sum: 5dab9c95b978dd9f79f0a8f6a28c941d)
2023-11-10 08:53:03,708 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-11::jmiranda::(MD5Sum: be12e7b15a3323c9e4aef9fbf5437ef0)
2023-11-10 08:53:03,717 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-13::jmiranda::(MD5Sum: 7290e543f6e033fde63f3b0c089e29c)
2023-11-10 08:53:03,725 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-14::dhatala::(MD5Sum: 74bd46d68a6214730dedafeca3f7385)
2023-11-10 08:53:03,733 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-15::dhatala::(MD5Sum: e1f4de3140657f7eddc76ee18480a4ca)
2023-11-10 08:53:03,741 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-16::dhatala::(MD5Sum: 57db51d93ad34d1c639045887a042da)
2023-11-10 08:53:03,749 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-17::dhatala::(MD5Sum: 5db594b28ea496d2e8cce84746d7a3d)
2023-11-10 08:53:03,758 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-18::jmiranda::(MD5Sum: 4d7ea16f2015559a729c4d47acc9165)
2023-11-10 08:53:03,770 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-19::dhatala::(MD5Sum: 6d593dd51d4e874b6dd78aaeaa4423)
2023-11-10 08:53:03,778 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-20::dhatala::(MD5Sum: 8486404cb2d5b28aa67ad8811216b770)
2023-11-10 08:53:03,786 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-21::pmuchowski::(MD5Sum: 8cdeae3d64c755276092949683b92f9)
2023-11-10 08:53:03,795 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-22::dhatala::(MD5Sum: de8a8a531d2ea0f07641713cb3543f)
2023-11-10 08:53:03,803 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-23::awalkowiak::(MD5Sum: 429c53125e5765f413d96f4e97af6416)
2023-11-10 08:53:03,832 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-23b::awalkowiak::(MD5Sum: d2c664aa1bd3127078a1eb6bb5bbe85)
2023-11-10 08:53:08,865 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-24::pmuchowski::(MD5Sum: a6ac361936b441ddd8d439f4fa8a457)
2023-11-10 08:53:08,873 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-25::dbienkowska::(MD5Sum: 4227dba941339f4cdcc183c5159317f)
2023-11-10 08:53:08,915 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-26::awalkowiak::(MD5Sum: 3fa0ac8c34124cccfd3d76a569edfb)
2023-11-10 08:53:08,922 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-27::pmuchowski::(MD5Sum: 376b802ad2080d148d2dc37bc44f024)
2023-11-10 08:53:08,929 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-28::pmuchowski::(MD5Sum: 8218dd1ca7f3b55527a5566e6c6da97)
2023-11-10 08:53:08,939 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-29::awalkowiak::(MD5Sum: 60104f587df8ae8c94b85a80b6125ba8)
2023-11-10 08:53:08,946 [localhost-startStop-1] INFO liquibase - Changeset views/changelog.xml::1580848680306-30::awalkowiak::(MD5Sum: c1a75e2ec3a8361ceece50a99738cc)
2023-11-10 08:53:08,955 [localhost-startStop-1] INFO liquibase - Release Database Lock
2023-11-10 08:53:08,957 [localhost-startStop-1] INFO liquibase - Successfully released change log lock
2023-11-10 08:53:08,969 [localhost-startStop-1] INFO bootstrap.BootStrap - Finished running liquibase changelog(s)!
2023-11-10 08:53:08,970 [localhost-startStop-1] INFO core.UploadService - Find or create uploads directory uploads
2023-11-10 08:53:08,973 [localhost-startStop-1] INFO core.FileService - Attempting to create directory /uploads
2023-11-10 08:53:08,973 [localhost-startStop-1] INFO core.FileService - - Directory /uploads already exists
2023-11-10 08:53:08,985 [localhost-startStop-1] INFO context.ContextLoader - Root WebApplicationContext: initialization completed in 68817 ms
2023-11-10 08:53:09,103 [DefaultPluginScheduler_Worker-2] INFO jobs.RefreshStockoutDataJob - Refreshing stockout data: [grailsArtefactJobName:org.pih.warehouse.jobs.RefreshStockoutDataJob]
2023-11-10 08:53:09,138 [DefaultPluginScheduler_Worker-3] INFO jobs.RefreshProductAvailabilityJob - Refreshing product availability data: [forceRefresh:true, grailsArtefactJobName:org.pih.warehouse.jobs.RefreshProductAvailabilityJob]
2023-11-10 08:53:09,154 [DefaultPluginScheduler_Worker-4] INFO jobs.RefreshDemandDataJob - Refreshing demand data: [grailsArtefactJobName:org.pih.warehouse.jobs.RefreshDemandDataJob]
2023-11-10 08:53:09,171 [DefaultPluginScheduler_Worker-5] INFO jobs.RefreshOrderSummaryJob - Refreshing order summary: [grailsArtefactJobName:org.pih.warehouse.jobs.RefreshOrderSummaryJob]
2023-11-10 08:53:09,241 [DefaultPluginScheduler_Worker-3] INFO jobs.GparsService - creating new pool 'RefreshAllProducts' of size 2
2023-11-10 08:53:09,611 [DefaultPluginScheduler_Worker-5] INFO data.DataService - Executing statement DROP TABLE IF EXISTS order_summary_mv_temp;
2023-11-10 08:53:09,611 [DefaultPluginScheduler_Worker-4] INFO data.DataService - Executing statement DROP TABLE IF EXISTS product_demand_details_tmp;
Nov 10, 2023 8:53:09 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deployment of web application archive /opt/apache-tomcat-7.0.94/webapps/openboxes.war has finished in 107,690 ms
Nov 10, 2023 8:53:09 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /opt/apache-tomcat-7.0.94/webapps/docs
2023-11-10 08:53:09,663 [DefaultPluginScheduler_Worker-5] INFO data.DataService - Updated 0 rows in 52 ms
2023-11-10 08:53:09,665 [DefaultPluginScheduler_Worker-5] INFO data.DataService - Executing statement CREATE TABLE order_summary_mv_temp AS SELECT DISTINCT * FROM order_summary;
2023-11-10 08:53:09,718 [DefaultPluginScheduler_Worker-4] INFO data.DataService - Updated 0 rows in 104 ms
2023-11-10 08:53:09,719 [DefaultPluginScheduler_Worker-4] INFO data.DataService - Executing statement CREATE TABLE product_demand_details_tmp AS
SELECT
request_id,
request_status,
request_number,
date_created,
date_requested,
date_issued,
origin_id,
origin_name,
destination_id,
destination_name,
request_item_id,
product_id,
product_code,
product_name,
quantity_requested,
quantity_canceled,
quantity_approved,
quantity_modified,
quantity_picked,
quantity_demand,
reason_code,
reason_code_classification
FROM product_demand;
Nov 10, 2023 8:53:09 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory /opt/apache-tomcat-7.0.94/webapps/docs has finished in 117 ms
Nov 10, 2023 8:53:09 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /opt/apache-tomcat-7.0.94/webapps/host-manager
2023-11-10 08:53:09,794 [DefaultPluginScheduler_Worker-5] INFO data.DataService - Updated 0 rows in 128 ms
Edited by @jmiranda for formatting
Yup, that looks like a pretty clean database migration.
Can you clarify which version of the software you are running? To confirm, post a screenshot that includes the footer with the application version.
Did you deploy v0.8.23 and then revert back to an older version like v0.8.22?
Or do you have multiple WAR files deployed?
hello Justin,
The thing is that i renamed the v0.8.22 to openboxes.old, it seems that this was the problem, and it was resolved after i moved it out of /tomcat/webapps folder.
thank you
Yay! I was hoping that was going to be the issue. Thanks for the update.