Broadleaf 3.0 - MySQL migration issues. Need urgent help

Forum for questions and issues related to 3.0 migration.

Those wishing to upgrade should start by looking at the migration documents published on the Broadleaf Commerce documentation site.

Moderator: jocanas

neethu_27
Newbie
Newbie
Posts: 7
Joined: Wed Aug 14, 2013 6:29 am

Broadleaf 3.0 - MySQL migration issues. Need urgent help

Postby neethu_27 » Tue Sep 03, 2013 6:38 am

I 'm having issues while trying to switch from HSQL to MYSQL database in broadleaf 3.0.

I followed the steps mentioned in http://docs.broadleafcommerce.org/core/ ... l-tutorial . I created a database called 'broadleaf' and got the following errors while building site :


[artifact:mvn] [ERROR] 15:33:12 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'longvarchar, VALUE varchar(255), SC_ID bigint, primary key (SC_FLD_ID))' at line 1
[artifact:mvn] [ERROR] 15:33:13 SchemaExport - HHH000389: Unsuccessful: create table BLC_SC_ITEM_CRITERIA (SC_ITEM_CRITERIA_ID bigint not null, ORDER_ITEM_MATCH_RULE longvarchar, QUANTITY integer not null, primary key (SC_ITEM_CRITERIA_ID))
[artifact:mvn] [ERROR] 15:33:13 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'longvarchar, QUANTITY integer not null, primary key (SC_ITEM_CRITERIA_ID))' at line 1
[artifact:mvn] [ERROR] 15:33:13 SchemaExport - HHH000389: Unsuccessful: create table BLC_SC_RULE (SC_RULE_ID bigint not null, MATCH_RULE longvarchar, primary key (SC_RULE_ID))
[artifact:mvn] [ERROR] 15:33:13 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'longvarchar, primary key (SC_RULE_ID))' at line 1
[artifact:mvn] [ERROR] 15:33:14 SchemaExport - HHH000389: Unsuccessful: create table BLC_SKU (SKU_ID bigint not null, ACTIVE_END_DATE timestamp, ACTIVE_START_DATE timestamp, AVAILABLE_FLAG char(255), DESCRIPTION varchar(255), CONTAINER_SHAPE varchar(255), DEPTH numeric, DIMENSION_UNIT_OF_MEASURE varchar(255), GIRTH numeric, HEIGHT numeric, CONTAINER_SIZE varchar(255), WIDTH numeric, DISCOUNTABLE_FLAG char(255), FULFILLMENT_TYPE varchar(255), INVENTORY_TYPE varchar(255), IS_MACHINE_SORTABLE boolean, LONG_DESCRIPTION longvarchar, NAME varchar(255), RETAIL_PRICE numeric, SALE_PRICE numeric, TAX_CODE varchar(255), TAXABLE_FLAG char(255), WEIGHT numeric, WEIGHT_UNIT_OF_MEASURE varchar(255), CURRENCY_CODE varchar(255), DEFAULT_PRODUCT_ID bigint, primary key (SKU_ID))
[artifact:mvn] [ERROR] 15:33:14 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'longvarchar, NAME varchar(255), RETAIL_PRICE numeric, SALE_PRICE numeric, TAX_CO' at line 1
[artifact:mvn] [ERROR] 15:33:14 SchemaExport - HHH000389: Unsuccessful: create table BLC_SKU_FEE (SKU_FEE_ID bigint not null, AMOUNT numeric not null, DESCRIPTION varchar(255), EXPRESSION longvarchar, FEE_TYPE varchar(255), NAME varchar(255), TAXABLE boolean, CURRENCY_CODE varchar(255), primary key (SKU_FEE_ID))
[artifact:mvn] [ERROR] 15:33:14 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'longvarchar, FEE_TYPE varchar(255), NAME varchar(255), TAXABLE boolean, CURRENCY' at line 1
[artifact:mvn] [ERROR] 15:33:15 SchemaExport - HHH000389: Unsuccessful: create table BLC_TRANSLATION (TRANSLATION_ID bigint not null, ENTITY_ID varchar(255), ENTITY_TYPE varchar(255), FIELD_NAME varchar(255), LOCALE_CODE varchar(255), TRANSLATED_VALUE longvarchar, primary key (TRANSLATION_ID))
[artifact:mvn] [ERROR] 15:33:15 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'longvarchar, primary key (TRANSLATION_ID))' at line 1
[artifact:mvn] [ERROR] 15:33:20 SchemaExport - HHH000389: Unsuccessful: create index CATEGORY_PARENT_INDEX on BLC_CATEGORY (DEFAULT_PARENT_CATEGORY_ID)
[artifact:mvn] [ERROR] 15:33:20 SchemaExport - Table 'broadleaf.blc_category' doesn't exist
[artifact:mvn] [ERROR] 15:33:20 SchemaExport - HHH000389: Unsuccessful: create index CATEGORY_NAME_INDEX on BLC_CATEGORY (NAME)
[artifact:mvn] [ERROR] 15:33:20 SchemaExport - Table 'broadleaf.blc_category' doesn't exist
[artifact:mvn] [ERROR] 15:33:20 SchemaExport - HHH000389: Unsuccessful: create index CATEGORY_URL_INDEX on BLC_CATEGORY (URL)
[artifact:mvn] [ERROR] 15:33:20 SchemaExport - Table 'broadleaf.blc_category' doesn't exist
[artifact:mvn] [ERROR] 15:33:20 SchemaExport - HHH000389: Unsuccessful: create index CATEGORY_URLKEY_INDEX on BLC_CATEGORY (URL_KEY)
[artifact:mvn] [ERROR] 15:33:20 SchemaExport - Table 'broadleaf.blc_category' doesn't exist
[artifact:mvn] [ERROR] 15:33:20 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY add constraint FK55F82D44B177E6 foreign key (DEFAULT_PARENT_CATEGORY_ID) references BLC_CATEGORY
[artifact:mvn] [ERROR] 15:33:20 SchemaExport - Table 'broadleaf.blc_category' doesn't exist
[artifact:mvn] [ERROR] 15:33:31 SchemaExport - HHH000389: Unsuccessful: create index OFFER_DISCOUNT_INDEX on BLC_OFFER (OFFER_DISCOUNT_TYPE)
[artifact:mvn] [ERROR] 15:33:31 SchemaExport - Table 'broadleaf.blc_offer' doesn't exist
[artifact:mvn] [ERROR] 15:33:31 SchemaExport - HHH000389: Unsuccessful: create index OFFER_MARKETING_MESSAGE_INDEX on BLC_OFFER (MARKETING_MESSASGE)
[artifact:mvn] [ERROR] 15:33:31 SchemaExport - Table 'broadleaf.blc_offer' doesn't exist
[artifact:mvn] [ERROR] 15:33:31 SchemaExport - HHH000389: Unsuccessful: create index OFFER_NAME_INDEX on BLC_OFFER (OFFER_NAME)
[artifact:mvn] [ERROR] 15:33:31 SchemaExport - Table 'broadleaf.blc_offer' doesn't exist
[artifact:mvn] [ERROR] 15:33:31 SchemaExport - HHH000389: Unsuccessful: create index OFFER_TYPE_INDEX on BLC_OFFER (OFFER_TYPE)
[artifact:mvn] [ERROR] 15:33:31 SchemaExport - Table 'broadleaf.blc_offer' doesn't exist
[artifact:mvn] [ERROR] 15:33:37 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAGE_FLD add constraint FK86433AD4883C2667 foreign key (PAGE_ID) references BLC_PAGE
[artifact:mvn] [ERROR] 15:33:37 SchemaExport - Table 'broadleaf.blc_page_fld' doesn't exist
[artifact:mvn] [ERROR] 15:33:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SC_FLD add constraint FK621D7B9513D95585 foreign key (SC_ID) references BLC_SC
[artifact:mvn] [ERROR] 15:33:45 SchemaExport - Table 'broadleaf.blc_sc_fld' doesn't exist
[artifact:mvn] [ERROR] 15:33:47 SchemaExport - HHH000389: Unsuccessful: create index SKU_ACTIVE_INDEX on BLC_SKU (ACTIVE_END_DATE)
[artifact:mvn] [ERROR] 15:33:47 SchemaExport - Table 'broadleaf.blc_sku' doesn't exist
[artifact:mvn] [ERROR] 15:33:47 SchemaExport - HHH000389: Unsuccessful: create index SKU_AVAILABLE_INDEX on BLC_SKU (AVAILABLE_FLAG)
[artifact:mvn] [ERROR] 15:33:47 SchemaExport - Table 'broadleaf.blc_sku' doesn't exist
[artifact:mvn] [ERROR] 15:33:47 SchemaExport - HHH000389: Unsuccessful: create index SKU_DISCOUNTABLE_INDEX on BLC_SKU (DISCOUNTABLE_FLAG)
[artifact:mvn] [ERROR] 15:33:47 SchemaExport - Table 'broadleaf.blc_sku' doesn't exist
[artifact:mvn] [ERROR] 15:33:47 SchemaExport - HHH000389: Unsuccessful: create index SKU_NAME_INDEX on BLC_SKU (NAME)
[artifact:mvn] [ERROR] 15:33:47 SchemaExport - Table 'broadleaf.blc_sku' doesn't exist
[artifact:mvn] [ERROR] 15:33:47 SchemaExport - HHH000389: Unsuccessful: create index SKU_TAXABLE_INDEX on BLC_SKU (TAXABLE_FLAG)
[artifact:mvn] [ERROR] 15:33:47 SchemaExport - Table 'broadleaf.blc_sku' doesn't exist
[artifact:mvn] [ERROR] 15:33:47 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU add constraint FK28E82CF73E2FC4F9 foreign key (CURRENCY_CODE) references BLC_CURRENCY
[artifact:mvn] [ERROR] 15:33:47 SchemaExport - Table 'broadleaf.blc_sku' doesn't exist
[artifact:mvn] [ERROR] 15:33:47 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU add constraint FK28E82CF77E555D75 foreign key (DEFAULT_PRODUCT_ID) references BLC_PRODUCT
[artifact:mvn] [ERROR] 15:33:47 SchemaExport - Table 'broadleaf.blc_sku' doesn't exist
[artifact:mvn] [ERROR] 15:33:48 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_FEE add constraint FKEEB7181E3E2FC4F9 foreign key (CURRENCY_CODE) references BLC_CURRENCY
[artifact:mvn] [ERROR] 15:33:48 SchemaExport - Table 'broadleaf.blc_sku_fee' doesn't exist
[artifact:mvn] [ERROR] 15:33:50 SchemaExport - HHH000389: Unsuccessful: create index ENTITY_TYPE_INDEX on BLC_TRANSLATION (ENTITY_TYPE)
[artifact:mvn] [ERROR] 15:33:50 SchemaExport - Table 'broadleaf.blc_translation' doesn't exist
[artifact:mvn] [ERROR] 15:33:52 SchemaExport - HHH000231: Schema export unsuccessful
[artifact:mvn] org.hibernate.tool.hbm2ddl.ImportScriptException: Error during statement execution (file: '/sql/load_catalog_data.sql'): INSERT INTO BLC_CATEGORY (CATEGORY_ID,DESCRIPTION,NAME,URL,DEFAULT_PARENT_CATEGORY_ID,ACTIVE_START_DATE) VALUES (1,'Root','Root',NULL,NULL,CURRENT_TIMESTAMP)



