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

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.2.7 to 6.3.2 [Release 6.2 to 6.3]
Information in this document applies to any platform.

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

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