Page 1 of 1

SQL errors after migrating to MySQL

Posted: Sun Sep 14, 2014 5:44 pm
by anikanchan
I am using the latest DemoSite code and it worked well with HSQL database. However after I migrated to MySQL, following the instructions I am seeing SQL errors in the log (copied). I am able to start the site as well as admin tool but not sure what to do about the errors with SQL.

...
...
[artifact:mvn] [ WARN] 18:27:44 AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [blSandBoxElements]; using defaults.
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDITIONAL_OFFER_INFO drop foreign key FK3BFDBD63B5D9C34D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_additional_offer_info' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDITIONAL_OFFER_INFO drop foreign key FK3BFDBD63D5F3FAF4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_additional_offer_info' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDITIONAL_OFFER_INFO drop foreign key FK3BFDBD631891FF79
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_additional_offer_info' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CEA46E16CF
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_address' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CEF1A6533F
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_address' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CEBF4449BA
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_address' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CEE12DC0C8
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_address' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CE337C4D50
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_address' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_PERMISSION_ENTITY drop foreign key FK23C09E3DE88B7D38
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_admin_permission_entity' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_PERMISSION_XREF drop foreign key FKBCAD1F5E88B7D38
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_admin_permission_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_PERMISSION_XREF drop foreign key FKBCAD1F575A3C445
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_admin_permission_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_ROLE_PERMISSION_XREF drop foreign key FK4A819D98E88B7D38
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_admin_role_permission_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_ROLE_PERMISSION_XREF drop foreign key FK4A819D985F43AAD8
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_admin_role_permission_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_SECTION drop foreign key FK7EA7D92FB1A18498
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_admin_section' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_SEC_PERM_XREF drop foreign key FK5E832966E88B7D38
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_admin_sec_perm_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_SEC_PERM_XREF drop foreign key FK5E8329663AF7F0FC
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_admin_sec_perm_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_ADDTL_FIELDS drop foreign key FK73274CDD46EBC38
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_admin_user_addtl_fields' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_PERMISSION_XREF drop foreign key FKF0B3BEEDE88B7D38
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_admin_user_permission_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_PERMISSION_XREF drop foreign key FKF0B3BEED46EBC38
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_admin_user_permission_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_ROLE_XREF drop foreign key FKFFD33A265F43AAD8
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_admin_user_role_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_ROLE_XREF drop foreign key FKFFD33A2646EBC38
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_admin_user_role_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_SANDBOX drop foreign key FKD0A97E09579FE59D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_admin_user_sandbox' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_SANDBOX drop foreign key FKD0A97E0946EBC38
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_admin_user_sandbox' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ASSET_DESC_MAP drop foreign key FKE886BAE3E2BA0C9D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_asset_desc_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ASSET_DESC_MAP drop foreign key FKE886BAE367F70B63
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_asset_desc_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_BUNDLE_ORDER_ITEM drop foreign key FK489703DBCCF29B96
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_bundle_order_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_BUNDLE_ORDER_ITEM drop foreign key FK489703DBB78C9977
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_bundle_order_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_BUNDLE_ORDER_ITEM drop foreign key FK489703DB9AF166DF
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_bundle_order_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_BUND_ITEM_FEE_PRICE drop foreign key FK14267A943FC68307
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_bund_item_fee_price' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_FG_OFFER drop foreign key FKCE785605028DC55
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_candidate_fg_offer' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_FG_OFFER drop foreign key FKCE78560D5F3FAF4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_candidate_fg_offer' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_ITEM_OFFER drop foreign key FK9EEE9B2D5F3FAF4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_candidate_item_offer' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_ITEM_OFFER drop foreign key FK9EEE9B29AF166DF
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_candidate_item_offer' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_ORDER_OFFER drop foreign key FK61852289D5F3FAF4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_candidate_order_offer' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_ORDER_OFFER drop foreign key FK6185228989FE8A02
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_candidate_order_offer' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY drop foreign key FK55F82D44B177E6
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_category' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_ATTRIBUTE drop foreign key FK4E441D4115D1A13D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_category_attribute' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_IMAGE drop foreign key FK27CF3E8015D1A13D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_category_image' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_MEDIA_MAP drop foreign key FKCD24B1066E4720E0
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_category_media_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_MEDIA_MAP drop foreign key FKCD24B106D786CEA2
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_category_media_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_PRODUCT_XREF drop foreign key FK635EB1A615D1A13D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_category_product_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_PRODUCT_XREF drop foreign key FK635EB1A65F11A0B7
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_category_product_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_XREF drop foreign key FKE889733615D1A13D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_category_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_XREF drop foreign key FKE8897336D6D45DBE
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_category_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SEARCH_FACET_EXCL_XREF drop foreign key FK8361EF4E15D1A13D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_cat_search_facet_excl_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SEARCH_FACET_EXCL_XREF drop foreign key FK8361EF4EB96B1C93
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_cat_search_facet_excl_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SEARCH_FACET_XREF drop foreign key FK32210EEB15D1A13D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_cat_search_facet_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SEARCH_FACET_XREF drop foreign key FK32210EEBB96B1C93
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_cat_search_facet_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SITE_MAP_GEN_CFG drop foreign key FK1BA4E695C5F3D60
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_cat_site_map_gen_cfg' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SITE_MAP_GEN_CFG drop foreign key FK1BA4E69BCAB9F56
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_cat_site_map_gen_cfg' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER drop foreign key FK7716F0241422B204
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_customer' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER drop foreign key FK7716F024A1E1C128
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_customer' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_ADDRESS drop foreign key FK75B95AB9C13085DD
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_customer_address' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_ADDRESS drop foreign key FK75B95AB97470F437
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_customer_address' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_ATTRIBUTE drop foreign key FKB974C8217470F437
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_customer_attribute' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_OFFER_XREF drop foreign key FK685E80397470F437
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_customer_offer_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_OFFER_XREF drop foreign key FK685E8039D5F3FAF4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_customer_offer_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_PAYMENT drop foreign key FK8B3DF0CBC13085DD
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_customer_payment' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_PAYMENT drop foreign key FK8B3DF0CB7470F437
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_customer_payment' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_PAYMENT_FIELDS drop foreign key FK5CCB14ADCA0B98E0
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_customer_payment_fields' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_PHONE drop foreign key FK3D28ED737470F437
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_customer_phone' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_PHONE drop foreign key FK3D28ED73D894CB5D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_customer_phone' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_ROLE drop foreign key FK548EB7B17470F437
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_customer_role' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_ROLE drop foreign key FK548EB7B1B8587B7
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_customer_role' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUST_SITE_MAP_GEN_CFG drop foreign key FK67C0DBA0BCAB9F56
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_cust_site_map_gen_cfg' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DATA_DRVN_ENUM_VAL drop foreign key FKB2D5700DA60E0554
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_data_drvn_enum_val' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISCRETE_ORDER_ITEM drop foreign key FKBC3A8A845CDFCA80
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_discrete_order_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISCRETE_ORDER_ITEM drop foreign key FKBC3A8A845F11A0B7
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_discrete_order_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISCRETE_ORDER_ITEM drop foreign key FKBC3A8A84B78C9977
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_discrete_order_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISCRETE_ORDER_ITEM drop foreign key FKBC3A8A841285903B
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_discrete_order_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISCRETE_ORDER_ITEM drop foreign key FKBC3A8A849AF166DF
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_discrete_order_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISC_ITEM_FEE_PRICE drop foreign key FK2A641CC8B76B9466
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_disc_item_fee_price' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DYN_DISCRETE_ORDER_ITEM drop foreign key FK209DEE9EB76B9466
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_dyn_discrete_order_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_EMAIL_TRACKING_CLICKS drop foreign key FKFDF9F52AFA1E5D61
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_email_tracking_clicks' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_EMAIL_TRACKING_OPENS drop foreign key FKA5C3722AFA1E5D61
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_email_tracking_opens' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_ADJUSTMENT drop foreign key FK468C8F255028DC55
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fg_adjustment' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_ADJUSTMENT drop foreign key FK468C8F25D5F3FAF4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fg_adjustment' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_FEE_TAX_XREF drop foreign key FK25426DC071448C19
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fg_fee_tax_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_FEE_TAX_XREF drop foreign key FK25426DC0598F6D02
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fg_fee_tax_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_FG_TAX_XREF drop foreign key FK61BEA45571448C19
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fg_fg_tax_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_FG_TAX_XREF drop foreign key FK61BEA4555028DC55
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fg_fg_tax_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_ITEM_TAX_XREF drop foreign key FKDD3E844371448C19
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fg_item_tax_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_ITEM_TAX_XREF drop foreign key FKDD3E8443E3BBB4D2
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fg_item_tax_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FIELD_SEARCH_TYPES drop foreign key FKF52D130D3C3907C4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_field_search_types' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FLD_DEF drop foreign key FK3FCB575E38D08AB5
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fld_def' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FLD_DEF drop foreign key FK3FCB575E6A79BDB5
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fld_def' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FLD_ENUM_ITEM drop foreign key FK83A6A84AFD2EA299
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fld_enum_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP drop foreign key FKC5B9EF18C13085DD
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fulfillment_group' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP drop foreign key FKC5B9EF1881F34C7F
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fulfillment_group' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP drop foreign key FKC5B9EF1889FE8A02
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fulfillment_group' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP drop foreign key FKC5B9EF1877F565E1
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fulfillment_group' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP drop foreign key FKC5B9EF18D894CB5D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fulfillment_group' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP_FEE drop foreign key FK6AA8E1BF5028DC55
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fulfillment_group_fee' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP_ITEM drop foreign key FKEA74EBDA5028DC55
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fulfillment_group_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP_ITEM drop foreign key FKEA74EBDA9AF166DF
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fulfillment_group_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_OPTION_FIXED drop foreign key FK408360313E2FC4F9
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fulfillment_option_fixed' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_OPTION_FIXED drop foreign key FK4083603181F34C7F
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fulfillment_option_fixed' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_OPT_BANDED_PRC drop foreign key FKB1FD71E981F34C7F
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fulfillment_opt_banded_prc' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_OPT_BANDED_WGT drop foreign key FKB1FD8AEC81F34C7F
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fulfillment_opt_banded_wgt' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_PRICE_BAND drop foreign key FK46C9EA726CDF59CA
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fulfillment_price_band' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_WEIGHT_BAND drop foreign key FK6A048D95A0B429C3
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_fulfillment_weight_band' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_GIFTWRAP_ORDER_ITEM drop foreign key FKE1BE1563B76B9466
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_giftwrap_order_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_IMG_STATIC_ASSET drop foreign key FKCC4B772167F70B63
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_img_static_asset' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ITEM_OFFER_QUALIFIER drop foreign key FKD9C50C61D5F3FAF4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_item_offer_qualifier' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ITEM_OFFER_QUALIFIER drop foreign key FKD9C50C619AF166DF
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_item_offer_qualifier' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_LOCALE drop foreign key FK56C7DC203E2FC4F9
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_locale' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_OFFER_CODE drop foreign key FK76B8C8D6D5F3FAF4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_offer_code' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_OFFER_INFO_FIELDS drop foreign key FKA901886183AE7237
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_offer_info_fields' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_OFFER_RULE_MAP drop foreign key FKCA468FE2C11A218D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_offer_rule_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_OFFER_RULE_MAP drop foreign key FKCA468FE245C66D1D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_offer_rule_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER drop foreign key FK8F5B64A83E2FC4F9
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER drop foreign key FK8F5B64A87470F437
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER drop foreign key FK8F5B64A8A1E1C128
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ADJUSTMENT drop foreign key FK1E92D164D5F3FAF4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_adjustment' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ADJUSTMENT drop foreign key FK1E92D16489FE8A02
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_adjustment' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ATTRIBUTE drop foreign key FKB3A467A589FE8A02
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_attribute' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM drop foreign key FK9A2E704A15D1A13D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM drop foreign key FK9A2E704AFD2F1F10
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM drop foreign key FK9A2E704A89FE8A02
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM drop foreign key FK9A2E704AB0B0D00A
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM drop foreign key FK9A2E704A77F565E1
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM_ADD_ATTR drop foreign key FKA466AB44B76B9466
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_item_add_attr' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM_ADJUSTMENT drop foreign key FKA2658C82D5F3FAF4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_item_adjustment' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM_ADJUSTMENT drop foreign key FKA2658C829AF166DF
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_item_adjustment' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM_ATTRIBUTE drop foreign key FK9F1ED0C79AF166DF
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_item_attribute' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM_DTL_ADJ drop foreign key FK85F0248FD5F3FAF4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_item_dtl_adj' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM_DTL_ADJ drop foreign key FK85F0248FD4AEA2C0
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_item_dtl_adj' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM_PRICE_DTL drop foreign key FK1FB64BF19AF166DF
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_item_price_dtl' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_MULTISHIP_OPTION drop foreign key FKB3D3F7D6C13085DD
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_multiship_option' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_MULTISHIP_OPTION drop foreign key FKB3D3F7D681F34C7F
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_multiship_option' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_MULTISHIP_OPTION drop foreign key FKB3D3F7D689FE8A02
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_multiship_option' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_MULTISHIP_OPTION drop foreign key FKB3D3F7D69AF166DF
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_multiship_option' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_OFFER_CODE_XREF drop foreign key FKFDF0E8533BB10F6D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_offer_code_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_OFFER_CODE_XREF drop foreign key FKFDF0E85389FE8A02
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_offer_code_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_PAYMENT drop foreign key FK9517A14FC13085DD
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_payment' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_PAYMENT drop foreign key FK9517A14F89FE8A02
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_payment' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_PAYMENT_TRANSACTION drop foreign key FK86FDE7CE6A69DD9D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_payment_transaction' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_PAYMENT_TRANSACTION drop foreign key FK86FDE7CEE1B66C71
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_order_payment_transaction' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAGE drop foreign key FKF41BEDD5D49D3961
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_page' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAGE_FLD_MAP drop foreign key FKE9EE09515AEDD08A
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_page_fld_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAGE_FLD_MAP drop foreign key FKE9EE0951883C2667
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_page_fld_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAGE_RULE_MAP drop foreign key FK1ABA0CA336D91846
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_page_rule_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAGE_RULE_MAP drop foreign key FK1ABA0CA3C38455DD
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_page_rule_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAGE_TMPLT drop foreign key FK325C9D5A1E1C128
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_page_tmplt' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAYMENT_LOG drop foreign key FKA43703453E2FC4F9
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_payment_log' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAYMENT_LOG drop foreign key FKA43703457470F437
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_payment_log' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PGTMPLT_FLDGRP_XREF drop foreign key FK99D625F66A79BDB5
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_pgtmplt_fldgrp_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PGTMPLT_FLDGRP_XREF drop foreign key FK99D625F6D49D3961
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_pgtmplt_fldgrp_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT drop foreign key FK5B95B7C9DF057C3F
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT drop foreign key FK5B95B7C96D386535
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_ATTRIBUTE drop foreign key FK56CE05865F11A0B7
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product_attribute' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_BUNDLE drop foreign key FK8CC5B85F11A0B7
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product_bundle' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_CROSS_SALE drop foreign key FK8324FB3C15D1A13D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product_cross_sale' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_CROSS_SALE drop foreign key FK8324FB3C5F11A0B7
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product_cross_sale' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_CROSS_SALE drop foreign key FK8324FB3C62D84F9B
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product_cross_sale' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_FEATURED drop foreign key FK4C49FFE415D1A13D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product_featured' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_FEATURED drop foreign key FK4C49FFE45F11A0B7
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product_featured' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_OPTION_VALUE drop foreign key FK6DEEEDBD92EA8136
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product_option_value' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_OPTION_XREF drop foreign key FKDA42AB2F5F11A0B7
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product_option_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_OPTION_XREF drop foreign key FKDA42AB2F92EA8136
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product_option_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_SKU_XREF drop foreign key FKF2DBF6D35F11A0B7
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product_sku_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_SKU_XREF drop foreign key FKF2DBF6D3B78C9977
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product_sku_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_UP_SALE drop foreign key FKF69054F515D1A13D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product_up_sale' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_UP_SALE drop foreign key FKF69054F55F11A0B7
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product_up_sale' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_UP_SALE drop foreign key FKF69054F562D84F9B
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_product_up_sale' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_QUAL_CRIT_OFFER_XREF drop foreign key FKD592E919D5F3FAF4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_qual_crit_offer_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_QUAL_CRIT_OFFER_XREF drop foreign key FKD592E9193615A91A
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_qual_crit_offer_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_QUAL_CRIT_PAGE_XREF drop foreign key FK874BE590883C2667
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_qual_crit_page_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_QUAL_CRIT_PAGE_XREF drop foreign key FK874BE590378418CD
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_qual_crit_page_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_QUAL_CRIT_SC_XREF drop foreign key FKC4A353AF13D95585
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_qual_crit_sc_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_QUAL_CRIT_SC_XREF drop foreign key FKC4A353AF85C77F2B
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_qual_crit_sc_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_RATING_DETAIL drop foreign key FKC9D04AD7470F437
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_rating_detail' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_RATING_DETAIL drop foreign key FKC9D04ADD4E76BF4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_rating_detail' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_REVIEW_DETAIL drop foreign key FK9CD7E6927470F437
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_review_detail' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_REVIEW_DETAIL drop foreign key FK9CD7E69245DC39E0
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_review_detail' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_REVIEW_DETAIL drop foreign key FK9CD7E692D4E76BF4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_review_detail' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_REVIEW_FEEDBACK drop foreign key FK7CC929867470F437
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_review_feedback' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_REVIEW_FEEDBACK drop foreign key FK7CC92986AE4769D6
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_review_feedback' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SANDBOX drop foreign key FKDD37A9A174160452
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sandbox' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SANDBOX_MGMT drop foreign key FK4845009F579FE59D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sandbox_mgmt' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SC drop foreign key FK74EEB716A1E1C128
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sc' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SC drop foreign key FK74EEB71671EBFA46
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sc' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SC_FLDGRP_XREF drop foreign key FK71612AEA6A79BDB5
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sc_fldgrp_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SC_FLDGRP_XREF drop foreign key FK71612AEAF6B0BA84
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sc_fldgrp_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SC_FLD_MAP drop foreign key FKD9480192DD6FD28A
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sc_fld_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SC_FLD_MAP drop foreign key FKD948019213D95585
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sc_fld_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SC_RULE_MAP drop foreign key FK169F1C8256E51A06
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sc_rule_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SC_RULE_MAP drop foreign key FK169F1C82156E72FC
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sc_rule_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SC_TYPE drop foreign key FKE19886C3F6B0BA84
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sc_type' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SEARCH_FACET drop foreign key FK4FFCC9863C3907C4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_search_facet' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SEARCH_FACET_RANGE drop foreign key FK7EC3B124B96B1C93
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_search_facet_range' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SEARCH_FACET_XREF drop foreign key FK35A63034DA7E1C7C
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_search_facet_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SEARCH_FACET_XREF drop foreign key FK35A63034B96B1C93
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_search_facet_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SITE_CATALOG drop foreign key FK5F3F2047843A8B63
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_site_catalog' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SITE_CATALOG drop foreign key FK5F3F2047A350C7F1
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_site_catalog' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SITE_MAP_CFG drop foreign key FK7012930FC50D449
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_site_map_cfg' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SITE_MAP_GEN_CFG drop foreign key FK1D76000A340ED71
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_site_map_gen_cfg' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SITE_MAP_URL_ENTRY drop foreign key FKE2004FED36AFE1EE
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_site_map_url_entry' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU drop foreign key FK28E82CF73E2FC4F9
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU drop foreign key FK28E82CF77E555D75
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_ATTRIBUTE drop foreign key FK6C6A5934B78C9977
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku_attribute' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_BUNDLE_ITEM drop foreign key FKD55968CCF29B96
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku_bundle_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_BUNDLE_ITEM drop foreign key FKD55968B78C9977
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku_bundle_item' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_FEE drop foreign key FKEEB7181E3E2FC4F9
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku_fee' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_FEE_XREF drop foreign key FKD88D409CB78C9977
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku_fee_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_FEE_XREF drop foreign key FKD88D409CCF4C9A82
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku_fee_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_FULFILLMENT_EXCLUDED drop foreign key FK84162D7381F34C7F
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku_fulfillment_excluded' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_FULFILLMENT_EXCLUDED drop foreign key FK84162D73B78C9977
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku_fulfillment_excluded' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_FULFILLMENT_FLAT_RATES drop foreign key FKC1988C9681F34C7F
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku_fulfillment_flat_rates' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_FULFILLMENT_FLAT_RATES drop foreign key FKC1988C96B78C9977
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku_fulfillment_flat_rates' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_MEDIA_MAP drop foreign key FKEB4AECF96E4720E0
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku_media_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_MEDIA_MAP drop foreign key FKEB4AECF9D93D857F
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku_media_map' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_OPTION_VALUE_XREF drop foreign key FK7B61DC0BB0C16A73
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku_option_value_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_OPTION_VALUE_XREF drop foreign key FK7B61DC0BB78C9977
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_sku_option_value_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_STATE drop foreign key FK8F94A1EBA46E16CF
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_state' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_TAR_CRIT_OFFER_XREF drop foreign key FK125F58033615A91A
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_tar_crit_offer_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_TAR_CRIT_OFFER_XREF drop foreign key FK125F5803D5F3FAF4
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_tar_crit_offer_xref' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_TAX_DETAIL drop foreign key FKEABE4A4B3E2FC4F9
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_tax_detail' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_TAX_DETAIL drop foreign key FKEABE4A4BC50D449
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_tax_detail' doesn't exist
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_TRANS_ADDITNL_FIELDS drop foreign key FK376DDE4B9E955B1D
[artifact:mvn] [ERROR] 18:27:45 SchemaExport - Table 'broadleafdb.blc_trans_additnl_fields' doesn't exist
[artifact:mvn] [ERROR] 18:27:57 SchemaExport - HHH000231: Schema export unsuccessful
[artifact:mvn] org.hibernate.tool.hbm2ddl.ImportScriptException: Error during statement execution (file: '/sql/load_catalog_i18n_data_FR.sql'): INSERT INTO BLC_TRANSLATION (TRANSLATION_ID, ENTITY_ID, LOCALE_CODE, ENTITY_TYPE, FIELD_NAME, TRANSLATED_VALUE) VALUES (-256, 3, 'fr', 'Sku', 'longDescription', 'Tangy, venu de Cayenne poivron flux avec l''ail, l''oignon pâte de tomate, et un soup??on de sucre de canne pour en faire une sauce onctueuse avec une morsure. Magnifique sur les ??ufs, la volaille, le porc ou le poisson, cette sauce marie pour faire des marinades et des soupes riches.')
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:451)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:378)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:304)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:293)
[artifact:mvn] at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:498)
[artifact:mvn] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1742)
[artifact:mvn] at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:94)
[artifact:mvn] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:905)
[artifact:mvn] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:310)
[artifact:mvn] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
[artifact:mvn] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
[artifact:mvn] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
[artifact:mvn] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
[artifact:mvn] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
[artifact:mvn] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1117)
[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:922)
[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
[artifact:mvn] at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
[artifact:mvn] at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
[artifact:mvn] at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
[artifact:mvn] at org.broadleafcommerce.common.web.extensibility.MergeContextLoaderListener.contextInitialized(MergeContextLoaderListener.java:50)
[artifact:mvn] at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:766)
[artifact:mvn] at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:406)
[artifact:mvn] at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:758)
[artifact:mvn] at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:242)...
...
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)
[artifact:mvn] at org.codehaus.classworlds.Launcher.main(Launcher.java:46)
[artifact:mvn] Caused by: java.sql.SQLException: Incorrect string value: '\xEF\xBF\xBD\xEF\xBF\xBD...' for column 'TRANSLATED_VALUE' at row 1
[artifact:mvn] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094)
[artifact:mvn] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4208)
[artifact:mvn] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4140)
[artifact:mvn] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2597)
[artifact:mvn] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2758)
[artifact:mvn] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2820)
...
[artifact:mvn] ... 69 more
[artifact:mvn] [ WARN] 18:28:04 SolrResourceLoader - Can't find (or read) directory to add to classloader: lib (resolved as: /var/folders/fv/390t4lhd72v27ps7x0hw38000000gn/T/anikanchan/solrhome/lib).
[artifact:mvn] 2014-09-14 18:28:08.180:INFO:oejsh.ContextHandler:started o.m.j.p.JettyWebAppContext{/,file:/Users/anikanchan/git/DemoSite/site/target/mycompany/},file:/Users/anikanchan/git/DemoSite/site/target/mycompany/
[artifact:mvn] 2014-09-14 18:28:08.255:INFO:/:Initializing Spring FrameworkServlet 'mycompany'
[artifact:mvn] 2014-09-14 18:28:10.859:INFO:oejs.AbstractConnector:Started SelectChannelConnector@0.0.0.0:8080
[artifact:mvn] 2014-09-14 18:28:10.945:INFO:oejus.SslContextFactory:Enabled Protocols [SSLv2Hello, SSLv3, TLSv1, TLSv1.1, TLSv1.2] of [SSLv2Hello, SSLv3, TLSv1, TLSv1.1, TLSv1.2]
[artifact:mvn] 2014-09-14 18:28:10.947:INFO:oejs.AbstractConnector:Started SslSelectChannelConnector@0.0.0.0:8443
[artifact:mvn] [INFO] Started Jetty Server

Re: SQL errors after migrating to MySQL

Posted: Fri Apr 03, 2015 11:55 am
by Swamy K
I am aldo facing the same issue.Please let me know if u have resolved the issue.

Re: SQL errors after migrating to MySQL

Posted: Fri Apr 03, 2015 1:49 pm
by phillipuniverse
Make sure that the database you created is UTF-8. This is the snippet that you need to activate that in /etc/my.cnf:

Code: Select all

[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci


More than likely, the database that you created got created with the latin1 charset. You will likely need to delete the schema that you created, shut down the server, make the modifications above to the [mysqld] section, start mysql back up, then recreate the database. From then on out you will have UTF-8 as the default charset for all of your newly-created schemas.