John Talbot (TALBJ)
Sr. System Architect
Pegasystems Inc.
TALBJ Member since 2010 19 posts
Posted: September 25, 2020
Last activity: October 9, 2020
Posted: 25 Sep 2020 3:10 EDT
Last activity: 9 Oct 2020 14:20 EDT

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

***Edited by Moderator Marissa to change type from General to Product, update Platform Capability tags****
Pega Platform 7.1.8 Data Integration