[jira] [Commented] (FINERACT-1314) Client Familiy Details Edit not working from client view screen

["Benura Abeywardena (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FINERACT-1314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17350584#comment-17350584 ] 

Benura Abeywardena commented on FINERACT-1314:
----------------------------------------------

[~bgowda] Hi sir, would you mind verifying the changes done in the PR?

> Client Familiy Details Edit not working from client view screen
> ---------------------------------------------------------------
>
>                 Key: FINERACT-1314
>                 URL: https://issues.apache.org/jira/browse/FINERACT-1314
>             Project: Apache Fineract
>          Issue Type: Bug
>    Affects Versions: 1.4.0
>            Reporter: bharath gowda
>            Assignee: Benura Abeywardena
>            Priority: Minor
>
> Edit option of client family details is not working.
>  
> To reproduce,
>  # Add family details to the client(do not add profession, gender, and marital status)
>  # Edit the family details and change any field.
> The system will not accept and the error is not handled in the system
> In the Inspect mode, the system is throwing an internal exception for "profession, marital and gender status_cv_id " even though these parameters are not mandatory
>  
> Expected behavior, the system should allow to Edit the family details, even when profession, marital and gender fields are not entered.
>  
> Exception example is below
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Cannot add or upda
> te a child row: a foreign key constraint fails (`fineract_default`.`m_family_mem
> bers`, CONSTRAINT `FK_m_family_members_profession_m_code_value` FOREIGN KEY (`pr
> ofession_cv_id`) REFERENCES `m_code_value` (`id`)) {prepstmnt 1120209371 UPDATE
> m_family_members SET age = ?, firstname = ?, gender_cv_id = ?, marital_status_cv
> _id = ?, profession_cv_id = ? WHERE id = ?} [code=1452, state=23000]
>  
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)