[
https://issues.apache.org/jira/browse/OFBIZ-10898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Le Roux updated OFBIZ-10898:
------------------------------------
Description:
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
was:
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:
{noformat}
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
{noformat}
> 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)
