Installation Unsuccessful

Hi,
I tried to install Scipio ERP on Mac. I followed following steps by references in documents.

  1. https://github.com/ilscipio/scipio-erp/
  2. https://www.scipioerp.com/community/developer/installation-configuration/
  3. Tried both flavours of database derby and mysql.

During * OS X: “./install.sh” step many demo data was not able to be updated in debry or mysql database

 [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`ofbiz`.`order_item`, CONSTRAINT `ORDER_ITEM_PRODUCT` FOREIGN KEY (`PRODUCT_ID`) REFERENCES `product` (`PRODUCT_ID`))
 [java] 	at jdk.internal.reflect.GeneratedConstructorAccessor48.newInstance(Unknown Source) ~[?:?]
 [java] 	at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?]
 [java] 	at java.lang.reflect.Constructor.newInstance(Constructor.java:488) ~[?:?]
 [java] 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.47.jar:5.1.47]
 [java] 	at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.47.jar:5.1.47]
 [java] 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) ~[mysql-connector-java-5.1.47.jar:5.1.47]
 [java] 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) ~[mysql-connector-java-5.1.47.jar:5.1.47]
 [java] 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) ~[mysql-connector-java-5.1.47.jar:5.1.47]
 [java] 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java-5.1.47.jar:5.1.47]
 [java] 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) ~[mysql-connector-java-5.1.47.jar:5.1.47]
 [java] 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495) ~[mysql-connector-java-5.1.47.jar:5.1.47]
 [java] 	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903) ~[mysql-connector-java-5.1.47.jar:5.1.47]
 [java] 	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2124) ~[mysql-connector-java-5.1.47.jar:5.1.47]
 [java] 	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2058) ~[mysql-connector-java-5.1.47.jar:5.1.47]
 [java] 	at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5158) ~[mysql-connector-java-5.1.47.jar:5.1.47]
 [java] 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2043) ~[mysql-connector-java-5.1.47.jar:5.1.47]
 [java] 	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.5.0.jar:2.5.0]
 [java] 	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.5.0.jar:2.5.0]
 [java] 	at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:431) ~[ofbiz-entity.jar:?]
 [java] 	at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167) ~[ofbiz-entity.jar:?]
 [java] 	at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[ofbiz-entity.jar:?]
 [java] 	at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?]
 [java] 	at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:881) ~[ofbiz-entity.jar:?]
 [java] 	at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1316) ~[ofbiz-entity.jar:?]
 [java] 	at org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:463) ~[ofbiz-entity.jar:?]
 [java] 	at org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:654) ~[ofbiz-entity.jar:?]
 [java] 	at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) ~[xercesImpl-2.12.0.jar:?]
 [java] 	at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source) ~[xercesImpl-2.12.0.jar:?]
 [java] 	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) ~[xercesImpl-2.12.0.jar:2.12.0]
 [java] 	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) ~[xercesImpl-2.12.0.jar:2.12.0]
 [java] 	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) ~[xercesImpl-2.12.0.jar:2.12.0]
 [java] 	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) ~[xercesImpl-2.12.0.jar:?]
 [java] 	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) ~[xercesImpl-2.12.0.jar:?]
 [java] 	at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) ~[xercesImpl-2.12.0.jar:?]
 [java] 	at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) ~[xercesImpl-2.12.0.jar:?]
 [java] 	at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) ~[xercesImpl-2.12.0.jar:?]
 [java] 	at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source) ~[xercesImpl-2.12.0.jar:?]
 [java] 	at javax.xml.parsers.SAXParser.parse(SAXParser.java:196) ~[?:?]
 [java] 	at org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:430) ~[ofbiz-entity.jar:?]
 [java] 	... 8 more
 [java] 2020-02-16 15:33:06,912 |main                 |EntitySaxReader               |I| Beginning import from URL: file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/commonext/data/CommonExtSecurityGroupDemoData.xml
 [java] 2020-02-16 15:33:06,914 |main                 |EntitySaxReader               |I| Transaction Timeout set to 2 hours (7200 seconds)
 [java] 2020-02-16 15:33:06,917 |main                 |EntitySaxReader               |I| Finished 1 values from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/commonext/data/CommonExtSecurityGroupDemoData.xml
 [java] 2020-02-16 15:33:06,917 |main                 |EntitySaxReader               |I| Beginning import from URL: file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/commonext/data/OfbizSetupSecurityGroupDemoData.xml
 [java] 2020-02-16 15:33:06,919 |main                 |EntitySaxReader               |I| Transaction Timeout set to 2 hours (7200 seconds)
 [java] 2020-02-16 15:33:06,922 |main                 |EntitySaxReader               |I| Finished 1 values from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/commonext/data/OfbizSetupSecurityGroupDemoData.xml
 [java] 2020-02-16 15:33:06,922 |main                 |EntitySaxReader               |I| Beginning import from URL: file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/setup/data/SetupSecurityGroupDemoData.xml
 [java] 2020-02-16 15:33:06,923 |main                 |EntitySaxReader               |I| Transaction Timeout set to 2 hours (7200 seconds)
 [java] 2020-02-16 15:33:06,924 |main                 |EntitySaxReader               |I| Finished 0 values from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/setup/data/SetupSecurityGroupDemoData.xml
 [java] 2020-02-16 15:33:06,924 |main                 |EntitySaxReader               |I| Beginning import from URL: file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/solr/data/SolrSecurityGroupDemoData.xml
 [java] 2020-02-16 15:33:06,925 |main                 |EntitySaxReader               |I| Transaction Timeout set to 2 hours (7200 seconds)
 [java] 2020-02-16 15:33:06,931 |main                 |EntitySaxReader               |I| Finished 9 values from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/solr/data/SolrSecurityGroupDemoData.xml
 [java] 2020-02-16 15:33:06,931 |main                 |EntitySaxReader               |I| Beginning import from URL: file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/solr/data/SolrUserDemoData.xml
 [java] 2020-02-16 15:33:06,932 |main                 |EntitySaxReader               |I| Transaction Timeout set to 2 hours (7200 seconds)
 [java] 2020-02-16 15:33:06,941 |main                 |EntitySaxReader               |I| Finished 13 values from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/solr/data/SolrUserDemoData.xml
 [java] 2020-02-16 15:33:06,941 |main                 |EntitySaxReader               |I| Beginning import from URL: file:/Users/pramodchanana/open/erp/scipio/scipio-erp/specialpurpose/assetmaint/data/AssetMaintSecurityGroupDemoData.xml
 [java] 2020-02-16 15:33:06,943 |main                 |EntitySaxReader               |I| Transaction Timeout set to 2 hours (7200 seconds)
 [java] 2020-02-16 15:33:06,948 |main                 |EntitySaxReader               |I| Finished 6 values from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/specialpurpose/assetmaint/data/AssetMaintSecurityGroupDemoData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| =-=-=-=-=-=-= Here is a summary of the data load:
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00016 of 00016 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/security/data/SecurityPermissionSeedData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00017 of 00033 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/CommonSecurityPermissionSeedData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00016 of 00049 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/CommonSystemPropertyData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00075 of 00124 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/CommonTypeData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00038 of 00162 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/CommonVisualThemeTypeData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00150 of 00312 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/CurrencyData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00737 of 01049 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/CountryCodeData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00565 of 01614 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00016 of 01630 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_AU.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00056 of 01686 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_BG.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00053 of 01739 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_BR.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00026 of 01765 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_CA.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00052 of 01817 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_CH.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00068 of 01885 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_CN.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00066 of 01951 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_CO.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00032 of 01983 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_DE.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00205 of 02188 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_ES.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00451 of 02639 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_FR.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00052 of 02691 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_IE.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00012 of 02703 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_IL.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00072 of 02775 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_IN.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00220 of 02995 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_IT.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00094 of 03089 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_JP.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00067 of 03156 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_MX.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00032 of 03188 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_MY.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00026 of 03214 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_NL.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00032 of 03246 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_PL.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00154 of 03400 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_TH.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00184 of 03584 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_UK.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00211 of 03795 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/GeoData_US.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00433 of 04228 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/LanguageData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00244 of 04472 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/UnitData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00007 of 04479 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/PeriodData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00012 of 04491 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/common/data/CommonPortletData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00010 of 04501 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/service/data/ScheduledServiceData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00147 of 04648 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/service/data/ServiceSeedData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00002 of 04650 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/service/data/ServiceSecurityPermissionSeedData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00012 of 04662 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/entityext/data/EntityExtTypeData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00002 of 04664 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/entityext/data/EntityExtSecurityPermissionSeedData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00035 of 04699 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/framework/webtools/data/WebtoolsSecurityPermissionSeedData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00034 of 04733 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/themes/base/data/BaseThemeData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00041 of 04774 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/themes/foundation-shop/data/ShopThemeData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00038 of 04812 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/themes/metro/data/MetroThemeData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00381 of 05193 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/party/data/PartyTypeData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00034 of 05227 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/party/data/PartySecurityPermissionSeedData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00003 of 05230 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/party/data/PartyGeoPointData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00055 of 05285 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/party/data/PartyPortletData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00002 of 05287 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/party/data/AdminUserLoginData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00004 of 05291 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/securityext/data/SecurityPermissionSeedData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00000 of 05291 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/content/data/ContentTypeData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00000 of 05291 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/content/data/ContentOperationData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 01471 of 06762 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/content/data/MimeTypeTikaData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00142 of 06904 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/content/data/MimeTypeData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00009 of 06913 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/content/data/MimeTypeTemplate.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00017 of 06930 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/content/data/DataCategoryData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00000 of 06930 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/content/data/TemplateData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00012 of 06942 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/content/data/ContentSecurityPermissionSeedData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00000 of 06942 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/content/data/MiscData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00000 of 06942 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/content/data/ContentHelpData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00000 of 06942 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/content/data/ContentHttpErrorData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00003 of 06945 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/content/data/ContentPortletData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00000 of 06945 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/content/data/PartyHelpData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00000 of 06945 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/content/data/WebtoolsHelpData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00177 of 07122 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/workeffort/data/WorkEffortTypeData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00000 of 07122 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/workeffort/data/WorkEffortPortletData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00010 of 07132 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/workeffort/data/WorkEffortSecurityPermissionSeedData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00523 of 07655 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/product/data/ProductTypeData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00000 of 07655 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/product/data/ProductHelpData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00097 of 07752 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/product/data/ShipmentTypeData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00019 of 07771 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/product/data/ProductSecurityPermissionSeedData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00008 of 07779 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/product/data/FacilitySecurityPermissionSeedData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00000 of 07779 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/product/data/ApiSchemaDhl.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00009 of 07788 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/product/data/ProductPortletData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00000 of 07788 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/manufacturing/data/ManufacturingData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00006 of 07794 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/manufacturing/data/ManufacturingSecurityPermissionSeedData.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00000 of 07794 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/manufacturing/data/ManufacturingHelpData_EN.xml
 [java] 2020-02-16 15:33:06,948 |main                 |EntityDataLoadContainer       |I| 00000 of 07794 from file:/Users/pramodchanana/open/erp/scipio/scipio-erp/applications/manufacturing/data/ManufacturingHelpData_NL.xml

