Re: Can't create initial organization

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

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