ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wolfgang Rauchholz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OFBIZ-10898) ofbizsetup ends with en arror message / https://localhost:8443/ofbizsetup/control/main
Date Fri, 05 Apr 2019 13:19:00 GMT

    [ 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)

Mime
View raw message