IBM FileNet P8, Version 5.2.1            

Queries do not find objects as expected (Oracle database)

Queries for objects can return unexpected results.

Symptoms

When you query for one or more objects that reside in an object store with Oracle configured as the database engine, the query returns unexpected results.

Causes

Queries can return unexpected results if string-valued properties, such as document title or folder name, are empty.

Resolving the problem

Make sure that all string-valued properties have a value other than an empty string (""). For more information on how the Oracle database handles empty strings, see Database Engine Differences.


Last updated: October 2015
p8pct007.htm

© Copyright IBM Corporation 2015.