CSV Upload For Flight Schedules Loads But All Rating Then Fails Until Edit Flight in GUI

(Doc ID 1486021.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Operational Planning - Version 6.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run a RIQ (Rate Inquiry) where a Flight is to be used the following error is seen:

2012-08-20 12:57:37.001 57678 Error Exception java.lang.StringIndexOutOfBoundsException: String index out of range: 2

java.lang.StringIndexOutOfBoundsException: String index out of range: 2
at java.lang.String.substring(String.java:1934)
at glog.business.rateservicescheduling.AirScheduleEngine.convertToRecurrentSchedule(AirScheduleEngine.java:260)
at glog.business.rateservicescheduling.AirScheduleEngine.prepFlightSchedules(AirScheduleEngine.java:118)
at glog.business.rateservicescheduling.AirScheduleEngine.prepSchedulingService(AirScheduleEngine.java:57)
at glog.business.rateservicescheduling.RateServiceDriveEngine.drive(RateServiceDriveEngine.java:179)
at glog.business.rateservicescheduling.RateServiceEngine.calculateServiceTime(RateServiceEngine.java:354)
at glog.business.rateservicescheduling.RateServiceEngine.calculateServiceTime(RateServiceEngine.java:442)
at glog.business.rate.rateservice.RateServiceSession.calculateService(RateServiceSession.java:268)
at glog.business.rate.rateinquiry.RateInquirySession.calculateServiceTime(RateInquirySession.java:1655)
at glog.business.rate.rateinquiry.RateInquirySession.getRates(RateInquirySession.java:1068)
at glog.business.rate.rateinquiry.RateInquirySession.getRatesInternal(RateInquirySession.java:897)
at glog.business.rate.rateinquiry.RateInquirySession.getRates(RateInquirySession.java:229)
at glog.business.action.RateActionExecutor.getRates(RateActionExecutor.java:83)
at glog.business.session.RateActionSessionBean.getRates(RateActionSessionBean.java:70)
at glog.business.session.RateActionSessionServerSideEJBWrapper.getRates(RateActionSessionServerSideEJBWrapper.java:68)
at glog.business.session.RateActionSessionHome_a6s4b5_EOImpl.getRates(RateActionSessionHome_a6s4b5_EOImpl.java:143)
at glog.business.session.RateActionSessionHome_a6s4b5_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:590)
at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:478)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:473)
at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:119)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)']

 

Steps to replicate:

1. Upload data to FLIGHT and INTERIM_FLIGHT tables.
2. Run an RIQ where you fill in the "RATE" radio button in the far upper-left corner and select a geo lane from which you have just loaded FLIGHT data.
3. The error is seen.

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