[jira] [Created] (OFBIZ-10907) Have additional Tree overviews of GlAccount records
Pierre Smits created OFBIZ-10907: Summary: Have additional Tree overviews of GlAccount records Key: OFBIZ-10907 URL: https://issues.apache.org/jira/browse/OFBIZ-10907 Project: OFBiz Issue Type: Improvement Components: accounting Reporter: Pierre Smits Currently there is only a tree like overview on GlAccount records based on the parentGlAccountId Other tree like overview on: * GlAccountTypeId * GlAccountClassId * GlResourceId -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (OFBIZ-10898) ofbizsetup ends with en arror message / https://localhost:8443/ofbizsetup/control/main
[
https://issues.apache.org/jira/browse/OFBIZ-10898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16811640#comment-16811640
]
Jacques Le Roux commented on OFBIZ-10898:
-
Wolfgang,
We need to clarify something. In SetupEvents.xml the setupDefaultGeneralLedger
event load the file [^OfbizSetupGlAccountData.xml] which is a parametrised file
with {{orgPartyId}} and {{fromDate}} parameters, eg the 1st line is :
{{}}
When I compare OfbizSetupGlAccountData with your [^GlAccount.xml] file I find
that some line are losely similar ({{GlAccountOrganization}} instead of
{{GlAccount}} for instanve. So it seems to me that we should be careful before
loading [^GlAccount.xml] as is. This needs more review to be sure we are not
going to fast.
Also we don't want fields like
{{lastUpdatedStamp="2019-03-09 11:31:12.037" lastUpdatedTxStamp="2019-03-09
11:31:12.005" createdStamp="2019-03-09 11:31:12.037" createdTxStamp="2019-03-09
11:31:12.005"}}
> 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, 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
> dataorg.xml.sax.SAXException: Error performing action
> CREATE_UPDATEorg.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,10(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 (10). 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,10(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 (10). 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,10(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
[jira] [Updated] (OFBIZ-10898) ofbizsetup ends with en arror message / https://localhost:8443/ofbizsetup/control/main
[ https://issues.apache.org/jira/browse/OFBIZ-10898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux updated OFBIZ-10898: Attachment: OfbizSetupGlAccountData.xml > 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, 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 > dataorg.xml.sax.SAXException: Error performing action > CREATE_UPDATEorg.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,10(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 (10). 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,10(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 (10). 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,10(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 (10). 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,10(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)
[jira] [Comment Edited] (OFBIZ-10898) ofbizsetup ends with en arror message / https://localhost:8443/ofbizsetup/control/main
[
https://issues.apache.org/jira/browse/OFBIZ-10898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16811614#comment-16811614
]
Jacques Le Roux edited comment on OFBIZ-10898 at 4/6/19 4:30 PM:
-
Fir with content
{noformat}
...
{noformat}
File generated from an export out of Web Tools from Ofbiz demo version. The
sequence of the records in this file were is slightly changed. I moved
...
File generated from an export out of Web Tools from Ofbiz demo version. The
sequence of the records in this file were is slightly changed. I moved
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
> dataorg.xml.sax.SAXException: Error performing action
> CREATE_UPDATEorg.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,10(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 (10). 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,10(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 (10). 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,10(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 (10). 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
>
[jira] [Commented] (OFBIZ-10898) ofbizsetup ends with en arror message / https://localhost:8443/ofbizsetup/control/main
[ https://issues.apache.org/jira/browse/OFBIZ-10898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16811633#comment-16811633 ] Jacques Le Roux commented on OFBIZ-10898: - I have attached [^GlAccount.xml] which is the file Wolfgang was referring to > 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 > dataorg.xml.sax.SAXException: Error performing action > CREATE_UPDATEorg.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,10(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 (10). 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,10(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 (10). 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,10(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 (10). 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,10(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, >
[jira] [Commented] (OFBIZ-10898) ofbizsetup ends with en arror message / https://localhost:8443/ofbizsetup/control/main
[ https://issues.apache.org/jira/browse/OFBIZ-10898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16811631#comment-16811631 ] Jacques Le Roux commented on OFBIZ-10898: - Damned, the visual mode of Jira is lying to me, showing multi lines and then when saved it's only one line :( > 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 > dataorg.xml.sax.SAXException: Error performing action > CREATE_UPDATEorg.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,10(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 (10). 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,10(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 (10). 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,10(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 (10). 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,10(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,
[jira] [Updated] (OFBIZ-10898) ofbizsetup ends with en arror message / https://localhost:8443/ofbizsetup/control/main
[
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
dataorg.xml.sax.SAXException: Error performing action
CREATE_UPDATEorg.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,10(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 (10). 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,10(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 (10). 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,10(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 (10). 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,10(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 (10). 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
dataorg.xml.sax.SAXException: Error
[jira] [Updated] (OFBIZ-10898) ofbizsetup ends with en arror message / https://localhost:8443/ofbizsetup/control/main
[
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:
{noformat}
Error:ERROR: parsing file: ERROR parsing Entity Xml file:
org.xml.sax.SAXException: A transaction error occurred reading
dataorg.xml.sax.SAXException: Error performing action
CREATE_UPDATEorg.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,10(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 (10). 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,10(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 (10). 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,10(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 (10). 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,10(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 (10). The statement has been rolled back.
Collapse
{noformat}
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:
Error:ERROR: parsing file: ERROR parsing Entity Xml file:
org.xml.sax.SAXException: A transaction error occurred reading
[jira] [Updated] (OFBIZ-10898) ofbizsetup ends with en arror message / https://localhost:8443/ofbizsetup/control/main
[ https://issues.apache.org/jira/browse/OFBIZ-10898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux updated OFBIZ-10898: Attachment: GlAccount.xml > 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 > dataorg.xml.sax.SAXException: Error performing action > CREATE_UPDATEorg.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,10(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 (10). 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,10(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 (10). 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,10(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 (10). 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,10(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 (?, ?, ?, ?, > ?, ?, ?, ?, ?)
[jira] [Commented] (OFBIZ-10898) ofbizsetup ends with en arror message / https://localhost:8443/ofbizsetup/control/main
[ https://issues.apache.org/jira/browse/OFBIZ-10898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16811614#comment-16811614 ] Wolfgang Rauchholz commented on OFBIZ-10898: Fir with content ... File generated from an export out of Web Tools from Ofbiz demo version. The sequence of the records in this file were is slightly changed. I moved 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 > dataorg.xml.sax.SAXException: Error performing action > CREATE_UPDATEorg.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,10(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 (10). 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,10(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 (10). 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,10(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 (10). 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,10(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
[jira] [Commented] (OFBIZ-9290) Have the ability to edit/remove terms of an invoice
[ https://issues.apache.org/jira/browse/OFBIZ-9290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16811559#comment-16811559 ] Jacques Le Roux commented on OFBIZ-9290: Hi Pierre, You mean you tested the patch in R16 and you did not cross the null values in fields when editing? > Have the ability to edit/remove terms of an invoice > --- > > Key: OFBIZ-9290 > URL: https://issues.apache.org/jira/browse/OFBIZ-9290 > Project: OFBiz > Issue Type: Improvement > Components: accounting >Affects Versions: Release Branch 13.07, Release Branch 14.12, Trunk, > Release Branch 15.12, Release Branch 16.11, Release Branch 17.12, Release > Branch 18.12 >Reporter: Pierre Smits >Assignee: Jacques Le Roux >Priority: Major > Attachments: OFBIZ-9290.patch > > > Currently the user has the ability to add terms to an invoice, but doesn't > have the functions to edit or remove existing terms. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (OFBIZ-10898) ofbizsetup ends with en arror message / https://localhost:8443/ofbizsetup/control/main
[ https://issues.apache.org/jira/browse/OFBIZ-10898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16811558#comment-16811558 ] Jacques Le Roux commented on OFBIZ-10898: - Wolfgang, There is no GlAccount.xml file in trunk. Which file do you refer to exactly, OfbizSetupGlAccountData? > 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 > dataorg.xml.sax.SAXException: Error performing action > CREATE_UPDATEorg.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,10(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 (10). 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,10(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 (10). 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,10(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 (10). 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,10(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, >
[jira] [Commented] (OFBIZ-7532) Form Display Field improvement to manage multiple number format
[ https://issues.apache.org/jira/browse/OFBIZ-7532?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16811556#comment-16811556 ] Jacques Le Roux commented on OFBIZ-7532: The patch looks good to me, I did not test only reviewed: +1 > Form Display Field improvement to manage multiple number format > --- > > Key: OFBIZ-7532 > URL: https://issues.apache.org/jira/browse/OFBIZ-7532 > Project: OFBiz > Issue Type: Improvement > Components: ALL COMPONENTS >Affects Versions: Trunk >Reporter: Charles STELTZLEN >Assignee: Jacques Le Roux >Priority: Minor > Attachments: OFBIZ-7532.patch, OFBIZ-7532.patch > > > On display field used in forms, there is a "type" "accounting-number" which > is used to format number like property configuration : > #,##0.;(#,##0.). > This JIRA propose to extend this idea by using a "type" "number" and an > additional attribute called "format-pattern". This field will be used by form > renderer to get the good property. It use FlexibleString to manage variable > in this field and so allow to have different format for the same column > according to some conditions. > example: format-pattern="accounting"/> > The "format-pattern" will be stored in arithmetic.properties. > example: > # the default number format > default.number.format = ##0.00 > accounting.number.format = #,##0.;(#,##0.) > quantity.number.format = ##0.00 > integer-quantity.number.format = #0 > percentage.number.format = ##.##% > export.number.format = #.00 > In ModelFormField.java, the system gets property using > EntityUtilProperties.getPropertyValue to ba able to quickly add a new format. > I think that it will require a discussion on Dev mailing-list to validate the > choices. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (OFBIZ-10817) Configure stackTrace displaying on ftl rendering
[
https://issues.apache.org/jira/browse/OFBIZ-10817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16811523#comment-16811523
]
Jacques Le Roux commented on OFBIZ-10817:
-
Thanks Nicolas,
Your example works!
Actually you don't need a patch simply remove a # in (for instance) product
Main.ftl. You will see that in this case (same for main.ftl in ecommerce, etc.
I guess) there is no stack trace OOTB.
If you use the above widget .properties setting, to be clear I copy mine :):
{noformat}
Index: widget.properties
===
--- widget.properties (revision 1857048)
+++ widget.properties (working copy)
@@ -25,7 +25,7 @@
# overridden in an application's web.xml file or in the screen rendering
context.
# A setting of false will override all other settings and disable all widget
# boundary comments.
-widget.verbose=true
+widget.verbose=false
# Default number of items to be displayed per page in a list form
widget.form.defaultViewSize=20
@@ -48,4 +48,4 @@
# When you don't displaying freemarker stacktrace, you can replace it by an
other message
# by default it use ∎ but you can set what you want, like 'ERROR', '##' or ' '
-#widget.freemarker.template.exception.message=
+widget.freemarker.template.exception.message=ERROR ERROR ERROR
{noformat}
and get to product component you will see no "ERROR ERROR ERROR" but the same
error than OOTB, ie:
{noformat}
Catalog Administration Main Page
Error rendering included template at location
[component://product/template/Main.ftl]: freemarker.core.ParseException: Syntax
error in template "component://product/template/Main.ftl" in line 23, column 1:
Unexpected directive, "". Check if you have a valid #if-#elseif-#else
structure.{noformat}
> Configure stackTrace displaying on ftl rendering
>
>
> Key: OFBIZ-10817
> URL: https://issues.apache.org/jira/browse/OFBIZ-10817
> Project: OFBiz
> Issue Type: Improvement
> Components: framework
>Affects Versions: Trunk
>Reporter: Nicolas Malin
>Assignee: Nicolas Malin
>Priority: Minor
> Attachments: Failure.png, FailureSafe.png, OFBIZ-10817.patch,
> OFBIZ-10817.patch, OFBIZ-10817.patch, Sélection_236.png, Sélection_237.png
>
>
> Currently when freemarker failed to execute a template, you have on end
> screen rendered all java stack trace generate.
> I propose to improve this to display the stack trace only when the property
> widget.verbose is true, no regression during development and when you switch
> to production site, in general your widget.verbose is false so end user
> haven't stack trace (that totally unused for them).
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (OFBIZ-7532) Form Display Field improvement to manage multiple number format
[ https://issues.apache.org/jira/browse/OFBIZ-7532?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16811513#comment-16811513 ] Jacques Le Roux commented on OFBIZ-7532: Hi Nicolas, looking forward :) > Form Display Field improvement to manage multiple number format > --- > > Key: OFBIZ-7532 > URL: https://issues.apache.org/jira/browse/OFBIZ-7532 > Project: OFBiz > Issue Type: Improvement > Components: ALL COMPONENTS >Affects Versions: Trunk >Reporter: Charles STELTZLEN >Assignee: Jacques Le Roux >Priority: Minor > Attachments: OFBIZ-7532.patch, OFBIZ-7532.patch > > > On display field used in forms, there is a "type" "accounting-number" which > is used to format number like property configuration : > #,##0.;(#,##0.). > This JIRA propose to extend this idea by using a "type" "number" and an > additional attribute called "format-pattern". This field will be used by form > renderer to get the good property. It use FlexibleString to manage variable > in this field and so allow to have different format for the same column > according to some conditions. > example: format-pattern="accounting"/> > The "format-pattern" will be stored in arithmetic.properties. > example: > # the default number format > default.number.format = ##0.00 > accounting.number.format = #,##0.;(#,##0.) > quantity.number.format = ##0.00 > integer-quantity.number.format = #0 > percentage.number.format = ##.##% > export.number.format = #.00 > In ModelFormField.java, the system gets property using > EntityUtilProperties.getPropertyValue to ba able to quickly add a new format. > I think that it will require a discussion on Dev mailing-list to validate the > choices. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
