We have a dbinput that pull in data from an Oracle database. Yesterday, there was some problems with our indexer so we lost a bit of data in that time. I know that I can change the rising checkpoint value to yesterday but it will reindex data till that point to now.
I want to know are there any other way to reindex those missing data in the pass without delete it all?
Edit: I try the delete and reindex all by changing the tail_rising_column_checkpoint_value to the epoch time in the pass but when it's start it only start indexing from the point that I refresh please help
How do you index the entries? Is this a scheduled report with collect or something like that? If so, you may need to modify the report to make it idempotent by checking with the existing entries from the index and removing duplicates before collecting the new entries.
I do something similar to this for summary indexes already.