Error while uploading the rate_offering stops through multi table csv

[cool_brat]

Hi,

I am getting this error when trying to upload multi-table csv. can some one let me know whether this is some issue with the structure of the csv or something else?


java.lang.ArrayIndexOutOfBoundsException: 11 >= 11

java.lang.ArrayIndexOutOfBoundsException: 11 >= 11

java.lang.ArrayIndexOutOfBoundsException: 11 >= 11
at java.util.Vector.elementAt(Vector.java:431)
at glog.database.admin.CSVUtil$ControlInfo.getColumnN ame(CSVUtil.java:532)
at glog.database.admin.CSVUtil$ControlInfo.getColumnD ataType(CSVUtil.java:547)
at glog.database.admin.CSVUtil$InsertCsvHandler.bind( CSVUtil.java:842)
at glog.database.admin.CSVUtil.bindGeneric(CSVUtil.ja va:1184)
at glog.database.admin.CSVUtil.processCSVDataLine(CSV Util.java:166
at glog.database.admin.CSVUtil.processMultiTableCSV(C SVUtil.java:1756)
at glog.database.admin.CSVUtil.processCSV(CSVUtil.jav a:1855)
at glog.database.admin.CSVUtil.run(CSVUtil.java:2521)
at glog.integration.servlet.CSVUtilServletHelper.proc essCSV(CSVUtilServletHelper.java:121)
at glog.integration.servlet.CSVUtilServletHelper.proc ess(CSVUtilServletHelper.java:239)
at glog.integration.servlet.CSVUtilServlet.process(CS VUtilServlet.java:26)
at glog.webserver.util.BaseServlet.service(BaseServle t.java:652)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at glog.webserver.screenlayout.ClientSessionTracker.d oFilter(ClientSessionTracker.java:56)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at glog.webserver.util.SetCharacterEncodingFilter.doF ilter(SetCharacterEncodingFilter.java:44)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:17
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:14
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyo teHandler.java:199)
at org.apache.jk.common.HandlerRequest.invoke(Handler Request.java:282)
at org.apache.jk.common.ChannelSocket.invoke(ChannelS ocket.java:754)
at org.apache.jk.common.ChannelSocket.processConnecti on(ChannelSocket.java:684)
at org.apache.jk.common.ChannelSocket$SocketConnectio n.runIt(ChannelSocket.java:876)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:534)

[james_foran]

Re: Error while uploading the rate_offering stops through multi table csv

I do get this every now and again also.

Ensure that you view each CSV file in a Text editor.

Also, if you load them individually, does this work successfully?

[cool_brat]

Re: Error while uploading the rate_offering stops through multi table csv

Hi James,

When I load individual files like Rate Offering, Rate Offering Stops then they get loaded successfully. However, when I am trying to load them together in a single file by keeping multitable csv then I am getting the error of array outbound.

Does OTM support uploading multi table files like X_lane,Rate_offering,Rate_offering_Stops,Rate_GEO, Rate_Geo_cost in a single file (multitable format) and loading into OTM.

I have seen the datamanagement guide which show the example of location having multiple table uploaded in a single file.So this case should be possible as well , but I had no luck so far.

Can you confirm if this functionality is supported ?

-Vipin

[MURTHYKO]

Re: Error while uploading the rate_offering stops through multi table csv

It can be either of the below reasons:
1) There might be a lot of records without any data (only commas) after the last record.
2) If you are uploading Saved query csv's then there might be lot of space between line to line in the query

If either didn't help you attach you zip, i will check and suggest something.

Regards,
Lakshman

[cool_brat]

Re: Error while uploading the rate_offering stops through multi table csv

Hi Lakshman,

I dont think, I have too many records. and if these files get loaded correctly when I am loading them one by one in the same format then why is it that these tables don;t get loaded when I try to load them together.

Attached file which I am trying to upload.(I hv converted it to .xls format as .csv was not getting loaded on this site. Pls change it to .csv when you are trying to test this.)

-VipinOTM_RATE_GEO_MULTI.xls

[cool_brat]

Re: Error while uploading the rate_offering stops through multi table csv

Hi,

I figured out that error was coming because when csv file is opened in excel and then post changes this file is saved, we get a warning message that csv format is not compatible with the excel and you may loose some features of csv file.

If all the editing is done in textpad then I am not facing any problem.
Can someone share their experience on this.

-Vipin

[chrisplough]

Re: Error while uploading the rate_offering stops through multi table csv

Typically, I use Programmer's Notepad (Windows) or Textmate (Mac) - so I haven't run into this specifically.

--Chris

[OTM_Learner]

Hi Vipin,
Please let me know if you got any solution for this. I am trying to upload a multi-table CSV for OTM agent but it is trowing error. Please anybody let me know if multi table csv upload works in OTM