Posted by
Szabolcs Szekelyi on
URL: http://ofbiz.116.s1.nabble.com/Can-t-create-initial-organization-tp4766384.html
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