[OFBIZ-12228] Setup instructions don't work

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Trunk, 18.12.01
• Fix Version/s: 18.12.01
• Component/s: Documentation, setup, start

Environment

{{$ uname -srvimpo }}
{{Linux 5.8.0-50-generic #56-Ubuntu SMP Mon Apr 12 17:18:36 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux }}

$ java -version  
{{openjdk version "1.8.0_282" }}
{{OpenJDK Runtime Environment (build 1.8.0_282-8u282-b08-0ubuntu1~20.10-b08) }}
OpenJDK 64-Bit Server VM (build 25.282-b08, mixed mode)

• Assignee: Nicolas Malin
• Reporter: Szabolcs Szekelyi
• Created: 25/Apr/21 00:11
• Updated: 11/Jan/22 09:37
• Resolved: 06/Sep/21 15:35

Description

Followed the setup instructions on https://ci.apache.org/projects/ofbiz/site/trunk/ofbizdoc/html5/user-manual.html#_quick_start but I'm unable to create the initial organization.

I'm getting the following error:

Error:ERROR: parsing file: ERROR parsing Entity Xml file: org.xml.sax.SAXException: A transaction error occurred reading data<br/>org.xml.sax.SAXException: Error performing action CREATE_UPDATE<br/>org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:GlAccountOrganization][createdStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][createdTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][fromDate,2021-04-25 01:51:26.07(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][organizationPartyId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'GL_ACCOUNT_ORGANIZATION' caused a violation of foreign key constraint 'GLACCT_ORG_GLA' for key (100000). The statement has been rolled back.)) (Error while inserting: [GenericEntity:GlAccountOrganization][createdStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][createdTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][fromDate,2021-04-25 01:51:26.07(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][organizationPartyId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'GL_ACCOUNT_ORGANIZATION' caused a violation of foreign key constraint 'GLACCT_ORG_GLA' for key (100000). The statement has been rolled back.))) (org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:GlAccountOrganization][createdStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][createdTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][fromDate,2021-04-25 01:51:26.07(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][organizationPartyId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'GL_ACCOUNT_ORGANIZATION' caused a violation of foreign key constraint 'GLACCT_ORG_GLA' for key (100000). The statement has been rolled back.)) (Error while inserting: [GenericEntity:GlAccountOrganization][createdStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][createdTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][fromDate,2021-04-25 01:51:26.07(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][organizationPartyId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'GL_ACCOUNT_ORGANIZATION' caused a violation of foreign key constraint 'GLACCT_ORG_GLA' for key (100000). The statement has been rolled back.))))

Steps to reproduce:

1. Download and unzip distrubution package
2. Open a terminal, go to extracted directory
3. Run ./gradle/init-gradle-wrapper.sh
4. Run ./gradlew cleanAll loadAll
5. Start OFBiz, run{{ ./gradlew ofbiz}}, log in, make sure it works
6. Run ./gradlew cleanAll
7. Run ./gradlew "ofbiz --load-data readers=seed,seed-initial"
8. Run ./gradlew loadAdminUserLogin -PuserLoginId=admin
9. Start OFBiz, run ./gradlew ofbiz
10. Go to https://localhost:8443/ofbizsetup
11. Log in, change password
12. Fill out 'Create New Organization' form
13. On the appearing page, click 'Set to complete'