Question3Replies419Views×Close popoverSrikanth Suryadevara (srikanths8919) HCL Technologies HCL Technologies NL View ProfileSend Message srikanths8919 Member since 2012 5 posts HCL Technologies Posted: September 13, 2018Last activity: September 18, 2018Posted: 13 Sep 2018 10:40 EDTLast activity: 18 Sep 2018 5:25 EDT Closed Populating database columns using the service-enabled Column Populator utilityI am trying to populate old column values through service-enabled column Populator utility ,is there any Pega provided REST service which let us do this?https://community.pega.com/sites/default/files/help_v72/procomhelpmain.htm#sys%20mgmt/sm-automated-expose-tsk.htm%3FTocPath%3DSystem%2520management%7CProperty%2520optimization%7CDatabase%2520Column%2520Population%2520using%2520the%2520Column%2520Populator%7C_____5Where exactly prpcServiceUtils.properties file is present? Data Integration System Administration ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 2 years agoPosted: 14 Sep 2018 5:25 EDT×Close popoverMarc Lasserre (MarcLasserre_GCS) PEGA Principal Software Solutions Engineer PEG FR View ProfileSend MessageMarcLasserre_GCS PEGA replied to srikanths8919Hello, On your distribution image you should have a "scripts" folder and inside this one an "utils" folder containing prpcServiceUtils.properties. I don't think we have an Out-Of-The-Box REST already existing for this. Posted: 2 years agoPosted: 18 Sep 2018 5:25 EDT×Close popoverSrikanth Suryadevara (srikanths8919) HCL Technologies HCL Technologies NL View ProfileSend Messagesrikanths8919 HCL Technologies replied to MarcLasserre_GCShttps://community1.pega.com/sites/pdn.pega.com/files/help_v73/procomhelpmain.htm#sys%20mgmt/sm-automated-expose-tsk.htm I found this which says service enabled Column populator utility Posted: 2 years agoPosted: 14 Sep 2018 5:29 EDT×Close popoverLaurence Brannigan (LaurenceB_GCS) PEGA Senior Software Solutions Engineer PEG GB View ProfileSend MessageLaurenceB_GCS PEGA replied to srikanths8919You can find the prpcServiceUtils.properties file in the installation media under /scripts/utils I wasn't too sure what you mean by old column (did you mean new column, but you have data that precedes it)? If you've optimize a property, then this should be recognised when you call prpcServiceUtils/prpcUtils with the expose option. Otherwise you can also cause it to regenerate the column individually by updating the pzreindex property to "true" and saving that record.