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

Reply via email to