6.6 Loading Content Explorer extremely slow

Is anyone else having problems with Content Explorer taking ages to restore the applet information in version 6.6?

OK it seems that the follow error is occuring when the Content Explorer applet is loading:

network: Connecting http://promcmsuat.rroom.net:9992/Rhythmyx/sys_cxViews/recent.xml with proxy=DIRECT
network: Connecting http://promcmsuat.rroom.net:9992/Rhythmyx/sys_cxViews/recent.xml with cookie “oracle.uix=0^^GMT+1:00; JSESSIONID=A1DA8B70348183676DC64596E03C5ED2”
network: Connecting http://promcmsuat.rroom.net:9992/Rhythmyx/sys_ceFieldsCataloger/SearchConfig with proxy=DIRECT
network: Connecting http://promcmsuat.rroom.net:9992/Rhythmyx/sys_ceFieldsCataloger/SearchConfig with cookie “oracle.uix=0^^GMT+1:00; JSESSIONID=A1DA8B70348183676DC64596E03C5ED2”
network: Connecting http://promcmsuat.rroom.net:9992/Rhythmyx/sys_webServicesHandler/app with proxy=DIRECT
network: Connecting http://promcmsuat.rroom.net:9992/Rhythmyx/sys_webServicesHandler/app with cookie “oracle.uix=0^^GMT+1:00; JSESSIONID=A1DA8B70348183676DC64596E03C5ED2”
Exception in thread “AWT-EventQueue-2” java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOf(Unknown Source)
at java.lang.StringCoding.safeTrim(Unknown Source)
at java.lang.StringCoding.access$100(Unknown Source)
at java.lang.StringCoding$StringDecoder.decode(Unknown Source)
at java.lang.StringCoding.decode(Unknown Source)
at java.lang.String.<init>(Unknown Source)
at java.lang.String.<init>(Unknown Source)
at com.percussion.util.PSHttpConnection.super(Unknown Source)
at com.percussion.util.PSHttpConnection.postData(Unknown Source)
at com.percussion.util.PSRemoteAppletRequester.o00000(Unknown Source)
at com.percussion.util.PSRemoteAppletRequester.getDocument(Unknown Source)
at com.percussion.cms.objectstore.ws.PSWSExecutableSearch.getSearchResults(Unknown Source)
at com.percussion.search.PSBaseExecutableSearch.executeSearch(Unknown Source)
at com.percussion.cx.PSExecutableSearch.executeSearch(Unknown Source)
at com.percussion.cx.PSSearchViewActionManager.loadChildren(Unknown Source)
at com.percussion.cx.PSActionManager.loadChildren(Unknown Source)
at com.percussion.cx.PSMainView.refreshChildNodes(Unknown Source)
at com.percussion.cx.PSMainView.valueChanged(Unknown Source)
at javax.swing.JTree.fireValueChanged(Unknown Source)
at javax.swing.JTree$TreeSelectionRedirector.valueChanged(Unknown Source)
at javax.swing.tree.DefaultTreeSelectionModel.fireValueChanged(Unknown Source)
at javax.swing.tree.DefaultTreeSelectionModel.notifyPathChange(Unknown Source)
at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPaths(Unknown Source)
at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPath(Unknown Source)
at javax.swing.JTree.setSelectionPath(Unknown Source)
at com.percussion.cx.PSNavigationTree.setSelectionPath(Unknown Source)
at com.percussion.cx.PSContentExplorerApplet$1.run(Unknown Source)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

Getting warmer the problem is being caused by the session information being stored regarding recent views.

[quote=fosterd;8831]OK it seems that the follow error is occuring when the Content Explorer applet is loading:

network: Connecting http://promcmsuat.rroom.net:9992/Rhythmyx/sys_cxViews/recent.xml with proxy=DIRECT
network: Connecting http://promcmsuat.rroom.net:9992/Rhythmyx/sys_cxViews/recent.xml with cookie “oracle.uix=0^^GMT+1:00; JSESSIONID=A1DA8B70348183676DC64596E03C5ED2”
network: Connecting http://promcmsuat.rroom.net:9992/Rhythmyx/sys_ceFieldsCataloger/SearchConfig with proxy=DIRECT
network: Connecting http://promcmsuat.rroom.net:9992/Rhythmyx/sys_ceFieldsCataloger/SearchConfig with cookie “oracle.uix=0^^GMT+1:00; JSESSIONID=A1DA8B70348183676DC64596E03C5ED2”
network: Connecting http://promcmsuat.rroom.net:9992/Rhythmyx/sys_webServicesHandler/app with proxy=DIRECT
network: Connecting http://promcmsuat.rroom.net:9992/Rhythmyx/sys_webServicesHandler/app with cookie “oracle.uix=0^^GMT+1:00; JSESSIONID=A1DA8B70348183676DC64596E03C5ED2”
Exception in thread “AWT-EventQueue-2” java.lang.OutOfMemoryError: Java heap space[/quote]<init><init>

This typically occurs when you’re attempting to log into a folder with 100’s or 1000’s of items in it. The client’s browser doesn’t have enough java heap to render all of the items in the folder.

First, I’d try setting a memory value for the client’s JRE:
Control Panel > Java > Java tab > View button under Java Applet Runtime Settings, add a Java Runtime Parameter of -Xmx128m or -Xmx256m. Click Ok, Ok, then Restart the browser.

If that doesn’t work, try truncating the PSX_PERSISTEDPROPERTYVALUES table, then have your users restart their browsers. This will remove the user’s session so that the next time they log in, they’ll go to the default folder instead of the folder with too many items. You wouldn’t typically do this while there are a bunch of people using the Cx as it’ll probably mess up their current session. </init></init><init><init></init></init>

This is occurring for completely new users after the first initial log in, I assume, these users should have very little or no recent items cached against their user log in and the CMS overall is a very new install with virtually no content in it.

Removing the ‘Recent Items’ view from the communities ACL settings has allowed us to temporarily get around his problem.

It is occurring on every client machine we try (roughly seven differnt machines in various browsers).

Daniel,

The issue isn’t related to the contents of the user’s cache, it’s related to the number of Content Items in the Folder or View on the Rhythmyx server. If a Folder contains hundreds or thousands of Content Items, or if a View returns hundreds or thousands of Content Items, it can overload the Java heap.

Brendon has outlined the standard solutions for this problem.

RLJII

As suggested we did truncate the PSX_PERSISTEDPROPERTYVALUES table but the default view is still recent and we do not see any difference in performance.

Can we default the users to a folder when they log in?

Ravi

If you truncated the table and the same values are still present, you probably didn’t commit the changes. Try using COMMIT; after using your TRUNCATE TABLE script.

Dan,
You don’t have to remove the Recent View from ACL.
If you have migrated all images, themes etc. for the “planet” project (which is 1000’s of items) and someone tried to browse one of those folders (for instance with admin1 account) than you’d have an issue.
Try to limit how many items displayed in Recent View by modifying the number of items to return in query to 100-200 as what you probably have now is “-1” - which is unlimited.
This can be done in Recent View xml application (see applications tab in workbench).
Hope this helps.

Mike
P.S. I thought that “planet” is running on 6.7, not 6.6

go to XML Apps tab > System > sys_cxViews

Open recent XML app and change the value in Pager (I think “results to return” ) to 200 or 100 instead of -1