Page 1 of 1

Broadleaf 3.0 - MySQL migration issues. Need urgent help

Posted: Tue Sep 03, 2013 6:38 am
by neethu_27
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

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

Posted: Mon Sep 09, 2013 8:33 am
by ig0r
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.

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

Posted: Thu Dec 26, 2013 4:25 am
by sourav
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:

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

Posted: Sat Feb 08, 2014 1:54 pm
by panopset
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

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

Posted: Sun May 04, 2014 5:19 am
by gsugiart
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

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

Posted: Thu Apr 23, 2015 5:34 am
by subhan
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

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

Posted: Thu Apr 23, 2015 10:52 am
by phillipuniverse
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.

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

Posted: Sat Apr 25, 2015 1:17 am
by subhan
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
.................