Question
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>"
Column Populator tool can be run to populate the newly created column values from BLOB.
Hi Praveen,
Can we copy embedded property values to newly created column? If Yes what is the process
Hi,
You can populate embed properties with RecreateIndexesForClass activity only and try to run this activity with 5000 records on one run.
Thanks,
Deva
Hi Deva,
I ran the activity to generate index for an instance of class but it's failed with the below error:
"Problems were encountered when regenerating indexes--see log for details: code: <none> SQLState: <none> Message: <none>"
In Logs I could see the message "Problem updating the instance ---". Attached Log File
Hi,
Can you run the RecreateIndexesForClass activity. Try to pass your class name as parameter and run. If did not works then save as activity applicaiton ruleset and add your class name in obj-browse then run the activity.
Thanks,
Deva
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