Question
6
Replies
638
Views
Mindtree
Posted: November 29, 2018
Last activity: December 4, 2018
Closed
Copy old case data(embedded properties) from BLOB to newly created columns in declare index table
While running report timeout is happening because it fetch the data(embedded properties) from BLOB.
To fix this, we have created the declare index table but only new case data is getting stored in table.
Need suggestions to copy the old case data to new table.
We ran the utility "RecreateIndexesForClass" but is failing with the below error "Problems were encountered when regenerating indexes--see log for details: code: <none> SQLState: <none> Message: <none>"
Please check these articles on re-indexing with prpcUtils or Column Populator.
https://community.pega.com/sites/default/files/help_v74/procomhelpmain.htm#rule-/rule-declare-/rule-declare-index/related.htm
https://community.pega.com/sites/default/files/help_v74/procomhelpmain.htm#engine/database/tools/eng-cp-column-populator-con.htm