2 Replies Latest reply on Mar 18, 2013 4:07 PM by anasazii1

    Array Index Out of Bounds Error

    979370
      Hi All,
      I have a peculiar problem and I need some help.

      I'm developing a BIP Excel Template. I'm only using XDO_?XYZ? and XDO_GROUP_?ABC? labels in the template and nothing more.

      The data-model has 6 datasets. I've completed development of three of the datasets, but, when I try to use the XDO_GROUP_?ABC? for the fourth dataset, the following things happen:

      In BI Publisher 11.1.1.3, I'm getting a blank XLS with no data.
      In BI Publisher 11.1.1.6, the data is populating fine and there are no errors.
      In BI Publisher 11.1.1.5, I get the following error:

      -----
      Start Excel Preview
      only open: false
      mTemplate: C:\Documents and Settings\ABC\Desktop\XYZ\Q\Templates\Quadv3.2.xls
      mTmpTemplate: C:\Documents and Settings\ABC\Local Settings\Application Data\Oracle\BIPublisher\TemplateBuilderforExcel\tmp/tmp.xls
      java.lang.ArrayIndexOutOfBoundsException: -1
           at java.util.Vector.elementData(Unknown Source)
           at java.util.Vector.elementAt(Unknown Source)
           at oracle.xdo.excel.user.biff.RowBlock.getRow(RowBlock.java:488)
           at oracle.xdo.excel.user.bimpl.BSheet.getRow(BSheet.java:942)
           at oracle.xdo.template.excel.object.SheetObject.initSimpleFieldsIndex(SheetObject.java:125)
           at oracle.xdo.template.excel.object.BookManager.getSheetObject(BookManager.java:280)
           at oracle.xdo.template.excel.object.BookManager.collectAllNameObjects(BookManager.java:218)
           at oracle.xdo.template.excel.object.BookManager.process(BookManager.java:147)
           at oracle.xdo.template.excel.ExcelController.parseExcelTemplate(ExcelController.java:304)
           at oracle.xdo.template.excel.ExcelController.generateXSL(ExcelController.java:259)
           at oracle.xdo.template.excel.ExcelController.process(ExcelController.java:237)
           at oracle.xdo.template.ExcelProcessor.process(ExcelProcessor.java:244)
           at ExcelPreview.runXDO(ExcelPreview.java:110)
           at ExcelPreview.main(ExcelPreview.java:87)
      -----

      Note: If I try to access the same dataset in a separate Blank template in *11.1.1.3*, it works fine.

      Due to client restrictions and Policies, I can not upgrade to 11.1.1.6 just yet and have to deliver the report in 11.1.1.3.

      Could you please help me figure out whats happening and how i can fix the problem in 11.1.1.3?

      Thanks in Advance.

      Edited by: 976367 on Dec 11, 2012 6:58 PM

      Edited by: 976367 on Dec 11, 2012 7:01 PM