In PEGA MARKETING 8.4, once we delete records from IH, Materialized IH Summary data is not gettting updated.
In PEGA MARKETING 8.4,once we add new records to IH, Materialized IH Summary data is gettting updated immidiately. However once we delete records from IH, Materialized IH Summary data is not gettting updated.
Is there any process to Sync the materilized IH Summary Data With IH after purging records from IH?
Is there any link/document to understand how cassandra DB is updated once we update or delete a record from IH?
Accepted Solution
Updated: 27 Apr 2021 7:33 EDT
Pegasystems Inc.
NL
Hi @Sandhya, it is by design that we don't delete from the IH summaries whenever records are deleted from the IH tables. Reason is that often the IH database has a short retention window. You usually don't want to delete from the summaries when IH is purged.
From the summaries landing page, you can re-create the summaries. That will force them to be synced back to the (possibly truncated) IH records in the database.
Pegasystems Inc.
US
@Sandhya , can you please elaborate. As Otto states, this is functioning as designed and the workaround he suggested is really one that should only be used in limited situations. Alex is trying to make sure the business need is understood, because the workaround can't be used regularly without a very good understanding of why you are doing it. You need to consider why IH records are being deleted. If it's for purge purposes, that should definitely not require summaries to be reconstructed. So again, please articulate well what is causing the client to want this.
Tech Mahindra
IN
@Otto_Perdeck Thank you so much Otto. Our Requirement is achieved .