Re: Can't create initial organization

Posted by Jacques Le Roux on
URL: http://ofbiz.116.s1.nabble.com/Can-t-create-initial-organization-tp4766384p4766744.html

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,