BUILD SUCCESSFUL
Total time: 1 minute 47 seconds

During ./start.sh
at org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:90) ~[ofbiz-service.jar:?]
at org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:72) [ofbiz-service.jar:?]
at org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) [ofbiz-service.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) [?:?]
at java.lang.Thread.run(Thread.java:844) [?:?]
2020-02-16 15:40:17,369 |Scipio-JobQueue-0 |PersistedServiceJob |I| Persisted Job [10000] Failed. Re-Scheduling : Sun Feb 16 15:43:17 CET 2020 (1581864197360)
2020-02-16 15:40:17,369 |Scipio-JobQueue-1 |PersistedServiceJob |I| Persisted Job [10024] Failed. Re-Scheduling : Sun Feb 16 15:43:17 CET 2020 (1581864197360)

any input will help.

Another error during ./install.sh

[java] org.ofbiz.base.util.GeneralException: Conversion from java.lang.String to Boolean not currently supported
[java] at org.ofbiz.base.util.ObjectType.simpleTypeConvert(ObjectType.java:722) ~[ofbiz-base.jar:?]
[java] at org.ofbiz.base.util.ObjectType.simpleTypeConvert(ObjectType.java:625) ~[ofbiz-base.jar:?]
[java] at org.ofbiz.base.util.ObjectType.simpleTypeConvert(ObjectType.java:731) ~[ofbiz-base.jar:?]
[java] at org.ofbiz.service.ModelServiceReader.createProperties(ModelServiceReader.java:756) [ofbiz-service.jar:?]
[java] at org.ofbiz.service.ModelServiceReader.createModelService(ModelServiceReader.java:282) [ofbiz-service.jar:?]
[java] at org.ofbiz.service.ModelServiceReader.getModelServices(ModelServiceReader.java:151) [ofbiz-service.jar:?]
[java] at org.ofbiz.service.ModelServiceReader.getModelServiceMap(ModelServiceReader.java:87) [ofbiz-service.jar:?]
[java] at org.ofbiz.service.DispatchContext$1.call(DispatchContext.java:236) [ofbiz-service.jar:?]
[java] at org.ofbiz.service.DispatchContext$1.call(DispatchContext.java:234) [ofbiz-service.jar:?]
[java] at java.util.concurrent.ForkJoinTask$AdaptedCallable.exec(ForkJoinTask.java:1431) [?:?]
[java] at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:283) [?:?]
[java] at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1603) [?:?]
[java] at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:175) [?:?]
[java] 2020-02-16 15:43:58,801 |JoinPool-1-worker-15 |ModelServiceReader |E| Unable to evaluate service property ‘shoppingCart.update’ for service 'createUpdateBillingAddressAndPaymentMethod (will be null)
[java] org.ofbiz.base.util.GeneralException: Conversion from java.lang.String to Boolean not currently supported
[java] at org.ofbiz.base.util.ObjectType.simpleTypeConvert(ObjectType.java:722) ~[ofbiz-base.jar:?]
[java] at org.ofbiz.base.util.ObjectType.simpleTypeConvert(ObjectType.java:625) ~[ofbiz-base.jar:?]
[java] at org.ofbiz.base.util.ObjectType.simpleTypeConvert(ObjectType.java:731) ~[ofbiz-base.jar:?]
[java] at org.ofbiz.service.ModelServiceReader.createProperties(ModelServiceReader.java:756) [ofbiz-service.jar:?]
[java] at org.ofbiz.service.ModelServiceReader.createModelService(ModelServiceReader.java:282) [ofbiz-service.jar:?]
[java] at org.ofbiz.service.ModelServiceReader.getModelServices(ModelServiceReader.java:151) [ofbiz-service.jar:?]
[java] at org.ofbiz.service.ModelServiceReader.getModelServiceMap(ModelServiceReader.java:87) [ofbiz-service.jar:?]
[java] at org.ofbiz.service.DispatchContext$1.call(DispatchContext.java:236) [ofbiz-service.jar:?]
[java] at org.ofbiz.service.DispatchContext$1.call(DispatchContext.java:234) [ofbiz-service.jar:?]
[java] at java.util.concurrent.ForkJoinTask$AdaptedCallable.exec(ForkJoinTask.java:1431) [?:?]
[java] at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:283) [?:?]
[java] at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1603) [?:?]
[java] at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:175) [?:?]

