Announcement

Collapse
No announcement yet.

Error while uploading the rate_offering stops through multi table csv

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error while uploading the rate_offering stops through multi table csv

    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)

  • #2
    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?
    James Foran
    Toll Global Information Services
    http://www.tollgroup.com

    Comment


    • #3
      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

      Comment


      • #4
        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
        Cheers,
        Murthy

        Comment


        • #5
          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

          Comment


          • #6
            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

            Comment


            • #7
              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

              Comment


              • #8
                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

                Comment

                Working...
                X