Close popover
Sudhanshu Kumar Yadav (SudhanshuY)
Labb Consulting
Lead System Architect
Labb Consulting
SudhanshuY Member since 2013 14 posts
Labb Consulting
Posted: September 12, 2017
Last activity: October 6, 2017

Running Column Population


I have below questions regarding column population which we need to run as part of upgrading our application from Pega 6.2 SP2 to Pega 7.2.2:

1. If complete this task using command line approach, in test evironment we have tested this and for 1497 records its taken 188 seconds out of which 21 seconds is for the actual expose and rest all for the environment initialization, so if we calculate using above 21 second for production which contains round about 1 million record it will take 5 hrs, which is acceptable. But in the log(attached) its saying for around 30000 records approx it will take 1 hr and if we take this then in production this utility will run for 38 hrs which is not acceptable because it will not fit into maintenance window. Please let us know which calculation we should consider or if you any other view or experience on this utility.

2. Can we run the multiple instance of column population either on single server(I don't think this is possible) or multiple server(this is possible as per me). Please let me know your view.

3. If as per question 1, the column population will take around 30-40 hrs, is it more advisable to use the agent to do this task on off business hours as per upgrade guide? One addition question, can we run this agent on business hours also?

4. As per the upgrade guide, this job just expose pxApplication after the upgrade, so just to be doubly sure doesnot it expose any other column also?


Sudhanshu Kumar Yadav

***9/26/17 Edited by moderator, Maryrita: moved to Product Support from Upgrade Center***

***Edited by Moderator Marissa to update categories***

System Administration
Moderation Team has archived post