Re: Can't create initial organization

Posted by Szabolcs Szekelyi on
URL: http://ofbiz.116.s1.nabble.com/Can-t-create-initial-organization-tp4766384p4767048.html

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,