Hi, I just installed OFBiz without the included database. I created the admin user from the command line and I'm able to log in now.
I'm trying to create the organization that represents my company, but I ran into an error. Specified all basic data like name and address, but when I click "Set to complete", I get this 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-03-07 22:29:17.784(java.sql.Timestamp)][createdTxStamp,2021-03-07 22:29:17.657(java.sql.Timestamp)][fromDate,2021-03-07 22:29:17.765(java.sql.Timestamp)][glAccountId,100000(java.lang.String)] [lastUpdatedStamp,2021-03-07 22:29:17.784(java.sql.Timestamp)] [lastUpdatedTxStamp,2021-03-07 22:29:17.657(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-03-07 22:29:17.784(java.sql.Timestamp)][createdTxStamp,2021-03-07 22:29:17.657(java.sql.Timestamp)][fromDate,2021-03-07 22:29:17.765(java.sql.Timestamp)][glAccountId,100000(java.lang.String)] [lastUpdatedStamp,2021-03-07 22:29:17.784(java.sql.Timestamp)] [lastUpdatedTxStamp,2021-03-07 22:29:17.657(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-03-07 22:29:17.784(java.sql.Timestamp)][createdTxStamp,2021-03-07 22:29:17.657(java.sql.Timestamp)][fromDate,2021-03-07 22:29:17.765(java.sql.Timestamp)][glAccountId,100000(java.lang.String)] [lastUpdatedStamp,2021-03-07 22:29:17.784(java.sql.Timestamp)] [lastUpdatedTxStamp,2021-03-07 22:29:17.657(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-03-07 22:29:17.784(java.sql.Timestamp)][createdTxStamp,2021-03-07 22:29:17.657(java.sql.Timestamp)][fromDate,2021-03-07 22:29:17.765(java.sql.Timestamp)][glAccountId,100000(java.lang.String)] [lastUpdatedStamp,2021-03-07 22:29:17.784(java.sql.Timestamp)] [lastUpdatedTxStamp,2021-03-07 22:29:17.657(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.)))) Am I doing something wrong? I found this thread: https://lists.apache.org/thread.html/ f99a13a3eabc739a117dffc74a62b0403f36dd00bdb841a3cc27af28%401311206645%40%3Cuser.ofbiz.apache.org%3E, but the link from there (https://www.antwebsystems.com/Setup-OFBiz-with-your-data-in-15-minutes-16907-content) just shows an empty page. I guess I need to import something first? Thanks, -- Szabi
