Hi Szabi, If you are using the (default) derby database cleanAll task deletes all the tables data. To run OFBiz you need seed and seed-initial data. With an empty database you can't run ofbiz.
To load specific readers data please use the following command. `./gradlew "ofbiz --load-data readers=seed,seed-initial"` Then create admin user login and use the application. Kind Regards, Deepak Dixit DIRECTOR OF PRODUCT ENGINEERING mobile: +91 9826754548 email: deepak.di...@hotwax.co *www.hotwax.co <http://www.hotwax.co/>* On Mon, Mar 8, 2021 at 6:48 AM Szabolcs Szekelyi <sz...@aura-labs.cc> wrote: > 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 > <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 <sz...@aura-labs.cc> > 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 > > > > >
