My Oracle Support Banner

Exported BOM Explosion Report On Excel Format (XLS) Is Generated With "Application Error The feature did not perform as expected. Please contact your Agile Administrator" Error (Doc ID 2656574.1)

Last updated on APRIL 06, 2020

Applies to:

Oracle Agile Product Collaboration - Version 9.3.5.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
After running BOM Explosion Report, select Export button with "Microsoft® Excel Workbook" to generate XLS format file.
Opening the generated Excel file have the following error shown.

ERROR
Application Error
The feature did not perform as expected. Please contact your Agile Administrator


From the application server log (agile2.log) it shows the following error :

Caused by: java.lang.IllegalArgumentException: Invalid column index (256).  Allowable column range for BIFF8 is (0..255) or ('A'..'IV')
        at org.apache.poi.hssf.usermodel.HSSFCell.checkBounds(HSSFCell.java:950) ~[poi-3.11-20141221.jar:3.11]
        at org.apache.poi.hssf.usermodel.HSSFCell.<init>(HSSFCell.java:156) ~[poi-3.11-20141221.jar:3.11]
        at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:148) ~[poi-3.11-20141221.jar:3.11]
        at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:124) ~[poi-3.11-20141221.jar:3.11]
        at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:102) ~[poi-3.11-20141221.jar:3.11]
        at com.agile.report.common.IndexFactory.toXLS(IndexFactory.java:789) ~[agileclasses.jar:?]
        at com.agile.report.common.IndexFactory.export(IndexFactory.java:697) ~[agileclasses.jar:?]
        at com.agile.ui.pcm.report.common.ReportExecHandler.downloadData(ReportExecHandler.java:516) ~[agileclasses.jar:?]
        ... 49 more



FACT
Export succeed with no error message when selecting CSV format file.

STEPS
The issue can be reproduced at will with the following steps:
1. Login to Web Client
2. Run BOM Explosion Report
3. Export in Excel format
4. Open the generated Excel file

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.