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

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-10898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16811614#comment-16811614 ]

Jacques Le Roux edited comment on OFBIZ-10898 at 4/6/19 4:30 PM:
-----------------------------------------------------------------

Fir with content

{noformat}
<?xml version="1.0" encoding="UTF-8"?>
<entity-engine-xml>
    <GlAccount glAccountId="100000" glAccountClassId="ASSET" glResourceTypeId="MONEY" accountCode="100000" accountName="ASSETS" lastUpdatedStamp="2019-03-09 11:31:12.037" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.037" createdTxStamp="2019-03-09 11:31:12.005"/>
    <GlAccount glAccountId="110000" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="100000" accountCode="110000" accountName="CASH" lastUpdatedStamp="2019-03-09 11:31:12.089" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.089" createdTxStamp="2019-03-09 11:31:12.005"/>
    <GlAccount glAccountId="111000" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="110000" accountCode="111000" accountName="CASH IN BANK AND ON HAND" lastUpdatedStamp="2019-03-09 11:31:12.09" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.09" createdTxStamp="2019-03-09 11:31:12.005"/>
    <GlAccount glAccountId="111100" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="111000" accountCode="111100" accountName="GENERAL CHECKING ACCOUNT" lastUpdatedStamp="2019-03-09 11:31:12.091" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.091" createdTxStamp="2019-03-09 11:31:12.005"/>
    <GlAccount glAccountId="111200" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="111000" accountCode="111200" accountName="PAYROLL CHECKING ACCOUNT" lastUpdatedStamp="2019-03-09 11:31:12.092" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.092" createdTxStamp="2019-03-09 11:31:12.005"/>
.......

    <GlAccount glAccountId="902000" glAccountClassId="NON_POSTING" glResourceTypeId="MONEY" parentGlAccountId="900000" accountCode="902000" accountName="STATE INCOME TAX" lastUpdatedStamp="2019-03-09 11:31:12.55" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.55" createdTxStamp="2019-03-09 11:31:12.005"/>
    <GlAccount glAccountId="903000" glAccountClassId="NON_POSTING" glResourceTypeId="MONEY" parentGlAccountId="900000" accountCode="903000" accountName="LOCAL INCOME TAX" lastUpdatedStamp="2019-03-09 11:31:12.551" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.551" createdTxStamp="2019-03-09 11:31:12.005"/>
        <GlAccount glAccountId="126000" glAccountTypeId="ACCREC_UNAPPLIED" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="200000" accountCode="126000" accountName="ACCOUNTS RECEIVABLE - UNAPPLIED PAYMENTS" lastUpdatedStamp="2019-03-09 11:31:12.179" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.179" createdTxStamp="2019-03-09 11:31:12.005"/>
</entity-engine-xml>

{noformat}

File generated  from an export out of Web Tools from Ofbiz demo version. The sequence of the records in this file were is slightly changed. I moved
<GlAccount glAccountId="126000" to the end. As its  parentGlAccountId="200000" it creates an error report if uploaded before.

Wolfgang


was (Author: wp.rauchholz):
Fir with content
<?xml version="1.0" encoding="UTF-8"?>
<entity-engine-xml>
    <GlAccount glAccountId="100000" glAccountClassId="ASSET" glResourceTypeId="MONEY" accountCode="100000" accountName="ASSETS" lastUpdatedStamp="2019-03-09 11:31:12.037" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.037" createdTxStamp="2019-03-09 11:31:12.005"/>
    <GlAccount glAccountId="110000" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="100000" accountCode="110000" accountName="CASH" lastUpdatedStamp="2019-03-09 11:31:12.089" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.089" createdTxStamp="2019-03-09 11:31:12.005"/>
    <GlAccount glAccountId="111000" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="110000" accountCode="111000" accountName="CASH IN BANK AND ON HAND" lastUpdatedStamp="2019-03-09 11:31:12.09" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.09" createdTxStamp="2019-03-09 11:31:12.005"/>
    <GlAccount glAccountId="111100" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="111000" accountCode="111100" accountName="GENERAL CHECKING ACCOUNT" lastUpdatedStamp="2019-03-09 11:31:12.091" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.091" createdTxStamp="2019-03-09 11:31:12.005"/>
    <GlAccount glAccountId="111200" glAccountTypeId="CURRENT_ASSET" glAccountClassId="CASH_EQUIVALENT" glResourceTypeId="MONEY" parentGlAccountId="111000" accountCode="111200" accountName="PAYROLL CHECKING ACCOUNT" lastUpdatedStamp="2019-03-09 11:31:12.092" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.092" createdTxStamp="2019-03-09 11:31:12.005"/>
.......

    <GlAccount glAccountId="902000" glAccountClassId="NON_POSTING" glResourceTypeId="MONEY" parentGlAccountId="900000" accountCode="902000" accountName="STATE INCOME TAX" lastUpdatedStamp="2019-03-09 11:31:12.55" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.55" createdTxStamp="2019-03-09 11:31:12.005"/>
    <GlAccount glAccountId="903000" glAccountClassId="NON_POSTING" glResourceTypeId="MONEY" parentGlAccountId="900000" accountCode="903000" accountName="LOCAL INCOME TAX" lastUpdatedStamp="2019-03-09 11:31:12.551" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.551" createdTxStamp="2019-03-09 11:31:12.005"/>
        <GlAccount glAccountId="126000" glAccountTypeId="ACCREC_UNAPPLIED" glAccountClassId="CURRENT_LIABILITY" glResourceTypeId="MONEY" parentGlAccountId="200000" accountCode="126000" accountName="ACCOUNTS RECEIVABLE - UNAPPLIED PAYMENTS" lastUpdatedStamp="2019-03-09 11:31:12.179" lastUpdatedTxStamp="2019-03-09 11:31:12.005" createdStamp="2019-03-09 11:31:12.179" createdTxStamp="2019-03-09 11:31:12.005"/>
</entity-engine-xml>

File generated  from an export out of Web Tools from Ofbiz demo version. The sequence of the records in this file were is slightly changed. I moved
<GlAccount glAccountId="126000" to the end. As its  parentGlAccountId="200000" it creates an error report if uploaded before.

Wolfgang

> 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
>         Attachments: GlAccount.xml
>
>
> 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)