You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "Jacques Le Roux (JIRA)" <ji...@apache.org> on 2019/04/17 08:44:00 UTC
[jira] [Commented] (OFBIZ-10898) ofbizsetup ends with en error
message / https://localhost:8443/ofbizsetup/control/main
[ https://issues.apache.org/jira/browse/OFBIZ-10898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819859#comment-16819859 ]
Jacques Le Roux commented on OFBIZ-10898:
-----------------------------------------
Hi Wolfgang,
Sorry for the delay, I just tried after setting the seed ang got an error when creating the product store:
{noformat}
2019-04-17 09:03:02,250 |jsse-nio-8443-exec-7 |ScreenFactory |I| Got 9 screens in 0.012s from: file:/C:/projectsASF/ofbiz/plugins/ecommerce/widget/CartScreens.xml
2019-04-17 09:03:02,266 |jsse-nio-8443-exec-7 |FreeMarkerWorker |E| null
freemarker.core.InvalidReferenceException: The following has evaluated to null or missing:
==> catalogQuickaddUse [in template "component://ecommerce/template/includes/Header.ftl" at line 108, column 12]
----
Tip: If the failing expression is known to legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing</#if>. (Thes
e only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)??
----
----
FTL stack trace ("~" means nesting-related):
- Failed at: #if catalogQuickaddUse [in template "component://ecommerce/template/includes/Header.ftl" at line 108, column 7]
{noformat}
I think it's related to OFBIZ-10567 which has been fixed but maybe not in the case of seed only... I'll check...
> ofbizsetup ends with en error 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, OfbizSetupGlAccountData.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)