http://ofbiz.116.s1.nabble.com/Can-t-create-initial-organization-tp4766384p4766661.html
I'm getting the same error message again. Do you have any other idea what can
foreign key constraint 'GLACCT_ORG_GLA' for key (100000). The statement has
been rolled back.)). Rolling back transaction.
> 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:
[hidden email]
> *www.hotwax.co <
http://www.hotwax.co/>*
>
> On Mon, Mar 8, 2021 at 6:48 AM Szabolcs Szekelyi <
[hidden email]> 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-manua> > l.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 <
[hidden email]>
> >
> > 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