Handle null values for address fields in Implementation Inventory GET API response

[himeshr]

Vinay found 365 entries of ImplementationInventory.. where address_id field is null. Its caused by following fields coming as null in the Goonj Salesforce "Get ImplementationInventories" API: "CenterFieldOfficeState": null, "CenterFieldOfficeDistrict": null,

Tasks:

• We need to handle Null values for address fields in all Goonj entities synced from Goonj Salesforce to Avni.
• Void all existing ImplementationInventory with addressIds null in DB (Post deploy of above fix)

Code place:

Subject.java: public void setAddress(String address) { map.put(AddressFieldName, address); }

[himeshr]

This bug has been fixed in Salesforce. ImplementationInventory wont send null values anymore. Ran the below command for entries in prod with null addressId: update individual set address_id = 413044, last_modified_date_time = current_timestamp + ((id) * interval '1 millisecond') where address_id is null and subject_type_id = 1020;

[ashusvnath]

@himeshr : How many records are updated by the script you provided in the comment ? Are all the 365 entries fixed ?