Hi Szabi, Can you share the detailed steps you are following for creating the organization?
Thanks & Regards -- Deepak Nigam On Mon, Mar 8, 2021, 3:20 AM Szabolcs Szekelyi <[email protected]> wrote: > 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 > > > > >
