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;
WARNING: These steps should be performed outside of business hours to avoid any potential performance impact.
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: January 2020
© 2020 Appian. All rights reserved.