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,
