"java.lang.NullPointerException" Attempting to Use the "Between" Operator on a Numeric Field in a Saved Query

(Doc ID 1503485.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.2.0 to 6.2.8 [Release 6.2]
Information in this document applies to any platform.

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

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