Can't create initial organization

[Szabolcs Szekelyi]

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

[deepak nigam-2]

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 <[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-16907-content)
> just shows an empty page.
>
> I guess I need to import something first?
>
> Thanks,
> --
> Szabi
>
>
>
>
>

[Szabolcs Szekelyi]

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 <[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

[Deepak Dixit-4]

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: [phone]
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-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 <[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
>
>
>
>
>

[Szabolcs Szekelyi]

Hi Deepak,

I wiped the database, ran the command you told, created the admin user, but
I'm getting the same error message again. Do you have any other idea what can
be wrong?

Here's the gist of the error message:

Failure in create operation for entity [GlAccountOrganization]:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:GlAccountOrganization][createdStamp,2021-03-14
00:20:32.997(java.sql.Timestamp)][createdTxStamp,2021-03-14
00:20:32.854(java.sql.Timestamp)][fromDate,2021-03-14
00:20:32.979(java.sql.Timestamp)][glAccountId,100000(java.lang.String)]
[lastUpdatedStamp,2021-03-14 00:20:32.997(java.sql.Timestamp)]
[lastUpdatedTxStamp,2021-03-14 00:20:32.854(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.)). Rolling back transaction.

Thanks,
--
Szabi

On Monday, 8 March 2021 06:57:58 CET Deepak Dixit wrote:

> 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: [phone]
> 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

[Jacques Le Roux]

Hi Szabolcs,

You may try that:

https://ci.apache.org/projects/ofbiz/site/trunk/ofbizdoc/html5/user-manual.html#_the_ofbiz_setup_application_overview

HTH

Jacques

Le 14/03/2021 à 00:24, Szabolcs Szekelyi a écrit :

> Hi Deepak,
>
> I wiped the database, ran the command you told, created the admin user, but
> I'm getting the same error message again. Do you have any other idea what can
> be wrong?
>
> Here's the gist of the error message:
>
> Failure in create operation for entity [GlAccountOrganization]:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:GlAccountOrganization][createdStamp,2021-03-14
> 00:20:32.997(java.sql.Timestamp)][createdTxStamp,2021-03-14
> 00:20:32.854(java.sql.Timestamp)][fromDate,2021-03-14
> 00:20:32.979(java.sql.Timestamp)][glAccountId,100000(java.lang.String)]
> [lastUpdatedStamp,2021-03-14 00:20:32.997(java.sql.Timestamp)]
> [lastUpdatedTxStamp,2021-03-14 00:20:32.854(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.)). Rolling back transaction.
>
> Thanks,

[Szabolcs Szekelyi]

Hi Jacques,

Thanks for the tip. This time I erased my entire installation on the filesystem
level, downloaded and extracted the most recent release 17.12.06, and followed
the instructions on that page point by point. I'm still getting the same
error.

Any other ideas?

Thanks,
--
Szabolcs

On Monday, 15 March 2021 11:16:09 CET Jacques Le Roux wrote:

> Hi Szabolcs,
>
> You may try that:
>
> https://ci.apache.org/projects/ofbiz/site/trunk/ofbizdoc/html5/user-manual.h
> tml#_the_ofbiz_setup_application_overview
>
> HTH
>
> Jacques
>
> Le 14/03/2021 à 00:24, Szabolcs Szekelyi a écrit :
> > Hi Deepak,
> >
> > I wiped the database, ran the command you told, created the admin user,
> > but
> > I'm getting the same error message again. Do you have any other idea what
> > can be wrong?
> >
> > Here's the gist of the error message:
> >
> > Failure in create operation for entity [GlAccountOrganization]:
> > org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> > [GenericEntity:GlAccountOrganization][createdStamp,2021-03-14
> > 00:20:32.997(java.sql.Timestamp)][createdTxStamp,2021-03-14
> > 00:20:32.854(java.sql.Timestamp)][fromDate,2021-03-14
> > 00:20:32.979(java.sql.Timestamp)][glAccountId,100000(java.lang.String)]
> > [lastUpdatedStamp,2021-03-14 00:20:32.997(java.sql.Timestamp)]
> > [lastUpdatedTxStamp,2021-03-14 00:20:32.854(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.)). Rolling back transaction.
> >
> > Thanks,

[Jacques Le Roux]

Hi Szabolcs,

Did you then try to follow https://cwiki.apache.org/confluence/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide ?

HTH

Jacques

Le 22/03/2021 à 03:25, Szabolcs Szekelyi a écrit :

> Hi Jacques,
>
> Thanks for the tip. This time I erased my entire installation on the filesystem
> level, downloaded and extracted the most recent release 17.12.06, and followed
> the instructions on that page point by point. I'm still getting the same
> error.
>
> Any other ideas?
>
> Thanks,