Disable Level and NOW Worksheet Displays NO Data - ERROR collaborator.sql: ODPM-70293: Error in instantiateFromResultSet: java.lang.NullPointerException (Doc ID 1072304.1)

Last updated on MAY 12, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 to 7.3.0 [Release 7.3.0]
Information in this document applies to any platform.
***Checked for relevance on 12-Feb-2013***


Symptoms


Customer has disabled a level. Now when a customer opens a worksheet and re runs the worksheet no data is displayed and he gets the following error:

java.lang.NullPointerException

It happens to all users and on all worksheets
By Design all the Worksheets are set with AutoRun--> OFF.
That is why you need to RUN the worksheet in order to see the error.




collaborator logs show the foll

collaborator.log

2010-02-22 17:21:47,091 CST [AJPRequestHandler-RMICallHandler-9] ERROR collaborator.sql: ODPM-70293: Error in instantiateFromResultSet: java.lang.NullPointerException:
2010-02-22 17:24:16,579 CST [AJPRequestHandler-RMICallHandler-9] ERROR appserver.error:
java.lang.NullPointerException
at com.demantra.applicationServer.services.generationServices.DemantraEntityGraphBuilder.getExtendedEntitiesGenaralLevel(DemantraEntityGraphBuilder.java:1419)
at com.demantra.applicationServer.services.generationServices.DemantraEntityGraphBuilder.loadEdgesGeneralLevel(DemantraEntityGraphBuilder.java:1254)
at com.demantra.applicationServer.services.generationServices.DemantraEntityGraphBuilder.loadEdges(DemantraEntityGraphBuilder.java:629)
at com.demantra.applicationServer.services.generationServices.DemantraEntityGraphBuilder.loadGraph(DemantraEntityGraphBuilder.java:241)
at com.demantra.applicationServer.services.generationServices.DemantraEntityGraphBuilder.(DemantraEntityGraphBuilder.java:221)
at com.demantra.applicationServer.metaDataObjects.component.ComponentsList.getDemantraEntityGraphBuilder(ComponentsList.java:1568)
at com.demantra.applicationServer.services.generationServices.QueryRequester.loadRequester(QueryRequester.java:886)
at com.demantra.applicationServer.services.generationServices.QueryRequester.(QueryRequester.java:299)
at com.demantra.applicationServer.services.generationServices.IncQueryRequester.(IncQueryRequester.java:29)
at com.demantra.applicationServer.services.queryrun.QueryRunnerFactory.getRequester(QueryRunnerFactory.java:152)
at com.demantra.applicationServer.services.queryrun.QueryRunnerFactory.getSelectBuilder(QueryRunnerFactory.java:113)
at com.demantra.applicationServer.services.queryrun.QueryRunnerFactory.getDataHandler(QueryRunnerFactory.java:339)
at com.demantra.applicationServer.services.queryrun.QueryRunnerFactory.getDataRunner(QueryRunnerFactory.java:288)
at com.demantra.bridge.server.SoapBridge.executeQuery(SoapBridge.java:547)
at com.demantra.bridge.server.SoapBridge.startLoadingQuery(SoapBridge.java:424)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.demantra.tunnel.task.operations.InvokeTaskVisitor.visit(InvokeTaskVisitor.java:228)
at com.demantra.tunnel.task.InvokeTask.acceptTaskVisitor(InvokeTask.java:49)
at com.demantra.tunnel.task.operations.InvokeTaskVisitor.invoke(InvokeTaskVisitor.java:116)
at com.demantra.tunnel.task.operations.InvokeTaskVisitor.access$000(InvokeTaskVisitor.java:50)
at com.demantra.tunnel.task.operations.InvokeTaskVisitor$1.process(InvokeTaskVisitor.java:104)
at com.demantra.tunnel.task.operations.LogProcessTaskVisitor.process(LogProcessTaskVisitor.java:188)
at com.demantra.tunnel.task.operations.LogProcessTaskVisitor.visitOther(LogProcessTaskVisitor.java:171)
at com.demantra.tunnel.task.operations.LogProcessTaskVisitor.visit(LogProcessTaskVisitor.java:160)
at com.demantra.tunnel.task.InvokeTask.acceptTaskVisitor(InvokeTask.java:49)
at com.demantra.tunnel.task.operations.LogProcessTaskVisitor.apply(LogProcessTaskVisitor.java:123)
at com.demantra.tunnel.task.operations.LogProcessTaskVisitor.process(LogProcessTaskVisitor.java:118)
at com.demantra.tunnel.task.operations.InvokeTaskVisitor.apply(InvokeTaskVisitor.java:101)
at com.demantra.tunnel.server.controller.TaskDispatcher.invokeImmediately(TaskDispatcher.java:225)
at com.demantra.tunnel.server.controller.TaskDispatcher.dispatchTask(TaskDispatcher.java:150)
at com.demantra.tunnel.server.controller.TaskDispatcher.dispatch(TaskDispatcher.java:86)
at com.demantra.tunnel.server.controller.TaskDispatcher.apply(TaskDispatcher.java:76)
at com.demantra.tunnel.server.controller.RequestDispatcher.processTask(RequestDispatcher.java:133)
at com.demantra.tunnel.server.controller.RequestDispatcher.processRequest(RequestDispatcher.java:90)
at com.demantra.tunnel.server.RequestDispatcherServlet.processRequest(RequestDispatcherServlet.java:79)
at com.demantra.tunnel.server.RequestDispatcherServlet.doPost(RequestDispatcherServlet.java:139)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at com.demantra.common.servlets.AuthorizationFilter.doFilter(AuthorizationFilter.java:61)
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)
2010-02-22 17:24:16,579 CST [AJPRequestHandler-RMICallHandler-9] ERROR tunnel.general: ODPM-70106: Task[20] encountered error in the facade code
com.demantra.applicationServer.appServerExceptions.ApplicationServerException: java.lang.NullPointerException
at com.demantra.bridge.server.SoapBridge.startLoadingQuery(SoapBridge.java:439)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)



