Re: Fwd: [jira] [Commented] (OFBIZ-10898) ofbizsetup ends with en arror message / https://localhost:8443/ofbizsetup/control/main

[Jacques Le Roux]

Hi Wolfgang,

Thanks, it would have been much easier to attach this file directly to Jira, so then everyone, and not only me, could work on it ;)

Anyway I just did it for you, and again thanks for your help, much appreciated

Jacques

Le 06/04/2019 à 17:23, Wolfgang Paul Rauchholz a écrit :

> Hi Jacques, as I cannot send an attachment through mailing list, here the file also directly.
> Generated from an export out of Web Tools from Ofbiz demo version. The sequence of the records in this file were It is slightly changed. I moved
> <GlAccount glAccountId="126000" to the end. As its  parentGlAccountId="200000" is creates an error report if uploaded before.
>
> Wolfgang
>
>
>
> ---------- Forwarded message ---------
> From: *Jacques Le Roux (JIRA)* <[hidden email] <mailto:[hidden email]>>
> Date: Sat, Apr 6, 2019 at 1:20 PM
> Subject: [jira] [Commented] (OFBIZ-10898) ofbizsetup ends with en arror message / https://localhost:8443/ofbizsetup/control/main
> To: <[hidden email] <mailto:[hidden email]>>
>
>
>
>     [
> https://issues.apache.org/jira/browse/OFBIZ-10898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16811558#comment-16811558 
> ]
>
> Jacques Le Roux commented on OFBIZ-10898:
> -----------------------------------------
>
> Wolfgang,
>
> There is no GlAccount.xml file in trunk. Which file do you refer to exactly, OfbizSetupGlAccountData?
>
> > ofbizsetup ends with en arror message / https://localhost:8443/ofbizsetup/control/main
> > --------------------------------------------------------------------------------------
> >
> >                 Key: OFBIZ-10898
> >                 URL: https://issues.apache.org/jira/browse/OFBIZ-10898
> >             Project: OFBiz
> >          Issue Type: Bug
> >          Components: accounting
> >    Affects Versions: 17.12.01
> >            Reporter: Wolfgang Rauchholz
> >            Priority: Major
> >
> > At the end of the setup procedure (Shop, Website, Customer, ... Product created) when hitting the button 'Set to complete', the error message as
> depicted underneath is shown:
> > Catalog, Category and Shop, Website and Product were created.
> > The financial side of Ofbiz was not created.
> > The Following Errors Occurred:
> > 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,2019-03-31 19:41:20.655(java.sql.Timestamp)][createdTxStamp,2019-03-31
> 19:41:20.247(java.sql.Timestamp)][fromDate,2019-03-31
> 19:41:20.623(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2019-03-31
> 19:41:20.655(java.sql.Timestamp)][lastUpdatedTxStamp,2019-03-31 19:41:20.247(java.sql.Timestamp)][organizationPartyId,Company(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,2019-03-31
> 19:41:20.655(java.sql.Timestamp)][createdTxStamp,2019-03-31 19:41:20.247(java.sql.Timestamp)][fromDate,2019-03-31
> 19:41:20.623(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2019-03-31
> 19:41:20.655(java.sql.Timestamp)][lastUpdatedTxStamp,2019-03-31 19:41:20.247(java.sql.Timestamp)][organizationPartyId,Company(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,2019-03-31
> 19:41:20.655(java.sql.Timestamp)][createdTxStamp,2019-03-31 19:41:20.247(java.sql.Timestamp)][fromDate,2019-03-31
> 19:41:20.623(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2019-03-31
> 19:41:20.655(java.sql.Timestamp)][lastUpdatedTxStamp,2019-03-31 19:41:20.247(java.sql.Timestamp)][organizationPartyId,Company(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,2019-03-31
> 19:41:20.655(java.sql.Timestamp)][createdTxStamp,2019-03-31 19:41:20.247(java.sql.Timestamp)][fromDate,2019-03-31
> 19:41:20.623(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2019-03-31
> 19:41:20.655(java.sql.Timestamp)][lastUpdatedTxStamp,2019-03-31 19:41:20.247(java.sql.Timestamp)][organizationPartyId,Company(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.))))
> > Collapse
>
>
>
> --
> This message was sent by Atlassian JIRA
> (v7.6.3#76005)
>
>
> --
>
> Wolfgang Rauchholz
>
>
>