Exporting Selected Records From Shipment Stop Screen Not Working (Doc ID 1543832.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

On OTM version 6.2

When attempting to Export from the OTM User Interface for Shipment Stops, where only a few records are selected the following error is generated within the file that is created:

ERROR
-----------------------
java.lang.NullPointerException

java.lang.NullPointerException
at glog.webserver.util.QueryHelper.buildCriteriaList(QueryHelper.java:2716)
at glog.webserver.finder.QueryFinderAdapter.loadResults(QueryFinderAdapter.java:475)
at glog.webserver.finder.QueryFinderAdapter.getResults(QueryFinderAdapter.java:466)
at glog.webserver.finder.ExportResultsServlet.getResults(ExportResultsServlet.java:105)
at glog.webserver.finder.ExportResultsServlet.getDocument(ExportResultsServlet.java:62)
at glog.webserver.util.AbstractServletProducer.process(AbstractServletProducer.java:75)
at glog.webserver.util.BaseServlet.service(BaseServlet.java:970)
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)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1 - Log onto OTM

2 - Navigate to: Shipment Management > Shipment Management > Shipment Stops.

3 - Run an open Query.

4 - Select several records, for example I randomly selected 5 rows.

5 - Click on the Export button at the base of hte screen.

6 - The next screen states:
"Do you want to use the 5 records selected or all 1,176 records?"

7 - Click on the 'Selected Records' button.

8 - In the File Download window click on Open.

9 - The file created does not contain the stop information but contains text, shown below this test case.

If the above steps are repeated but ALL records are selected and Exported the file is generated and contains the data correctly.

Cause

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