Java console

JAVA Console ERROR Java Plug-in 1.6.0_07 Usar versión JRE 1.6.0_07 Java HotSpot(TM) Client VM Directorio local del usuario = C:\Documents and Settings\<username> ---------------------------------------------------- c: borrar ventana de consola f: finalizar objetos en la cola de finalización g: liberación de recursos h: presentar este mensaje de ayuda l: volcar lista del cargador de clases m: imprimir sintaxis de memoria o: activar registro p: recargar configuración de proxy q: ocultar consola r: recargar configuración de norma s: volcar propiedades del sistema y de despliegue t: volcar lista de subprocesos v: volcar pila de subprocesos x: borrar antememoria del cargador de clases 0-5: establecer nivel de rastreo en ---------------------------------------------------- java.lang.NullPointerException at sun.plugin.AppletViewer.loadJarFiles(Unknown Source) at sun.applet.AppletPanel.runLoader(Unknown Source) at sun.applet.AppletPanel.run(Unknown Source) at java.lang.Thread.run(Unknown Source) java.lang.InterruptedException at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at sun.plugin.ClassLoaderInfo.lock(Unknown Source) at sun.plugin.AppletViewer.loadJarFiles(Unknown Source) at sun.applet.AppletPanel.runLoader(Unknown Source) at sun.applet.AppletPanel.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 2010-02-22 13:24:27,734 CST [thread applet-com.demantra.partner.client.main.PartnerApplet.class] INFO dpweb.general :: ODPM-50010: Worksheets Window Logging Started... 2010-02-22 13:24:27,734 CST [thread applet-com.demantra.partner.client.main.PartnerApplet.class] INFO dpweb.general :: ODPM-50009: Worksheets Window is started in Online mode. 2010-02-22 13:24:28,015 CST [thread applet-com.demantra.partner.client.main.PartnerApplet.class] INFO tunnel.general :: ODPM-50016: No proxy selected 2010-02-22 13:24:28,375 CST [thread applet-com.demantra.partner.client.main.PartnerApplet.class] INFO dpweb.general :: ODPM-40690: Worksheets Window Started on Time Zone America/Mexico_City DST off, Locale español (México) 2010-02-22 13:24:28,375 CST [thread applet-com.demantra.partner.client.main.PartnerApplet.class] INFO dpweb.general :: ODPM-50011: Worksheets Window is using Server Time Zone America/Mexico_City 2010-02-22 13:25:02,203 CST [Keep_Session_Alive_Thread] INFO dpweb.connection :: ODPM-50002: Connectivity status is: 'Connected' Exception occurred during event dispatching: java.lang.ExceptionInInitializerError at com.demantra.bridge.server.SoapBridge.validateLevelSelectionInternal(SoapBridge.java:7331) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.demantra.tunnel.task.operations.InvokeTaskVisitor.visit(InvokeTaskVisitor.java:228) at com.demantra.tunnel.task.InvokeTask.acceptTaskVisitor(InvokeTask.java:49) at com.demantra.tunnel.task.operations.InvokeTaskVisitor.invoke(InvokeTaskVisitor.java:116) at com.demantra.tunnel.task.operations.InvokeTaskVisitor.access$000(InvokeTaskVisitor.java:50) at com.demantra.tunnel.task.operations.InvokeTaskVisitor$1.process(InvokeTaskVisitor.java:104) at com.demantra.tunnel.task.operations.LogProcessTaskVisitor.process(LogProcessTaskVisitor.java:188) at com.demantra.tunnel.task.operations.LogProcessTaskVisitor.visitOther(LogProcessTaskVisitor.java:171) at com.demantra.tunnel.task.operations.LogProcessTaskVisitor.visit(LogProcessTaskVisitor.java:160) at com.demantra.tunnel.task.InvokeTask.acceptTaskVisitor(InvokeTask.java:49) at com.demantra.tunnel.task.operations.LogProcessTaskVisitor.apply(LogProcessTaskVisitor.java:123) at com.demantra.tunnel.task.operations.LogProcessTaskVisitor.process(LogProcessTaskVisitor.java:118) at com.demantra.tunnel.task.operations.InvokeTaskVisitor.apply(InvokeTaskVisitor.java:101) at com.demantra.tunnel.server.controller.TaskDispatcher.invokeImmediately(TaskDispatcher.java:225) at com.demantra.tunnel.server.controller.TaskDispatcher.dispatchTask(TaskDispatcher.java:150) at com.demantra.tunnel.server.controller.TaskDispatcher.dispatch(TaskDispatcher.java:86) at com.demantra.tunnel.server.controller.TaskDispatcher.apply(TaskDispatcher.java:76) at com.demantra.tunnel.server.controller.RequestDispatcher.processTask(RequestDispatcher.java:133) at com.demantra.tunnel.server.controller.RequestDispatcher.processRequest(RequestDispatcher.java:90) at com.demantra.tunnel.server.RequestDispatcherServlet.processRequest(RequestDispatcherServlet.java:79) at com.demantra.tunnel.server.RequestDispatcherServlet.doPost(RequestDispatcherServlet.java:139) at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at com.demantra.common.servlets.AuthorizationFilter.doFilter(AuthorizationFilter.java:61) 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) Caused by: java.lang.NullPointerException at com.demantra.applicationServer.services.generationServices.DemantraEntityGraphBuilder.getExtendedEntitiesGenaralLevel(DemantraEntityGraphBuilder.java:1419) at com.demantra.applicationServer.services.generationServices.DemantraEntityGraphBuilder.loadEdgesGeneralLevel(DemantraEntityGraphBuilder.java:1254) at com.demantra.applicationServer.services.generationServices.DemantraEntityGraphBuilder.loadEdges(DemantraEntityGraphBuilder.java:629) at com.demantra.applicationServer.services.generationServices.DemantraEntityGraphBuilder.loadGraph(DemantraEntityGraphBuilder.java:241) at com.demantra.applicationServer.services.generationServices.DemantraEntityGraphBuilder.(DemantraEntityGraphBuilder.java:221) at com.demantra.applicationServer.metaDataObjects.component.ComponentsList.getDemantraEntityGraphBuilder(ComponentsList.java:1568) at com.demantra.bridge.server.utils.ContentValidator.(ContentValidator.java:95) at com.demantra.bridge.server.utils.ContentValidator.(ContentValidator.java:89) ... 38 more 2010-02-22 13:25:47,515 CST [Keep_Session_Alive_Thread] INFO dpweb.connection :: ODPM-50002: Connectivity status is: 'Connected' 2010-02-22 13:28:24,078 CST [Keep_Session_Alive_Thr

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