[FINERACT-1451] Beneficiary: unable to add a second beneficiary (same name as first, but different accountNo/currency)

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.5.0
• Component/s: Database
• Assignee: Francis Guchie
• Reporter: Thomas Kerin
• Created: 22/Dec/21 18:28
• Updated: 22/Mar/23 11:26

Description

The 'name' index on the m_selfservice_beneficiaries_tpt table prevents a client from adding two

 

Server error:

Duplicate entry 'Clint Westwood-4-\x01' for key 'name' {prepstmnt 128161655 INSERT INTO m_selfservice_beneficiaries_tpt (account_id, account_type, app_user_id, client_id, is_active, name, office_id, transfer_limit) VALUES (?, ?, ?, ?, ?, ?, ?, ?)} [code=1062, state=23000]

 

mysql> show index from m_selfservice_beneficiaries_tpt;
-------------------------------{}--------{}+{}------{}{}----------{}{}---------{}{}-------{}{}---------{}{}------{}{}----{}{}--{}{}--------{}{}-----{}+{}-------------
| Table                           | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
-------------------------------{}--------{}+{}------{}{}----------{}{}---------{}{}-------{}{}---------{}{}------{}{}----{}{}--{}{}--------{}{}-----{}+{}-------------
| m_selfservice_beneficiaries_tpt |          0 | PRIMARY  |            1 | id          | A         |           1 |     NULL | NULL   |      | BTREE      |         |               |
| m_selfservice_beneficiaries_tpt |          0 | name     |            1 | name        | A         |           1 |     NULL | NULL   |      | BTREE      |         |               |
| m_selfservice_beneficiaries_tpt |          0 | name     |            2 | app_user_id | A         |           1 |     NULL | NULL   |      | BTREE      |         |               |
| m_selfservice_beneficiaries_tpt |          0 | name     |            3 | is_active   | A         |           1 |     NULL | NULL   |      | BTREE      |         |               |
-------------------------------{}--------{}+{}------{}{}----------{}{}---------{}{}-------{}{}---------{}{}------{}{}----{}{}--{}{}--------{}{}-----{}+{}-------------