DRAFT KB-XXX News Posts missing in Tempo

Symptoms

Past News Posts (greater than approximately 1 week old) are missing from Tempo. However, the older News Posts are present when running the following SQL query in the Appian Primary Data Source:

SELECT * FROM tp_feed_entry ORDER BY id ASC;

Cause

News Posts are stored in the Appian Primary Data Source in the tp_feed_entry table. For quick retrieval, these posts are indexed.

1. In Appian 17.1 and 17.2, these News Posts are indexed by Apache Lucene. The index files are stored in the <APPIAN_HOME>\_admin\search-local\index-primary directory.
2. In Appian 17.3 and beyond, these News Posts are indexed the Search Server. The index files are stored in the <APPIAN_HOME>\_admin\search-local\search-server\data\appian-search-cluster\nodes\0\indices directory. If Search Server experiences an issue (i.e. crashes due to network issue or runs out of disk space), the indices may be corrupted. From that point on, only new entries are stored. This causes only new News Posts to be displayed in Tempo.