I could also see that 160 tables have been created on broadleaf database.
Please help . Urgent

ig0r
Newbie
Newbie
Posts: 10
Joined: Wed Mar 27, 2013 3:57 am

Re: Broadleaf 3.0 - MySQL migration issues. Need urgent help

Postby ig0r » Mon Sep 09, 2013 8:33 am

had the same issue, as far as i remember putting these 3 lines also in my xy-shared.properties solved it. i think the settings in common-shared.properties are not being picked up or are overwritten somewhere.

blPU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
blSecurePU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
blCMSStorage.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

i.

sourav
Newbie
Newbie
Posts: 3
Joined: Wed Dec 25, 2013 11:54 pm

Re: Broadleaf 3.0 - MySQL migration issues. Need urgent help

Postby sourav » Thu Dec 26, 2013 4:25 am

I added

blPU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
blSecurePU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
blCMSStorage.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

in

1) staging-shared.properties
2) production-shared.properties
3) integrationqa-shared.properties
4) integrationdev-shared.properties
5) development-shared.properties

Not sure what I am doing wrong.

I even tried as per below URL
http://forum.broadleafcommerce.org/viewtopic.php?f=11&t=2165

Still I am getting same issue.. not sure what I missed... :roll:

panopset
Newbie
Newbie
Posts: 8
Joined: Fri Nov 22, 2013 1:59 pm
Contact:

Re: Broadleaf 3.0 - MySQL migration issues. Need urgent help

Postby panopset » Sat Feb 08, 2014 1:54 pm

