[jira] [Updated] (OFBIZ-10523) You can't create a New Payment Group

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-10523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux updated OFBIZ-10523:
------------------------------------
    Description:
I think this has never worked and nobody never cared to fix it. The error is
{noformat}
Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:PaymentGroup][createdStamp,2018-08-14 18:33:40.669(java.sql.Timestamp)][createdTxStamp,2018-08-14 18:33:40.668(
 java.sql.Timestamp)][lastUpdatedStamp,2018-08-14 18:33:40.669(java.sql.Timestamp)][lastUpdatedTxStamp,2018-08-14 18:33:40.668(java.sql.Timestamp)][paymentGroupId,10050(java.lang.String)][paymentGroupName,Demo
 customer checks(java.lang.String)][paymentGroupTypeId,[, CHECK_RUN](java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PAYMENT_GROUP (PAYMENT_GROUP_ID, PAYMENT_GROUP_TYPE_ID, P
 AYMENT_GROUP_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PAYMENT_GROUP' caused a violation of foreign key constraint 'PAYMN
 TGP_PGTYPE' for key ([, CHECK_RUN]). The statement has been rolled back.))
 {noformat}
 Obviously there is a duplicated paymentGroupTypeId, it should be a string not a list.

  was:
I think this has never worked and nobody never cared to fix it. The error is
{noformat}
Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:PaymentGroup][createdStamp,2018-08-14 18:33:40.669(java.sql.Timestamp)][createdTxStamp,2018-08-14 18:33:40.668(
 java.sql.Timestamp)][lastUpdatedStamp,2018-08-14 18:33:40.669(java.sql.Timestamp)][lastUpdatedTxStamp,2018-08-14 18:33:40.668(java.sql.Timestamp)][paymentGroupId,10050(java.lang.String)][paymentGroupName,Demo
 customer checks(java.lang.String)][paymentGroupTypeId,[, CHECK_RUN](java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PAYMENT_GROUP (PAYMENT_GROUP_ID, PAYMENT_GROUP_TYPE_ID, P
 AYMENT_GROUP_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PAYMENT_GROUP' caused a violation of foreign key constraint 'PAYMN
 TGP_PGTYPE' for key ([, CHECK_RUN]). The statement has been rolled back.))
 {noformat}
 Obviously there is a duplicated paymentGroupTypeId, it should a string not a list.

> You can't create a New Payment Group
> ------------------------------------
>
>                 Key: OFBIZ-10523
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-10523
>             Project: OFBiz
>          Issue Type: Bug
>          Components: accounting
>    Affects Versions: Trunk, 17.12.01, 16.11.04
>            Reporter: Jacques Le Roux
>            Assignee: Jacques Le Roux
>            Priority: Major
>             Fix For: 17.12.01, 16.11.05
>
>
> I think this has never worked and nobody never cared to fix it. The error is
> {noformat}
> Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:PaymentGroup][createdStamp,2018-08-14 18:33:40.669(java.sql.Timestamp)][createdTxStamp,2018-08-14 18:33:40.668(
>  java.sql.Timestamp)][lastUpdatedStamp,2018-08-14 18:33:40.669(java.sql.Timestamp)][lastUpdatedTxStamp,2018-08-14 18:33:40.668(java.sql.Timestamp)][paymentGroupId,10050(java.lang.String)][paymentGroupName,Demo
>  customer checks(java.lang.String)][paymentGroupTypeId,[, CHECK_RUN](java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PAYMENT_GROUP (PAYMENT_GROUP_ID, PAYMENT_GROUP_TYPE_ID, P
>  AYMENT_GROUP_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PAYMENT_GROUP' caused a violation of foreign key constraint 'PAYMN
>  TGP_PGTYPE' for key ([, CHECK_RUN]). The statement has been rolled back.))
>  {noformat}
>  Obviously there is a duplicated paymentGroupTypeId, it should be a string not a list.

--
This message was sent by Atlassian JIRA
(v7.6.3#76005)