KB-2238 "The username <UUID> is not a valid user" error when accessing the Infrastructure page of the Admin Console

Symptoms

The following error is seen when attempting to access the Infrastructure page of the Admin Console:

Corresponding error in the application server log:

ERROR com.appiancorp.rest.shared.AppianExceptionMapper - Internal Server Error on REST API invocation.
com.appiancorp.exceptions.LocalizedAppianRuntimeException$LocalizedAppianException: 
Expression evaluation error [evaluation ID = 3a5d4:caf85] : The username <UUID> is not a valid user. (APNX-1-4198-000)
... 
Caused by: ObjectNotFoundException[<UUID>]: The username <UUID> is not a valid user. (APNX-1-4100-000)

The user in the error corresponds to a user from another environment, but there is no connected infrastructure set up between these two environments.

Cause

The Admin Console settings were imported from another environment and the referenced user does not exist in the affected environment.

Action

1. Check whether the cfg table in the primary database references the invalid user's UUID:

   select * from cfg where prop_key = "conf.designDeployment.DEPLOYMENT_USER_UUID" OR prop_key = "conf.designDeployment.AUTHENTICATE_AS_USER_UUID";

2. If so, run the following and save the output in case the above properties need to be reverted:

   select * from cfg where prop_key = "conf.designDeployment.DEPLOYMENT_USER_UUID" OR prop_key = "conf.designDeployment.AUTHENTICATE_AS_USER_UUID";

3. Clear these properties:

   update cfg set isDefault = 1 prop_value = NULL where prop_key = "conf.designDeployment.DEPLOYMENT_USER_UUID" OR prop_key = "conf.designDeployment.AUTHENTICATE_AS_USER_UUID";

Affected Versions

This article applies to all self-managed versions of Appian.

Last Reviewed: May 2023