You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@fineract.apache.org by "Francis Guchie (Jira)" <ji...@apache.org> on 2023/03/22 11:27:00 UTC
[jira] [Assigned] (FINERACT-1451) Beneficiary: unable to add a second beneficiary (same name as first, but different accountNo/currency)
[ 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)