Discussion

Populating Index Table from Complex Property

In our project we have a complex property that we have now determined we need to report on. Since we cannot expose complex properties, through my reading I have found that we will need to create an associated index table so we can expose the property using declarative indexing.

My question, if I create the index table (now), what would be the quickest and simplest way to populate the table with data stored in the BLOB of the complex property?

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

July 13, 2012 - 12:42pm

How to achieve this in PRPC 6.X??

July 13, 2012 - 1:37pm

Hi All

Check Property Optimization tool

Thanks and Regards
Vinoth Sridharan

July 14, 2012 - 2:38am

Refer this link,

/node/12409

Thanks,
Austin Jonny.

July 14, 2012 - 10:57am

From 6.1 onwards ,resaver servlet is replaced with column populator utility
If you want to use OOTB solution try following link
http://pdn.pega.com/DevNet/PRPCv6/KB/26168.asp

March 18, 2010 - 4:42pm

To clarify, I will need to pull data already stored in the database in the BLOB and populate the new index table.

FYI the article I am referring to is:
http://pdn.pega.com/ProductSupport/Products/PegaRULESProcessCommander/documents/PRPC/V5/502/HTMLdocs/admin_html52_1-18/adminsec_05_databasep5.asp

March 19, 2010 - 1:19am

Hello,

In order to pull data already stored in the database in the BLOB you may need to run the resaver servlet (it depends on the number of WO's and this may take some time).

Property values for new work objects created after the change are stored in the new table, existing records do not automatically move data to that column and still have values for the exposed property stored in the BLOB column only. Running a report that includes records saved before the property was exposed show "null" as the value for that property for the old records.

Hope the below information can help you out (you can find the information the link that was provided by you)

Resaving Records

Whether you use your own database tools or the Process Commander Database Schema wizard to expose a property as a database column, existing records do not automatically move data to that column. Property values for new work objects created after the change are stored in the column, but previously saved work objects still have values for the exposed property stored in the BLOB column only. Running a report that includes records saved before the property was exposed show "null" as the value for that property for the old records.

If you want all records - existing and new - to use the new column, you must resave the existing data. To do so, you use the resave function of the Process Commander Database Utilities application after you have created the new column.

The URL of the Database Utilities application is:

http://servername:portnumber/prdbutil

For example, if the Process Commander URL is:

http://serverX:8080/prweb/PRServlet

Then, the URL of the database utilities servlet is:

http://serverX:8080/prdbutil

Before you begin, open and save the appropriate database name or database table object, so Process Commander notices the change to the schema. If you changed one or two tables, open the database table objects that map instances of classes to those tables and resave them. If you changed several tables in the same database, open the database name object that represents that database and resave it. That way, all the table mappings that refer to that database are refreshed.

Cheers.

October 13, 2015 - 5:32am

Hi KIMLEVIS,,

 

The link u have provided as mentioned below is not working/does not contain any information. Can you please send us the link once again..

http://pdn.pega.com/ProductSupport/Products/PegaRULESProcessCommander/documents/PRPC/V5/502/HTMLdocs/admin_html52_1-18/adminsec_05_databasep5.asp

 

Regards,

Ashiq

Pega
October 25, 2015 - 12:56pm

https://pdn.pega.com/pegarules-database/how-to-use-the-column-populator-utility