[FINERACT-1314] Client Familiy Details Edit not working from client view screen

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.4.0
• Fix Version/s: 1.6.0
• Assignee: Benura Abeywardena
• Reporter: Bharath Gowda
• Created: 04/Feb/21 13:19
• Updated: 21/Sep/21 13:51
• Resolved: 21/Sep/21 13:51

Description

Edit option of client family details is not working.

 

To reproduce,

1. Add family details to the client(do not add profession, gender, and marital status)
2. 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]

 

 

Issue Links

• Blocked: FINERACT-1305 Release Apache Fineract v1.5.0
• Blocked: FINERACT-866 Improve Robustness of Mifos X and Apache Fineract by Fixing Issues/Feature Requests in Backlog
• links to: GitHub Pull Request #1735