[
https://issues.apache.org/jira/browse/FINERACT-1451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Francis Guchie reassigned FINERACT-1451:
----------------------------------------
Assignee: Francis Guchie
> Beneficiary: unable to add a second beneficiary (same name as first, but
> different accountNo/currency)
> ------------------------------------------------------------------------------------------------------
>
> Key: FINERACT-1451
> URL: https://issues.apache.org/jira/browse/FINERACT-1451
> Project: Apache Fineract
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.5.0
> Reporter: Thomas Kerin
> Assignee: Francis Guchie
> Priority: Major
>
> 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, ap{}}}{{{}p_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
> | | |}}
> {{{+}--------------------------------{-}{-}{+}----------{-}++{-}--------{-}{-}------------{-}++{-}-----------{-}{-}---------{-}++{-}-----------{-}{-}--------{-}++{-}------{-}{-}----{-}++{-}----------{-}{-}-------{-}++{-}--------------}}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