Hi,

and welcome to the community. That is an interesting error. The error you see comes from the entity engine trying to update an existing database and failing to do so.

Are you re-using an existing database by any chance?

Hi,
Thank You for update. I am not reusing any database. Atleast with MYSQL it was first installation.

Best Regards

Hm, did you make any file changes? Which steps did you take in particular?

I am still trying to figure out which modifications could have caused this…

Reminds me to say: after switching to mysql, did you rerun the install script?

Hi,
I did changes mentioned in step for installing with MYSQL at URI location : https://www.scipioerp.com/community/developer/installation-configuration/configuration/

Kindly find attached screen shot for file changes.
52%20PM

I did following steps

  1. Open your command line, go to the extracted folder and run:
  • OS X: “./install.sh”
  1. From the same command line run:
  • OS X: “bash /start.sh”

Even when i was running first time with derby db. after running mentioed steps https://www.scipioerp.com/community/developer/installation-configuration/ i was never able to reach

  1. To access the SCIPIO ERP Backoffice, open your browser: https://localhost:8443/admin.
  2. To access the SCIPIO ERP Demo Store: https://localhost:8443/shop

I also installed ofbiz with deafult derby db day before SCIPIO. Can it impact ?

Best Regards,

Hi,

“I also installed ofbiz with deafult derby db day before SCIPIO. Can it impact ?”

That was my suspicion to be honest. if you are reusing the same source folder and used derby in ofbiz and then downloaded our files and override the ofbiz sources then that’s a possibility. Same goes for the mysql database. If you are reusing an existing database, you would see the errors you have posted. At least there is a potential. In the latter case you’d need to drop your mysql db and restart from scratch.

If you did use OFBiz in a production environment before and therefore have data worth saving, we can also help you with a proper migration plan, but that takes a lot more time. If you are just trying out the software i’d really recommend to start from scratch.

On a sidenote: please make sure that you adapted the mysql settings too. Ie: you modified the mysql config to match your database location, username, password and such. Also: make sure you placed the mysql jdbc jar in the right location or ran the proper ant task to download it automatically. (we described this step in more detail here: https://www.scipioerp.com/community/developer/installation-configuration/configuration/#database-configuration