[
https://issues.apache.org/jira/browse/OFBIZ-12228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nicolas Malin closed OFBIZ-12228.
---------------------------------
Fix Version/s: Upcoming Branch
18.12.01
Resolution: Fixed
The correction is loaded on trunk and release18.12
Thanks both :)
> Setup instructions don't work
> -----------------------------
>
> Key: OFBIZ-12228
> URL: https://issues.apache.org/jira/browse/OFBIZ-12228
> Project: OFBiz
> Issue Type: Bug
> Components: Documentation, setup, start
> Affects Versions: 18.12.01, Trunk
> 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)}}
> Reporter: Szabolcs Szekelyi
> Assignee: Jacques Le Roux
> Priority: Major
> Fix For: 18.12.01, Upcoming Branch
>
> Attachments: OFBIZ-12228.patch
>
>
> 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:
> {quote}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.))))
> {quote}
> Steps to reproduce:
> # Download and unzip distrubution package
> # Open a terminal, go to extracted directory
> # Run {{./gradle/init-gradle-wrapper.sh}}
> # Run {{./gradlew cleanAll loadAll}}
> # Start OFBiz, run{{ ./gradlew ofbiz}}, log in, make sure it works
> # Run {{./gradlew cleanAll}}
> # Run {{./gradlew "ofbiz --load-data readers=seed,seed-initial"}}
> # Run {{./gradlew loadAdminUserLogin -PuserLoginId=admin}}
> # Start OFBiz, run {{./gradlew ofbiz}}
> # Go to [https://localhost:8443/ofbizsetup]
> # Log in, change password
> # Fill out 'Create New Organization' form
> # On the appearing page, click 'Set to complete'
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
