Ok... With a couple corrections, this appears to work fine for me. I
made some changes starting around line 59.
I also, accidentally, grabbed Lubuntu 17.04 (not 16.04) but I believe
the changes I had to make to this text file were just things I glossed
over anyway. Nothing jumps out at me as being specific to Ubuntu
variants 16.04 or 17.04. I'm pretty sure if I went back into my Mint 18
install and looked at command history, they'd be the same.
Stuff I forgot and rushed through (so pay attention if you're eyes work
like mine) was forgetting to add credentials for the other (as in, not
ofbiz) two databases. That screwed me up for a half hour before I
realized. I do a genuine facepalm about once a month -- this was one of
them...
I also added how to get sample data vs a clean db. If anyone wants to
point out any errors, please do. I'm game for another facepalm. :) I'd
also like to start polishing this for Sharon to use with whatever final
"install it in Ubuntu" guide we end up with in the end.
On 04/22/2017 01:19 PM, Craig Parker wrote:
Howdy, Adeel. Have a gander at these are notes I sent off to a friend.
I'm very sarcastic by nature, but I think I've cleaned most of the
snark out of them...
I've got an old box that's struggling with Mint/XFCE horsepower-wise,
so I'm throwing a clean Lubuntu 16.04 on it today. I'll be running
through this whole OFBiz procedure from scratch in the process to see
if I missed anything, and I'll keep you posted.
There are some "loading default vs clean data" messages in the group
from earlier this week. The results of those discussions have not yet
made it into my notes.
I'm currently running Mint18 64bit (I believe this is the equivalent
of Ubuntu 16.04), openjdk 1.8.0_121 (although I noticed this morning
on someone's Windows box that Oracle has _131 out in the wild -- I've
not run an apt-get update/upgrade for a few days on my own stuff to
see if openjdk 131 is out there too), and MySQL 5.7.17
On 04/22/2017 12:30 PM, Muhammad Adeel Zahid wrote:
Hi Craig,
Is it working for you on ubuntu/debian/mint using openjdk and mysql?
Its not working for me on ubuntu 16.04 TLS, mysql mysql Ver 14.14
Distrib 5.7.11, for Linux (x86_64) using EditLine wrapper.
However, it works fine when i switch to oracle jdk. Can you update me
on what version of mysql and ubuntu you were using? Also, are there
any changes to make in mysql.cnf or my.cnf?
Regards
Adeel
________________________________
From: Craig Parker <cr...@fossfolks.com>
Sent: Saturday, April 22, 2017 6:07:36 AM
To: user@ofbiz.apache.org
Subject: Re: Error Migrating Ofbiz from derby to mysql
I've got a walkthrough in the works using openjdk and mysql, but for
ubuntu/debina/mint, not windows...
On 04/21/2017 04:53 PM, Muhammad Adeel Zahid wrote:
Yes, I was right. When I replaced openjdk-8 with oracle-jdk-8, the
data loaded just fine. However, we are more interested in open
source solution. Is there a way, I can run Ofbiz, with openjdk and
mysql.
Regards
Adeel
________________________________
From: Muhammad Adeel Zahid <16030...@lums.edu.pk>
Sent: Friday, April 21, 2017 10:44:37 PM
To: user@ofbiz.apache.org
Subject: Re: Error Migrating Ofbiz from derby to mysql
Hi Pranay Panday,
Thanks for the prompt response. I was trying your solution on
different systems and it worked great on windows machine. On
windows, I have been able to load demo data into mysql and run the
application with mysql. However, on debian and ubuntu machines,
ofbiz can create database with all 861 tables in ofbizdb and some
other in tenant and olap dbs. But it fails to load demo data into
db. There are many exceptions when inserting data into the db. Some
of the example exceptions are .
org.xml.sax.SAXException: A transaction error occurred reading data
at
org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:240)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:199)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:257)
[ofbiz.jar:?]
at
org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadContainer(EntityDataLoadContainer.java:492)
[ofbiz.jar:?]
at
org.apache.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:246)
[ofbiz.jar:?]
at
org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:155)
[ofbiz.jar:?]
at
org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:80)
[ofbiz.jar:?]
at
org.apache.ofbiz.base.start.StartupControlPanel.loadStartupLoaders(StartupControlPanel.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:71)
[ofbiz.jar:?]
at org.apache.ofbiz.base.start.Start.main(Start.java:84) [ofbiz.jar:?]
Caused by: org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException: Error while
inserting: [GenericEntity:WebSite][createdStamp,2017-04-21
22:26:40.665(java.sql.Timestamp)][createdTxStamp,2017-04-21
22:26:40.662(java.sql.Timestamp)][lastUpdatedStamp,2017-04-21
22:26:40.665(java.sql.Timestamp)][lastUpdatedTxStamp,2017-04-21
22:26:40.662(java.sql.Timestamp)][productStoreId,9100(java.lang.String)][siteName,Web
POS
Site(java.lang.String)][visualThemeSetId,BACKOFFICE(java.lang.String)][webSiteId,WebStorePos(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO WEB_SITE
(WEB_SITE_ID, SITE_NAME, HTTP_HOST, HTTP_PORT, HTTPS_HOST,
HTTPS_PORT, ENABLE_HTTPS, STANDARD_CONTENT_PREFIX,
SECURE_CONTENT_PREFIX, COOKIE_DOMAIN, VISUAL_THEME_SET_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP, PRODUCT_STORE_ID, ALLOW_PRODUCT_STORE_CHANGE,
HOSTED_PATH_ALIAS, IS_DEFAULT, DISPLAY_MAINTENANCE_PAGE) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add
or update a child row: a foreign key constraint fails
(`ofbiz`.`WEB_SITE`, CONSTRAINT `WEB_SITE_PRDS` FOREIGN KEY
(`PRODUCT_STORE_ID`) REFERENCES `PRODUCT_STORE`
(`PRODUCT_STORE_ID`)))) (Error while inserting:
[GenericEntity:WebSite][createdStamp,2017-04-21
22:26:40.665(java.sql.Timestamp)][createdTxStamp,2017-04-21
22:26:40.662(java.sql.Timestamp)][lastUpdatedStamp,2017-04-21
22:26:40.665(java.sql.Timestamp)][lastUpdatedTxStamp,2017-04-21
22:26:40.662(java.sql.Timestamp)][productStoreId,9100(java.lang.String)][siteName,Web
POS
Site(java.lang.String)][visualThemeSetId,BACKOFFICE(java.lang.String)][webSiteId,WebStorePos(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO WEB_SITE
(WEB_SITE_ID, SITE_NAME, HTTP_HOST, HTTP_PORT, HTTPS_HOST,
HTTPS_PORT, ENABLE_HTTPS, STANDARD_CONTENT_PREFIX,
SECURE_CONTENT_PREFIX, COOKIE_DOMAIN, VISUAL_THEME_SET_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP, PRODUCT_STORE_ID, ALLOW_PRODUCT_STORE_CHANGE,
HOSTED_PATH_ALIAS, IS_DEFAULT, DISPLAY_MAINTENANCE_PAGE) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add
or update a child row: a foreign key constraint fails
(`ofbiz`.`WEB_SITE`, CONSTRAINT `WEB_SITE_PRDS` FOREIGN KEY
(`PRODUCT_STORE_ID`) REFERENCES `PRODUCT_STORE`
(`PRODUCT_STORE_ID`)))))
(org.apache.ofbiz.entity.GenericEntityException: Error while
inserting: [GenericEntity:WebSite][createdStamp,2017-04-21
22:26:40.665(java.sql.Timestamp)][createdTxStamp,2017-04-21
22:26:40.662(java.sql.Timestamp)][lastUpdatedStamp,2017-04-21
22:26:40.665(java.sql.Timestamp)][lastUpdatedTxStamp,2017-04-21
22:26:40.662(java.sql.Timestamp)][productStoreId,9100(java.lang.String)][siteName,Web
POS
Site(java.lang.String)][visualThemeSetId,BACKOFFICE(java.lang.String)][webSiteId,WebStorePos(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO WEB_SITE
(WEB_SITE_ID, SITE_NAME, HTTP_HOST, HTTP_PORT, HTTPS_HOST,
HTTPS_PORT, ENABLE_HTTPS, STANDARD_CONTENT_PREFIX,
SECURE_CONTENT_PREFIX, COOKIE_DOMAIN, VISUAL_THEME_SET_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP, PRODUCT_STORE_ID, ALLOW_PRODUCT_STORE_CHANGE,
HOSTED_PATH_ALIAS, IS_DEFAULT, DISPLAY_MAINTENANCE_PAGE) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add
or update a child row: a foreign key constraint fails
(`ofbiz`.`WEB_SITE`, CONSTRAINT `WEB_SITE_PRDS` FOREIGN KEY
(`PRODUCT_STORE_ID`) REFERENCES `PRODUCT_STORE`
(`PRODUCT_STORE_ID`)))) (Error while inserting:
[GenericEntity:WebSite][createdStamp,2017-04-21
22:26:40.665(java.sql.Timestamp)][createdTxStamp,2017-04-21
22:26:40.662(java.sql.Timestamp)][lastUpdatedStamp,2017-04-21
22:26:40.665(java.sql.Timestamp)][lastUpdatedTxStamp,2017-04-21
22:26:40.662(java.sql.Timestamp)][productStoreId,9100(java.lang.String)][siteName,Web
POS
Site(java.lang.String)][visualThemeSetId,BACKOFFICE(java.lang.String)][webSiteId,WebStorePos(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO WEB_SITE
(WEB_SITE_ID, SITE_NAME, HTTP_HOST, HTTP_PORT, HTTPS_HOST,
HTTPS_PORT, ENABLE_HTTPS, STANDARD_CONTENT_PREFIX,
SECURE_CONTENT_PREFIX, COOKIE_DOMAIN, VISUAL_THEME_SET_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP, PRODUCT_STORE_ID, ALLOW_PRODUCT_STORE_CHANGE,
HOSTED_PATH_ALIAS, IS_DEFAULT, DISPLAY_MAINTENANCE_PAGE) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add
or update a child row: a foreign key constraint fails
(`ofbiz`.`WEB_SITE`, CONSTRAINT `WEB_SITE_PRDS` FOREIGN KEY
(`PRODUCT_STORE_ID`) REFERENCES `PRODUCT_STORE`
(`PRODUCT_STORE_ID`))))))
at
org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1351)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228)
~[ofbiz.jar:?]
... 9 more
Caused by: org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException: Error while
inserting: [GenericEntity:WebSite][createdStamp,2017-04-21
22:26:40.665(java.sql.Timestamp)][createdTxStamp,2017-04-21
22:26:40.662(java.sql.Timestamp)][lastUpdatedStamp,2017-04-21
22:26:40.665(java.sql.Timestamp)][lastUpdatedTxStamp,2017-04-21
22:26:40.662(java.sql.Timestamp)][productStoreId,9100(java.lang.String)][siteName,Web
POS
Site(java.lang.String)][visualThemeSetId,BACKOFFICE(java.lang.String)][webSiteId,WebStorePos(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO WEB_SITE
(WEB_SITE_ID, SITE_NAME, HTTP_HOST, HTTP_PORT, HTTPS_HOST,
HTTPS_PORT, ENABLE_HTTPS, STANDARD_CONTENT_PREFIX,
SECURE_CONTENT_PREFIX, COOKIE_DOMAIN, VISUAL_THEME_SET_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP, PRODUCT_STORE_ID, ALLOW_PRODUCT_STORE_CHANGE,
HOSTED_PATH_ALIAS, IS_DEFAULT, DISPLAY_MAINTENANCE_PAGE) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add
or update a child row: a foreign key constraint fails
(`ofbiz`.`WEB_SITE`, CONSTRAINT `WEB_SITE_PRDS` FOREIGN KEY
(`PRODUCT_STORE_ID`) REFERENCES `PRODUCT_STORE`
(`PRODUCT_STORE_ID`)))) (Error while inserting:
[GenericEntity:WebSite][createdStamp,2017-04-21
22:26:40.665(java.sql.Timestamp)][createdTxStamp,2017-04-21
22:26:40.662(java.sql.Timestamp)][lastUpdatedStamp,2017-04-21
22:26:40.665(java.sql.Timestamp)][lastUpdatedTxStamp,2017-04-21
22:26:40.662(java.sql.Timestamp)][productStoreId,9100(java.lang.String)][siteName,Web
POS
Site(java.lang.String)][visualThemeSetId,BACKOFFICE(java.lang.String)][webSiteId,WebStorePos(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO WEB_SITE
(WEB_SITE_ID, SITE_NAME, HTTP_HOST, HTTP_PORT, HTTPS_HOST,
HTTPS_PORT, ENABLE_HTTPS, STANDARD_CONTENT_PREFIX,
SECURE_CONTENT_PREFIX, COOKIE_DOMAIN, VISUAL_THEME_SET_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP, PRODUCT_STORE_ID, ALLOW_PRODUCT_STORE_CHANGE,
HOSTED_PATH_ALIAS, IS_DEFAULT, DISPLAY_MAINTENANCE_PAGE) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add
or update a child row: a foreign key constraint fails
(`ofbiz`.`WEB_SITE`, CONSTRAINT `WEB_SITE_PRDS` FOREIGN KEY
(`PRODUCT_STORE_ID`) REFERENCES `PRODUCT_STORE`
(`PRODUCT_STORE_ID`)))))
at
org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:906)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1316)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228)
~[ofbiz.jar:?]
... 9 more
Caused by: org.apache.ofbiz.entity.GenericEntityException: Error
while inserting: [GenericEntity:WebSite][createdStamp,2017-04-21
22:26:40.665(java.sql.Timestamp)][createdTxStamp,2017-04-21
22:26:40.662(java.sql.Timestamp)][lastUpdatedStamp,2017-04-21
22:26:40.665(java.sql.Timestamp)][lastUpdatedTxStamp,2017-04-21
22:26:40.662(java.sql.Timestamp)][productStoreId,9100(java.lang.String)][siteName,Web
POS
Site(java.lang.String)][visualThemeSetId,BACKOFFICE(java.lang.String)][webSiteId,WebStorePos(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO WEB_SITE
(WEB_SITE_ID, SITE_NAME, HTTP_HOST, HTTP_PORT, HTTPS_HOST,
HTTPS_PORT, ENABLE_HTTPS, STANDARD_CONTENT_PREFIX,
SECURE_CONTENT_PREFIX, COOKIE_DOMAIN, VISUAL_THEME_SET_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP, PRODUCT_STORE_ID, ALLOW_PRODUCT_STORE_CHANGE,
HOSTED_PATH_ALIAS, IS_DEFAULT, DISPLAY_MAINTENANCE_PAGE) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add
or update a child row: a foreign key constraint fails
(`ofbiz`.`WEB_SITE`, CONSTRAINT `WEB_SITE_PRDS` FOREIGN KEY
(`PRODUCT_STORE_ID`) REFERENCES `PRODUCT_STORE` (`PRODUCT_STORE_ID`))))
at
org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:178)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1316)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228)
~[ofbiz.jar:?]
... 9 more
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL
Exception while executing the following:INSERT INTO WEB_SITE
(WEB_SITE_ID, SITE_NAME, HTTP_HOST, HTTP_PORT, HTTPS_HOST,
HTTPS_PORT, ENABLE_HTTPS, STANDARD_CONTENT_PREFIX,
SECURE_CONTENT_PREFIX, COOKIE_DOMAIN, VISUAL_THEME_SET_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP, PRODUCT_STORE_ID, ALLOW_PRODUCT_STORE_CHANGE,
HOSTED_PATH_ALIAS, IS_DEFAULT, DISPLAY_MAINTENANCE_PAGE) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add
or update a child row: a foreign key constraint fails
(`ofbiz`.`WEB_SITE`, CONSTRAINT `WEB_SITE_PRDS` FOREIGN KEY
(`PRODUCT_STORE_ID`) REFERENCES `PRODUCT_STORE` (`PRODUCT_STORE_ID`)))
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1316)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228)
~[ofbiz.jar:?]
... 9 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot
add or update a child row: a foreign key constraint fails
(`ofbiz`.`WEB_SITE`, CONSTRAINT `WEB_SITE_PRDS` FOREIGN KEY
(`PRODUCT_STORE_ID`) REFERENCES `PRODUCT_STORE` (`PRODUCT_STORE_ID`))
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:533)
~[mysql-connector-java-6.0.6-bin.jar:6.0.6]
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
~[mysql-connector-java-6.0.6-bin.jar:6.0.6]
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
~[mysql-connector-java-6.0.6-bin.jar:6.0.6]
at
com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983)
~[mysql-connector-java-6.0.6-bin.jar:6.0.6]
at
com.mysql.cj.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1826)
~[mysql-connector-java-6.0.6-bin.jar:6.0.6]
at
com.mysql.cj.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2034)
~[mysql-connector-java-6.0.6-bin.jar:6.0.6]
at
com.mysql.cj.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:1970)
~[mysql-connector-java-6.0.6-bin.jar:6.0.6]
at
com.mysql.cj.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5001)
~[mysql-connector-java-6.0.6-bin.jar:6.0.6]
at
com.mysql.cj.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1955)
~[mysql-connector-java-6.0.6-bin.jar:6.0.6]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1316)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228)
~[ofbiz.jar:?]
... 9 more
And here is the summary of data load. You can see a lot of errors
reported towards the end wile loading data from xml or writing it
into the db.
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
=-=-=-=-=-=-= Here is a summary of the data load:
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00016 of 00016 from
file:/home/adeel/workspace/ofbiz/framework/security/data/SecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00017 of 00033 from
file:/home/adeel/workspace/ofbiz/framework/common/data/CommonSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00016 of 00049 from
file:/home/adeel/workspace/ofbiz/framework/common/data/CommonSystemPropertyData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00104 of 00153 from
file:/home/adeel/workspace/ofbiz/framework/common/data/CommonTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00168 of 00321 from
file:/home/adeel/workspace/ofbiz/framework/common/data/CurrencyData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00737 of 01058 from
file:/home/adeel/workspace/ofbiz/framework/common/data/CountryCodeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00335 of 01393 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00016 of 01409 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_AU.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00056 of 01465 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_BG.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00053 of 01518 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_BR.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00026 of 01544 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_CA.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00052 of 01596 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_CH.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00068 of 01664 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_CN.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00066 of 01730 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_CO.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00032 of 01762 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_DE.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00138 of 01900 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_ES.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00451 of 02351 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_FR.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00052 of 02403 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_IE.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00012 of 02415 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_IL.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00070 of 02485 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_IN.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00220 of 02705 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_IT.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00094 of 02799 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_JP.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00067 of 02866 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_MX.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00032 of 02898 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_MY.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00026 of 02924 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_NL.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00032 of 02956 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_PL.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00154 of 03110 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_TH.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00184 of 03294 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_UK.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00211 of 03505 from
file:/home/adeel/workspace/ofbiz/framework/common/data/GeoData_US.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00433 of 03938 from
file:/home/adeel/workspace/ofbiz/framework/common/data/LanguageData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00244 of 04182 from
file:/home/adeel/workspace/ofbiz/framework/common/data/UnitData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00007 of 04189 from
file:/home/adeel/workspace/ofbiz/framework/common/data/PeriodData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00012 of 04201 from
file:/home/adeel/workspace/ofbiz/framework/common/data/CommonPortletData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00008 of 04209 from
file:/home/adeel/workspace/ofbiz/framework/service/data/ScheduledServiceData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00141 of 04350 from
file:/home/adeel/workspace/ofbiz/framework/service/data/ServiceSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00002 of 04352 from
file:/home/adeel/workspace/ofbiz/framework/service/data/ServiceSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00012 of 04364 from
file:/home/adeel/workspace/ofbiz/framework/entityext/data/EntityExtTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00002 of 04366 from
file:/home/adeel/workspace/ofbiz/framework/entityext/data/EntityExtSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00035 of 04401 from
file:/home/adeel/workspace/ofbiz/framework/webtools/data/WebtoolsSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00033 of 04434 from
file:/home/adeel/workspace/ofbiz/themes/bluelight/data/BlueLightThemeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00034 of 04468 from
file:/home/adeel/workspace/ofbiz/themes/flatgrey/data/FlatGreyThemeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00009 of 04477 from
file:/home/adeel/workspace/ofbiz/themes/multiflex/data/MultiflexThemeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00164 of 04641 from
file:/home/adeel/workspace/ofbiz/themes/rainbowstone/data/RainbowStoneThemeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00033 of 04674 from
file:/home/adeel/workspace/ofbiz/themes/tomahawk/data/TomahawkThemeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00384 of 05058 from
file:/home/adeel/workspace/ofbiz/applications/party/data/PartyTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00034 of 05092 from
file:/home/adeel/workspace/ofbiz/applications/party/data/PartySecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00003 of 05095 from
file:/home/adeel/workspace/ofbiz/applications/party/data/PartyGeoPointData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00055 of 05150 from
file:/home/adeel/workspace/ofbiz/applications/party/data/PartyPortletData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00005 of 05155 from
file:/home/adeel/workspace/ofbiz/applications/securityext/data/SecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00182 of 05337 from
file:/home/adeel/workspace/ofbiz/applications/content/data/ContentTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00098 of 05435 from
file:/home/adeel/workspace/ofbiz/applications/content/data/ContentOperationData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00108 of 05543 from
file:/home/adeel/workspace/ofbiz/applications/content/data/MimeTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00009 of 05552 from
file:/home/adeel/workspace/ofbiz/applications/content/data/MimeTypeTemplate.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00017 of 05569 from
file:/home/adeel/workspace/ofbiz/applications/content/data/DataCategoryData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00010 of 05579 from
file:/home/adeel/workspace/ofbiz/applications/content/data/BlogSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00049 of 05628 from
file:/home/adeel/workspace/ofbiz/applications/content/data/TemplateData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00012 of 05640 from
file:/home/adeel/workspace/ofbiz/applications/content/data/ContentSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00004 of 05644 from
file:/home/adeel/workspace/ofbiz/applications/content/data/MiscData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00029 of 05673 from
file:/home/adeel/workspace/ofbiz/applications/content/data/ContentHelpData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00019 of 05692 from
file:/home/adeel/workspace/ofbiz/applications/content/data/ContentHttpErrorData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00003 of 05695 from
file:/home/adeel/workspace/ofbiz/applications/content/data/ContentPortletData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00006 of 05701 from
file:/home/adeel/workspace/ofbiz/applications/content/data/PartyHelpData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00006 of 05707 from
file:/home/adeel/workspace/ofbiz/applications/content/data/WebtoolsHelpData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00183 of 05890 from
file:/home/adeel/workspace/ofbiz/applications/workeffort/data/WorkEffortTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00006 of 05896 from
file:/home/adeel/workspace/ofbiz/applications/workeffort/data/WorkEffortPortletData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00010 of 05906 from
file:/home/adeel/workspace/ofbiz/applications/workeffort/data/WorkEffortSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00521 of 06427 from
file:/home/adeel/workspace/ofbiz/applications/product/data/ProductTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00018 of 06445 from
file:/home/adeel/workspace/ofbiz/applications/product/data/ProductHelpData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00097 of 06542 from
file:/home/adeel/workspace/ofbiz/applications/product/data/ShipmentTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00019 of 06561 from
file:/home/adeel/workspace/ofbiz/applications/product/data/ProductSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00008 of 06569 from
file:/home/adeel/workspace/ofbiz/applications/product/data/FacilitySecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00003 of 06572 from
file:/home/adeel/workspace/ofbiz/applications/product/data/ApiSchemaDhl.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00009 of 06581 from
file:/home/adeel/workspace/ofbiz/applications/product/data/ProductPortletData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00000 of 06581 from
file:/home/adeel/workspace/ofbiz/applications/manufacturing/data/ManufacturingData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00006 of 06587 from
file:/home/adeel/workspace/ofbiz/applications/manufacturing/data/ManufacturingSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00108 of 06695 from
file:/home/adeel/workspace/ofbiz/applications/manufacturing/data/ManufacturingHelpData_EN.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00108 of 06803 from
file:/home/adeel/workspace/ofbiz/applications/manufacturing/data/ManufacturingHelpData_NL.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00000 of 06803 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/AccountingTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00363 of 07166 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/AccountingHelpData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00156 of 07322 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/UsTaxAccountGroups.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00034 of 07356 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/AccountingSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00027 of 07383 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/AccountingPortletData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00114 of 07497 from
file:/home/adeel/workspace/ofbiz/applications/humanres/data/HumanResTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00054 of 07551 from
file:/home/adeel/workspace/ofbiz/applications/humanres/data/HumanResHelpData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00007 of 07558 from
file:/home/adeel/workspace/ofbiz/applications/humanres/data/HumanResSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00005 of 07563 from
file:/home/adeel/workspace/ofbiz/applications/humanres/data/HumanResPortletData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00318 of 07881 from
file:/home/adeel/workspace/ofbiz/applications/order/data/OrderTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00041 of 07922 from
file:/home/adeel/workspace/ofbiz/applications/order/data/OrderPortletData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00025 of 07947 from
file:/home/adeel/workspace/ofbiz/applications/order/data/OrderSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00009 of 07956 from
file:/home/adeel/workspace/ofbiz/applications/order/data/OrderHelpData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00072 of 08028 from
file:/home/adeel/workspace/ofbiz/applications/marketing/data/MarketingTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00016 of 08044 from
file:/home/adeel/workspace/ofbiz/applications/marketing/data/MarketingSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00036 of 08080 from
file:/home/adeel/workspace/ofbiz/applications/marketing/data/MarketingHelpData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00004 of 08084 from
file:/home/adeel/workspace/ofbiz/applications/marketing/data/SfaPortletData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00221 of 08305 from
file:/home/adeel/workspace/ofbiz/applications/commonext/data/EntityDiagramGroupData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00002 of 08307 from
file:/home/adeel/workspace/ofbiz/applications/commonext/data/CommonExtSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00036 of 08343 from
file:/home/adeel/workspace/ofbiz/applications/commonext/data/CommonExtHelpData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00008 of 08351 from
file:/home/adeel/workspace/ofbiz/applications/commonext/data/SystemInfoPortletData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00000 of 08351 from
file:/home/adeel/workspace/ofbiz/applications/commonext/data/SetupData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00003 of 08354 from
file:/home/adeel/workspace/ofbiz/applications/commonext/data/OfbizSetupSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00009 of 08363 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/EcommerceTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00003 of 08366 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/EcommerceSecurityData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00003 of 08369 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/EcommerceSystemPropertyData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00003 of 08372 from
file:/home/adeel/workspace/ofbiz/specialpurpose/hhfacility/data/HhFacilitySecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00006 of 08378 from
file:/home/adeel/workspace/ofbiz/specialpurpose/assetmaint/data/AssetMaintSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00000 of 08378 from
file:/home/adeel/workspace/ofbiz/specialpurpose/assetmaint/data/AssetMaintSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00043 of 08421 from
file:/home/adeel/workspace/ofbiz/specialpurpose/projectmgr/data/ProjectMgrTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00063 of 08484 from
file:/home/adeel/workspace/ofbiz/specialpurpose/projectmgr/data/ProjectMgrHelpData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00011 of 08495 from
file:/home/adeel/workspace/ofbiz/specialpurpose/projectmgr/data/ProjectMgrSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00011 of 08506 from
file:/home/adeel/workspace/ofbiz/specialpurpose/projectmgr/data/ProjectMgrPortletData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00100 of 08606 from
file:/home/adeel/workspace/ofbiz/specialpurpose/scrum/data/scrumTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00059 of 08665 from
file:/home/adeel/workspace/ofbiz/specialpurpose/scrum/data/scrumSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00102 of 08767 from
file:/home/adeel/workspace/ofbiz/specialpurpose/scrum/data/scrumHelpData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00003 of 08770 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ebay/data/EbaySecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00005 of 08775 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ebay/data/EbayTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00036 of 08811 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ebay/data/EbayHelpData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00003 of 08814 from
file:/home/adeel/workspace/ofbiz/specialpurpose/myportal/data/MyPortalSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00003 of 08817 from
file:/home/adeel/workspace/ofbiz/specialpurpose/webpos/data/WebPosSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00021 of 08838 from
file:/home/adeel/workspace/ofbiz/specialpurpose/webpos/data/PosSecurityData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00008 of 08846 from
file:/home/adeel/workspace/ofbiz/specialpurpose/webpos/data/PosTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00003 of 08849 from
file:/home/adeel/workspace/ofbiz/specialpurpose/birt/data/BirtHelpData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00018 of 08867 from
file:/home/adeel/workspace/ofbiz/specialpurpose/birt/data/OrderPortletData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00006 of 08873 from
file:/home/adeel/workspace/ofbiz/specialpurpose/bi/data/BiTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00003 of 08876 from
file:/home/adeel/workspace/ofbiz/specialpurpose/bi/data/BiSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00000 of 08876 from
file:/home/adeel/workspace/ofbiz/specialpurpose/example/data/ExampleTypeData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00006 of 08882 from
file:/home/adeel/workspace/ofbiz/specialpurpose/example/data/ExampleSecurityPermissionSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00007 of 08889 from
file:/home/adeel/workspace/ofbiz/specialpurpose/example/data/ExamplePortletData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00011 of 08900 from
file:/home/adeel/workspace/ofbiz/specialpurpose/example/data/ExamplePortalSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00013 of 08913 from
file:/home/adeel/workspace/ofbiz/specialpurpose/example/data/ExampleHelpData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00003 of 08916 from
file:/home/adeel/workspace/ofbiz/specialpurpose/passport/data/OAuth2CommonSeedData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00001 of 08917 from
file:/home/adeel/workspace/ofbiz/framework/service/data/ScheduledServices.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00007 of 08924 from
file:/home/adeel/workspace/ofbiz/framework/entityext/data/EntityScheduledServices.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00002 of 08926 from
file:/home/adeel/workspace/ofbiz/applications/party/data/ScheduledJobs.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00014 of 08940 from
file:/home/adeel/workspace/ofbiz/applications/workeffort/data/WorkEffortSystemPropertyData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00001 of 08941 from
file:/home/adeel/workspace/ofbiz/applications/product/data/ProductScheduledServices.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00013 of 08954 from
file:/home/adeel/workspace/ofbiz/applications/product/data/CatalogSystemPropertyData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00033 of 08987 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/PaymentGatewayConfData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00009 of 08996 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/AccountingScheduledServiceData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00010 of 09006 from
file:/home/adeel/workspace/ofbiz/applications/order/data/OrderScheduledServices.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00004 of 09010 from
file:/home/adeel/workspace/ofbiz/applications/order/data/OrderSystemPropertyData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00002 of 09012 from
file:/home/adeel/workspace/ofbiz/specialpurpose/projectmgr/data/ProjectMgrSystemPropertyData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00002 of 09014 from
file:/home/adeel/workspace/ofbiz/specialpurpose/bi/data/BiSystemPropertyData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00006 of 09020 from
file:/home/adeel/workspace/ofbiz/framework/security/data/PasswordSecurityDemoData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00015 of 09035 from
file:/home/adeel/workspace/ofbiz/framework/security/data/SecurityGroupDemoData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00008 of 09043 from
file:/home/adeel/workspace/ofbiz/framework/security/data/SecurityTypeDemoData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00014 of 09057 from
file:/home/adeel/workspace/ofbiz/framework/common/data/CommonSecurityGroupDemoData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00002 of 09059 from
file:/home/adeel/workspace/ofbiz/framework/service/data/ServiceSecurityGroupDemoData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00057 of 09116 from
file:/home/adeel/workspace/ofbiz/framework/service/data/ServiceDemoData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00002 of 09118 from
file:/home/adeel/workspace/ofbiz/framework/entityext/data/EntityExtSecurityGroupDemoData.xml
2017-04-21 22:26:42,064 |main |EntityDataLoadContainer |I|
00041 of 09159 from
file:/home/adeel/workspace/ofbiz/framework/webtools/data/WebtoolsSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00033 of 09192 from
file:/home/adeel/workspace/ofbiz/applications/party/data/PartySecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00026 of 09218 from
file:/home/adeel/workspace/ofbiz/applications/party/data/PartyDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00049 of 09267 from
file:/home/adeel/workspace/ofbiz/applications/securityext/data/UserDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00016 of 09283 from
file:/home/adeel/workspace/ofbiz/applications/content/data/ContentSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00041 of 09324 from
file:/home/adeel/workspace/ofbiz/applications/content/data/UsersDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00004 of 09328 from
file:/home/adeel/workspace/ofbiz/applications/content/data/DemoBlogPubPtData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00062 of 09390 from
file:/home/adeel/workspace/ofbiz/applications/content/data/DemoBlogUsersData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00058 of 09448 from
file:/home/adeel/workspace/ofbiz/applications/content/data/DemoBlogEntryData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00007 of 09455 from
file:/home/adeel/workspace/ofbiz/applications/content/data/WebSitePublishPointData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00124 of 09579 from
file:/home/adeel/workspace/ofbiz/applications/content/data/CompDocData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00035 of 09614 from
file:/home/adeel/workspace/ofbiz/applications/content/data/ForumDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00019 of 09633 from
file:/home/adeel/workspace/ofbiz/applications/workeffort/data/WorkEffortSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 09633 from
file:/home/adeel/workspace/ofbiz/applications/workeffort/data/WorkEffortDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00035 of 09668 from
file:/home/adeel/workspace/ofbiz/applications/product/data/ProductSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00007 of 09675 from
file:/home/adeel/workspace/ofbiz/applications/product/data/FacilitySecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00022 of 09697 from
file:/home/adeel/workspace/ofbiz/applications/product/data/ProductDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00007 of 09704 from
file:/home/adeel/workspace/ofbiz/applications/manufacturing/data/ManufacturingSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 09704 from
file:/home/adeel/workspace/ofbiz/applications/manufacturing/data/ManufacturingExampleData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00058 of 09762 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/AccountingSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 09762 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoGeneralChartOfAccounts.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 09762 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoOrganizationData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 09762 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoGlSetupData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 09762 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoFinAccountData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 09762 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoTaxAuthority.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 09762 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoAcctgTransactionData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 09762 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoPaymentsInvoices.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 09762 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoAccountingUserData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 09762 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoAssetMaintData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 09762 from
file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoBudgetData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00021 of 09783 from
file:/home/adeel/workspace/ofbiz/applications/humanres/data/HumanResSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 09783 from
file:/home/adeel/workspace/ofbiz/applications/humanres/data/HumanResDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00093 of 09876 from
file:/home/adeel/workspace/ofbiz/applications/order/data/OrderSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00008 of 09884 from
file:/home/adeel/workspace/ofbiz/applications/order/data/OrderDemoUser.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00013 of 09897 from
file:/home/adeel/workspace/ofbiz/applications/order/data/OrderDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00006 of 09903 from
file:/home/adeel/workspace/ofbiz/applications/order/data/OrderQuoteDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00014 of 09917 from
file:/home/adeel/workspace/ofbiz/applications/marketing/data/MarketingSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00001 of 09918 from
file:/home/adeel/workspace/ofbiz/applications/marketing/data/SfaSystemPropertyData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00111 of 10029 from
file:/home/adeel/workspace/ofbiz/applications/marketing/data/sfaDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00001 of 10030 from
file:/home/adeel/workspace/ofbiz/applications/commonext/data/CommonExtSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00001 of 10031 from
file:/home/adeel/workspace/ofbiz/applications/commonext/data/OfbizSetupSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10031 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoProduct.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00075 of 10106 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoSurvey.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00038 of 10144 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoRentalShipping.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00192 of 10336 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoShipping.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10336 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoWebSitePublishPointData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00001 of 10337 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoTemplateData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00010 of 10347 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoContent.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10347 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoTopic.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10347 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoTree.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10347 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoFactoids.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00016 of 10363 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoRelatedData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10363 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoConfigurator.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10363 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoRentalProduct.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00020 of 10383 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoProductImages.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10383 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoTaxAuthority.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10383 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoOrderPeopleData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10383 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoOrderTestData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10383 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoMarketing.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10383 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoPurchasing.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10383 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoStandardCosting.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10383 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoStoreGiftCertificateSettings.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10383 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoFinAccount.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00024 of 10407 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoProductI18nData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10407 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoProductCategoriesI18nData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10407 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoTreeContent.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00247 of 10654 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoTestSurveyData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00050 of 10704 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoProductAdditionalViewData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10704 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoPopularCategoriesData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00012 of 10716 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoContentAltUrl.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00001 of 10717 from
file:/home/adeel/workspace/ofbiz/specialpurpose/hhfacility/data/HhFacilitySecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00006 of 10723 from
file:/home/adeel/workspace/ofbiz/specialpurpose/assetmaint/data/AssetMaintSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00063 of 10786 from
file:/home/adeel/workspace/ofbiz/specialpurpose/cmssite/data/CmsMultiSiteDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00091 of 10877 from
file:/home/adeel/workspace/ofbiz/specialpurpose/cmssite/data/CmsSiteDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00013 of 10890 from
file:/home/adeel/workspace/ofbiz/specialpurpose/projectmgr/data/ProjectMgrSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10890 from
file:/home/adeel/workspace/ofbiz/specialpurpose/projectmgr/data/ProjectMgrDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 10890 from
file:/home/adeel/workspace/ofbiz/specialpurpose/projectmgr/data/ProjectMgrDemoPasswordData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00128 of 11018 from
file:/home/adeel/workspace/ofbiz/specialpurpose/scrum/data/scrumSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 11018 from
file:/home/adeel/workspace/ofbiz/specialpurpose/scrum/data/scrumDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00004 of 11022 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ebay/data/EbaySecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00027 of 11049 from
file:/home/adeel/workspace/ofbiz/specialpurpose/ebay/data/DemoEbayData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00058 of 11107 from
file:/home/adeel/workspace/ofbiz/specialpurpose/myportal/data/MyPortalSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00133 of 11240 from
file:/home/adeel/workspace/ofbiz/specialpurpose/myportal/data/MyPortalPageDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 11240 from
file:/home/adeel/workspace/ofbiz/specialpurpose/myportal/data/MyPortalDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00002 of 11242 from
file:/home/adeel/workspace/ofbiz/specialpurpose/webpos/data/WebPosSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 11242 from
file:/home/adeel/workspace/ofbiz/specialpurpose/webpos/data/DemoRetail.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00000 of 11242 from
file:/home/adeel/workspace/ofbiz/specialpurpose/webpos/data/DemoPosData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00040 of 11282 from
file:/home/adeel/workspace/ofbiz/specialpurpose/webpos/data/PosSyncSettings.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00001 of 11283 from
file:/home/adeel/workspace/ofbiz/specialpurpose/bi/data/BiSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00007 of 11290 from
file:/home/adeel/workspace/ofbiz/specialpurpose/example/data/ExampleSecurityGroupDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00058 of 11348 from
file:/home/adeel/workspace/ofbiz/specialpurpose/example/data/ExampleDemoData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00003 of 11351 from
file:/home/adeel/workspace/ofbiz/specialpurpose/passport/data/OAuth2LinkedInSeedData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
00003 of 11354 from
file:/home/adeel/workspace/ofbiz/specialpurpose/passport/data/OAuth2GitHubSeedData.xml
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I| The
following errors occurred in the data load:
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/applications/manufacturing/data/ManufacturingData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/applications/accounting/data/AccountingTypeData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/applications/workeffort/data/WorkEffortDemoData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/applications/manufacturing/data/ManufacturingExampleData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoGeneralChartOfAccounts.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoOrganizationData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoGlSetupData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoFinAccountData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoTaxAuthority.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoAcctgTransactionData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoPaymentsInvoices.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoAccountingUserData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoAssetMaintData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/applications/accounting/data/DemoBudgetData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/applications/humanres/data/HumanResDemoData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoProduct.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoWebSitePublishPointData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,065 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoTopic.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoTree.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoFactoids.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoConfigurator.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoRentalProduct.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoTaxAuthority.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoOrderPeopleData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoOrderTestData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoMarketing.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoPurchasing.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoStandardCosting.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoStoreGiftCertificateSettings.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoFinAccount.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoProductCategoriesI18nData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoTreeContent.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/ecommerce/data/DemoPopularCategoriesData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/projectmgr/data/ProjectMgrDemoData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/projectmgr/data/ProjectMgrDemoPasswordData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/scrum/data/scrumDemoData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/myportal/data/MyPortalDemoData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/webpos/data/DemoRetail.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
[loadData]: Error loading XML Resource
"file:/home/adeel/workspace/ofbiz/specialpurpose/webpos/data/DemoPosData.xml";
Error was: A transaction error occurred reading data
2017-04-21 22:26:42,066 |main |EntityDataLoadContainer |I|
=-=-=-=-=-=-= Finished the data load with 11354 rows changed.
2017-04-21 22:26:42,066 |main |ContainerLoader |I|
Started container dataload-container
2017-04-21 22:26:42,066 |main |ContainerLoader |I|
Shutting down containers
2017-04-21 22:26:42,068 |main |ContainerLoader |I|
Stopping container dataload-container
2017-04-21 22:26:42,068 |main |ContainerLoader |I|
Stopped container dataload-container
2017-04-21 22:26:42,068 |main |ContainerLoader |I|
Stopping container service-container
2017-04-21 22:26:42,069 |main |JobPoller |I|
Shutting down JobPoller.
2017-04-21 22:26:42,069 |OFBiz-JobPoller
|JobPoller |I| JobPoller thread started.
2017-04-21 22:26:42,069 |main |JobPoller |I|
JobPoller shutdown completed.
2017-04-21 22:26:42,070 |OFBiz-JobPoller
|JobPoller |I| JobPoller thread stopped.
2017-04-21 22:26:42,070 |main |ServiceContainer |I|
Removing from cache dispatcher: entity-default
2017-04-21 22:26:42,070 |main |ServiceDispatcher |I|
De-Registering dispatcher: entity-default
2017-04-21 22:26:42,070 |main |ServiceDispatcher |I|
Shutting down the service engine...
2017-04-21 22:26:42,070 |main |ContainerLoader |I|
Stopped container service-container
2017-04-21 22:26:42,070 |main |ContainerLoader |I|
Stopping container component-container
2017-04-21 22:26:42,070 |main |ContainerLoader |I|
Stopped container component-container
I think, there might be some error with java-1.8-openjdk. I doubt
that I am using oracle jdk on windows machine but not sure. Will
update you ASAP.
Regards
Adeel
________________________________
From: Pranay Pandey <pranay.pan...@hotwaxsystems.com>
Sent: Friday, April 21, 2017 11:11:15 AM
To: user@ofbiz.apache.org
Subject: Re: Error Migrating Ofbiz from derby to mysql
Hi Muhammad Adeel,
I tried connecting MySQL DB with OFBiz 16.11 and it worked without any
issues.
While copying and pasting details from the mentioned document,
please be
careful that group name has been updated in 16.11, not a major
change but
addition of apache. So it changed as:
org.ofbiz ==> org.apache.ofbiz
*org.ofbiz.olap ==> org.apache*.ofbiz.olap
*org.ofbiz.tenant ==> org.apache*.ofbiz.tenant
Here is a tutorial video on OFBiz YouTube channel that can help you
with this setup: https://www.youtube.com/watch?v=Lzmv0DCC5N4
Regarding adding connector jar, follow the instructions about adding
build dependency mentioned in the video. You can also add db jar
dependency in your OFBiz build.xml file, In video it has been
demonstrated by adding this dependency in custom component build.xml.
Please let us know how it goes.
Best regards,
Pranay Pandey
HotWax Systems
http://www.hotwaxsystems.com/
On Thu, Apr 20, 2017 at 7:16 PM, Muhammad Adeel Zahid
<16030...@lums.edu.pk>
wrote:
Hi community,
I have been using ofbiz 16.11 (latest release) with derby for quite
some
time. Few days ago I started trying to migrate db from derby to
mysql. I
installed mysql 5.7 made the changes in my.ini (I am on windows 10,
though
I tried same on *nix machines with same error). I also created
three dbs
named ofbiz, ofbiztenant and ofbizolap and three users with same
name and
same password.
For changes in entityengine.xml, I copy/pasted everything(mysql
datasources and delegators) from this guide<https://cwiki.apache.
org/confluence/display/OFBIZ/How+to+migrate+OFBiz+from+
Derby+to+MySQL+database>. I have also put
mysql-java-connector-6.0.6 in
/framework/entity/lib/jdbc and added the same as runtime dependency in
build.gradle.
After doing all this when I run 'gradlew cleanAll loadDefault', I
get the
following errors
|E| The declared group name org.apache.ofbiz.olap has no corresponding
group-map in entityengine.xml
and the following stacktrace
java.util.concurrent.ExecutionException:
java.lang.NullPointerException
at
java.util.concurrent.FutureTask.report(FutureTask.java:122)
~[?:1.8.0_121]
at java.util.concurrent.FutureTask.get(FutureTask.java:192)
~[?:1.8.0_121]
at
org.apache.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:44)
[ofbiz.jar:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.
loadContainer(EntityDataLoadContainer.java:283) [ofbiz.jar:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.
start(EntityDataLoadContainer.java:246) [ofbiz.jar:?]
at org.apache.ofbiz.base.container.ContainerLoader.
startLoadedContainers(ContainerLoader.java:155) [ofbiz.jar:?]
at
org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:80)
[ofbiz.jar:?]
at org.apache.ofbiz.base.start.StartupControlPanel.
loadStartupLoaders(StartupControlPanel.java:240) [ofbiz.jar:?]
at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:71)
[ofbiz.jar:?]
at org.apache.ofbiz.base.start.Start.main(Start.java:84)
[ofbiz.jar:?]
Caused by: java.lang.NullPointerException
at
org.apache.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:566)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:111)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:229)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:34)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25)
~[ofbiz.jar:?]
at
org.apache.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:201)
~[ofbiz.jar:?]
at org.apache.ofbiz.entity.DelegatorFactory$
DelegatorConfigurable.call(DelegatorFactory.java:83) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.DelegatorFactory$
DelegatorConfigurable.call(DelegatorFactory.java:74) ~[ofbiz.jar:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
~[?:1.8.0_121]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
~[?:1.8.0_121]
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
~[?:1.8.0_121]
at java.util.concurrent.ScheduledThreadPoolExecutor$
ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
~[?:1.8.0_121]
at java.util.concurrent.ScheduledThreadPoolExecutor$
ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
~[?:1.8.0_121]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
~[?:1.8.0_121]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
~[?:1.8.0_121]
at java.lang.Thread.run(Thread.java:745) ~[?:1.8.0_121]
I have no idea what I have done wrong? Please guide me in right
direction
Regards
Adeel
Install Java (open java works)
sudo apt-get install openjdk-8-jdk
If you forgot to get MySQL and Apache and stuff, you may also want to
grab the LAMP stack:
sudo apt-get install lamp-server^
don't forget the caret on the end of that command
Download ofbiz, and I'm assuming it went into your downloads folder
sudo -i
-you'll just be essentially root from here on
mv /home/userdownloadingofbiz/Downloads/apache-ofbiz-x.x.x.zip /
-change x.x.x with correct version number
mv /apache-ofbiz-x.x.x.zip /ofbiz
useradd -m ofbiz
chown -R ofbiz:ofbiz /ofbiz
#-----------------------------------------------------------------------
# MySQL -- Create DBs, grant everything to ofbiz user, and make OFBiz
# use it
#-----------------------------------------------------------------------
create database ofbiz;
create database ofbizolap;
create database ofbiztenant;
grant all on ofbiz.* to 'ofbiz'@localhost identified by 'g1t3rdun';
grant all on ofbizolap.* to 'ofbiz'@localhost identified by 'g1t3rdun';
grant all on ofbiztenant.* to 'ofbiz'@localhost identified by 'g1t3rdun';
Copied mysql-connector-java-5.1.41-bin.jar to /ofbiz/framework/entity,
after I grabbed it from the MySQL site. This version number will change
over time
Added:
runtime 'mysql:mysql-connector-java:5.1.41'
to build.gradle (line 149 in dependencies section)
#----------------------------------------------------------------------
# MAKE SURE colon is between java and the version
# A dash doesn't work, even though the filename has the dash...
#----------------------------------------------------------------------
Edit /ofbiz/framework/entity/config/entityengine.xml
Three groups of three lines refer to derby -- change them to mysql:
<delegator name="default" entity-model-reader="main"...
<group-map group-name="org.apache.ofbiz" datasource-name="localmysql"/>
<group-map group-name="org.apache.ofbiz.olap"
datasource-name="localmysqlolap"/>
<group-map group-name="org.apache.ofbiz.tenant"
datasource-name="localmysqltenant"/>
</delegator>
These used to say localderby, localderbyolap, and localderbytenant
Remember, there's three groups of these
#-----------------------------------------------------------------------
# DOH! Don't forget this!
#-----------------------------------------------------------------------
Also, down in the vicinity of line 348, make sure to stick a username and
pass for the mysql user and pass (ofbiz and g1t3rdun in this case) you'll
need for hooking into the db.
And if it wasn't bad enough forgetting to fix that, 348 only fixes the ofbiz
database connections. Still have to fix the ofbizoplap and ofbiztenant
connection authentication down at lines 381 and 414. Double DOH!!!
#-----------------------------------------------------------------------
# To get the ball rolling...
#-----------------------------------------------------------------------
su - ofbiz
cd /ofbiz
#-----------------------------------------------------------------------
# Run OFBiz with a bunch of practice data
#-----------------------------------------------------------------------
./gradlew cleanAll loadDefault
#-----------------------------------------------------------------------
# To run OFBiz with a brand spanking new database -- NO data except a user
# named admin with a pass of ofbiz
#-----------------------------------------------------------------------
./gradlew "ofbiz ‐‐load-data readers=seed,seed-initial" loadAdminUserLogin
-PuserLoginId=admin
#-----------------------------------------------------------------------
# And then actually starting OFBiz up manually
#-----------------------------------------------------------------------
./gradlew ofbiz
gradlew stands for gradle wrapper; if that's ever on Jeopardy, don't forget
#-----------------------------------------------------------------------
# This will run it as a daemon:
#-----------------------------------------------------------------------
cp /ofbiz/tools/rc.ofbiz.for.debian /etc/init.d/ofbiz
edit so that any gradlew command is preceeded by /ofbiz
(as in /ofbiz/gradlew ofbiz -- there's maybe a couple three spots)
-maybe if I added /ofbiz to the ofbiz user's path, I could do without this...
-I tried that. /ofbiz is now in ofbiz's path, and I can run gradlew, but
getting errors that there's no cleanAll or loadDefault. same command worked
fine when I first cd-ed to /ofbiz
-so screw it, just precede gradlew commands with /ofbiz/
chown ofbiz:ofbiz /etc/init.d/ofbiz
chmod u+x /etc/init.d/ofbiz
-There appears to be an error in that file. Line 77
echo_success
ought to be:
echo success
Space instead of underscore.
su - ofbiz
/etc/init.d/ofbiz start
If that works, then create a file called /etc/init.d/ofbiz_start that says:
#!/bin/bash
sudo -u ofbiz /etc/init.d/ofbiz start
and then get it to start at boot with:
sudo update-rc.d ofbiz_start defaults