For each object store to be upgraded, you must determine
the associated classes and properties that are currently enabled for
content-based retrieval (CBR). You enable these properties after the
upgrade is complete.
To determine the classes and properties that are CBR-enabled:
- Using an RDBMS tool, access the object store database as
a user who has appropriate privileges to query the object store tables.
- Run the following SQL query command on each object store
database to determine which properties are enabled for CBR:
select
p.dbg_class_name, p.dbg_display_name, c.is_cbr_enabled, p.is_cbr_enabled
from ClassDefinition c inner join PropertyDefinition p on p.parent_id
= c.object_id where p.is_cbr_enabled = 1 AND c.is_cbr_enabled = 0
- Record the results of the query commands. After
you upgrade the object stores, you need to run FileNet® Enterprise Manager to enable CBR on these properties
after you enable CBR on the classes that these properties are associated
with.