[
https://issues.apache.org/jira/browse/OFBIZ-10898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16810815#comment-16810815
]
Wolfgang Rauchholz commented on OFBIZ-10898:
--------------------------------------------
Yes,
# Customer; currently also a work-around is required to setup the customer. The
password for the user is not shown on the screen and therefor it throws out an
error. The workaround here to is to open a new tab and create the customer
going through Party Mgr > Create Customer (needs to be done after creating the
store, as this is a mandatory filed too.
# It would be nice to allow default currency being selected rather than going
to Web Tool > Entity Management
# Maybe more for the future one could consider to allow user to chose COA from
different countries to be loaded (I will try with help from others to create an
XML file for Spanish COA. You should see an email soon)
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
>
> 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)
