My Oracle Support Banner

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

Last updated on JUNE 07, 2024

Applies to:

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


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


[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']


[fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO AssetSubtypes (ASSETTYPE,SUBTYPE,PUBID) VALUES (?,?,?)
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> .


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.