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:
SELECT * FROM tp_feed_entry ORDER BY id ASC;
If the above procedure does not resolve the issue, proceed with the following steps:
Note: Resetting the search server indices can resolve a number of other issues. See KB-1082 for more symptoms regarding issues related to the search server indices.
This article applies to Appian 17.1 and later.
Last Reviewed: June 2018
© 2020 Appian. All rights reserved.