News posts before a specific date have disappeared from Tempo.
News posts are stored in the Appian primary data source in the 'tp_feed_entry' table. These posts are indexed for quick retrieval. If these indices become corrupt, indexing must restart, which causes only new entries to be stored and displayed in Tempo. The following sections explain how the posts are indexed based on the Appian version:
These news posts are indexed purely by the Apache Lucene software. The indices are stored in the <APPIAN_HOME>\_admin\search-local\index-primary directory.
SELECT * FROM tp_feed_entry ORDER BY id ASC;
WARNING: These steps should be performed outside of business hours to avoid any potential performance impact.
This article applies to Appian 17.1 and later.
Last Reviewed: August 2020
© 2020 Appian. All rights reserved.