Hi Deepak, On Monday, 8 March 2021 02:05:32 CET Deepak Nigam wrote: > Can you share the detailed steps you are following for creating the > organization?
Sure. I basically followed the instructions from https://ci.apache.org/ projects/ofbiz/site/trunk/ofbizdoc/html5/user-manual.html#_quick_start Actually after compiling I loaded the demo database but then I erased it with the cleanAll task. After that I couldn't log in, because there were no users so I created a user from the command line as described on the page above. Logged in, changed the password, then a form came up to create an organization. It was asking for company name, address and contact information. I filled out the form, pressed OK or something. This took me to a page that's hard to identify, but it says "OFBiz: Setup Application : Create New Organization". Near the top I see Organization, Facility, Product Store, Web Site, First Customer and First Product, with a button below that says "Set to complete". When I press that, I get the error message. Hope that will be helpful. Thanks, -- Szabi > 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-169 > > 07-content) just shows an empty page. > > > > I guess I need to import something first? > > > > Thanks, > > -- > > Szabi
