Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-12228

Setup instructions don't work

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • Trunk, 18.12.01
    • 18.12.01
    • Documentation, setup, start
    • None

    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'

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            nmalin Nicolas Malin
            szekelyisz Szabolcs Szekelyi
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment