Symptom

When attempting to make changes within an existing Sponsor Portal in ISE GUI and pressing the 'Save' button, ISE sits idle and nothing happens. The 'Save' button becomes greyed out, and the changes are not applied. Furthermore, upon navigating away from the page, ISE prompts you to discard the changes. No error messages are seen from the GUI. In ise-psc.logs, the following logs are seen: at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292] Caused by: com.google.gson.JsonParseException: The JsonDeserializer StringTypeAdapter failed to deserialized json object ["false","true"] given the type class java.lang.String. As there are multiple entries the map value for a key is string, while it should be a string(either ?true? or ?false?).

Conditions

Duplicate custom field value allowed in Guest Settings In the sponsor portal configuration under Portal Customization > 'Create Account for Known Guests', we can see that a single Custom Field contains duplicate entries.

Workaround

If there are duplicates custom fields and if those are referenced to any of the portal, then first we need to delete those references and then delete from the custom fields page. The issue is when duplicates are present for a particular portal we can't directly delete them through the UI as it is getting stuck. For that we need to execute a sql script in the DB so that the duplicate references get deleted for any portal using its name and the duplicate custom field GUID. DELETE FROM EDF_GUEST_SPNSR_GUEST_FIELD WHERE EDF_SPONSOR_GUEST_FIELD_GUID = ( SELECT EDF_SPONSOR_GUEST_FIELD_GUID FROM ( SELECT EDF_SPONSOR_GUEST_FIELD_GUID, ROW_NUMBER() OVER (ORDER BY EDF_SPONSOR_GUEST_FIELD_GUID) AS row_num FROM EDF_GUEST_PORTAL egp JOIN EDF_GUEST_PORTAL_FLOW egpf ON egp.EDF_PORTAL_GUID = egpf.PORTAL_ID JOIN EDF_GUEST_PORTAL_FLOW_STEP egpfs ON egpf.EDF_PORTAL_FLOW_GUID = egpfs.PORTAL_FLOW_ID JOIN EDF_GUEST_SPNSR_HOME_CFG egshc ON egpfs.EDF_PORTAL_FLOW_STEP_GUID = egshc.PORTAL_FLOW_STEP_ID JOIN EDF_GUEST_SPNSR_GUEST_FIELD egsgf ON egshc.EDF_STEP_CONFIG_GUID = egsgf.SPONSOR_HOME_CONFIG_ID JOIN EDF_GUEST_CREATE_FIELD egcf ON egsgf.GUEST_ACCOUNT_FIELD_ID = egcf.EDF_GUEST_CREATE_FIELD_GUID WHERE egp.PORTAL_NAME = 'Guest Sponsor Portal' AND egcf.EDF_GUEST_CREATE_FIELD_GUID = 'abc' ) temp WHERE row_num = 1 ); COMMIT; / Explanation: Lets say there are two duplicates referenced to portal 'Guest Sponsor Portal' and the duplicate custom field id(any of the duplicates id works as finally we only keep one of those field and delete all other duplicates) is 'abc'. Then the above script deletes one of the duplicate and keeps the other. Now we can delete the duplicate custom field from the GUI as its reference is removed through the sql script.

Further Problem Description