Re: Can't create initial organization

Posted by deepak nigam-2 on
URL: http://ofbiz.116.s1.nabble.com/Can-t-create-initial-organization-tp4766384p4766390.html

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