"java.lang.NullPointerException" Attempting to Use the "Between" Operator on a Numeric Field in a Saved Query (Doc ID 1503485.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

When attempting to use the "Between" operator on a Saved Query criteria for a Numeric field, the following NullPointer Exception is encountered

java.lang.NullPointerException
at java.util.Calendar.setTime(Calendar.java:1075)
at glog.util.LocalTimestamp.(LocalTimestamp.java:93)
at glog.util.LocalDate.(LocalDate.java:68)
at glog.util.LocalDate.valueOf(LocalDate.java:108)
at glog.webserver.util.QueryHelper.setFieldElementValueAttributes(QueryHelper.java:581)
at glog.webserver.util.QueryHelper.createFieldElement(QueryHelper.java:429)
at glog.webserver.util.QueryHelper.getFields(QueryHelper.java:145)
at glog.webserver.util.QueryHelper.getFields(QueryHelper.java:109)
at glog.webserver.agent.SavedQueryUpdateServlet.duplicateCheck(SavedQueryUpdateServlet.java:263)
at glog.webserver.agent.SavedQueryUpdateServlet.newSavedQueryValue(SavedQueryUpdateServlet.java:195)
at glog.webserver.agent.SavedQueryUpdateServlet.handleGrid(SavedQueryUpdateServlet.java:156)
at glog.webserver.agent.SavedQueryUpdateServlet.processGrids(SavedQueryUpdateServlet.java:40)
at glog.webserver.util.DocumentUpdateServlet.getDocument(DocumentUpdateServlet.java:87)
at glog.webserver.util.AbstractServletProducer.process(AbstractServletProducer.java:75)
at glog.webserver.util.BaseServlet.service(BaseServlet.java:950)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at glog.webserver.screenlayout.FrameInterceptFilter.doFilter(FrameInterceptFilter.java:29)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at glog.webserver.session.ParameterValidation.doFilter(ParameterValidation.java:29)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at glog.webserver.screenlayout.ClientSessionTracker.doFilter(ClientSessionTracker.java:72)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at glog.webserver.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:44)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)


To reproduce:

  Navigate Business Process Automation > Power Data > Event Management > Saved Queries.
  Create New Query.
  Enter a query name like TEST_PRIORITY_BETWEEN
  Pick the Object Type ID of ORDER RELEASE (for example)
  Click the Checkbox next to Use In Finder
  Click View/Define Query button
  In the Criteria section, click the drop down list box under Column and choose "Priority" (or any other numeric field)
  In the new section that appears, click the operand drop down list box (defaults to an =) and select "Between". Notice that another box now appears so you can enter values for the Between. Enter 1 and 100 for Between 1 and 100.
  Click the Save button on the Criteria row you just created. Notice that the null pointer exception is thrown.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.