[OFBIZ-10523] You can't create a New Payment Group

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 16.11.04, 17.12.01, Trunk
• Fix Version/s: 16.11.05, 17.12.01
• Component/s: accounting
• Assignee: Jacques Le Roux
• Reporter: Jacques Le Roux
• Created: 14/Aug/18 16:42
• Updated: 14/Aug/18 17:16
• Resolved: 14/Aug/18 16:45

Description

I think this has never worked and nobody never cared to fix it. The error is

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

Obviously there is a duplicated paymentGroupTypeId, it should be a string not a list.