Unable To See The Content Modulues In The Collaborator Workbench (Doc ID 1382564.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 09-Aug-2013***

Symptoms



On : 7.3.0 version, CollabWB

Unable to see the content modules when attempting to log into Collaborator Workbench as a 'System Manager' user,
the following error occurs.

ERROR
-----------------------
2011-08-19 10:01:21,888 EDT [OC4J Launcher] DEBUG appserver.system: Service Demantra Application Server/7.3.0 (7300007) (366) Started.
2011-08-19 10:01:21,888 EDT [OC4J Launcher] INFO tunnel.general: ODPM-50020: Servlet context initialization in progress.
2011-08-19 10:02:52,888 EDT [AJPRequestHandler-HTTPThreadGroup-4] ERROR collaborator.sql: ODPM-70293: Error in instantiateFromResultSet: java.lang.NullPointerException:
2011-08-19 10:02:52,888 EDT [AJPRequestHandler-HTTPThreadGroup-4] ERROR collaborator.sql: ContainerPane::readUserChildPanesFromTemplate(long), Exception!
2011-08-19 10:02:52,888 EDT [AJPRequestHandler-HTTPThreadGroup-4] ERROR collaborator.sql: ODPM-70273: Exception null
java.lang.NullPointerException
at com.demantra.portal.beans.ContainerPane.readUserChildPanesFromTemplate(ContainerPane.java:1067)
at com.demantra.portal.beans.ContainerPaneManager.createUserContentPaneFromTemplate(ContainerPaneManager.java:256)
at com.demantra.portal.beans.ContainerPaneManager.getUserContainerPane(ContainerPaneManager.java:167)
at _portal._pagebuilder._jspService(_pagebuilder.java:538)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:453)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:591)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:515)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at com.demantra.common.utils.ParamEncodingFilter.doFilter(ParamEncodingFilter.java:27)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:302)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:190)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)
2011-08-19 10:02:53,123 EDT [AJPRequestHandler-HTTPThreadGroup-4] ERROR collaborator.sql: getInterpriseContentsInfo: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000

2011-08-19 10:03:09,685 EDT [AJPRequestHandler-HTTPThreadGroup-5] ERROR collaborator.sql: ODPM-70293: Error in getAvailableUserContents: java.sql.SQLException: ORA-01795: maximum
number of expressions in a list is 1000
:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a user as 'System Manager'
1. Login into collaborator Workbench.
2. Go to Administrator and Click Personalise.

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