Question
Mindtree
AU
Last activity: 4 Dec 2018 8:09 EST
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>"
Pegasystems Inc.
US
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
Coforge Technologies (Erstwhile Incessant Technologies)
GB
Column Populator tool can be run to populate the newly created column values from BLOB.
Swedbank AB
SE
Hi,
You can populate embed properties with RecreateIndexesForClass activity only and try to run this activity with 5000 records on one run.
Thanks,
Deva
Mindtree
AU
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
Swedbank AB
SE
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