This is how I was able to get DemoSite 3.0.8-GA going on MySql using a Linux Mint Ubuntu system.

As was already mentioned in this forum above, replace all org.hibernate.dialect.HSQLDialect with org.hibernate.dialect.MySQL5InnoDBDialect in /DemoSite/core/src/main/resources/runtime-properties/common-shared.properties (and everywhere else you may find it).

My development.shared.properties specifies create-drop for blPU:

Code: Select all

blPU.hibernate.hbm2ddl.auto=create-drop
blCMSStorage.hibernate.hbm2ddl.auto=update
blSecurePU.hibernate.hbm2ddl.auto=update


My integrationdev-shared.properties specifies all update, so admin changes are preserved:

Code: Select all

blPU.hibernate.hbm2ddl.auto=update
blCMSStorage.hibernate.hbm2ddl.auto=update
blSecurePU.hibernate.hbm2ddl.auto=update


(Don't use hbm2ddl.auto=validate for now: https://github.com/BroadleafCommerce/BroadleafCommerce/issues/189)

That way you don't have to recompile to switch "environments", just update /usr/share/tomcat7/bin/setenv.sh, here is mine.

Code: Select all

JAVA_HOME="<PATH TO JDK>"
JAVA_OPTS="${JAVA_OPTS} -Djava.awt.headless=true -XX:+UseConcMarkSweepGC"
JAVA_OPTS="${JAVA_OPTS} -Xms1024m -Xmx2048m -XX:PermSize=256m -XX:MaxPermSize=512m"

#This won’t be required after we go to 3.1
JAVA_OPTS="${JAVA_OPTS} -javaagent:/<PATHTO>/spring-instrument-3.2.2.RELEASE.jar"

#This is for jconsole, if we enable jmxremote in production we’ll have to lock down security more than this:
CATALINA_OPTS="${CATALINA_OPTS} -Dcom.sun.management.jmxremote"
CATALINA_OPTS="${CATALINA_OPTS} -Dcom.sun.management.jmxremote.port=9902"
CATALINA_OPTS="${CATALINA_OPTS} -Dcom.sun.management.jmxremote.ssl=false"
CATALINA_OPTS="${CATALINA_OPTS} -Dcom.sun.management.jmxremote.authenticate=false"

#Determine environment here:
JAVA_OPTS="${JAVA_OPTS} -Druntime.environment=development"


(unrelated to this discussion, but why we need instrumentation specified here: http://docs.broadleafcommerce.org/core/current/release-notes/3.0.6-ga)

Update /etc/mysql/my.cnf, we need a reasonable number of connections with a big enough table cache:

Code: Select all

max_connections = 1024
table_cache = 4096


Tomcat needs to have the mysql-connector-java.jar, that is shipped with mysql-server, in its classpath:

Code: Select all

cd /usr/share/tomcat7/lib
sudo ln -s /usr/share/java/mysql-connector-java.jar


Edit /etc/tomcat7/context.xml and define the jdbc resources DemoSite needs (defined in the site and admin META-INF/context.xml files):

Code: Select all


<Resource name="jdbc/web"
          auth="Container"
          type="javax.sql.DataSource"
          factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
          testWhileIdle="true"
          testOnBorrow="true"
          testOnReturn="false"
          validationQuery="SELECT 1"
          validationInterval="30000"
          timeBetweenEvictionRunsMillis="30000"
          maxActive="100"
          minIdle="10"
          maxWait="10000"
          initialSize="10"
          removeAbandonedTimeout="60"
          removeAbandoned="true"
          logAbandoned="true"
          minEvictableIdleTimeMillis="30000"
          jmxEnabled="true"
          jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;
            org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
          username="root"
          password="*"
          driverClassName="com.mysql.jdbc.Driver"
          url="jdbc:mysql://localhost:3306/bl_web"/>

<Resource name="jdbc/secure"
          auth="Container"
          type="javax.sql.DataSource"
          factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
          testWhileIdle="true"
          testOnBorrow="true"
          testOnReturn="false"
          validationQuery="SELECT 1"
          validationInterval="30000"
          timeBetweenEvictionRunsMillis="30000"
          maxActive="100"
          minIdle="10"
          maxWait="10000"
          initialSize="10"
          removeAbandonedTimeout="60"
          removeAbandoned="true"
          logAbandoned="true"
          minEvictableIdleTimeMillis="30000"
          jmxEnabled="true"
          jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;
            org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
          username="root"
          password="*"
          driverClassName="com.mysql.jdbc.Driver"
          url="jdbc:mysql://localhost:3306/bl_secure"/>

<Resource name="jdbc/storage"
          auth="Container"
          type="javax.sql.DataSource"
          factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
          testWhileIdle="true"
          testOnBorrow="true"
          testOnReturn="false"
          validationQuery="SELECT 1"
          validationInterval="30000"
          timeBetweenEvictionRunsMillis="30000"
          maxActive="100"
          minIdle="10"
          maxWait="10000"
          initialSize="10"
          removeAbandonedTimeout="60"
          removeAbandoned="true"
          logAbandoned="true"
          minEvictableIdleTimeMillis="30000"
          jmxEnabled="true"
          jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;
            org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
          username="root"
          password="*"
          driverClassName="com.mysql.jdbc.Driver"
          url="jdbc:mysql://localhost:3306/bl_storage"/>



In the DemoSite parent, admin, and site projects pom.xml files, you will have to replace hsqldb dependencies with mysql:

Code: Select all

Replace:
 <groupId>org.hsqldb</groupId>
 <artifactId>hsqldb</artifactId>
With:
 <groupId>mysql</groupId>
 <artifactId>mysql-connector-java</artifactId>


And make sure the versions are right of course.

To reset everything, create a sql script like this:

Code: Select all

drop database bl_web;
drop database bl_secure;
drop database bl_storage;
create database bl_web;
create database bl_secure;
create database bl_storage;


To execute it:

Code: Select all

mysql -u root -p* < reset.sql


While working through all these issues, I found it useful to have this script in my DemoSite project:

Code: Select all

mvn clean install
DEPLOY_STORE=ROOT
WEBAPPS=/var/lib/tomcat7/webapps
sudo service tomcat7 stop
sudo rm -rf ${WEBAPPS}/admin
sudo rm -rf ${WEBAPPS}/admin.war
sudo rm -rf ${WEBAPPS}/${DEPLOY_STORE}
sudo rm -rf ${WEBAPPS}/${DEPLOY_STORE}.war
sudo cp site/target/<WAR_NAME>.war ${WEBAPPS}/${DEPLOY_STORE}.war
sudo cp admin/target/admin.war ${WEBAPPS}/
sudo rm /var/log/tomcat7/*
sudo service tomcat7 start
kate /var/log/tomcat7/catalina.out

gsugiart
Newbie
Newbie
Posts: 1
Joined: Sun May 04, 2014 5:11 am

Re: Broadleaf 3.0 - MySQL migration issues. Need urgent help

Postby gsugiart » Sun May 04, 2014 5:19 am

Thanks for your help panopset. I ditch running jetty-demo all together because it just failed during database tables creation. I used Tomcat 7 now.

Also in addition to your info I also has to do these additional things:
1. Copy tomcat-jdbc-7.0.30.jar to tomcat/lib dir. Without doing this it will complain ClassNotFoundException for "org.apache.tomcat.jdbc.pool.DataSourceFactory".
2. Also I have to remove site/src/main/webapp/META-INF/context.xml & in admin/src/main/webapp/context.xml

After this I am able to run the ecommerce site

subhan
Newbie
Newbie
Posts: 8
Joined: Tue Apr 07, 2015 5:03 am

Re: Broadleaf 3.0 - MySQL migration issues. Need urgent help

Postby subhan » Thu Apr 23, 2015 5:34 am

I am using 3.1.13-GAversion of broadleaf.
After following instruction at http://docs.broadleafcommerce.org/current/Switch-To-MySQL-Tutorial.html,
In DB 179 tables created.. but I am getting these errors:-
..........
[artifact:mvn] [SUPPORT] 15:51:36 DirectCopyClassTransformer - Basic Inventory Management - END - Transform - Copying into [org.broadleafcommerce.core.catalog.domain.SkuImpl] from [org.broadleafcommerce.core.catalog.domain.QuantityAvailableSkuTemplate]
[artifact:mvn] [ WARN] 15:51:41 AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [blSandBoxElements]; using defaults.
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDITIONAL_OFFER_INFO drop foreign key FK3BFDBD63B5D9C34D
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - Error on rename of './broadleaf/BLC_ADDITIONAL_OFFER_INFO' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDITIONAL_OFFER_INFO drop foreign key FK3BFDBD63D5F3FAF4
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - Error on rename of './broadleaf/BLC_ADDITIONAL_OFFER_INFO' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDITIONAL_OFFER_INFO drop foreign key FK3BFDBD631891FF79
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - Error on rename of './broadleaf/BLC_ADDITIONAL_OFFER_INFO' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CEA46E16CF
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - Error on rename of './broadleaf/BLC_ADDRESS' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CEF1A6533F
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - Error on rename of './broadleaf/BLC_ADDRESS' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CEBF4449BA
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - Error on rename of './broadleaf/BLC_ADDRESS' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CEE12DC0C8
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - Error on rename of './broadleaf/BLC_ADDRESS' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CE337C4D50
[artifact:mvn] [ERROR] 15:51:43 SchemaExport - Error on rename of './broadleaf/BLC_ADDRESS' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_PERMISSION_ENTITY drop foreign key FK23C09E3DE88B7D38
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_PERMISSION_ENTITY' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_PERMISSION_XREF drop foreign key FKBCAD1F5E88B7D38
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_PERMISSION_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_PERMISSION_XREF drop foreign key FKBCAD1F575A3C445
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_PERMISSION_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_ROLE_PERMISSION_XREF drop foreign key FK4A819D98E88B7D38
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_ROLE_PERMISSION_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_ROLE_PERMISSION_XREF drop foreign key FK4A819D985F43AAD8
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_ROLE_PERMISSION_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_SECTION drop foreign key FK7EA7D92FB1A18498
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_SECTION' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_SEC_PERM_XREF drop foreign key FK5E832966E88B7D38
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_SEC_PERM_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_SEC_PERM_XREF drop foreign key FK5E8329663AF7F0FC
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_SEC_PERM_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_ADDTL_FIELDS drop foreign key FK73274CDD46EBC38
[artifact:mvn] [ERROR] 15:51:44 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_USER_ADDTL_FIELDS' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_PERMISSION_XREF drop foreign key FKF0B3BEEDE88B7D38
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_USER_PERMISSION_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_PERMISSION_XREF drop foreign key FKF0B3BEED46EBC38
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_USER_PERMISSION_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_ROLE_XREF drop foreign key FKFFD33A265F43AAD8
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_USER_ROLE_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_ROLE_XREF drop foreign key FKFFD33A2646EBC38
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_USER_ROLE_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_SANDBOX drop foreign key FKD0A97E09579FE59D
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_USER_SANDBOX' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_SANDBOX drop foreign key FKD0A97E0946EBC38
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_USER_SANDBOX' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ASSET_DESC_MAP drop foreign key FKE886BAE3E2BA0C9D
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - Error on rename of './broadleaf/BLC_ASSET_DESC_MAP' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ASSET_DESC_MAP drop foreign key FKE886BAE367F70B63
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - Error on rename of './broadleaf/BLC_ASSET_DESC_MAP' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_BUNDLE_ORDER_ITEM drop foreign key FK489703DBCCF29B96
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - Error on rename of './broadleaf/BLC_BUNDLE_ORDER_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_BUNDLE_ORDER_ITEM drop foreign key FK489703DBB78C9977
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - Error on rename of './broadleaf/BLC_BUNDLE_ORDER_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_BUNDLE_ORDER_ITEM drop foreign key FK489703DB9AF166DF
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - Error on rename of './broadleaf/BLC_BUNDLE_ORDER_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - HHH000389: Unsuccessful: alter table BLC_BUND_ITEM_FEE_PRICE drop foreign key FK14267A943FC68307
[artifact:mvn] [ERROR] 15:51:45 SchemaExport - Error on rename of './broadleaf/BLC_BUND_ITEM_FEE_PRICE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_FG_OFFER drop foreign key FKCE785605028DC55
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - Error on rename of './broadleaf/BLC_CANDIDATE_FG_OFFER' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_FG_OFFER drop foreign key FKCE78560D5F3FAF4
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - Error on rename of './broadleaf/BLC_CANDIDATE_FG_OFFER' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_ITEM_OFFER drop foreign key FK9EEE9B2D5F3FAF4
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - Error on rename of './broadleaf/BLC_CANDIDATE_ITEM_OFFER' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_ITEM_OFFER drop foreign key FK9EEE9B29AF166DF
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - Error on rename of './broadleaf/BLC_CANDIDATE_ITEM_OFFER' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_ORDER_OFFER drop foreign key FK61852289D5F3FAF4
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - Error on rename of './broadleaf/BLC_CANDIDATE_ORDER_OFFER' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_ORDER_OFFER drop foreign key FK6185228989FE8A02
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - Error on rename of './broadleaf/BLC_CANDIDATE_ORDER_OFFER' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY drop foreign key FK55F82D44B177E6
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_ATTRIBUTE drop foreign key FK4E441D4115D1A13D
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_ATTRIBUTE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_IMAGE drop foreign key FK27CF3E8015D1A13D
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_IMAGE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_MEDIA_MAP drop foreign key FKCD24B1066E4720E0
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_MEDIA_MAP' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_MEDIA_MAP drop foreign key FKCD24B106D786CEA2
[artifact:mvn] [ERROR] 15:51:46 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_MEDIA_MAP' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_PRODUCT_XREF drop foreign key FK635EB1A615D1A13D
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_PRODUCT_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_PRODUCT_XREF drop foreign key FK635EB1A65F11A0B7
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_PRODUCT_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_XREF drop foreign key FKE889733615D1A13D
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_XREF drop foreign key FKE8897336D6D45DBE
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SEARCH_FACET_EXCL_XREF drop foreign key FK8361EF4E15D1A13D
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - Error on rename of './broadleaf/BLC_CAT_SEARCH_FACET_EXCL_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SEARCH_FACET_EXCL_XREF drop foreign key FK8361EF4EB96B1C93
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - Error on rename of './broadleaf/BLC_CAT_SEARCH_FACET_EXCL_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SEARCH_FACET_XREF drop foreign key FK32210EEB15D1A13D
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - Error on rename of './broadleaf/BLC_CAT_SEARCH_FACET_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SEARCH_FACET_XREF drop foreign key FK32210EEBB96B1C93
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - Error on rename of './broadleaf/BLC_CAT_SEARCH_FACET_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SITE_MAP_GEN_CFG drop foreign key FK1BA4E695C5F3D60
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - Error on rename of './broadleaf/BLC_CAT_SITE_MAP_GEN_CFG' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SITE_MAP_GEN_CFG drop foreign key FK1BA4E69BCAB9F56
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - Error on rename of './broadleaf/BLC_CAT_SITE_MAP_GEN_CFG' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER drop foreign key FK7716F0241422B204
[artifact:mvn] [ERROR] 15:51:47 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER drop foreign key FK7716F024A1E1C128
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_ADDRESS drop foreign key FK75B95AB9C13085DD
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_ADDRESS' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_ADDRESS drop foreign key FK75B95AB97470F437
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_ADDRESS' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_ATTRIBUTE drop foreign key FKB974C8217470F437
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_ATTRIBUTE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_OFFER_XREF drop foreign key FK685E80397470F437
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_OFFER_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_OFFER_XREF drop foreign key FK685E8039D5F3FAF4
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_OFFER_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_PAYMENT drop foreign key FK8B3DF0CBC13085DD
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_PAYMENT' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_PAYMENT drop foreign key FK8B3DF0CB7470F437
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_PAYMENT' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_PAYMENT_FIELDS drop foreign key FK5CCB14ADCA0B98E0
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_PAYMENT_FIELDS' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_PHONE drop foreign key FK3D28ED737470F437
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_PHONE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_PHONE drop foreign key FK3D28ED73D894CB5D
[artifact:mvn] [ERROR] 15:51:48 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_PHONE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_ROLE drop foreign key FK548EB7B17470F437
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_ROLE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_ROLE drop foreign key FK548EB7B1B8587B7
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_ROLE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUST_SITE_MAP_GEN_CFG drop foreign key FK67C0DBA0BCAB9F56
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - Error on rename of './broadleaf/BLC_CUST_SITE_MAP_GEN_CFG' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DATA_DRVN_ENUM_VAL drop foreign key FKB2D5700DA60E0554
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - Error on rename of './broadleaf/BLC_DATA_DRVN_ENUM_VAL' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISCRETE_ORDER_ITEM drop foreign key FKBC3A8A845CDFCA80
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - Error on rename of './broadleaf/BLC_DISCRETE_ORDER_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISCRETE_ORDER_ITEM drop foreign key FKBC3A8A845F11A0B7
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - Error on rename of './broadleaf/BLC_DISCRETE_ORDER_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISCRETE_ORDER_ITEM drop foreign key FKBC3A8A84B78C9977
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - Error on rename of './broadleaf/BLC_DISCRETE_ORDER_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISCRETE_ORDER_ITEM drop foreign key FKBC3A8A841285903B
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - Error on rename of './broadleaf/BLC_DISCRETE_ORDER_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISCRETE_ORDER_ITEM drop foreign key FKBC3A8A849AF166DF
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - Error on rename of './broadleaf/BLC_DISCRETE_ORDER_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISC_ITEM_FEE_PRICE drop foreign key FK2A641CC8B76B9466
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - Error on rename of './broadleaf/BLC_DISC_ITEM_FEE_PRICE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DYN_DISCRETE_ORDER_ITEM drop foreign key FK209DEE9EB76B9466
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - Error on rename of './broadleaf/BLC_DYN_DISCRETE_ORDER_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - HHH000389: Unsuccessful: alter table BLC_EMAIL_TRACKING_CLICKS drop foreign key FKFDF9F52AFA1E5D61
[artifact:mvn] [ERROR] 15:51:49 SchemaExport - Error on rename of './broadleaf/BLC_EMAIL_TRACKING_CLICKS' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_EMAIL_TRACKING_OPENS drop foreign key FKA5C3722AFA1E5D61
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - Error on rename of './broadleaf/BLC_EMAIL_TRACKING_OPENS' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_ADJUSTMENT drop foreign key FK468C8F255028DC55
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - Error on rename of './broadleaf/BLC_FG_ADJUSTMENT' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_ADJUSTMENT drop foreign key FK468C8F25D5F3FAF4
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - Error on rename of './broadleaf/BLC_FG_ADJUSTMENT' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_FEE_TAX_XREF drop foreign key FK25426DC071448C19
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - Error on rename of './broadleaf/BLC_FG_FEE_TAX_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_FEE_TAX_XREF drop foreign key FK25426DC0598F6D02
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - Error on rename of './broadleaf/BLC_FG_FEE_TAX_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_FG_TAX_XREF drop foreign key FK61BEA45571448C19
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - Error on rename of './broadleaf/BLC_FG_FG_TAX_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_FG_TAX_XREF drop foreign key FK61BEA4555028DC55
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - Error on rename of './broadleaf/BLC_FG_FG_TAX_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_ITEM_TAX_XREF drop foreign key FKDD3E844371448C19
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - Error on rename of './broadleaf/BLC_FG_ITEM_TAX_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_ITEM_TAX_XREF drop foreign key FKDD3E8443E3BBB4D2
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - Error on rename of './broadleaf/BLC_FG_ITEM_TAX_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FIELD_SEARCH_TYPES drop foreign key FKF52D130D3C3907C4
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - Error on rename of './broadleaf/BLC_FIELD_SEARCH_TYPES' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FLD_DEF drop foreign key FK3FCB575E38D08AB5
[artifact:mvn] [ERROR] 15:51:50 SchemaExport - Error on rename of './broadleaf/BLC_FLD_DEF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FLD_DEF drop foreign key FK3FCB575E6A79BDB5
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - Error on rename of './broadleaf/BLC_FLD_DEF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FLD_ENUM_ITEM drop foreign key FK83A6A84AFD2EA299
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - Error on rename of './broadleaf/BLC_FLD_ENUM_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP drop foreign key FKC5B9EF18C13085DD
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_GROUP' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP drop foreign key FKC5B9EF1881F34C7F
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_GROUP' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP drop foreign key FKC5B9EF1889FE8A02
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_GROUP' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP drop foreign key FKC5B9EF1877F565E1
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_GROUP' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP drop foreign key FKC5B9EF18D894CB5D
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_GROUP' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP_FEE drop foreign key FK6AA8E1BF5028DC55
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_GROUP_FEE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP_ITEM drop foreign key FKEA74EBDA5028DC55
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_GROUP_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP_ITEM drop foreign key FKEA74EBDA9AF166DF
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_GROUP_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_OPTION_FIXED drop foreign key FK408360313E2FC4F9
[artifact:mvn] [ERROR] 15:51:51 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_OPTION_FIXED' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_OPTION_FIXED drop foreign key FK4083603181F34C7F
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_OPTION_FIXED' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_OPT_BANDED_PRC drop foreign key FKB1FD71E981F34C7F
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_OPT_BANDED_PRC' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_OPT_BANDED_WGT drop foreign key FKB1FD8AEC81F34C7F
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_OPT_BANDED_WGT' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_PRICE_BAND drop foreign key FK46C9EA726CDF59CA
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_PRICE_BAND' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_WEIGHT_BAND drop foreign key FK6A048D95A0B429C3
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_WEIGHT_BAND' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_GIFTWRAP_ORDER_ITEM drop foreign key FKE1BE1563B76B9466
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - Error on rename of './broadleaf/BLC_GIFTWRAP_ORDER_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_IMG_STATIC_ASSET drop foreign key FKCC4B772167F70B63
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - Error on rename of './broadleaf/BLC_IMG_STATIC_ASSET' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ITEM_OFFER_QUALIFIER drop foreign key FKD9C50C61D5F3FAF4
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - Error on rename of './broadleaf/BLC_ITEM_OFFER_QUALIFIER' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ITEM_OFFER_QUALIFIER drop foreign key FKD9C50C619AF166DF
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - Error on rename of './broadleaf/BLC_ITEM_OFFER_QUALIFIER' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_LOCALE drop foreign key FK56C7DC203E2FC4F9
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - Error on rename of './broadleaf/BLC_LOCALE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_OFFER_CODE drop foreign key FK76B8C8D6D5F3FAF4
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - Error on rename of './broadleaf/BLC_OFFER_CODE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_OFFER_INFO_FIELDS drop foreign key FKA901886183AE7237
[artifact:mvn] [ERROR] 15:51:52 SchemaExport - Error on rename of './broadleaf/BLC_OFFER_INFO_FIELDS' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:53 SchemaExport - HHH000389: Unsuccessful: alter table BLC_OFFER_RULE_MAP drop foreign key FKCA468FE2C11A218D
[artifact:mvn] [ERROR] 15:51:53 SchemaExport - Error on rename of './broadleaf/BLC_OFFER_RULE_MAP' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:53 SchemaExport - HHH000389: Unsuccessful: alter table BLC_OFFER_RULE_MAP drop foreign key FKCA468FE245C66D1D
[artifact:mvn] [ERROR] 15:51:53 SchemaExport - Error on rename of './broadleaf/BLC_OFFER_RULE_MAP' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:53 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER drop foreign key FK8F5B64A83E2FC4F9
[artifact:mvn] [ERROR] 15:51:53 SchemaExport - Error on rename of './broadleaf/BLC_ORDER' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:53 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER drop foreign key FK8F5B64A87470F437
[artifact:mvn] [ERROR] 15:51:53 SchemaExport - Error on rename of './broadleaf/BLC_ORDER' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER drop foreign key FK8F5B64A8A1E1C128
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - Error on rename of './broadleaf/BLC_ORDER' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ADJUSTMENT drop foreign key FK1E92D164D5F3FAF4
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_ADJUSTMENT' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ADJUSTMENT drop foreign key FK1E92D16489FE8A02
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_ADJUSTMENT' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ATTRIBUTE drop foreign key FKB3A467A589FE8A02
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_ATTRIBUTE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM drop foreign key FK9A2E704A15D1A13D
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM drop foreign key FK9A2E704AFD2F1F10
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM drop foreign key FK9A2E704A89FE8A02
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM drop foreign key FK9A2E704AB0B0D00A
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM drop foreign key FK9A2E704A77F565E1
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_ITEM' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM_ADD_ATTR drop foreign key FKA466AB44B76B9466
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_ITEM_ADD_ATTR' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM_ADJUSTMENT drop foreign key FKA2658C82D5F3FAF4
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_ITEM_ADJUSTMENT' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM_ADJUSTMENT drop foreign key FKA2658C829AF166DF
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_ITEM_ADJUSTMENT' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM_ATTRIBUTE drop foreign key FK9F1ED0C79AF166DF
[artifact:mvn] [ERROR] 15:51:54 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_ITEM_ATTRIBUTE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM_DTL_ADJ drop foreign key FK85F0248FD5F3FAF4
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_ITEM_DTL_ADJ' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM_DTL_ADJ drop foreign key FK85F0248FD4AEA2C0
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_ITEM_DTL_ADJ' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_ITEM_PRICE_DTL drop foreign key FK1FB64BF19AF166DF
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_ITEM_PRICE_DTL' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_MULTISHIP_OPTION drop foreign key FKB3D3F7D6C13085DD
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_MULTISHIP_OPTION' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_MULTISHIP_OPTION drop foreign key FKB3D3F7D681F34C7F
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_MULTISHIP_OPTION' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_MULTISHIP_OPTION drop foreign key FKB3D3F7D689FE8A02
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_MULTISHIP_OPTION' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_MULTISHIP_OPTION drop foreign key FKB3D3F7D69AF166DF
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_MULTISHIP_OPTION' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_OFFER_CODE_XREF drop foreign key FKFDF0E8533BB10F6D
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_OFFER_CODE_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_OFFER_CODE_XREF drop foreign key FKFDF0E85389FE8A02
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_OFFER_CODE_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_PAYMENT drop foreign key FK9517A14FC13085DD
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_PAYMENT' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_PAYMENT drop foreign key FK9517A14F89FE8A02
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_PAYMENT' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_PAYMENT_TRANSACTION drop foreign key FK86FDE7CE6A69DD9D
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_PAYMENT_TRANSACTION' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ORDER_PAYMENT_TRANSACTION drop foreign key FK86FDE7CEE1B66C71
[artifact:mvn] [ERROR] 15:51:55 SchemaExport - Error on rename of './broadleaf/BLC_ORDER_PAYMENT_TRANSACTION' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAGE drop foreign key FKF41BEDD5D49D3961
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - Error on rename of './broadleaf/BLC_PAGE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAGE_FLD_MAP drop foreign key FKE9EE09515AEDD08A
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - Error on rename of './broadleaf/BLC_PAGE_FLD_MAP' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAGE_FLD_MAP drop foreign key FKE9EE0951883C2667
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - Error on rename of './broadleaf/BLC_PAGE_FLD_MAP' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAGE_RULE_MAP drop foreign key FK1ABA0CA336D91846
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - Error on rename of './broadleaf/BLC_PAGE_RULE_MAP' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAGE_RULE_MAP drop foreign key FK1ABA0CA3C38455DD
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - Error on rename of './broadleaf/BLC_PAGE_RULE_MAP' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAGE_TMPLT drop foreign key FK325C9D5A1E1C128
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - Error on rename of './broadleaf/BLC_PAGE_TMPLT' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAYMENT_LOG drop foreign key FKA43703453E2FC4F9
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - Error on rename of './broadleaf/BLC_PAYMENT_LOG' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PAYMENT_LOG drop foreign key FKA43703457470F437
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - Error on rename of './broadleaf/BLC_PAYMENT_LOG' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PGTMPLT_FLDGRP_XREF drop foreign key FK99D625F66A79BDB5
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - Error on rename of './broadleaf/BLC_PGTMPLT_FLDGRP_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PGTMPLT_FLDGRP_XREF drop foreign key FK99D625F6D49D3961
[artifact:mvn] [ERROR] 15:51:56 SchemaExport - Error on rename of './broadleaf/BLC_PGTMPLT_FLDGRP_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT drop foreign key FK5B95B7C9DF057C3F
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT drop foreign key FK5B95B7C96D386535
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_ATTRIBUTE drop foreign key FK56CE05865F11A0B7
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT_ATTRIBUTE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_BUNDLE drop foreign key FK8CC5B85F11A0B7
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT_BUNDLE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_CROSS_SALE drop foreign key FK8324FB3C15D1A13D
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT_CROSS_SALE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_CROSS_SALE drop foreign key FK8324FB3C5F11A0B7
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT_CROSS_SALE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_CROSS_SALE drop foreign key FK8324FB3C62D84F9B
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT_CROSS_SALE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_FEATURED drop foreign key FK4C49FFE415D1A13D
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT_FEATURED' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_FEATURED drop foreign key FK4C49FFE45F11A0B7
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT_FEATURED' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_OPTION_VALUE drop foreign key FK6DEEEDBD92EA8136
[artifact:mvn] [ERROR] 15:51:57 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT_OPTION_VALUE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_OPTION_XREF drop foreign key FKDA42AB2F5F11A0B7
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT_OPTION_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_OPTION_XREF drop foreign key FKDA42AB2F92EA8136
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT_OPTION_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_SKU_XREF drop foreign key FKF2DBF6D35F11A0B7
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT_SKU_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_SKU_XREF drop foreign key FKF2DBF6D3B78C9977
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT_SKU_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_UP_SALE drop foreign key FKF69054F515D1A13D
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT_UP_SALE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_UP_SALE drop foreign key FKF69054F55F11A0B7
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT_UP_SALE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - HHH000389: Unsuccessful: alter table BLC_PRODUCT_UP_SALE drop foreign key FKF69054F562D84F9B
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - Error on rename of './broadleaf/BLC_PRODUCT_UP_SALE' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - HHH000389: Unsuccessful: alter table BLC_QUAL_CRIT_OFFER_XREF drop foreign key FKD592E919D5F3FAF4
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - Error on rename of './broadleaf/BLC_QUAL_CRIT_OFFER_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - HHH000389: Unsuccessful: alter table BLC_QUAL_CRIT_OFFER_XREF drop foreign key FKD592E9193615A91A
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - Error on rename of './broadleaf/BLC_QUAL_CRIT_OFFER_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - HHH000389: Unsuccessful: alter table BLC_QUAL_CRIT_PAGE_XREF drop foreign key FK874BE590883C2667
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - Error on rename of './broadleaf/BLC_QUAL_CRIT_PAGE_XREF' to './broadleaf/#sql2-448-26' (errno: 152)
[artifact:mvn] [ERROR] 15:54:19 SchemaExport - HHH000231: Schema export unsuccessful
[artifact:mvn] org.hibernate.tool.hbm2ddl.ImportScriptException: Error during statement execution (file: '/sql/load_catalog_i18n_data_ES.sql'): INSERT INTO BLC_TRANSLATION (TRANSLATION_ID, ENTITY_ID, LOCALE_CODE, ENTITY_TYPE, FIELD_NAME, TRANSLATED_VALUE) VALUES (-56, 3, 'es', 'Sku', 'longDescription', 'Picante, maduro pimienta que se mezcla junto con el ajo, la cebolla, pasta de tomate y una pizca de az&uacute;car de ca&ntilde;a para hacer de esto una salsa suave. Maravilloso en huevos, aves de corral, carne de cerdo o pescado, esta salsa se ​​mezcla para hacer los adobos y sopas ricas.')
[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.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:890)
[artifact:mvn] at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74)
[artifact:mvn] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:290)
[artifact:mvn] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:310)
[artifact:mvn] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1573)
[artifact:mvn] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1511)
[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:293)
[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:290)
[artifact:mvn] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1119)
[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:924)
[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.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1233)
[artifact:mvn] at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:701)
[artifact:mvn] at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:475)
[artifact:mvn] at org.mortbay.jetty.plugin.JettyWebAppContext.doStart(JettyWebAppContext.java:256)
[artifact:mvn] at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
[artifact:mvn] at org.eclipse.jetty.server.handler.HandlerCollection.doStart(HandlerCollection.java:224)
[artifact:mvn] at org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:167)
[artifact:mvn] at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
[artifact:mvn] at org.eclipse.jetty.server.handler.HandlerCollection.doStart(HandlerCollection.java:224)
[artifact:mvn] at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
[artifact:mvn] at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:90)
[artifact:mvn] at org.eclipse.jetty.server.Server.doStart(Server.java:272)
[artifact:mvn] at org.mortbay.jetty.plugin.JettyServer.doStart(JettyServer.java:65)
[artifact:mvn] at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
[artifact:mvn] at org.mortbay.jetty.plugin.AbstractJettyMojo.startJetty(AbstractJettyMojo.java:511)
[artifact:mvn] at org.mortbay.jetty.plugin.AbstractJettyMojo.execute(AbstractJettyMojo.java:364)
[artifact:mvn] at org.mortbay.jetty.plugin.JettyRunMojo.execute(JettyRunMojo.java:516)
[artifact:mvn] at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101)
[artifact:mvn] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209)
[artifact:mvn] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
[artifact:mvn] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161)
[artifact:mvn] at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320)
[artifact:mvn] at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)
[artifact:mvn] at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537)
[artifact:mvn] at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)
[artifact:mvn] at org.apache.maven.cli.MavenCli.main(MavenCli.java:141)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[artifact:mvn] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[artifact:mvn] at java.lang.reflect.Method.invoke(Method.java:606)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
[artifact:mvn] at org.codehaus.classworlds.Launcher.main(Launcher.java:47)
[artifact:mvn] Caused by: java.sql.SQLException: Incorrect string value: '\xE2\x80\x8B\xE2\x80\x8B...' for column 'TRANSLATED_VALUE' at row 1
[artifact:mvn] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
[artifact:mvn] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
[artifact:mvn] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
[artifact:mvn] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
[artifact:mvn] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
[artifact:mvn] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
[artifact:mvn] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
[artifact:mvn] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564)
[artifact:mvn] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485)
[artifact:mvn] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
[artifact:mvn] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.DatabaseExporter.export(DatabaseExporter.java:64)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:446)
[artifact:mvn] ... 69 more
[artifact:mvn] [ WARN] 15:54:28 SolrCore - [primary] Solr index directory '/tmp/subhan/solrhome/core0dir/data/index' doesn't exist. Creating new index...
[artifact:mvn] [ WARN] 15:54:28 SolrCore - [reindex] Solr index directory '/tmp/subhan/solrhome/core1dir/data/index' doesn't exist. Creating new index...
[artifact:mvn] 2015-04-23 15:54:31.504:INFO:oejsh.ContextHandler:started o.m.j.p.JettyWebAppContext{/,file:/home/subhan/Music/eclipse-workspace/DemoSite/site/target/heatclinic/},file:/home/subhan/Music/eclipse-workspace/DemoSite/site/target/heatclinic/
[artifact:mvn] 2015-04-23 15:54:31.934:INFO:/:Initializing Spring FrameworkServlet 'heatclinic'
[artifact:mvn] 2015-04-23 15:54:35.473:INFO:oejs.AbstractConnector:Started SelectChannelConnector@0.0.0.0:8080
[artifact:mvn] [INFO] Started Jetty Server
[artifact:mvn] 2015-04-23 15:54:35.675:INFO:oejus.SslContextFactory:Enabled Protocols [SSLv2Hello, SSLv3, TLSv1, TLSv1.1, TLSv1.2] of [SSLv2Hello, SSLv3, TLSv1, TLSv1.1, TLSv1.2]
[artifact:mvn] 2015-04-23 15:54:35.677:INFO:oejs.AbstractConnector:Started SslSelectChannelConnector@0.0.0.0:8443

phillipuniverse
Team Member
Team Member
Posts: 1563
Joined: Tue Dec 20, 2011 12:11 pm

Re: Broadleaf 3.0 - MySQL migration issues. Need urgent help

Postby phillipuniverse » Thu Apr 23, 2015 10:52 am

Looks like the problem has to do with UTF-8 characters. Make sure your my.cnf configuration file (usually in /etc/my.cnf) has this:

Code: Select all

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


Once you make this change you will need to restart MySQL and likely recreate the schema so that it has these defaults.

I also updated the documentation that you referenced to recommend these MySQL settings.

subhan
Newbie
Newbie
Posts: 8
Joined: Tue Apr 07, 2015 5:03 am

Re: Broadleaf 3.0 - MySQL migration issues. Need urgent help

Postby subhan » Sat Apr 25, 2015 1:17 am

Hi Phillip,
Thanks for the reply ,It was very helpful.
In database 179 tables created (How many tables required ?? ) and
SQL and Hibernate related exceptions are resolved By changing my.cnf

bu still following errors are same..

..........
[ERROR] 10:37:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDITIONAL_OFFER_INFO drop foreign key FK3BFDBD63B5D9C34D
[artifact:mvn] [ERROR] 10:37:50 SchemaExport - Table 'broadleaf.blc_additional_offer_info' doesn't exist
[artifact:mvn] [ERROR] 10:37:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDITIONAL_OFFER_INFO drop foreign key FK3BFDBD63D5F3FAF4
[artifact:mvn] [ERROR] 10:37:50 SchemaExport - Table 'broadleaf.blc_additional_offer_info' doesn't exist
[artifact:mvn] [ERROR] 10:37:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDITIONAL_OFFER_INFO drop foreign key FK3BFDBD631891FF79
[artifact:mvn] [ERROR] 10:37:50 SchemaExport - Table 'broadleaf.blc_additional_offer_info' doesn't exist
[artifact:mvn] [ERROR] 10:37:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CEA46E16CF
[artifact:mvn] [ERROR] 10:37:50 SchemaExport - Table 'broadleaf.blc_address' doesn't exist
[artifact:mvn] [ERROR] 10:37:50 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CEF1A6533F
.................


Return to “3.0 Upgrade and Migration”

Who is online

Users browsing this forum: No registered users and 2 guests