Describe the bug
Bug discovered as part of this ticket.
When user attempts to perform Location CSV Upload to update location properties, in-case the update location addressLevel's parent's name is not unique for that addressLevelType in the organisation, then the upload of that entry fails with UniqueConstraint exception.
Exception message:
org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2; nested exception is javax.persistence.NonUniqueResultException: query did not return a unique result: 2
To Reproduce
Steps to reproduce the behavior:
Create/upload Locations such that the last but one addressLevelType from the bottom has 2 different addressLevels with same title but different lineages.
Attempt to update properties for any of the children of the above parent addressLevel using "Create+edit" mode
Upload fails with "NonUniqueResultException" exception
Expected behavior
Location CSV Upload to update location properties is successul even when addressLevel's parent's name is not unique for that addressLevelType in the organisation
Describe the bug Bug discovered as part of this ticket. When user attempts to perform Location CSV Upload to update location properties, in-case the update location addressLevel's parent's name is not unique for that addressLevelType in the organisation, then the upload of that entry fails with UniqueConstraint exception.
Exception message: org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2; nested exception is javax.persistence.NonUniqueResultException: query did not return a unique result: 2
To Reproduce Steps to reproduce the behavior:
Refer this ticket for error case.
Expected behavior Location CSV Upload to update location properties is successul even when addressLevel's parent's name is not unique for that addressLevelType in the organisation
Additional Information ErrorStackTrace-3897.txt
Developer Checklist Developer fixing the bug should fill this checklist.