KB-2066 Connected systems object authorization fails with "query did not return a unique result" following import

Symptoms

After importing a Connected System object from one environment to another and attempting to authorize the object, the below error is thrown:

The System Has Encountered an Error 
HTTP Code: 500 
APNX-X-XXXX-XXX 

Error Evaluating UI Expression Expression evaluation error [evaluation ID = XXXXXXXX] : [valid:false,syntaxError:false,value:Expression evaluation error: An error occurred while executing a save: org.hibernate.NonUniqueResultException: query did not return a unique result: X]

Cause

This issue has been reported to the Appian Product Team. The reference number for this issue is AN-147907.

Action

Delete the Connected System that fails to authorize and re-import it.

Affected Versions

This article applies to Appian 18.1 and later.

Last Reviewed: January 2020