Question
7
Replies
2132
Views
Tata Consultancy Services Ltd
Posted: June 9, 2017
Last activity: June 16, 2017
Closed
Optimize for Reporting not working for existing cases
Hi,
I have used optimize for reporting for a property which is available in an embeded page of pyWorkPage( pyWorkPage.DeviceRegistration.Property). After running the wizard I don't see the property data from BLOB to a new column. Below are the observations
1) New column is created
2) Data is not populated for the existing case
3) Data is populating for new cases created.
Appreciate if any one has faced similar issue.
-- Suman
It is a very common issue. For existing details, the population starts by a batch and starts populating. So you may wait for sometimes. If still not populated, there are two ways to do it. 2nd one you may try.
1) You may use ColumnPopulation utility. You have to request for it.
2) Write an activity to open the objects with lock and save it again. The column will be populated. But if number of such object is very high then it might hang. To avoid that first obj-browse using this column is not null as a criteria and give max count as 1000. Then loop through the resultset , obj-open-by-handle and save with write now.