Support Article
Column Populator Not Working As Expected
SA-55950
Summary
When running a column population job to populate the old cases data to the existing cases, data does not populate. data populates in to the index tables when creating new cases.
Error Messages
Not Applicable
Steps to Reproduce
- Create a concrete class derived from the Index- base class.
- Create Single Value properties in the new class to hold values of the embedded values.
- Create a Declare Index rule with an embedded Page Context value that copies the embedded values to a new Index- instance.
- Save the Declare Index rule. It executes immediately, adding and deleting instances of the new class.
- Expose database columns corresponding to the Index- class.
Root Cause
A defect or configuration issue in the operating environment.
If a pagelist property is optimized, an Index class and a declare index are created automatically. This is followed by the column population job. This extracts data to the table that is mapped to the Index table. In this case, all the classes and properties are created manually.
Column population was run using Index-Classes. Since, tables mapped to Index classes do not have a BLOB column, regular column population will not work.
Resolution
Perform the following local-change:
- Provide work classes to the expose.classes property and access group for the class to which the declare index belongs.
- Run the column population.
expose.declareIndex.accessgroup= AccessGroup
expose.reindex=true
Published July 23, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.