[ https://issues.apache.org/jira/browse/OFBIZ-10898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16810776#comment-16810776 ]
Jacques Le Roux commented on OFBIZ-10898: ----------------------------------------- Thanks Wolfgang, We could update the OFBiz setup by loading this file. Anything else you crossed which could be useful? > 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)