ResultsSet Cache Not Synchronized Between WCSites Cluster Nodes Due to Different Datasource Names (Doc ID 1984797.1)

Last updated on JULY 07, 2017

Applies to:

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

Symptoms

In a 2-node cluster, update an asset in one node does not invalidate the ResultSet cache on the other node. (Other caches are working fine.)

A simple test case is to update the name/description of an asset on node1, and observe stale asset name/description on node 2 on the Inspect screen.

InCache/network communication is not problem here as DEBUG/TRACE messages shows incache notifications are able to reach to the other node.

For example, with the following logger enabled:

nodo1.log:

[2014-11-20 17:20:00,245 CET] [DEBUG] [WebContainer : 4] [net.sf.ehcache.Cache] Cache: jndi/datasourceNode1myAssetType store hit for jndi/datasourceNode1-SELECT ID FROM MYASSETTYPE WHERE ID=?[Number of positions=1] data [{0=1360680831344}]

nodo2.log:

[2014-11-20 17:21:08,118 CET] [DEBUG] [WebContainer : 0] [net.sf.ehcache.Cache] Cache: cached-catalogs store hit for jndi/datasourceNode2siteentry
...
[2014-11-20 17:20:41,244 CET] [DEBUG] [CP Connection(8)-{IP_Address}] [sf.ehcache.distribution.RMICachePeer] RMICachePeer for cache notifier: remote remove received for key: InvalidationNotification{cacheName='linked-cache', invalidationData=InvalidationData{deps=[jndi/datasourceNode1myAssetType], time=1416500441241}, key='18415852@MX03010016D0046-1296616724'}


Changes

When the cluster was set up, even though both nodes are pointing to the same database, they are using different datasource name.

For example:

node1: datasourceNode1

node2: datasourceNode2

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