Declare Index losing records
Has anybody seen declare index tables lose records? We have an index where rows have gone missing. We have a backup from April and they were present then. The index records for other pages from the same list are still there. Resave the work object using pzReIndex restores the index, so the data is still in the blob.
Any ideas how this might have happened? DB is Oracle.
---------------------------------
Declare Index doesn’t work as expected sometime.
Especially when there is Transaction Rollback happening.
See this article
https://community.pega.com/support/support-articles/declare-index-does-not-fire-expected