Results for Query {query} cannot be cached as {table} does not exist in system.
(Doc ID 1458352.1)
Last updated on NOVEMBER 04, 2022
Applies to:
Oracle WebCenter Sites - Version 6.1 and laterInformation 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
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
Symptoms |
Cause |
Solution |
References |