SA-24362

Summary

The resulting extracted list has two entries for each selected property.

Error Messages

Not Applicable

Steps to Reproduce

1. Create an Extract rule.
2. Select the properties to be included.
3. Observe the resulting list.

Root Cause

A defect or configuration issue in the operating environment:
The primary key on the PR_SYS_RULESET_INDEX table was missing, resulting in duplicate entries in this caching table.

Resolution

Make the following change to the operating environment:

truncate table PR_SYS_RULESET_INDEX;

ALTER TABLE pr_sys_ruleset_index
ADD CONSTRAINT pr_sys_ruleset_index_PK PRIMARY KEY
(
   pzInsKey
)