[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]

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]

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]

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]

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]

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]

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

--Chris