Results for Query {query} cannot be cached as {table} does not exist in system. (Doc ID 1458352.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle WebCenter Sites - Version 6.1 and later
Information in this document applies to any platform.

Symptoms

Some queries return stale or invalid data.

 

In Oracle WebCenter Sites 7.6.1 and later you may see this warning message:

[WARN] Results for Query {query} cannot be cached as {table} does not exist in system. Please note that the cache names are case sensitive

 

In the same and earlier versions, symptoms may include these errors when accessing the SitePlanTree table:

[ERROR] errno -110 on attempt to get children from a tree for tree SitePlanTree

and

[ERROR] object.load invalid node object identifier PubRoot.nid.

 

Or exceptions like the following, when accessing the Publication table:

java.sql.SQLException: Column not found: PUBROOT.NID in statement [SELECT COUNT(*) as "mycount"
                                FROM  SitePlanTree
                                WHERE nparentid = PubRoot.nid
                                AND ncode = 'Placed']

Or:

[fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO AssetSubtypes (ASSETTYPE,SUBTYPE,PUBID) VALUES (?,?,?)
ASSETTYPE = Page
SUBTYPE = MySubtype
PUBID = 1230987654321
java.sql.SQLException: ORA-01400: cannot insert NULL into ("SITESDB"."ASSETSUBTYPES"."ID")

 

In the Support Tools, in ResultSet Cache Profiler, there may be duplicate entries for a table (e.g. csDataSourceAssignment and csDataSourceassignment ).  The multiple entries for the same table have different capitalization.

 

Other possible symptoms are described in <Document 1452810.1> .

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms