In RWB in csv upload there is location type dam/nalla is not accepting the value

[AchalaBelokar]

Describe the bug
In RWB in csv upload there is location type dam/nalla is not accepting the value
https://app.rwb.avniproject.org
Login with AchalaB@rwb24uat
prod Staging.csv
tried with csv it is giving invalid address but it is valid user

To Reproduce
Steps to reproduce the behavior:

1. Login with AchalaB@rwb24uat
2. click on admin
3. click on upload
4. upload csv on farmer registration
5. see the error

Analysis:

Identify if some fix made in Avni need to be released to rwb env or new fix needed, since RWB env frequently deals with CSV uploads.

[mahalakshme]

@AchalaBelokar did the above issue happen in prerelease also?

[1t5j0y]

Issue is because subject csv upload does not currently handle having multiple location types at the lowest level.

SubjectWriter.write sorts the locationTypes by level and calls AddressLevelCreator.findAddressLevel which uses only the last element for further processing.

For setups where multiple location types are at the same lowest level, different location types could be referred to in different runs.

Not fixing immediately as prod orgs don't have setups like this typically or do not use the different locationTypes at the lowest level even if setup. Moving to hold.