KB-2110 Health Check stuck on the "Analyze Data" stage in Appian 19.4

Symptoms

The Appian Health Check is stuck on the "Analyze Data" stage, typically on the first execution of the Health Check. No Appian Health Check errors are printed in the tomcat-stdOut.log.

Cause

There is no timeout specified for the HTTP connection to Appian Forum. This issue has been addressed via AN-148308 in Appian 19.4 Hotfix Package C.

Action

There are two actions that can be taken to resolve this issue:

1. Apply the latest hotfix to your Appian installation.
2. Follow the below steps based on installation type:

Cloud

Open a case with Appian Support and note to the case description that you are experiencing behavior in line with this article.

Self-managed

1. Connect to the Appian Primary Database.
2. Run: SELECT * FROM healthcheck;
3. For any rows that have a fields of status=RUNNING and heartbeat=null, note down the value of the id field.
4. With the identified id in Step 3, run UPDATE healthcheck set status='FAILED',status_constraint=<ID_OF_STUCK_RUN> where id=<ID_OF_STUCK_RUN>;
5. Execute the Appian Health Check.

Affected Versions

This article applies to Appian 19.4.

Last Reviewed: April 2020